- Home
- Skills
- Finance & Accounting
- Dcf Valuation Excel
Works with the AI Agents you already use
Dcf Valuation Excel
Build an institutional-quality DCF valuation in Excel: project revenue, build free cash flow from EBIT through NOPAT, D&A, capex and working capital, compute WA
Free
Dcf Valuation Excel
Example session with this skill installed
Build a 5-year DCF model for a SaaS company with $50M revenue, 15% growth, 25% EBIT margin, 8% WACC, and 2% terminal growth. Include a sensitivity table.
- Read your context and instructions
- Compiled the dcf valuation excel
Workbook structure generated
- Assumptions: Rev Growth (15%), EBIT Margin (25%), Tax (21%).
- FCF Bridge: NOPAT + D&A - Capex - ΔNWC.
- Valuation: TV = Year 5 FCF * (1.02) / (0.08 - 0.02).
- Sensitivity: 2-variable data table for WACC (7-9%) vs Terminal Growth (1-3%).
Connects securely to your tools. The creator never sees your data.
About this skill
The problem
Building a discounted cash flow model from scratch is prone to hardcoding errors and circular references. Manually bridging EBIT to Free Cash Flow while managing WACC sensitivities across multiple sheets is tedious and easy to break.
What it does
- Generates a multi-sheet Excel architecture including Assumptions, Projections, FCF, WACC, and Valuation.
- Builds a complete FCF bridge calculating NOPAT, D&A, Capex, and Net Working Capital changes.
- Calculates WACC using CAPM for equity and tax-shielded cost of debt based on target capital structures.
- Computes Enterprise Value and Equity Value per share using Gordon Growth for terminal value.
- Automates a two-variable sensitivity table for WACC and terminal growth rates.
Frameworks & tools
Microsoft Excel, VBA/Macros, Financial Modeling best practices.
Why this beats prompting it yourself
Generic prompts often result in flat lists or simplified math that ignores NOPAT and NWC adjustments. This skill enforces institutional-grade linking, ensuring every projection cell traces back to a central Assumptions sheet without hardcoded values in the logic.
Use cases
- Preparing valuation models for M&A support or investment memos.
- Stress-testing a company purchase price against varying WACC assumptions.
- Internal budgeting and long-term financial planning against valuation targets.
- Generating sensitivity matrices for equity research reports.
Known limitations
Not suitable for early-stage startups without revenue history or highly cyclical businesses with unpredictable cash flows. Requires manual entry of historical revenue and debt figures.
Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Finance & Accounting.
Requires manual input for historical financials and debt levels. Not intended for early-stage companies with no revenue or highly cyclical industries where FCF is not an anchored metric.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before buying a skill.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
6 uses
Times used to date
Free to use
No account required to browse
Trust & safety
Security scan
Security scan passed 3 months ago
- Free with an Agensi account
Permissions
No special permissions declared or detected