Discounted Cash Flow (DCF) Model

Discounted Cash Flow (DCF) Model (Manual Input)

A DCF model is used to estimate the value of an investment based on its expected future cash flows. This tool helps you perform a DCF analysis by inputting key assumptions manually.

Select Currency: INR (₹) USD ($) EUR (€) GBP (£) JPY (¥) CAD (C$) AUD (A$)

Number of Projection Years (1-10):

Enter Financial Data & Assumptions

Scroll horizontally (swipe on mobile) for all input categories.

Base & Projection Assumptions

Most Recent Year's Revenue:

₹

Most Recent Year's EBIT:

₹

Effective Tax Rate: %

D&A (% of Revenue): %

CapEx (% of Revenue): %

Change in NWC (% of Revenue Change): %

Discount Rate (WACC)

Risk-Free Rate: %

Equity Beta (β):

Market Risk Premium: %

---

Pre-Tax Cost of Debt: %

Tax Rate for Debt Shield (if different from income tax): %

---

Market Value of Equity:

₹

Market Value of Debt:

₹

Terminal Value & Final Inputs

Perpetual Growth Rate (g): %

---

Shares Outstanding:

Net Debt (Total Debt - Cash):

₹

Current Market Price per Share (Optional for comparison):

₹

DCF Model Results

Free Cash Flow Projections:

Discount Rate (WACC) Calculation:

Cost of Equity (Ke): -

After-Tax Cost of Debt (Kd): -

WACC: -

Valuation Summary:

PV of Projected FCFFs: -

Terminal Value (at end of projection): -

PV of Terminal Value: -

---

Enterprise Value (EV): -

Equity Value: -

Intrinsic Value per Share: -

Current Market Price: -
Upside/Downside: -

Using the DCF Model:

1. Select your preferred currency and number of projection years.
2. Enter base year financial data and your assumptions for projections (growth rates, margins, etc.). The tool will dynamically create input fields for each projection year's Revenue Growth and EBIT Margin if you want to vary them.
3. Provide inputs for WACC calculation (risk-free rate, beta, market premium, cost of debt, capital structure).
4. Enter assumptions for terminal value (perpetual growth rate) and final valuation (shares outstanding, net debt).
5. Click "Calculate DCF Value". The results will show projected FCFs, WACC, and the intrinsic value.
6. "Load Example Data" populates fields with sample values. "Clear All Fields" resets everything.

Important: The accuracy of a DCF model heavily depends on the quality of your assumptions. This tool is for educational and illustrative purposes. All data must be entered manually.