skills.rest
Timmy6942025
Timmy6942025COMMUNITY
Explore all skills by this author →
GitHub

dcf-model

Automate DCF model creation with WACC calculations and sensitivity analysis.

3|Updated May 30, 2026
Search Tags:#financial modeling#data analysis#Excel#DCF#equity valuation
One-click install
npx skills add https://github.com/Timmy6942025/open-financial-agents --skill dcf-model-timmy6942025
Or copy as Structured Prompt for Agentâ–¼
Please help me install this Agent Skill.
Skill: dcf-model
Source: https://github.com/Timmy6942025/open-financial-agents/tree/main/src/agent-skills/pitch-agent/skills/dcf-model
Command: npx skills add https://github.com/Timmy6942025/open-financial-agents --skill dcf-model-timmy6942025

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill solves the problem of manually creating detailed DCF (Discounted Cash Flow) models for equity valuation, providing a comprehensive solution that automates data retrieval, model building, and sensitivity analysis.

Core Features & Use Cases

  • Automated Data Retrieval: Fetches financial data from SEC filings, user-provided data, and the web.
  • DCF Model Building: Constructs institutional-quality DCF models with proper WACC calculations and sensitivity analysis.
  • Use Case: When a user needs to value a company using DCF methodology and requires a detailed Excel model with executive summaries and sensitivity tables.

Quick Start

Use the dcf-model skill to create a DCF model for a company with the ticker symbol 'AAPL'.

Frequently Asked Questions about dcf-model

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

FAQPage Schema
How do I automate DCF model building for equity valuation in Excel?â–¼

Automating DCF model building requires fetching financial data, projecting cash flows, and calculating WACC to output an institutional-quality Excel file. This Skill handles the entire workflow and performs sensitivity analysis automatically.

Do I need openpyxl to generate Excel financial models?â–¼

Yes, you need openpyxl installed to generate Excel financial models. The Skill relies on this dependency to handle Excel file operations and recalculate the institutional-quality DCF outputs.

Can I use SEC filings data to create a discounted cash flow model?â–¼

Yes, you can use SEC filings data to create a discounted cash flow model. The Skill features automated data retrieval from SEC filings, user-provided data, and the web to construct accurate cash flow projections.

What is the best way to calculate WACC and perform sensitivity analysis for investment analysis?â–¼

Calculating WACC and performing sensitivity analysis for investment analysis is best handled by automating the construction of a comprehensive DCF model. This Skill computes WACC and generates sensitivity tables within an Excel workbook.

How do I value a company using a DCF methodology without manually building spreadsheets?â–¼

To value a company using DCF methodology without manual spreadsheet building, you can automate the process by providing a ticker symbol like 'AAPL'. The Skill fetches the necessary data and constructs the complete valuation model.

Does this DCF model builder include executive summaries and sensitivity tables?â–¼

Yes, the DCF model builder includes executive summaries and sensitivity tables. It constructs institutional-quality Excel models that feature proper WACC calculations and detailed sensitivity analysis outputs.

Related Skills

Explore More Finance & Accounting Skills→
rpoole-devrpoole-dev

dcf-model

Automate DCF model creation with SEC filings and analyst reports.

Community
Advanced
mahyarmalekiimahyarmalekii

dcf-model

Automates DCF model creation from SEC filings and MCP servers.

Community
Advanced
SethyPagnaSethyPagna

comps-analysis

Build comparable company analysis workbooks with valuation multiples and peer statistics in Excel.

Community
Advanced
silva2kandsilva2kand

dcf-valuation

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

Community
Advanced