Excel template to evaluate MBA offers.

Question

Hi all,

As round 2 results will be released soon, many of us will need to face a complex choice: which schools to pick?

There are so many quantitative and qualitative factors to consider. Scholarship. Tuition fees. Living expenses (during academic year and also year round). School brand name. Program fit. Etc...

Has anyone made an excel spreadsheet to help with the decision and comparison?

Thanks.

Ross Admission Director's Template

https://docs.google.com/spreadsheets/d/ ... edit#gid=0

Yodboy's Template

Attachment:

Business School Choice (1).xlsx [12.76 KiB]
Downloaded 617 times

Narenn's Template (Combining best of Soojin's and Yodboy's templates

Attachment:

Spreadsheet to Evaluate Schools.xlsx [481.82 KiB]
Downloaded 847 times

iVoRy · Answer

Ross admission director "Soojin Kwon" shared a spreadsheet she uses to compare MBA programs a while ago.

You can check her video and spreadsheet below.

Excel Spreadsheet Link: https://myumi.ch/JWw2w

yodboy · Answer

Dear Ivory,

Thanks. The file is very thorough. However, I would want to add in factors such as costs.

Cheers

iVoRy · Answer

You're welcome. It's not my file but I think most people would find it helpful. I agree that cost is another important factor that is missing from the template but according to her it's not a major factor in the long run. Personally, I think it's an important factor for me though but right now I'd be happy to get into any school that I applied too. :cry:

bb · Answer

I love the idea - thank you  yodboy  for suggesting it.

This spreadsheet seems a bit soft for a spreadsheet. I am not even asking much - how about a number in there? Seems more of a cozy mindmap than a spreadsheet.

I would definitely add some of the financials (tuition, fees, living expenses), as well as school stats - number of courses/electives that you care enouogh about though make sure these are offered and not just offered once every 4 years, employment stats - you can get carried away here too, ranking of a city/area - e.g. I would probably prefer California to Michigan but then if I had all my family living in Michigan.... then definitely California. How about just good old raw rankings - perhaps an average over the last 5 years in case this is Yale or Stern and whatever else works for you.

What do you think?

iVoRy · Answer

Yes, that is a good idea.
I have another spreadsheet that I use when I'm deciding which program to apply to.
The employment stat (in my case ratio of students that go to MBB firms) and number of local alumni in linkedin are 2 criteria that I would add.

yodboy · Answer

Hi  bb

Thanks for your input.

Last night, to distract myself from the agony of the wait, I've made the attached file for myself.

Sheet 1 is very detailed in terms of costs for 2 years. I excluded the costs in the 3 summer months, assuming internship salary can cover it.

I'm waiting for the result from Duke/Darden/Booth. So I don't have any scholarship details to put into those schools yet.

Sheet number 2 is where I put key measures and weight and assign scores.

Would be happy if you can share your view regarding the file.

Cheers

MBAHanover2018 · Answer

great !!! thanks for sharing

bb · Answer

BUMP. Perhaps someone finds this tool useful for the 2019 Decisions.

Excel template to evaluate MBA offers.

Prep Toolkit

Top 5 GMAT Debrief Videos

615 to 715 in 15 Days (Ria's Strategies)

More than Quant/Verbal Abilities: Speed vs. Accuracy

745 with Only Self-Prep and GMAT Club

From 555 to 765: 210-point Improvement

Perfect 805 Score Debrief by Julia

My Rewards