Fundamentals & Valuation
dcf-modeler
DCF Modeler creates venture-focused Discounted Cash Flow valuations for late-stage and growth-stage investment analysis, exit planning, and LP return modeling.
Overview
DCF Modeler creates venture-focused Discounted Cash Flow valuations for late-stage and growth-stage investment analysis, exit planning, and LP return modeling.
DCF Modeler creates venture-focused Discounted Cash Flow valuations for late-stage and growth-stage investment analysis, exit planning, and LP return modeling. Key features include detailed operating cash flow projections (revenue build-up, margin modeling, capex, and working capital), modeling the transition from loss-making to steady-state, and configurable projection horizons (5–10 years). It computes appropriate discount rates, including WACC and venture-adjusted cost of equity with stage and risk premiums, and estimates terminal value using exit multiples, perpetuity growth, or hybrid methods with built-in sanity checks. Integrated sensitivity analysis produces tables, scenario matrices, and tornado charts to quantify the impact of key drivers. Use it to generate transparent valuation outputs, methodology notes, terminal-value concentration metrics, and investor-ready tables and charts for diligence, fundraising, and exit planning.
Skill.md
How this skill works
DCF Modeler creates venture-focused Discounted Cash Flow valuations for late-stage and growth-stage investment analysis, exit planning, and LP return modeling.
DCF Modeler
Overview
The DCF Modeler skill builds Discounted Cash Flow valuation models for venture capital analysis. While DCF is less common for early-stage VC, it supports late-stage growth investments, exit analysis, and LP return modeling where cash flow projections are meaningful.
Capabilities
Cash Flow Projection
- Project operating cash flows
- Model capital expenditure requirements
- Estimate working capital changes
- Handle loss-making growth phase transitions
Discount Rate Calculation
- Calculate WACC for appropriate structures
- Apply venture-appropriate discount rates
- Adjust for stage and risk profile
- Model cost of equity with VC premiums
Terminal Value Estimation
- Calculate terminal value via exit multiple
- Apply perpetuity growth method
- Hybrid terminal value approaches
- Terminal value sanity checks
Sensitivity Analysis
- Build sensitivity tables
- Model key assumption impacts
- Calculate value driver sensitivities
- Create scenario matrices
Usage
Build DCF Model
Input: Financial projections, assumptions
Process: Build cash flow model, calculate value
Output: DCF valuation, model outputs
Calculate Discount Rate
Input: Company profile, capital structure
Process: Calculate appropriate discount rate
Output: WACC/discount rate, methodology notes
Estimate Terminal Value
Input: Terminal year financials, exit assumptions
Process: Calculate terminal value
Output: Terminal value, percentage of total value
Run Sensitivity Analysis
Input: Base case model, sensitivity parameters
Process: Calculate sensitivities across ranges
Output: Sensitivity tables, tornado charts
DCF Components
| Component | VC Considerations |
|---|---|
| Projection Period | 5-10 years to steady state |
| Discount Rate | 20-40%+ for early stage |
| Terminal Value | Often 60-80%+ of total value |
| Cash Flows | May be negative for years |
| Exit Multiple | Primary terminal method |
Integration Points
- DCF Analysis Process: Core modeling skill
- Financial Model Validator: Validate model inputs
- Multiple Calculator: Terminal value multiples
- Sensitivity Analyst (Agent): Support analysis
Discount Rate Considerations
| Stage | Typical Discount Rate |
|---|---|
| Seed | 40-60% |
| Series A | 35-50% |
| Series B | 30-40% |
| Growth | 20-30% |
| Late Stage | 15-25% |
Best Practices
- DCF is supplementary for early-stage VC
- Use realistic projections, not hockey sticks
- Heavily weight terminal value sensitivities
- Consider probability-weighted scenarios
- Triangulate with VC method and comparables
Best used for
When to use it
DCF Modeler creates venture-focused Discounted Cash Flow valuations for late-stage and growth-stage investment analysis, exit planning, and LP return modeling.
01 · PRE-MEETING
Prepare a decision brief
Turn scattered evidence into a structured case before an investment committee meeting.
02 · TEAM WORKFLOW
Standardize handoffs
Create consistent research outputs across analysts, portfolio managers, and agents.
03 · LIVE UPDATE
Refresh the thesis
Update scenarios after a new catalyst, KPI release, or earnings result.
Community notes
Built to improve with use.
随着 Skill 被使用与评审，反馈将展示在这里。
Discover more
Related skills
View allIndustry Primer
Analyze an industry's structure, profit pools, key players, supply chain, and regime drivers. Use when starting research on an industry, mapping market structure, or framing sector-level opportunity…
Bear Case Builder
Stress test consensus with bearish counter-narratives, failure modes, and probability-severity analysis. Use when building downside cases, short theses, or risk scenarios against a bullish narrative.
Business Model Comp Matching
Match a company to the right peer set by business model, revenue mix, margin structure, and economics. Use when standard comp sets are misleading or when the user asks for more precise peer selection.