| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
1 | |||||||||||
2 | Modifying the Master Monthly Budget will affect all 12 months! | ||||||||||
3 | |||||||||||
4 | MASTER MONTHLY | MASTER MONTHLY | Money left to Budget: | $1,091.92 | |||||||
5 | Variable Expenses | Fixed Expenses | |||||||||
6 | Groceries | $300.00 | Mortgage | $665.16 | Income | Monthly | Yearly | Passive? | |||
7 | Gasoline & Travel | $200.00 | Rent | $754.95 | Paycheck | $2,800.00 | $33,600.00 | No | |||
8 | Medical | $30.00 | Life Insurance | $62.35 | Paycheck (Spouse) | $1,250.00 | $15,000.00 | No | |||
9 | General Merchandise | $100.00 | Property Insurance | $42.00 | Rental Income | $835.00 | $10,020.00 | Yes | |||
10 | Auto Insurance | $50.00 | HOA | $22.92 | Taxable Dividends | $100.00 | $1,200.00 | Yes | |||
11 | Vehicle - Other | $30.00 | Property Tax | $108.03 | Retirement Dividends | $150.00 | $1,800.00 | Yes | |||
12 | Donations | $20.00 | Cable | $65.00 | Freelance | $0.00 | $0.00 | No | |||
13 | Rental Upkeep | $100.00 | Royalties / Other | $50.00 | $600.00 | Yes | |||||
14 | Memberships | $16.67 | CC Cashback | $10.00 | $120.00 | Yes | |||||
15 | Cell Phones | $35.00 | To HSA | $537.50 | $6,450.00 | No | |||||
16 | Restaurants | $20.00 | To 401(k) | $650.00 | $7,800.00 | No | |||||
17 | Trash | $25.00 | Total | $6,382.50 | $76,590.00 | ||||||
18 | Water | $65.00 | |||||||||
19 | Electric | $80.00 | |||||||||
20 | Internet | $20.00 | Instructions: | ||||||||
21 | Online Services | $26.00 | 1) Complete income sources and estimated monthly amounts. | ||||||||
22 | Dental | $70.00 | 2) Specify whether your income streams are active or passive. | ||||||||
23 | Alcohol | $25.00 | 2) Complete the Variable & Fixed expenses. | ||||||||
24 | Other/Misc | $25.00 | 3) Use the current month's worksheet to track your progress. | ||||||||
25 | TOTAL | $1,720.41 | |||||||||
26 | Tips: | ||||||||||
27 | 1) CTRL + ; (semicolon) will autocomplete today's date (CMD + ; on a Mac) | ||||||||||
28 | Fixed Expenses Total | $1,720.41 | 2) Keep your expenses lower than your income! | ||||||||
29 | Total Expenses | $2,958.08 | 3) Use the Inc vs Ex & Savings Rate worksheets for motivation. | ||||||||
30 | |||||||||||