Using the Gordon growth model to find intrinsic value is fairly simple to calculate in Microsoft Excel. To get started, set up the following in an Excel spreadsheet: Enter "stock price" into cell A2 ...

This works out to be about a 32% compound annual growth rate (CAGR) from the end of its fiscal 2023, which ended in January. For perspective, Snowflake grew its product revenue by 70% in fiscal 2023.

Revenue growth calculates by dividing the end revenue by start, then raising to power of 1/years. The example shows a 3-year compound annual growth rate of 14.5% using exponent and subtraction ...

In Years 1, 2, and 3, ABC’s expected earnings growth exceeds its revenue growth. The change in growth rates will be reflected in the valuation multiple the market is willing to pay for this stock.

The LTGM-TFP is an Excel-based companion to the standard LTGM that helps users assess a country’s potential for improving its TFP growth rate over the next few decades. The LTGM-TFP toolkit combines a ...