Debt Planner: Payoff Month Not Calculating Correctly

Hey everyone!

I might have a fix but it will require a little testing…

I just built a new version of the Debt Planner template. You can view it here. Rather than using some overly-clever assumptions, this new version brute forces the analysis by running down the accounts month by month. I haven’t done too much testing yet but this approach (once vetted) will better handle the troublesome scenarios we flagged above.

Would anyone be willing to take it for a spin?

Just open the view-only template, manually copy it into your spreadsheet, and see if the results make sense for your portfolio. (You can run it in parallel with the original version.)

I’m confident in the approach, but I haven’t had a chance to test it thoroughly.

Once we’ve got this a little more buttoned down, I can replace the master in the Tiller Money Labs add-on.

Thanks for your help on this.

P.S. I removed the total remaining interest payment since my initial efforts weren’t working on that feature. Let me know if it is important to you.