Google Sheets Debt Repayment Template

Click the this link to make your own copy of the template.

This Google Sheet will help you create a debt repayment plan. All you have to do is enter: the amount you owe, your monthly payment, and payment start date. The spreadsheet will then automatically show how long it will take you to repay the debt and your remaining debt each month.

Make a copy and try it out yourself! If you have any questions about how this works, let me know in the comments.

How to use this template

Step 1: Go to this link and make a copy

Step 2: Enter the amount owed in C2

Step 3: Enter your planned monthly payment in A2

Step 4: Enter the starting month and year of your payments in A4

Step 5 (optional): If you are paying a different amount than your monthly payment, enter that amount in the B column in the row corresponding with the month of that payment.