DCF Financial Model Builder

Build your discounted cash flow model by defining key assumptions

Risk Profile

Select industry and country to get initial risk parameters

Beta Parameters

0.0000
βU × (1 + (1-T) × D/E)

Risk Premiums & Rates

Calculated Costs

Cost of Equity (Re)
4.44%
Rf + Levered Beta × (ERP + CRP)
Cost of Debt (Rd)
9.44%
Rf + Adj. Default Spread + Company Spread
WACC
4.44%
(E/V × CoE) + (D/V × CoD × (1-Tax))

* Data Source: Professor Aswath Damodaran, NYU Stern School of Business

DCF Financial Model

Click rows to configure • Double-click cells to edit
Financial Projections

Enter 1-20 years

Projecting 5 years from 2025
Line Item2025E2026E2027E2028E2029E
Revenue
Revenue Growth
YoY Growth
Base
-
-
-
-
Cost of Goods Sold
Gross Profit
Gross Margin
Operating Expenses
Other Income
Other Expenses
EBITDA
EBITDA Margin
Depreciation & Amortization
EBIT
EBIT Margin
Taxes
Net Income
Net Income Margin
Capital Expenditures
Net Working Capital
Change in NWC
Free Cash Flow
Discounted Cash Flow
Terminal Value
-
PV of Terminal Value
-
Enterprise Value
-
Equity Value
-
Projection Period: 2025 - 2029
Manual Override25 line items

Model JSON

Click "Show" to preview your model assumptions