What is the formula for calculating constant-growth model using excel?
New number divided by old number minus one. Example: year one
sales were 200, year two sales were 300. Year two's growth over
year one is 300/200-1, which equals .5, or expressed as a
percentage, 50%. yt=y0(1+g)t