| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
1 | Spending power calculator | |||||
2 | ||||||
3 | Directions: Make a copy of the spreadsheet and fill in the Yellow cells, the rest will be calculated for you automatically. The taxes values filled in are for California | |||||
4 | ||||||
5 | Gross annual salary | 100,000.00 | Gross hours spent working per week | 50.00 | ||
6 | Federal tax rate that you pay | 27.00 | Weeks worked per year | 49.18 | ||
7 | State tax rate that you pay | 8.00 | Hours worked per year | 2,458.88 | ||
8 | State sale tax | 8.00 | Income after federal taxes | 73,000.00 | ||
9 | Hours worked per day | 8.00 | Income after state tax (annually) | 67,160.00 | ||
10 | Days worked per week | 5.00 | Income that lands in your pocket (monthly) | 5,596.67 | ||
11 | Minutes spent in commute per day | 120.00 | Spendable Income earned per hour | 27.31 | ||
12 | Days of paid vacation per year | 21.00 | Minutes needed to be worked to spend this amount | 4,744.94 | ||
13 | Amount of money you want to spend | 2,000.00 | Rounded number of minutes/hours for spending this amount | 79.1 hours | ||
14 | Total money you need to pay (sales tax included) | 2,160.00 | ||||
15 | ||||||
16 | ||||||
17 | ||||||
18 | ||||||
19 | ||||||