I'm trying to apply an annual growth rate to my model. The way I have done it so far it works but after I set the Growth Rate assumption above 25%, when I calc. the actual rate it's above 25%.
Attached is a WB with a better explanation. I think it's a common math issue. I need to apply to growth rate to the previous months value.
ExcelForumPost.xlsm
Bookmarks