How to Use the Debt Eradication Roadmap Spreadsheet

The Debt Eradication Roadmap spreadsheet turns your list of debts into a clear order and a debt-free date. This article shows you what to gather before you open it and how to read the result. It comes free when you buy Mastering Money.

Mastering Money book that includes the Debt Eradication Roadmap spreadsheet

What to gather before you start

First, collect a recent statement for every debt. You will need these details for each one:

  • the current balance
  • the interest rate
  • the minimum monthly payment
  • your monthly income after tax

Include credit cards, store accounts, personal loans, vehicle finance, overdrafts and your home loan.

Using the spreadsheet

Open the file in Excel and save your own copy before you type anything. Then enter your debts in the cells provided. Do not change the formulas, and never type ID numbers or bank details into it. The sheet works only with the figures above.

Reading your Roadmap result

The spreadsheet shows the order in which your debts should be tackled and when you could be debt free. Treat the result as your plan, and update it every month with new balances. As a result, you can see your progress and stay motivated.

The book explains the reasoning behind the order, so read the chapter on the Roadmap before you act on the numbers.

Tips for using the Debt Eradication Roadmap spreadsheet

  • Update your balances once a month, on the same day.
  • Use your real statement figures, not estimates.
  • Keep a backup copy in case you overwrite your work.
  • Share the result with your accountability partner.

If you are stuck, send a support request or book a call. We would rather help you start than watch you give up.

Common questions about the Debt Eradication Roadmap spreadsheet

Readers often ask whether they can use the Debt Eradication Roadmap spreadsheet on a phone or tablet. It works best in Excel on a computer, because the formulas need a full spreadsheet program. You can also use the free calculators on this site for quick checks, then return to the spreadsheet for your full plan.

Need a hand?

If your debts are complicated, or you owe SARS, we can look at your numbers with you.

Leave a Comment

Scroll to Top