Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    Dcf Valuation Excel

    1

    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

    6 usesSecurity scanned
    Dcf Valuation Excel

    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. 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. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 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

    Listed3 months ago

    What's inside

    Frequently Asked Questions

    The skill generates a professional, multi-sheet Excel workbook featuring a dynamic Assumptions tab, NOPAT-based Free Cash Flow projections, WACC calculations via CAPM, and a sensitivity matrix for terminal growth.

    This skill is designed for use with AI agents that have file-generation capabilities, specifically those supporting Excel (.xlsx) output. It works best with agents that can process financial data inputs to populate the model's historical fields.

    Unlike generic AI prompts that often produce flat, broken formulas, this skill enforces strict financial modeling integrity, ensuring all projections are dynamically linked to assumptions without hardcoded logic in the calculation cells.

    Yes, the model is fully editable; it generates standard Excel formulas and VBA (where applicable) so you can manually adjust inputs or add custom line items once the file is generated.

    The skill is optimized for established companies with predictable cash flows; it is not recommended for pre-revenue startups or highly cyclical industries where traditional Gordon Growth terminal value methods may not apply.

    You will need to provide the target company's historical revenue, debt levels, tax rates, and basic capital structure data for the agent to accurately populate the initial Assumptions sheet.

    New in Finance & Accounting

    Free