NEW HERE? LEARN MORE
closeclose
Last visit was: 26 Apr 2024, 16:11 It is currently 26 Apr 2024, 16:11
Decision Tracker
My Rewards
New posts
New comers' posts

Close
GMAT Club Daily Prep
Thank you for using the timer - this advanced tool can estimate your performance and suggest more practice questions. We have subscribed you to Daily Prep Questions via email.

Customized
for You

we will pick new questions that match your level based on your Timer History

Track
Your Progress

every week, we’ll send you an estimated GMAT score based on your performance

Practice
Pays

we will pick new questions that match your level based on your Timer History
Not interested in getting valuable practice questions and articles delivered to your email? No problem, unsubscribe here.
Go to My Error Log Learn more
Close
Request Expert Reply
Confirm Cancel

Excel template to evaluate MBA offers.

Tags:
Find Similar Topics  Add a Tag
Show Tags
Hide Tags
avatar
B
yodboy
Manager
Manager
Joined: 14 Apr 2011
Posts: 92
Own Kudos [?]: 16 [5]
Given Kudos: 73
Location: Viet Nam
Schools: Goizueta '19 (A$) Booth '19 (WL) Duke '19 (A)
GMAT 1: 720 Q48 V40
GPA: 3.08
Send PM
Excel template to evaluate MBA offers. [#permalink] New post   Updated on: 16 Mar 2017, 06:58
2
Kudos
3
Bookmarks
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 524 times




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


Attachment:
Spreadsheet to Evaluate Schools.xlsx [481.82 KiB]
Downloaded 728 times

Originally posted by yodboy on 13 Mar 2017, 00:27.
Last edited by Narenn on 16 Mar 2017, 06:58, edited 5 times in total.
Put all templates together
User avatar
G
iVoRy
Manager
Manager
Joined: 21 Apr 2011
Posts: 140
Own Kudos [?]: 31 [4]
Given Kudos: 36
Concentration: Strategy
Schools: Darden '19 (M)
GMAT 1: 700 Q48 V38
GPA: 3.09
Send PM
Reviews Badge
Re: Excel template to evaluate MBA offers. [#permalink] New post   Updated on: 13 Mar 2017, 02:57
3
Kudos
1
Bookmarks
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



Originally posted by iVoRy on 13 Mar 2017, 02:39.
Last edited by iVoRy on 13 Mar 2017, 02:57, edited 1 time in total.
avatar
B
yodboy
Manager
Manager
Joined: 14 Apr 2011
Posts: 92
Own Kudos [?]: 16 [0]
Given Kudos: 73
Location: Viet Nam
Schools: Goizueta '19 (A$) Booth '19 (WL) Duke '19 (A)
GMAT 1: 720 Q48 V40
GPA: 3.08
Send PM
Re: Excel template to evaluate MBA offers. [#permalink] New post   13 Mar 2017, 02:53
Dear Ivory,

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

Cheers
User avatar
G
iVoRy
Manager
Manager
Joined: 21 Apr 2011
Posts: 140
Own Kudos [?]: 31 [0]
Given Kudos: 36
Concentration: Strategy
Schools: Darden '19 (M)
GMAT 1: 700 Q48 V38
GPA: 3.09
Send PM
Reviews Badge
Re: Excel template to evaluate MBA offers. [#permalink] New post   13 Mar 2017, 19:09
yodboy wrote:
Dear Ivory,

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

Cheers

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:
User avatar
L
bb
Founder
Founder
Joined: 04 Dec 2002
Posts: 37311
Own Kudos [?]: 72892 [0]
Given Kudos: 18869
Location: United States (WA)
GMAT 1: 750 Q49 V42
GPA: 3
Send PM
GMAT ToolKit User CAT Tests Forum Quiz Mode
Re: Excel template to evaluate MBA offers. [#permalink] New post   13 Mar 2017, 21:05
Expert Reply
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?
User avatar
G
iVoRy
Manager
Manager
Joined: 21 Apr 2011
Posts: 140
Own Kudos [?]: 31 [0]
Given Kudos: 36
Concentration: Strategy
Schools: Darden '19 (M)
GMAT 1: 700 Q48 V38
GPA: 3.09
Send PM
Reviews Badge
Re: Excel template to evaluate MBA offers. [#permalink] New post   13 Mar 2017, 21:18
bb wrote:
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?

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.
avatar
B
yodboy
Manager
Manager
Joined: 14 Apr 2011
Posts: 92
Own Kudos [?]: 16 [3]
Given Kudos: 73
Location: Viet Nam
Schools: Goizueta '19 (A$) Booth '19 (WL) Duke '19 (A)
GMAT 1: 720 Q48 V40
GPA: 3.08
Send PM
Re: Excel template to evaluate MBA offers. [#permalink] New post   13 Mar 2017, 21:22
3
Kudos
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
Attachments

Business School Choice.xlsx [12.76 KiB]
Downloaded 313 times

avatar
B
MBAHanover2018
Intern
Intern
Joined: 16 May 2018
Posts: 29
Own Kudos [?]: 15 [0]
Given Kudos: 61
Concentration: General Management, Nonprofit
Schools: Haas '21 Tuck '21
GMAT 1: 700 Q50 V37
GPA: 3.9
Send PM
Re: Excel template to evaluate MBA offers. [#permalink] New post   10 Jun 2018, 14:35
great !!! thanks for sharing
User avatar
L
bb
Founder
Founder
Joined: 04 Dec 2002
Posts: 37311
Own Kudos [?]: 72892 [0]
Given Kudos: 18869
Location: United States (WA)
GMAT 1: 750 Q49 V42
GPA: 3
Send PM
GMAT ToolKit User CAT Tests Forum Quiz Mode
Re: Excel template to evaluate MBA offers. [#permalink] New post   26 Mar 2019, 19:56
Expert Reply
BUMP. Perhaps someone finds this tool useful for the 2019 Decisions.
GMAT Club Bot
gmatclubot
Re: Excel template to evaluate MBA offers. [#permalink]
26 Mar 2019, 19:56
Moderator:
PyjamaScientist
Admitted - Which School Forum Moderator
1131 posts

Powered by phpBB © phpBB Group | Emoji artwork provided by EmojiOne
Main navigation
GMAT Resources
Partners
MBA Resources
www.gmac.com|www.mba.com | | GMAT Club Rules | Terms and Conditions