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.

45 日前に更新セットアップ 1 分未満

概要

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

この Skill の仕組み

DCF Modeler creates venture-focused Discounted Cash Flow valuations for late-stage and growth-stage investment analysis, exit planning, and LP return modeling.

SKILL.mdALPHIO / 検証済み

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

こんな用途に最適

どんなときに使うか

DCF Modeler creates venture-focused Discounted Cash Flow valuations for late-stage and growth-stage investment analysis, exit planning, and LP return modeling.