Debt Repayment Calculator
To use this calculator: 1) Enter your debts in any order. Fill in only the light don’t know your interest rate, call your creditor and ask. 2) Push the "Sort" button to the left - this will put your debts in the order in whic 3) See the results of using the Debt Repayment schedule in the yellow boxes 4) Pay off your debts according to the payoff schedule. To see the schedule, p Schedule" button. Remember, the total Redirected Payments go to the the de still has a balance.
Sort Hide Payment Schedule
Debt Name 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Best Buy Shell gasoline card Circuit City AutoZone MBNA Visa card $ $ $ $ $
Note: If you input a Starting Balance, interest rate, and payment amount that m a #NUM error under Number of Payments. Check your figures and enter them Starting Balance 3,000.00 1,000.00 3,000.00 3,000.00 1,500.00 Interest Rate 10.00% 8.00% 21.90% 5.00% 10.00%
Totals $
11,500.00
Total payments Total interest paid Total principal payments Months until debt is paid off
Before DR Plan After DR Plan $ 13,874.37 $ 12,971.48 $ 2,374.37 $ 1,471.48 $ 11,500.00 $ 11,500.00 64.95 25.00
Fill in only the light-blue fields, and leave the other fields alone. If you l your creditor and ask. this will put your debts in the order in which they should be repaid. ebt Repayment schedule in the yellow boxes at the bottom. o the payoff schedule. To see the schedule, push the "See Payment he total Redirected Payments go to the the debt highest on the list that
ance, interest rate, and payment amount that make no sense, you'll get Payments. Check your figures and enter them again. Payment Amount 300.00 36.69 100.00 75.00 30.00 Total Interest 145.44 107.29 1,384.56 288.62 448.46 Number of Payments 10.4848 30.1796 43.8456 43.8483 64.9487
See Payment Schedule
$ $ $ $ $
$ $ $ $ $
$
541.69
$
2,374.37
$ $ $
Savings 902.89 902.89 39.95
nt Schedule
Dear Friend, Thanks for downloading this Excel personal finance spreadsheet. It gives me a real thrill to know that I've made something that people find useful and that benefits them. Since you've downloaded and actually opened this spreadsheet, you're probably concerned about your personal finances. I was, and that's why my wife and I started a personal budget. It's been the best experience of our lives -- We paid cash for last year's Christmas gifts, we've taken several vacations, and our bank account balance is constantly increasing. It's an Excel-based budgeting system, and it's so simple, yet amazingly powerful. I highly recommend it. To find out more about why I think this budget is the best gift you could give yourself, please click on the gift box below.
Sincerely,
Sean Payne
heet. It gives me a seful and that
eet, you're hat's why my wife f our lives -- We cations, and our
mazingly
you could give