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