A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | ||||||||||||||||
2 | Use this tool to generate a very simple snapshot of your finances based on a 50/30/20 budget. | ––– | ||||||||||||||
3 | How it Works → | Spend 50% each month on living expenses: | Spend 30% each month on discretionary expenses: | Save 20% each month (or use to eliminate debt): | ||||||||||||
4 | Enter your total annual income after taxes (edit the number in the box): | $65,000 | $2,708 | $1,625 | $1,083 | |||||||||||
5 | Enter your total credit card debt: | $5,000 | You should have three months income in an emergency account: | Using the entire saving allocation above, you could fully fund your emergency account in this many months: | OR you could eliminate all credit card debt in this many months: | |||||||||||
6 | Enter your total student, car, mortgage, personal and other loans: | $16,250 | 15 | 4.62 | ||||||||||||
7 | Estimate the total value of assets you own (cash, home and real estate, investments, valuable possessions): | $100,000 | OR you could eliminate all loans in this many years: | After your emergency fund is full and your credit cards paid off, save 15% each month for retirement: | Your current total net worth (assets minus liabilities): | |||||||||||
8 | For a full featured, automated budget for Google Sheets, explore the Foundation Template → | 0.00 | $813 | $95,000 | ||||||||||||
9 | 9/21/2022 | |||||||||||||||
10 | ||||||||||||||||
11 | ||||||||||||||||
12 | ||||||||||||||||
13 | ||||||||||||||||
14 | ||||||||||||||||
15 | ||||||||||||||||
16 | ||||||||||||||||
17 | ||||||||||||||||
18 | ||||||||||||||||
19 | ||||||||||||||||
20 | ||||||||||||||||
21 | ||||||||||||||||
22 | ||||||||||||||||
23 | ||||||||||||||||
24 | ||||||||||||||||
25 | ||||||||||||||||
26 | ||||||||||||||||
27 | ||||||||||||||||
28 | ||||||||||||||||
29 | ||||||||||||||||
30 | ||||||||||||||||
31 | ||||||||||||||||
32 | ||||||||||||||||
33 | ||||||||||||||||
34 | ||||||||||||||||
35 | ||||||||||||||||
36 | ||||||||||||||||
37 | ||||||||||||||||
38 | ||||||||||||||||
39 | ||||||||||||||||
40 |