Horizon Value Calculator
When evaluating a company’s value using discounted cash flow (DCF) models, most of the total valuation often comes from the horizon value, also known as the terminal value. This metric estimates a business’s value beyond the forecast period into perpetuity, helping investors and analysts make more accurate long-term projections.
Our Horizon Value Calculator simplifies this process by calculating the future value of free cash flows growing at a constant rate beyond a specific horizon date. It's an essential tool for financial analysts, students, and anyone involved in corporate valuation.
Formula
The formula used in this calculator is based on the Gordon Growth Model (also known as the Perpetuity Growth Model):
Horizon Value = FCFₙ × (1 + g) / (r − g)
Where:
- FCFₙ = Free Cash Flow at the end of the projection period (horizon date)
- g = Constant growth rate of cash flows beyond the forecast period
- r = Discount rate or required rate of return
This formula assumes that the business will continue to grow at a steady rate indefinitely after the forecast period.
How to Use the Horizon Value Calculator
Follow these steps:
- Enter the Free Cash Flow at the Horizon Date (FCFₙ)
This is the projected cash flow in the final year of your forecast. - Enter the Discount Rate (r)
Use your required rate of return, expressed as a percentage (e.g., 10 for 10%). - Enter the Growth Rate (g)
This is the expected perpetual growth rate after the horizon year, expressed as a percentage (e.g., 3 for 3%). - Click the "Calculate" button
The calculator will show the horizon value, which you can use in your DCF model.
Example
Let’s consider the following inputs:
- Free Cash Flow at horizon (FCFₙ): $1,000,000
- Discount Rate (r): 10%
- Growth Rate (g): 3%
Plugging into the formula:
Horizon Value = 1,000,000 × (1 + 0.03) / (0.10 − 0.03)
Horizon Value = 1,030,000 / 0.07 = $14,714,285.71
So the business's estimated horizon value is $14.71 million.
FAQs about Horizon Value Calculator
- What is a horizon value?
It’s the estimated value of a business beyond a forecast period, assuming constant growth. - Is horizon value the same as terminal value?
Yes, both terms are used interchangeably in financial modeling. - Why is horizon value important in valuation?
It often represents the majority of a company’s total value in a DCF model. - Can the horizon value be negative?
Not typically. If the discount rate is lower than the growth rate, the formula breaks down. - What’s the difference between enterprise value and equity value?
Horizon value often contributes to enterprise value. Equity value is enterprise value minus debt plus cash. - What happens if the discount rate equals the growth rate?
The formula becomes undefined due to division by zero. Always ensure r > g. - Is the Gordon Growth Model always appropriate?
It works best for mature companies with stable growth, not startups or volatile firms. - Can I use this calculator for real estate valuations?
Yes, if you're projecting constant income growth beyond a specific period. - How is the horizon value used in a DCF model?
It’s discounted back to present value and added to the sum of discounted cash flows. - Can I change the formula for variable growth rates?
This calculator only handles constant growth. For variable growth, a more complex model is needed. - What’s a typical growth rate (g) assumption?
Often between 2% to 4%, aligned with long-term GDP growth. - Is horizon value calculated in future dollars or present value?
It gives a future value, which should then be discounted to present value in a full DCF. - Should inflation be considered in the growth rate?
If using nominal cash flows, yes. Ensure consistency across inputs. - How often should I recalculate horizon value?
It should be recalculated when market assumptions, growth rates, or business projections change. - Is the calculator suitable for public and private companies?
Yes, it works for both as long as you have reasonable forecasts. - Why is my result unusually high?
Double-check that your discount rate is higher than your growth rate. - Can this be used for stock price valuation?
Indirectly yes, when calculating enterprise value and then subtracting debt and dividing by shares. - Is horizon value affected by capital structure?
Yes. If using WACC (Weighted Average Cost of Capital), the capital structure is accounted for. - Can I export the results?
The current version is simple, but you can copy the results or expand it with CSV features. - Is this calculator suitable for academic use?
Absolutely. It's a standard financial model used in textbooks and MBA programs.
Conclusion
The Horizon Value Calculator is a vital tool in corporate finance, enabling users to estimate the future value of a company beyond a detailed forecast period. This long-term value plays a key role in Discounted Cash Flow (DCF) models and often accounts for a significant portion of the total valuation.
By inputting just three variables—cash flow, discount rate, and growth rate—you can quickly determine a firm's terminal value using the widely accepted Gordon Growth Model. Whether you're an investor, student, or finance professional, this calculator is an essential addition to your valuation toolkit.