Number
1
1
2
2
3
3
4
4
5
5
6
6
7
7
Drag to adjust the number of frozen columns
Notes
Link
Used formulas from FIRE Master Spreadsheet, u/mikhial, Reddit
https://www.reddit.com/r/financialindependence/comments/4p4s4q/fire_spreadsheet_with_mint_integration/
Since NPER (Excel) doesn't exist on AirTable, had to determine the manual formula. Used this breakdown.
https://www.techrepublic.com/forums/discussions/the-real-math-behind-excel-formulas/
And used this for specific definitions.
https://exceljet.net/excel-functions/excel-nper-function
Solved the modified equation on here to get the FIRE ETA
https://www.symbolab.com/solver/solve-for-equation-calculator/solve%20for%20n%2C%20P%5Ccdot%5Cleft(%5Cleft(1%2BR%5Cright)%5E%7Bn%7D%5Cright)%2Bm%5Cleft(1%2BR%5Cright)%5Ccdot%5Cfrac%7B%5Cleft(%5Cleft(%5Cleft(1%2BR%5Cright)%5E%7Bn%7D%5Cright)-1%5Cright)%7D%7BR%7D%2BF%3D%3D0
Since ln function does not exist in AirTable, had to use a Log conversion.
https://sciencing.com/convert-ln-log-10-8359505.html
[need to add graphics and walkthrough for ease of use, coloring of manual-entry cells, and graphs. Free version doesn't allow further development. This would be a good place for someone to continue the project. I'd love a message about the end result!]
ALTERNATIVE WAY TO USE THIS: If you track all your real monthly expenses elsewhere (such as YNAB or Mint), you can delete the rows in the [Budget] tab and just summarize your monthly expenses from your other app.
7 records

Alert

Lorem ipsum
Okay