Yes, i can see it now. Thanks.
It looks very extensive!
- Investment Growth Rate - I would prefer multiple growth rate scenarios at the same time.
- Taxes - Either way would be fine, but if there was an annual manual rate, it would be good to have a way to default that to a global rate.
- Other features - Monte Carlo projections or facilitate integration with other MC tools. This is a good example (https://www.portfoliovisualizer.com/financial-goals)
Interesting, @blarue001… I totally agree that running scenarios is a core use of this tool. Our thought was that the scenarios could be configured & run by checking/unchecking life events in the
Where can I find the Fire sheet? Or is it just the cash flow one?
If you are going to add RMD for IRA withdrawals you may consider the ability to assess Roth Conversions. If you don’t mind the added complexity you may consider including RMD for both personal IRA’s and Inherited IRA’s since the withdrawal rates are completely different
We are still developing the FIRE sheet. It’s not published yet.
Our plan is the FIRE sheet will work with the existing Cash Flow sheet.
- You must have drawn the short straw here. Good luck.
- The first item you mentioned was investment growth rate. I would like to be able to associate a growth rate with every investment asset that I have. So, if I have three accounts and each account has two positions, I would like to have six different rates that I can use, one for each position. Of course there are practical limitations here. I might suggest six, and maybe no more than ten. I adopt a lazy portfolio so I do not have many positions. I just moved from three to four.
- The second item you mentioned was taxes. I know all about taxes, right? You guys need to make the call here. Taxes bring lots of complexity but honestly any worthy tool needs to address income taxes, and that means both federal and state.
- Someone mentioned RMD’s. You need to think about the presentation here. In my mind, RMD’s and other IRA transactions are only tax issues. Otherwise, they are no different than moving money from your savings account and your checking account. Obviously, you would not be calculating the RMD, only providing a space for the user to enter an amount.
- You are already providing the ability to enter Social Security. The big question for the user is what numbers to use. That is on the user, not Tiller.
- You need to consider withdrawal strategies. The three I see are based on spending needs, maximum spending, and fixed percentage withdrawals.
- Someone mentioned Portfolio Visualizer. Very sophisticated, all of which I love. They have lots of great tools there but I suspect most of it is beyond the scope of your project.
- What is the new projected rollout date?
- Finally, I save the best for last. I have mentioned NewRetirement.com many times on this community but have never received much traction. I am sure Tiller has been listening and has looked at their product. If not, go there right now. This is what your are trying to replicate. I like and use their product. No harm in looking at their tool for ideas, presentation, etc. (Enough said…this is where that little man on my shoulder tells me to shut up and I actually listen to him.)
Thanks @Blake for your helpful feedback and suggestions. You organized some of the issues very clearly.
We don’t have a rollout date yet. I can’t even give you an estimate. I think we were close, but we are trying our best to deal with the complexities.
One concept we are considering is to allow you to put in whatever adjustments you want based on year, amount and growth rate. So each user could make it as complex or simple as they wanted.
Great feedback, @Blake.
There are some parts of what you’re requesting that we will be able to implement and some parts that are well beyond the scope of our project.
Within a spreadsheet, there are some significant performance, UX and special-case constraints that do not exist within dedicated retirement planning tools. Tax planning & consequences, in particular, are an area where the scenarios are just far too complex for us to keep pace, provide accurate guidance, and not confuse template users. Most spreadsheet-based solutions address this by relying on the spreadsheet user to input “after tax” growth rates, effectively best-effort personalized assumptions provided by each user.
I realize these compromises may be disappointing to users hoping for an end-all-be-all solution to retirement planning in a spreadsheet. Our hope is that this is a first step— we currently don’t have a tool or workflow to address these needs— and that this community can improve & build on the foundation of this simplified first release.
I am well aware of the constraints. You do the best you can with what you have. It is better than nothing. Are you guys going to charge extra for this? Cheers.
These templates will be free just like the rest of the Tiller Money Labs templates.
What is this then?
That link is to a beta for positions/holdings feeds, @blake.
This thread is about a template.
Thanks everyone in this thread for your feedback and suggestions.
It was very helpful!
We have just released our first version of the new Retirement Planner.
You can read about it and find out how to install it here:
I think the issue might be that I have a huge “net actuals” deficit due to moving funds from the sale of my house into various other assets. Those funds appeared in my first Tiller budget as savings so there isn’t income to offset the expenses, and it looks like I’m living with huge negative cash flow.
I’m not completely clear on the issue you are having.
But if you have an unusually large budget amount in a category in the current year that won’t be true going forward, you could create a life event with the same category name in the Cash Flow sheet starting next year with a 0 or lower amount. That should account for the unusual budget in future years.
Hey guys. Any update on when the FIRE sheet will be available?
Hi @DL19 ,
We released the FIRE sheet a few weeks ago. But we are calling it the Retirement Planner, since it’s not just for FIRE. It’s for retirement in general.
It was mentioned earlier in this thread. But here’s a link to the details:
Let us know what you think.
Finally got a chance to play with the Cash Flow forecast and Retirement Planner spreadsheets and they are great! I don’t have budget data so I had to enter estimates using the life planner section. took me a while to work out MY bugs but I think I have a fairly good representation of my situation. I really like playing with the investment and withdrawal rates. Since I used the life events instead of income and expenses, I can’t see how inflation will affect my spending ability in retirement. Any way to play with having income stop at a certain year and expenses continuing on?
thanks for all you do.
Hi @markchuteski ,
I’m glad you are enjoying the sheets.
It certainly can work without using budgets.
There are a number of ways to do it. For example you can set-up a life event of Income and another of Expense.
The Income could have a year range so you could adjust the end year. That would let your income stop.
The negative Expense value could have a growth rate which would match your estimated inflation rate.
Does that make sense?