Discounted Cash Flow Calculator DFC

Company Letterhead

{{company_name}}

{{company_address}}

Phone: {{phone}}

Email: {{email}}

Website: {{website}}

Introduction to Discounted Cash Flow (DCF)

The Discounted Cash Flow (DCF) method is a valuation technique used to estimate the attractiveness of an investment opportunity. DCF analysis uses future free cash flow projections and discounts them to arrive at a present value estimate, which is used to evaluate the potential for investment.

Key Assumptions

This DCF model relies on several key assumptions. Please review and adjust these assumptions based on your specific business and market conditions.

1. **Discount Rate (WACC):** {{discount_rate}}%

2. **Terminal Growth Rate:** {{terminal_growth_rate}}%

3. **Forecast Period:** {{forecast_period}} years

Revenue Projections

Projected annual revenues for the forecast period:

Year 1: {{revenue_year_1}}

Year 2: {{revenue_year_2}}

Year 3: {{revenue_year_3}}

Year 4: {{revenue_year_4}}

Year 5: {{revenue_year_5}}

Operating Expenses Projections

Projected annual operating expenses (excluding depreciation) for the forecast period:

Year 1: {{op_expenses_year_1}}

Year 2: {{op_expenses_year_2}}

Year 3: {{op_expenses_year_3}}

Year 4: {{op_expenses_year_4}}

Year 5: {{op_expenses_year_5}}

Capital Expenditures (CAPEX) Projections

Projected annual capital expenditures for the forecast period:

Year 1: {{capex_year_1}}

Year 2: {{capex_year_2}}

Year 3: {{capex_year_3}}

Year 4: {{capex_year_4}}

Year 5: {{capex_year_5}}

Changes in Working Capital Projections

Projected annual changes in net working capital:

Year 1: {{nwc_change_year_1}}

Year 2: {{nwc_change_year_2}}

Year 3: {{nwc_change_year_3}}

Year 4: {{nwc_change_year_4}}

Year 5: {{nwc_change_year_5}}

Calculation of Free Cash Flow (FCF)

Free Cash Flow (FCF) = EBIT (1 - Tax Rate) + Depreciation - CAPEX - Change in Working Capital

Tax Rate: {{tax_rate}}%

Year 1 FCF: {{fcf_year_1}}

Year 2 FCF: {{fcf_year_2}}

Year 3 FCF: {{fcf_year_3}}

Year 4 FCF: {{fcf_year_4}}

Year 5 FCF: {{fcf_year_5}}

Terminal Value Calculation

The Terminal Value (TV) represents the value of the free cash flows beyond the explicit forecast period. It is calculated using the Gordon Growth Model.

Terminal Value = (FCF in last forecast year * (1 + Terminal Growth Rate)) / (Discount Rate - Terminal Growth Rate)

Calculated Terminal Value: {{terminal_value}}

Net Present Value (NPV) Calculation

The Net Present Value (NPV) is the sum of the present values of individual free cash flows and the present value of the terminal value. It represents the intrinsic value of the investment.

Calculated Net Present Value: {{npv}}

Conclusion

Based on the inputs and assumptions provided, the estimated intrinsic value of the investment is {{npv}}. This value should be considered in conjunction with other financial metrics and qualitative factors for a comprehensive investment decision.

Signature Block

________________________

{{analyst_name}}

{{analyst_title}}

{{date}}