I have been working on a spreadsheet to calculate the breakeven point for attending b-schools. I based this on the budgeted cost for attending these b-schools (cost of living, etc is included).
I put this spreadsheet together pretty fast so there might be some mistakes or something else may need to be included. I need to get some more data on the schools that I included. Also, I know I missed some schools so if you have a school you want me to add just let me know and I will.
Here is how it works:
1) Pick the b-school from the drop down box.
2) Select yes or no depending on if your a resident of the state the b-school is in.
3) Enter your current salary.
4) Enter the percentage raise each year you currently receive.
5) If you were accepted to a school and know you received a scholarship, then you can put in the amount of your scholarship.
6) You can change the expected yearly raise percentage after MBA.
7) You can change the discount rate for calculating the NPV. I just used 5%.
The rest will be calculated for you. Let me know what you all think.
B-school breakeven and payback periods
This topic has expert replies
- dmateer25
- Community Manager
- Posts: 1049
- Joined: Sun Apr 06, 2008 5:15 pm
- Location: Pittsburgh, PA
- Thanked: 113 times
- Followed by:27 members
- GMAT Score:710
- Attachments
-
- bschools.xlsx
- (19.45 KiB) Downloaded 149 times
- dmateer25
- Community Manager
- Posts: 1049
- Joined: Sun Apr 06, 2008 5:15 pm
- Location: Pittsburgh, PA
- Thanked: 113 times
- Followed by:27 members
- GMAT Score:710
Quick question to anyone that has looked at this. Do you think this is a helpful tool to value an MBA from each school? I don't want to put a lot more time into this if people don't feel it is valuable.
- shadowsjc
- Master | Next Rank: 500 Posts
- Posts: 139
- Joined: Tue Aug 18, 2009 11:52 am
- Location: Jersey City, NJ
- Thanked: 14 times
- GMAT Score:770
great tool.. thanks
my GMAT debrief: https://www.beatthegmat.com/came-through ... 44327.html
You will not fear the terror of night, nor the arrow that flies by day,
nor the pestilence that stalks in the darkness, nor the plague that destroys at midday.
A thousand may fall at your side, ten thousand at your right, but it will not come near you.
- Psalm 91: 5-7
You will not fear the terror of night, nor the arrow that flies by day,
nor the pestilence that stalks in the darkness, nor the plague that destroys at midday.
A thousand may fall at your side, ten thousand at your right, but it will not come near you.
- Psalm 91: 5-7