Payoff month for a $100 balance is showing up >30 years in the debt planner spreadsheet

In the debt planner sheets I get a random red >30 years marker in the paid off month and an 86,000 in interest. What am I doing wrong?

Essentially that means that your budgeted debt pay down cannot retire the listed debts in less than three years. This can be because the loans are too great & expensive to service or because the payment is insufficient.

Have a look at this demo sheet to see how the Debt Planner looks when it is working.