Dear Visitor, I'd like to take this opportunity to say "Thanks very much!" for visiting It's Your Money! and for downloading this financial spreadsheet. (Feel free to try out all my others, too!) I truly hope that the spreadsheets and tools I've made available there help you as much as they've helped me. I’m going to go out on a limb here. I'll guess that since you've downloaded and opened this spreadsheet, that little voice inside your head is urging you to take action (somehow!) to improve your financial situation. I know all about that voice. I spent way too many years ignoring it! That said, I am being entirely honest when I say that the single most effective thing I ever did for my family's finances was to start planning our spending on a monthly basis. You can call it "budgeting" if you want, but "budgeting" doesn't sound the least bit fun. And if you play your cards right, and let spreadsheets help you, you can actually make your "budgeting" fun. That's where the "You Need A Budget" spreadsheet comes in. I've seen a lot of budgeting spreadsheets over the years, and this one beats 'em all. Handily. (Personally, I couldn't build anything nearly so cool.) I mention this only because I know the power of a good spending plan ("budget"), and "You Need a Budget" is about as good as it gets. If you'd like to know more, just click the YNAB icon below to read my review. Once more, thanks very much for stopping by!
Michael @ It's Your Money!
DebtTracker Spreadsheet
For the very latest instructions, tutorials, and FAQs relating to my DebtTracker spreadsheet, head to:
DebtTracker Spreadsheet Details Page
Also, if you feel the DebtTracker spreadsheet is worthy of a small donation, you can do so (via Paypal) on that same page. I hope that the DebtTracker aids you greatly in your quest for debt freedom! Regards,
(via Paypal) on
DEBT TYPES
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Credit Card Mortgage Auto / Vehicle Loan Student Loan HELOC
HOUSEHOLD INCOME
Annual Amount
Gross (Pre-tax) Net (After Tax) $60,000 $35,000
Monthly Average
$5,000 $2,916
This page is simply a convenient place to store account-related information for any banks, utilities, or other businesses.
Name Citibank Visa
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Electric Service
Institution Address Citibank Attn. Payments Dept. 1111 NW 32nd St. New York, NY 10010-1202 Texas Gas 1301 N. 158th Place & Electric Waco, TX 71234-5678 First Nat'l Bank of Ft. Worth 82 N. Spencer Terrace Ft. Worth, TX 71237-1234
Phone 800-444-5555
Contact Stan Stanson
Account # 1234-5678-9012-3456
555-8787
38-98345622
Main Bank Account
555-8989 Fax 555-9090
Checking: 123456-001 Savings: 123456-000
20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40
40 41 42 43 44 45
Client Name
Amount Owed $ 1,780.00
Payment Arguments
Due Date 10/10/2007
Avg. Payment Amount $ 105.00
Notes
$
-
15th
$
110.00
$
-
SORT BY: SORT FROM:
TYPE Lowest to Highest
GO!
INITIAL or RATE 14.8% 9.9% 17.0% 15.9% 10.8% 19.9% LIMIT $ $ $ $ $ $ HIGH BALANCE 9,000.00 20,000.00 1,000.00 4,000.00 4,980.00 200.00
DEBT NAME Bob's Boats GMAC Visa 2 Mastercard Mastercard 2 Roger's Antiques
TYPE Auto / Vehicle Loan Auto / Vehicle Loan Credit Card Credit Card Credit Card Credit Card
$ $ $ $
1,350.00 5,000.00 5,000.00 300.00
$
11,650
$
39,180.00
APPROXIMATE APPROXIMATE CURRENT BALANCE $ $ $ $ $ $ 7,000.00 14,000.00 900.00 3,000.00 3,700.00 100.00 $ $ $ $ $ $ MIN. PAYMENT 400.00 475.00 30.00 53.00 37.00 25.00 UPDATED 23-Sep-06 23-Sep-06 23-Sep-06 23-Sep-06 23-Sep-06 23-Sep-06 $ $ $ $ $ $ INTEREST/MONTH 86.33 115.50 12.75 39.75 33.30 1.66 MONTHS 'TIL PAYOFF 20 34 39 105 257 4
$
28,700.00
$
1,020
$
289.29
% LIMIT USED
66.7% 60.0% 74.0% 33.3%
Lowest to Highest Highest to Lowest
TYPE OF DEBT 1 Credit Card 2 Mortgage 3 Auto / Vehicle Loan 4 Student Loan 5 HELOC 6 7 8 9 10 11 12 13 14 15 Total Debt (excl. mortgage) Total Debt (incl. mortgage) $ $ $ $ $ $ $
CURRENT BALANCE 7,700.00 21,000.00 $ $ $ $ $
PRINCIPAL PAID TO DATE 2,480.00 8,000.00 -
BALANCE AS % OF TOTAL NONMORTGAGE DEBT 26.8% n/a 73.2%
28,700.00 28,700.00
Debt-to-Income Ratio (excl. mortgage) Monthly Housing Ratio
ANNUAL INCOME, GROSS 0.48 n/a
ANNUAL INCOME, NET 0.82 n/a
Credit Card Utilization Ratio
66.1%
TOTAL MONTHLY PAYMENTS $ $ 145 875
$ $
1,020 1,020 MONTHLY INCOME, GROSS 0.20 n/a MONTHLY INCOME, NET 0.35 n/a
Debt Name:
FirstBank Visa
$12,000.00
$10,000.00
$8,000.00 $6,000.00
$4,000.00
$2,000.00 $1/06 2/06
Date 01/28/06 02/28/06 03/28/06 04/28/06 05/28/06
Balance $ 10,000.00 $ 8,000.00 $ 7,125.00 $ 7,010.00 $ 4,900.00
Input new dates and balances as your paydown progresses.
Debt Paydown
Balance
3/06
4/06
5/06
Debt Name:
[Insert Debt Name Here]
$1.00 $0.90 $0.80 $0.70 $0.60 $0.50 $0.40 $0.30
$0.20
$0.10
$-
Date
Balance
Input new dates and balances as your paydown progresses.
Debt Paydown
Balance
Debt Name:
[Insert Debt Name Here]
$1.00 $0.90 $0.80 $0.70 $0.60 $0.50 $0.40 $0.30
$0.20
$0.10
$-
Date
Balance
Input new dates and balances as your paydown progresses.
Debt Paydown
Balance