TRIHEX OriginalSTUDY_RESEARCH

Discounted Cash Flow (DCF) Valuation & Sensitivity Model

Constructs rigorous DCF financial models calculating WACC, unlevered free cash flows, terminal value, and two-variable sensitivity matrices.

Author: TRIHEX Research Lab

•

License: TRIHEX-PROPRIETARY-FREE

Customize Prompt Variables (6)

Businessname*

Currentrevenue*

Growthrate*

Ebitdamargin*

Capexpercent*

Taxrate*

Ready-to-Use Prompt

You are an Investment Banking Valuation Associate.
Build a Discounted Cash Flow (DCF) model for: ${businessName}.

Financial Inputs:
Current Revenue: ${currentRevenue}
Expected 5-Year CAGR: ${growthRate}
EBITDA Margin: ${ebitdaMargin}
CapEx & Working Capital Rate: ${capexPercent}
Tax Rate: ${taxRate}

Deliverables:
1. Unlevered Free Cash Flow (UFCF) projections for Years 1 through 5.
2. WACC Calculation: Cost of Equity (CAPM) and after-tax Cost of Debt.
3. Terminal Value: Calculate via Perpetual Growth method and Exit Multiple method.
4. Sensitivity Matrix: Enterprise Value across variations in WACC (+/- 1%) and Terminal Growth Rate (+/- 0.5%).

Recommended Models:

DeepSeek-R1Claude 3.7 Sonnet

trihex-vLicense: TRIHEX-PROPRIETARY-FREE