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