ABCDEF
1
One Time / Yearly Expenses (Total for 2 years)InputMultiplierTotalNotes
2
Tuition$73,4402$146,880
3
Required Fees$3,7922$7,584
4
Health Insurance (if not included above)$4,0402$8,080
5
Moving Expense$5,0002$10,000Moving to Campus; Moving after Graduation
6
Miscellaneous Setup Expenses$1,2002$2,400Setup at Campus; Setup at new location after graduation
7
New Computer$1,6001$1,600
8
Clubs / Membership$1,0001$1,000
9
10
Monthly Expenses (24 months = Aug to Aug approx.)
11
Rent$2,60024$62,400
12
Groceries$30024$7,200
13
Alcohol$20024$4,800
14
Uber / Car$15024$3,600
15
Dining Out$1,00024$24,000
16
Shopping (Clothes, etc.)$50024$12,000
17
Misc (Phone, Netflix etc.)$50024$12,000
18
Existing Loans$024$0
19
Trips$1,20016$19,200Consider long weekend trips and larger trips (like spring break, thanksgiving, winter, summer etc.)
20
21
Total Expenses in B-School$303,544
22
23
Income
24
Internship Income (Total Internship minus rent)$25,0000.7$17,500Assumed 30% tax
25
Partner Income (Total over 2 years)$00.65$0Assumed 30% tax, 5% 401K contribution
26
Passive Income (Total over 2 years)$00.7$0Assumed 30% tax
27
Scholarship$25,0001$25,000
28
29
30
Savings (if you are willing to use it, don't go broke!)
31
Cash$50,0001$50,000
Recommend to have some cash remaining in your bank at graduation; Nikhil left 30K in emergency savings
32
Stocks$01$0You may need to adjust the multiplier to account for capital gains tax (federal and state)
33
Other$01$0
34
35
Total Available Funds$92,500
36
37
Funding Gap / Loan Need$211,044
38
39
40
41
42