Hello!
I’m building a personal finance dashboard for myself and want to include a simple forecast model.
At the minimum, I need an input for “base annual income”, and “income growth rate” to forecast how annual income would increase over n years.
The math would be:
- (1+growth rate)^n * base annual income
I don’t know how to do this so that it auto-calculates (assuming that is possible). Maybe I could manually do a calculation for each year in the forecast, but that seems really inefficient, there must be a better way for it to auto-calculate?
Thanks in advance if you can help!
Drew