< All Topics

Sales growth example

I want to have sales in the model, and I want it to grow by 5% per year. How do I do that?

The correct answer is: 1. Add [Sales growth factor] and [Annual sales growth rate] to your model.
2. Set [Sales growth factor] = IF([Period number]=1,1,PREVIOUSVALUE() * (1 + [Annual sales growth rate]) ^ (1/[Periods per year]) )
3. Set [Annual sales growth rate] to 5%
4. Set [Sales]=[Base period sales] * [Sales growth factor]

Leave a Reply