@Peter Vander Ploeg
This is what three CFPs had no idea how to help me on...
Address or Create some software that correctly analyzes a paydown phase of rental properties. I would be happy to partner with you on the software creation!
Consider someone who has purchased several rental properties at 20% down and is planning to match a payoff of all loans to a retirement date with pensions starting (military, state, etc).
Assuming there will be no more purchases and a set amount of monthly money (cashflow plus additional owner input) is used to paydown loans via debt snowball/avalanche process, what is the actual timing of the payoffs? Be sure to include continuation of taxes and insurance remaining as an expense and increasing by a certain amount each year. Then, make it update-able without losing a copy of the original plan, so that I can compare on a regular basis if I am still on track or how far off-track (time and dollars) I am and how to get back on track.
It took me many hours to get a spreadsheet that i think gets me within a year or so of a correct payoff date but doesnt correctly account for taxes and insurance.