# Financial Model **URL:** \ **Category:** App Organization\ **Created:** [June 25, 2021, 2:07pm UTC](https://forum.bubble.io/t/financial-model/157373 "2021-06-25T14:07:43Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![d9999](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/d9999/32/95645_2.png) [@d9999](https://forum.bubble.io/u/d9999)\ **Post date:** [June 25, 2021, 2:07pm UTC](https://forum.bubble.io/t/financial-model/157373/1 "2021-06-25T14:07:43Z")
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: ![image](https://us1.discourse-cdn.com/bubble/original/3X/f/b/fbaa428c092d08527a03442a9d0f61a7a8d986d2.png) 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 🙂 ---
**Author:** ![Bubbleboy](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/bubbleboy/32/19512_2.png) [@Bubbleboy](https://forum.bubble.io/u/Bubbleboy)\ **Post date:** [June 25, 2021, 3:31pm UTC](https://forum.bubble.io/t/financial-model/157373/2 "2021-06-25T15:31:54Z")
> [@fire \[PLUGIN RELEASE\] Advanced Dynamic Tables for Bubble (Excel-like)](http://forum.bubble.io/t/plugin-release-advanced-dynamic-tables-for-bubble-excel-like/145600): > > rocket Populate your table with data and update data dynamically at any time. Update any table’s option dynamically without page reloads. Includes sorting, search and filtering data out of the box. Check our demo to see it in action! Plugin uses latest DataTables library ([https://datatables.net](https://datatables.net/)) under the hood . fire Some features: Two styling themes Conditional formatting artRow selection Columns reordering Populate your table with data dynamically at any time without page reloa… ---
**Author:** ![BubbleSam](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/bubblesam/32/85699_2.png) [@BubbleSam](https://forum.bubble.io/u/BubbleSam)\ **Post date:** [June 25, 2021, 3:45pm UTC](https://forum.bubble.io/t/financial-model/157373/3 "2021-06-25T15:45:29Z")
Thank you @Bubbleboy for sharing this! @d9999 you could also try out this one: > [@pencil2 Editable Tables with Formulas / Online Spreadsheet](http://forum.bubble.io/t/editable-tables-with-formulas-online-spreadsheet/150132): > > Online spreadsheet / Excel like tables for Bubble supporting formulas and multiple data types pencil2 Check the demo pages to see it in action! fire Easy to use plugin with advanced settings: Can be used like a static read-only or editable table Create professional Excel-like and Google Sheets-like spreadsheets Formulas support Powerful cells. It can contain text, html, number, image, checkbox, radio button, dropdown, calendar… Cells HTML code support Export data to CSV Context menu s… It supports inline editing and basic formulas 🙂 ---
**Author:** ![sem](https://avatars.discourse-cdn.com/v4/letter/s/59ef9b/32.png) [@sem](https://forum.bubble.io/u/sem)\ **Post date:** [January 18, 2025, 8:19pm UTC](https://forum.bubble.io/t/financial-model/157373/7 "2025-01-18T20:19:22Z")
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…