A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | General Information (Setup A) | ||||||||||||||
2 | Name | Jerry Spender | |||||||||||||
3 | Date Started | 1/1/2020 | |||||||||||||
4 | Starting Savings Balance | $1,500.00 | |||||||||||||
5 | Weekly Spending Allowance | $125.00 | |||||||||||||
6 | |||||||||||||||
7 | |||||||||||||||
8 | Instructions | Goals (Setup B) | |||||||||||||
9 | This budget tool can help you easily calculate how much you should save each time you get paid, help you track your savings goals, and track your expenses. Intended for use at the end of each pay period. Setup A: Complete "General Information" (All Fields) B: Set a few "Goals". Your general savings should be one, others can be big purchases, upcoming travel plans, big events, etc. Each Pay Step 1: Complete "Income" (Job Name, Job 2 (if applicable), and Amount Earned) Step 2: Complete "Expenses" - List all expenses such as bills or other debts that will be paid from now to your next pay. Step 3: Enter your "Remaining Cash" (from last pay) into the "Pay Period Calculation" Step 4: Deposit your "Save Amount" into your savings account at your bank or credit union Step 5: Determine what you're saving for - distribute your "Save Amount" among your goals and log them in the next tab: "Savings Log" Step 6: Monitor and adjust. If you're constantly short of your total save goal, consider scaling back your goals. If you're constantly able to save more, consider increasing your savings or making another goal! | Goal Name | Start Date | Target Date | Days Until Target Date | Amount Required | Amount Saved | Amount Needed | Need to Save per Week | ||||||
10 | SAVINGS ACCOUNT | 1/1/2018 | 1/1/2021 | -865 | $5,000.00 | $2,090.03 | $2,909.97 | $2,909.97 | |||||||
11 | Trip to DisneyLand | 2/3/2018 | 3/10/2021 | -797 | $1,000.00 | $301.74 | $698.26 | $698.26 | |||||||
12 | New Car | 5/1/2018 | 1/1/2021 | -865 | $3,500.00 | $508.48 | $2,991.52 | $2,991.52 | |||||||
13 | Birthday Present for Mom | 5/13/2018 | 11/15/2021 | -547 | $75.00 | $75.00 | $0.00 | $0.00 | |||||||
14 | Please Set Goal | $0.00 | $0.00 | Please Set Goal | |||||||||||
15 | Please Set Goal | $0.00 | $0.00 | Please Set Goal | |||||||||||
16 | Please Set Goal | $0.00 | $0.00 | Please Set Goal | |||||||||||
17 | Please Set Goal | $0.00 | $0.00 | Please Set Goal | |||||||||||
18 | Please Set Goal | $0.00 | $0.00 | Please Set Goal | |||||||||||
19 | Please Set Goal | $0.00 | $0.00 | Please Set Goal | |||||||||||
20 | Please Set Goal | $0.00 | $0.00 | Please Set Goal | |||||||||||
21 | Please Set Goal | $0.00 | $0.00 | Please Set Goal | |||||||||||
22 | Total save per week to accomplish ALL listed goals | $6,599.75 | |||||||||||||
23 | |||||||||||||||
24 | Expenses (Step 2) | Pay Period Calculation (Step 3) | |||||||||||||
25 | |||||||||||||||
26 | Income (Step 1) | Expense Name | Monthly Cost | Deposit Period (Since Last Deposit) | 2 Weeks | ||||||||||
27 | Job Name | Call Center | Cell Phone | $60.00 | |||||||||||
28 | Pay Period | 2 Weeks | Music App | $5.00 | Earned | $1,050.00 | |||||||||
29 | Amount Earned (one period) | $900.00 | Car Payment | $270.00 | Remaining Cash | $15.00 | |||||||||
30 | Balance | $1,065.00 | |||||||||||||
31 | Job 2 | Mowing Lawns | |||||||||||||
32 | Pay Period | 1 Week | Expenses | $154.62 | |||||||||||
33 | Amount Earned (one period) | $75.00 | Spending Allowance | $250.00 | |||||||||||
34 | |||||||||||||||
35 | Total Income Per Week | $525.00 | Save Amount (Step 4) | $660.38 | |||||||||||
36 | Monthly Pre-tax Income | $2,275.00 | Left Over After All Goals | -$12,539.11 | |||||||||||
37 | Annual Pre-tax Income | $27,300.00 | Expenses Total | $335.00 | |||||||||||
38 |