Growth function in Excel
Posted on 2010-08-13
I'm working on a revenue forecast and have several revenue streams. I'm predicting a different month for stabilization, after which I think a monthly or annual growth rate is appropriate. Until that point in time, though, I expect an exponential growth. For example, memberships are expected to reach 10k per month by month 6, with a 5% growth per month thereafter. I'd like to figure out, via a formula, a quick way to grow the revenue from $0 to $10k per month by month 6, with the ability to change the stabilization month (6 in this case) and Dollar figure ($10k in this case) at the stabilization point. Anyone have any ideas?