A | B | C | D | E | F | G | H | I | J | K | |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | name | Comprehensive Household Spending Plan v1.4 | date | ||||||||
2 | Income | 1 | Monthly net/take-home income for the household, all sources. | 1 | $ 4,530.62 | ||||||
3 | Pay yourself first | 2 | Designated monthly surplus for use toward financial goals including retirement savings and additional debt payments. | 2 | $ 100.00 | ||||||
4 | Reserve for non-monthly expenses | 3 | a | Property/estimated tax payments (annual total). | 3 | a | This is the amount you'll need to save in reserve each month in order to cover your non-monthly, non-discretionary expenses. | ||||
5 | b | Auto / home / life / health insurance (if not paid monthly). | 3 | b | |||||||
6 | c | Home maintenance and upkeep (annual average). | 3 | c | |||||||
7 | (Enter annual amounts) | d | Auto maintenance/replacement (annual average). | 3 | d | $ 1,736.00 | |||||
8 | e | Medical/pet care (annual average). | 3 | e | $ 600.00 | ||||||
9 | f | Other non-monthly, non-discretionary expenses. | 3 | f | |||||||
10 | 4 | Add lines 3a through 3f for an annual subtotal. | 4 | $ 2,336.00 | |||||||
11 | 5 | Divide line 4 by the number 12 for monthly non-discretionary reserve savings. | 5 | $ 194.67 | |||||||
12 | 6 | a | Holidays/birthdays/gifts (annual total). | 6 | a | $ 400.00 | |||||
13 | b | Vacation/travel (annual average). | 6 | b | $ 180.00 | This is the amount you'll need to save in reserve each month in order to cover your non-monthly, discretionary expenses. | |||||
14 | c | Dues/subscriptions (if not paid monthly). | 6 | c | $ 120.00 | ||||||
15 | d | Education/enrichment/recreation (annually). | 6 | d | $ 150.00 | ||||||
16 | e | Personal property replacement (annual average). | 6 | e | $ 1,800.00 | ||||||
17 | f | Clothing (annual average). | 6 | f | $ 1,300.00 | ||||||
18 | g | Other non-monthly, discretionary expenses. | 6 | g | $ 1,500.00 | ||||||
19 | 7 | Add lines 6a through 6g for an annual subtotal. | 7 | $ 5,450.00 | |||||||
20 | 8 | Divide line 7 by the number 12 for monthly discretionary reserve savings. | 8 | $ 454.17 | |||||||
21 | Monthly obligations | 9 | Minimum debt payments (total of minimums only) | 9 | $ 803.00 | ||||||
22 | 10 | Alimony/child support. | 10 | $ 400.00 | |||||||
23 | 11 | Charity/pledges/tithe. | 11 | ||||||||
24 | 12 | Add lines 9, 10, and 11. This is your total monthly obligations. | 12 | $ 1,203.00 | |||||||
25 | Monthly bills | 13 | Housing (rent, mortgage, HOA). | 13 | |||||||
26 | 14 | Utilities (electric, gas, water, sewer, trash). | 14 | ||||||||
27 | 15 | Telephone/mobile phone service. | 15 | $ 213.00 | |||||||
28 | 16 | Internet. | 16 | ||||||||
29 | 17 | Television/entertainment. | 17 | ||||||||
30 | 18 | Auto / home / life / health insurance (paid monthly). | 18 | $ 267.00 | |||||||
31 | 19 | Child care. | 19 | ||||||||
32 | 20 | Other monthly bills (dues, fee, subscriptions). | 20 | $ 30.00 | |||||||
33 | 21 | Add lines 13 through 20. This is your total monthly bills. | 21 | $ 510.00 | |||||||
34 | Monthly household discretionary spending | 22 | Food/dining. | 22 | $ 380.00 | ||||||
35 | 23 | Auto fuel/transportation. | 23 | $ 217.00 | |||||||
36 | 24 | Fun/entertainment. | 24 | ||||||||
37 | 25 | Other (personal, beauty, vices, miscellaneous). | 25 | $ 30.00 | |||||||
38 | 26 | Add lines 22 through 25. This is your monthly discretionary spending. | 26 | $ 627.00 | |||||||
39 | Total expenses | 27 | Add lines 5, 8, 12, 21, and 26. This is your average monthly spending. | 27 | $ 2,988.83 | ||||||
40 | 28 | Add line 2 to line 27. This is your average monthly expenses. | 28 | $ 3,088.83 | |||||||
41 | Unallocated spending | 29 | Subtract line 28 from line 1. If negative, enter zero. This is the additional amount you can save and/or spend each month. | 29 | $ 1,441.79 | ||||||
42 | Amount to cut | 30 | If line 28 is greater than line 1, subtract line 1 from line 28. This is the monthly amount to cut from spending. | 30 | |||||||
43 | © 2017 by Dylan L. Ross. This work is made available under the terms of the Creative Commons Attribution-ShareAlike 3.0 license, http://creativecommons.org/licenses/by-sa/3.0/. |