skills.rest
mouseqiao85
mouseqiao85COMMUNITY
Explore all skills by this author →
GitHub

dcf-model

Generate DCF models with WACC calculations and sensitivity analysis.

1|Updated Feb 1, 2026
Search Tags:#financial modeling#data analysis#DCF#sensitivity analysis#equity valuation
One-click install
npx skills add https://github.com/mouseqiao85/AI-Plat --skill dcf-model-mouseqiao85
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dcf-model
Source: https://github.com/mouseqiao85/AI-Plat/tree/main/agent/skills/dcf-model
Command: npx skills add https://github.com/mouseqiao85/AI-Plat --skill dcf-model-mouseqiao85

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, requests, pandas, numpy, and includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill simplifies the creation of complex DCF models for equity valuation, allowing users to efficiently perform detailed financial analysis without extensive manual input.

Core Features & Use Cases

  • DCF Model Creation: Automates the process of building a DCF model from scratch.
  • Data Retrieval: Fetches financial data from SEC filings and analyst reports.
  • Scenario Analysis: Allows for building Bear, Base, and Bull scenarios with ease.
  • Use Case: For an investment bank analyst, this Skill can quickly generate a detailed DCF model for a company, including cash flow projections, WACC calculations, and sensitivity analysis.

Quick Start

Create a DCF model for company 'ABC Corp' using the dcf-model skill.

Frequently Asked Questions about dcf-model

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I build a DCF model for equity valuation from SEC filings?▼

To build a DCF model for equity valuation, this Skill extracts financial data from SEC filings and analyst reports, calculates WACC, projects cash flows, performs sensitivity analysis, and outputs a professional Excel model.

Can I run sensitivity analysis and build Bear, Base, and Bull scenarios for a DCF model?▼

Yes, you can run sensitivity analysis and build Bear, Base, and Bull scenarios for a DCF model. The Skill automates scenario generation and incorporates sensitivity analysis directly into the final Excel output.

Do I need pandas and openpyxl to generate Excel financial models?▼

Yes, you need pandas and openpyxl to generate Excel financial models. The Skill requires openpyxl for spreadsheet operations and Python libraries like pandas and numpy for data fetching and processing.

What is the best way to calculate WACC and project cash flows for investment banking analysis?▼

The best way to calculate WACC and project cash flows for investment banking analysis is using automated financial modeling tools. This Skill handles proper WACC calculations and cash flow projections tailored for investment banking workflows.

Does this DCF model generator work with data fetched directly from analyst reports?▼

Yes, this DCF model generator works with data fetched directly from analyst reports. It automatically retrieves financial data from both SEC filings and analyst reports to build comprehensive cash flow projections.

Related Skills

Explore More Finance & Accounting Skills→
hxhyyyhxhyyy

sec-edgar

Resolve U.S. equity tickers to CIK identifiers and retrieve SEC EDGAR filing data.

Community
Intermediate
open-nekoopen-neko
11

dcf-model

Build DCF valuation models with live Excel workbooks and sensitivity tables.

Official
Advanced
JoeyJoziahJoeyJoziah

financial-modeling

Build DCF, comparable company, and LBO financial models with sensitivity testing.

Community
Advanced
silva2kandsilva2kand

dcf-valuation

Build a discounted cash flow model estimating enterprise and equity value.

Community
Advanced