Explaining Gordon Growth Model for Valuation (Excel Template)

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.

Constant-growth valuation Up to 4 discount rates Valuation comparison chart Excel download
Gordon Growth business valuation illustration
$45 One-time purchase / Excel download
Add to Cart

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.

  1. 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.

  2. Set the long-term growth rate

    Choose the constant growth assumption that will apply to the projected stream into perpetuity.

  3. 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.

  4. 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.

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.

Get the Excel Template — $45