DCF Valuation Builder for M&A Analysis
Build institutional-grade DCF models with WACC, scenarios, and audit-ready assumptions
What You Can Do
You'll build comprehensive DCF models that automate explicit forecast periods, terminal value calculations, and weighted average cost of capital derivation. The skill produces audit-ready assumption documentation, multi-scenario sensitivity tables, and valuation ranges across bear/base/bull cases—all formatted for board presentations and fairness opinions. You'll stress-test equity value assumptions and compare DCF outputs to trading multiples and M&A precedent data.
Features
derives risk-free rate, equity risk premium, beta, and blended cost of debt to establish discount rates
builds bear, base, and bull case projections with distinct revenue growth, margin, and exit assumptions
stress-tests equity value across revenue growth, EBITDA margin, and terminal growth rate ranges
calculates perpetuity growth and exit multiple methods with clear assumption documentation
generates assumption documentation with source citations for each input (comparables, historical, market data)
delivers low/mid/high equity value estimates with confidence intervals for IC review
bridges DCF valuation to trading multiples and M&A precedent comparisons
Example Output
DCF Model Summary (Target: Tech Acme Inc.)
Base Case Valuation: $450M
- Bear Case: $380M (conservative margins, higher WACC)
- Bull Case: $520M (market share gains, lower terminal rate)
WACC Calculation:
- Risk-free rate: 4.5% | Equity risk premium: 6.2% | Beta: 1.1 | Cost of equity: 11.2%
- After-tax cost of debt: 3.8% | Weight equity/debt: 80%/20% | WACC: 9.4%
Sensitivity Table (Equity Value $M):
| Revenue CAGR | 3% WACC | 4% WACC | 5% WACC |
|---|---|---|---|
| 8% | $485 | $450 | $420 |
| 10% | $540 | $502 | $468 |
| 12% | $595 | $555 | $515 |
Key Assumptions (Auditable):
- Explicit forecast: 5 years | Terminal growth: 2.5% | Exit multiple: 12.5x EBITDA (median precedent)
- Revenue CAGR assumptions tied to 3-yr historical trend + market growth analysis
What's Included
- SKILL.md: complete DCF model framework and workflow instructions
- DCF Model Template: pre-structured Excel/spreadsheet skeleton with formula scaffolding
- WACC Calculation Worksheet: input guide for cost of equity, cost of debt, and capital structure derivation
- Sensitivity Analysis Grid: two-way sensitivity table templates (revenue growth × WACC, margin × terminal rate)
- Assumption Documentation Checklist: audit trail template mapping each input to source (comparables, financials, market data)
- Scenario Case Builder: bear/base/bull case setup guide with margin and growth variance logic
Who It's For
- M&A Analysts — valuation professionals building DCF models for acquisition targets and fairness opinions
- Investment Bankers — advisors preparing pitch books and valuation support for client presentations
- Private Equity Associates — deal teams stress-testing acquisition economics and LBO entry assumptions
- Corporate Development Managers — in-house teams evaluating strategic acquisition targets and synergy scenarios
- Equity Research Analysts — sell-side professionals producing intrinsic value estimates and target price updates
Best For
- Acquisition target valuation and fairness opinion preparation
- Multi-scenario DCF modeling with sensitivity stress-testing across 3–5 year explicit forecast periods
- WACC derivation and discount rate benchmarking for institutional credibility
- Assumption documentation and audit trail creation for investment committee and board review
- Valuation range anchoring (DCF vs. trading multiples vs. M&A precedent comparison)
- Deal economic analysis with bear/base/bull case equity value reconciliation
You might also like
You systematically evaluate bank proposals against standardized criteria, uncovering pricing structures and covenant terms that impact your treasury strategy. The framework helps you compare commitment fees, arrangement fees, and facility structures across multiple term sheets, then generates data-backed talking points for renegotiating existing arrangements and consolidating redundant banking relationships.
by fastclaw-ai
You can conduct multi-scenario covenant stress testing to quantify financial headroom between current metrics and covenant thresholds, identify which covenants are most vulnerable to market downturns, and calculate the cost-benefit of proactive amendments versus reactive refinancing. This enables you to report covenant health to leadership with actionable mitigation strategies before breach risk materializes.
by fastclaw-ai
You'll construct defensible, driver-based revenue forecasts that link operational metrics (customer count, contract value, churn, win rates) directly to revenue outcomes. Claude helps you build base, upside, and downside scenarios with transparent assumptions, perform sensitivity analysis to quantify business variable impacts, and automatically document variance explanations—enabling you to respond confidently to CFO and board-level scrutiny.
by fastclaw-ai
You can build comprehensive deal execution timelines that map interdependencies across all workstreams—legal, regulatory, financing, and operations—and automatically flag risks that could delay closing. The skill identifies which delays actually impact your close date versus minor slippage, creates decision trees for contingency scenarios, and generates stakeholder-ready reports for boards, lenders, and sponsors. You turn raw deal data into a living, weekly-updated source of truth for deal execution status.
by fastclaw-ai
You can build 12-month rolling forecast models that automatically drop the oldest completed month and add a new forward month as actuals close each period. The skill calculates budget variances (favorable/unfavorable) with root cause drivers, reforecasts remaining quarters based on current spending patterns and run-rate assumptions, and generates executive dashboards highlighting key budget risks and opportunities before they become serious overruns.
by fastclaw-ai
You can generate a focused, investor-ready one-page startup plan that captures your business model, target market, revenue streams, and competitive advantage. Claude asks clarifying questions about your idea, validates key assumptions, and produces a structured document you can use for pitches, investor meetings, or internal alignment.
by fastclaw-ai
This skill converts unstructured cash position data—bank balances, payables, receivables, and scheduled transactions—into structured liquidity analysis with clear decision frameworks. You'll identify liquidity gaps before they create operational friction, distinguish between structural and transactional funding needs, and receive specific recommendations for cash movements, investment opportunities, and contingency planning across multiple currencies and operational time zones.
by fastclaw-ai
Create a structured one-page business model that captures your core value proposition, revenue model, and key partnerships. You will define your riskiest assumptions, design an MVP with prioritized features, and build a customer discovery roadmap with interview templates and validation experiments. This approach helps you move from theory to validated learning before investing significant resources.
by fastclaw-ai