I would like to build an app for creating financial projections. i.e. adding revenue streams and cost items and (e.g. salaries) and then calculating them for each month and calculate the resulting profits on a monthly basis.
Like the one in the picture below:
Has anyone done something similar? I wonder how to best approach the problem in terms of
Structuring the database and how to deal with the time series aspect (eg save a number for every month or calculate them on the fly etc.)
where to perform the calculations (i.e. in bubble or somewhere else like google sheets)
how to best display the data (eg a repeating group or something else?)
The whole thing is pretty straightforward in an excel / google sheet but not sure how to best approach this on bubble as the displayed values are dependent on each other…
I am looking for some basic guidance to point me in the right direction to get started with this - all inputs and ideas are welcome
We have an excel model in which you only enter your sales funnel assumptions and data plus other known costs and also input like hours, price per customer etc and you get your growth or decline for each month, needed capital, cashflow statement, balance for each month and much more.
I asked AI to turn it into a online program with Postgres db. Amazing…
