dcf-model

Build detailed DCF valuation models with financial projections and sensitivity analysis.

Updated May 3, 2026

Search Tags:#financial modeling #cash flow #valuation #DCF #investment analysis #sensitivity #equity

Ready to run

npx skills add https://github.com/sammyTI/dotcompany-template --skill dcf-model-sammyti

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: dcf-model
Source: https://github.com/sammyTI/dotcompany-template/tree/main/plugins/vertical-plugins/financial-analysis/skills/dcf-model
Command: npx skills add https://github.com/sammyTI/dotcompany-template --skill dcf-model-sammyti

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill enables users to build detailed, institution-grade DCF models for accurate company valuation, incorporating financial data retrieval, projections, and sensitivity analysis.

Core Features & Use Cases

Financial Data Integration: Retrieves financial information from SEC filings and analyst reports to inform valuation assumptions.
Comprehensive Cash Flow Modeling: Projects revenue, operating expenses, free cash flows, and terminal value with embedded formulas, supporting scenario analysis.
Use Case: An analyst can generate a full valuation model, including sensitivity tests on WACC and growth assumptions, for potential acquisition targets.

Quick Start

Use the dcf-model skill to generate an Excel financial model that includes detailed projections, terminal value, and sensitivity analysis based on your inputs.

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 discounted cash flow model for company valuation?▼

To build a discounted cash flow model, you project revenue, operating expenses, and free cash flows, then calculate terminal value and apply a discount rate. This Skill generates an Excel model integrating financial data, assumptions, and sensitivity analysis for comprehensive valuation.

Can I run sensitivity analysis on WACC and growth assumptions in a DCF model?▼

Yes, you can run sensitivity analysis on WACC and growth assumptions within the DCF model. This Skill supports scenario testing by embedding formulas across projected cash flows and terminal value, allowing investment analysts to evaluate valuation impacts.

Does this DCF model integrate financial data from SEC filings?▼

Yes, the DCF model integrates financial data from SEC filings and analyst reports. It retrieves this information to inform your valuation assumptions, ensuring the projected cash flows and terminal value calculations are based on accurate financial data.

What is the best way to generate an Excel financial model for investment analysis?▼

The best way to generate an Excel financial model for investment analysis is using a DCF Skill that outputs detailed projections and sensitivity analysis. It provides institution-grade valuation by retrieving financial data and embedding formulas for free cash flow and terminal value.

Can I use openpyxl to export DCF valuation outputs to Excel?▼

Yes, you can use openpyxl to export DCF valuation outputs to Excel. This Skill relies on openpyxl as a dependency to generate the financial model file, populating it with detailed projections, terminal value calculations, and sensitivity analysis.

DCF model not capturing terminal value correctly, what are the limitations?▼

If your DCF model is not capturing terminal value correctly, check the embedded formulas and growth assumptions. Limitations depend on the accuracy of retrieved financial data and your scenario inputs, so ensure SEC filing integrations and WACC sensitivity parameters are correctly configured.