SmartHelping / Business Valuation / Excel
Gordon Growth Valuation Excel Template
Explore the present value of a business's future cash flows under a constant long-term growth assumption. Set the starting amount and perpetual growth rate, then compare the valuation across up to four discount rates.
Use the comparison chart to see how the selected discount rate changes the result and understand the assumptions behind a growing-perpetuity valuation.
Immediate download after purchase. By purchasing, you agree to the Terms of Service.
Template walkthrough
See how growth and discounting affect value.
Watch the overview to explore the starting input, growth assumption, discount-rate comparison, and valuation chart.
Valuation features
Connect the starting amount, growth rate, and discount rate.
A focused Excel template for exploring constant-growth valuation and comparing the effect of different discount-rate assumptions.
NOI or EBITDA starting input
Use the most recent net operating income as the starting amount. The template also allows EBITDA as an alternative earnings base for the analysis.
Perpetual growth assumption
Set the long-term growth rate used to project the starting amount forward under a constant-growth assumption.
Discounted future values
Apply a discount rate to future projected amounts to express their value in today's terms.
Growing-perpetuity analysis
Explore the combined present value of the projected stream under the model's perpetual-growth assumptions.
Compare up to four discount rates
Review valuation outcomes using up to four discount rates to see how the selected rate affects the estimate.
Visual valuation comparison
Use the included chart to compare valuations relative to the discount rates applied.
Understanding the method
Value a continuing stream under a constant-growth assumption.
The model projects the starting amount forward at a constant long-term growth rate and discounts the projected amounts back to present value. It then combines those discounted values into a valuation estimate.
For a finite growing-perpetuity value, the discount rate must exceed the perpetual growth rate. As the two rates move closer together, the valuation becomes increasingly sensitive to small changes in either assumption.
The starting input also matters. NOI and EBITDA can serve as earnings proxies in this template, but neither automatically equals free cash flow. Interpret the output on the basis of the amount and discount rate you choose.
How to use the template
Build the valuation and compare the rate assumptions.
-
Choose the starting amount
Enter the most recent net operating income or use EBITDA as the alternative earnings base, keeping the basis of your analysis clear.
-
Set the long-term growth rate
Choose the constant growth assumption that will apply to the projected stream into perpetuity.
-
Enter the discount rates
Compare up to four discount-rate assumptions. Keep each rate above the perpetual growth rate for a finite growing-perpetuity valuation.
-
Review the values and chart
Compare the valuation outcomes and use the chart to see how much the discount-rate choice changes the result.
Included in the valuation bundle
Explore more valuation methods in one collection.
This Gordon Growth Model is included in the Valuation and DCF Analysis Bundle.
Valuation and DCF Analysis Bundle
Explore spreadsheets for business valuation, discounted cash flow, acquisition analysis, discount rates, and investment returns.
Explore the bundle →Cash flow, investment returns, and forecasting
Explore supporting financial models.
Compare cash-flow scenarios, discount rates, interest payments, target returns, and a SaaS operating forecast.
5-Year SaaS Startup Model
Forecast four subscription tiers, optional signup fees, customer growth, churn, financing, financial statements, and acquisition metrics over five years.
View template details →Interest Rate Swap Financial Model
Compare fixed and floating interest payments, payment timing, and the accumulated present value of each leg under your rate assumptions.
View template details →Monthly DCF Analysis
Analyze up to 120 monthly cash-flow periods with NPV, monthly and annual IRR, ROI, and equity-multiple outputs.
View template details →DCF Analysis with Sensitivity Tables
Compare cash-flow NPV across six discount rates and up to four scenarios, alongside IRR results and charts.
View template details →IRR Target Investment Analysis
Calculate the final distribution needed to reach a target IRR after accounting for investments and interim distributions.
View template details →WACC Calculator
Calculate weighted average cost of capital from debt, equity, tax, and market assumptions, then connect it to DCF analysis.
View template details →Common questions
Before you build your constant-growth valuation.
What starting input does the template use?
The template uses the most recent net operating income to start the growth and discounting calculations. EBITDA can also be used as an alternative earnings base. These inputs are proxies and are not automatically equivalent to free cash flow.
How many discount rates can I compare?
You can compare up to four discount rates. The included chart shows the valuation relative to the rate applied.
What does perpetual growth mean?
It means the model assumes the projected stream continues indefinitely at a constant growth rate. The estimate depends on that long-term assumption and the discount rate used.
Can the growth rate equal or exceed the discount rate?
The standard growing-perpetuity calculation requires the discount rate to be higher than the growth rate. If that condition is not met, the positive projected stream does not converge to a finite present value.
Can the method be applied to SaaS customer value?
The growth-and-discounting approach can help explore the present value of customer cash flows relative to customer acquisition cost. For that application, use customer cash-flow assumptions suited to the analysis and consider whether a perpetual-growth assumption is appropriate.
Is this template included in a bundle?
Yes. It is included in the Valuation and DCF Analysis Bundle linked above.
When can I download the template?
The Excel template is available to download immediately after purchase.
Make the valuation assumptions visible
See how growth and discount rates shape the estimate.
Explore a constant-growth valuation and compare up to four discount rates in Excel. Need a tailored model? Contact Jason.