Budget Modeler Example
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABAC
1
Monthly Business PerformanceIncome Sources (Monthly)Business Expenses (Non-Labor)Labor ExpensesInvesting (Monthly)Personal Expenses (Monthly)
2
3
Gross Income$3,180.00SourceAmountExpenseAmountPersonAmountInvestmentAmountExpenseAmount
4
Non-Labor Expenses$60.00Job$2,880.00Adobe$50.00N/AInvestment 1$475.00Apartment Costs$980.00
5
Net Income Before Labor$3,120.00Freelance gig$300.00Dropbox$10.00Car Payment$200.00
6
Gas$100.00
7
Labor Expenses$0.00Car Insurance$100.00
8
Spotify$10.00
9
Monthly Net Income$3,120.00Health/Dental Insurance$90.00
10
Yearly Net Income$37,440.00Groceries$100.00
11
This sheet is view-only. Make a copy of it (File -> Make a copy) if you want your own that you can change. Then delete this.Eating Out$50.00
12
Taxes and IRA (Yearly)Coffee$20.00
13
IRA Contribution$0.00Cat$30.00
14
Charitable Contributions$50.00
15
Adjusted Gross Income$37,390.00
16
Salary$37,390.00
17
Income Tax$3,342.10
18
FICA Tax$3,130.34
19
Colorado State Tax$2,991.20My new housing cost calculator is in the Tools sheet. Use the tabs at the bottom to find it.
20
21
Total Tax Liability$9,463.64
22
% of Income Paid in Tax25.28%
23
24
Monthly Personal Performance
25
Take-Home Pay (Yearly)$27,926.37Some cells have notes to help you out. They'll have a small black mark in the upper right corner. Unfortunately I can't provide personal support on this spreadsheet due to my other commitments, so if you get stuck, you'll need to do some Googling or ask for help in the CIG subreddit: collegeinfogeek.com/community
26
Take-Home Pay (Monthly)$2,327.00
27
28
Total Investments$475.00
29
Total Investments (Yearly)$5,700.00
30
% of Income Invested15.24%
31
32
Total Personal Expenses$1,680.00
33
Total Personal Expenses (Yearly)
$20,160.00
34
% of Income Spent on Housing
31.41%
35
36
Total Leftover$172.00
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
Main menu