DISCOUNTED CASH FLOW CALCULATOR
The Discounted Cash Flow (DCF) method is a fundamental financial analysis technique used to estimate the value of an investment based on its expected future cash flows. By calculating the present value of these cash flows, investors can make informed decisions about whether to invest in a project or company. This method is widely used in corporate finance, investment banking, and real estate to assess potential investments. In this article, we will guide you through the process of calculating DCF manually, providing you with the essential steps and formulas needed for accurate valuation.
DCF CALCULATOR
Cash Flows
How to Calculate DCF Manually
Calculating the Discounted Cash Flow (DCF) manually involves several steps that require careful attention to detail. Here’s an in-depth guide to help you through the process:
Step 1: Estimate Future Cash Flows
The first step in the DCF calculation is to estimate the future cash flows that the investment is expected to generate. This typically involves projecting cash flows over a specific time horizon, often 5 to 10 years. Consider factors such as revenue growth, operating expenses, taxes, and changes in working capital.
Example: If you expect an investment to generate cash flows of $10,000 in Year 1, $12,000 in Year 2, and $15,000 in Year 3, these figures will be your future cash flows.
Step 2: Determine the Discount Rate
The discount rate reflects the risk associated with the investment and is often based on the company’s weighted average cost of capital (WACC). The WACC accounts for both equity and debt financing costs. A higher discount rate indicates greater risk and reduces the present value of future cash flows.
Example: If your calculated WACC is 8%, this will be your discount rate.
Step 3: Calculate Present Value of Future Cash Flows
Using the estimated cash flows and the discount rate, calculate the present value (PV) of each future cash flow using the formula:
Where:
- CF = Cash flow for each year
- r = Discount rate (as a decimal)
- = Year number
Example Calculation:
Step 4: Sum All Present Values
Total PV = 9,259.26 + 10,290.57 + 11,887.43 = 31,437.26
Step 5: Analyze Terminal Value (if applicable)
If your analysis extends beyond your projection period (e.g., beyond Year 3), you may need to calculate a terminal value using either the perpetuity growth model or an exit multiple approach.
Where:
- CFn+1 = Cash flow in the year following the last projected year (Year n)
- r = Discount rate
- g = Growth rate beyond year n
This formula is used to calculate the terminal value of an investment when cash flows are expected to continue indefinitely at a stable growth rate.