The Simple Investment Calculator can help you find out if you’re on track with your investment goals and what changes you can make to reach them.
My personal finance goals revolve around how much I can save, but I wanted to know how impactful my savings contributions were. Should I prioritize one investment account over the other? How much does my spouse need to increase his 401K contributions by to reach our goals?
Previously I would fill my sheet to get the latest balances, then navigate to another website to use an investment calculator, then back and forth between that site and my sheet to input how much I was saving in each account and what my future values would be.
I eventually got tired of this and wanted to just have the future value calculations directly in my sheet. I started with some formulas and wanted to keep it dynamic so when sharing the sheet with my spouse, he can input some “what if” numbers without the fear of breaking anything.
I enlisted @randy to help me connect the sheet to my accounts and balances then a zoom call later it has a graph and is ready to share with the Tiller Community!
The Simple Investment Calculator is now available for free in the Tiller Community Solutions add-on for Google Sheets.
Use the Years to Chart drop down to select the amount of years you want to see your values calculated through.
In the Tiller Linked Accounts section, you can select one of your Tiller accounts from the drop down in the Account section to pull in your most recent balance.
If you want to see the future value of a manual account, you can enter those balance amounts below in the Manually-entered Accounts section.
Then, enter your monthly contribution amounts, the year you expect to contribute these amounts through, your average rate of return (or you can use the min and max to create a range), and there’s your future value!
The graph shows the average future value amounts for each of the accounts you’ve entered alongside a Total line.
Future value calculations are based on payments made at the end of the period.
The graph requires an entry in the “Avg RoR” for an account to be displayed.
This template can only compute positive amounts entered for the rate (RoR).