Forum Academy Marketplace Showcase Pricing Features

How to structure data types to build forecast model (personal finance)?


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!