It is currently Fri Mar 12, 2010 11:19 am
Image
GMAT ToolKit becomes an open platform for test takers and Prep companies!

Additional 236 questions from our partner Manhattan Review are already available. Update your application for free.

Manhattan Review Discount: Save 10% and free GMAT Club Tests




Post new topic Reply to topic  [ 49 posts ]  Bookmark and Share Go to page 1, 2, 3  Next
Author Message
TAGS:
 Post subject: The True Value of YOUR MBA [#permalink]
PostPosted: Tue May 20, 2008 3:37 pm 
Offline
Major Shareholder
Major Shareholder
User avatar

Joined: Fri Jul 27, 2007
Posts: 875
Location: Sunny So Cal
Concentration: Investment Management
Schools: CBS, Cornell, Duke, Ross, Darden

Kudos (?): 115 (45), given: 4

So I’ve had a little downtime over the last few days in the office and was thinking about my cost of earning an MBA. This mini-analysis ended up taking on a life of its own and it turned into a pretty sophisticated look at figuring out what am I giving up and how long (and how much) it is going to take to pay off. I realize that $$$ is not the (only) reason that people go to b-school, but it's definitely an important factor. As a very analytical person, I thought it was important to dig deep on this topic.

I have put together what I think is a comprehensive MBA return on investment (ROI) tool/model (more specifically, I used net present value, NPV). It looks at the MBA and non-MBA career paths and identifies not only when you’ll “breakeven” but also how your compensation will look over an extended period of time. I believe there are some other tools available online, but I don’t think that any of them offer much flexibility and are way to simplistic for a very important and complicated decision. Since I’ve gained so much from gmatclub, I wanted to share this tool so that my fellow g-clubbers can tailor it based on personalized life plans.

For example, some people want to go into i-banking. This particular job function has a pretty unique compensation path. Moreover, most people that (want to) go into banking, only do so for a few years before jumping to investment management or private equity or some other excursion. Therefore, it wouldn’t make sense to say, “My compensation is going to be $350k for the next 12 years.” Other folks want to go into marketing, consulting, operations, strategy, etc. - areas that have different compensation tracks than investment banking. This tool is designed for any person starting with/transitioning to any career path.

I realize this may not be perfect, but I think it will be very informative regardless of your interests. This should help you whether you’re considering an elite vs. a trans-elite or a tier-two school vs. a regional program. It will also be helpful for those that are deciding between a part-time or full-time program. This will also help high-income earners that are deciding whether to go back to school at all. Ultimately, I wanted to create something that is user friendly and allows for almost an unlimited number of scenarios. If you have any questions, feel free to ask. Enjoy and let me know what you think.


Cheers,
ryguy


EDIT - Version 2.0 Available Now!

I made a handful of changes since I created this model last summer, but below are the two major changes that I have made:

1) Updated fields to incorporate internship earnings

2) Ability to easily compare a part-time v. full-time MBA program (from a financial perspective)


A couple of comments and feedback that were suggested from last time that I did not specifically address (and my reasons for choosing not to do so).

1) Debt service of student loans. So here’s the deal. This model assumes that tuition is paid upfront (i.e., during school). This is unrealistic for the vast majority of folks on the board here, and probably most students in general. However, I prefer to take a highly conservative approach when it comes to figuring out when I will break even. I suppose this is a worst-case scenario (i.e., makes the payback period look longer than it should), but in my mind, I’d rather err on the side of a longer payback period than a shorter payback period.

So why does this matter when tuition is paid? It is more expensive to pay for tuition with today’s dollars than it is X years down the road. For instance, if you are on a 10-yr repayment plan paying $600 a month - $600 in today’s terms is a lot more money than it is 5, 6, or 7 years from now (and for simplicity’s sake, let’s ignore fluctuations in the value of the US dollar). If you don’t believe me, ask yourself this: Would you rather I gave you $600 today or $600 in 6 years from now. Good, I’m glad we’re on the same page. :) For more detail on this, I explain this in general assumption #3 on the Instructions worksheet. In that section, I’ve also included instructions for a scenario that could be applicable for folks that go into investment banking, private equity, or any other very high paying post-MBA job.

2) Taxes. I received some comments saying that tuition is paid with after-tax dollars, but salary is listed in before tax dollars. Sure, fair enough. If you think that it is appropriate to adjust for this, multiple your salary by (1 minus your expected tax rate) and plug that in for your post-grad salary. I chose not to do this for the base case scenario, but again, I’ve tried to make this model flexible enough where you can put in whatever assumptions YOU think are appropriate.


Updated directions are included on the first worksheet of the excel file. Let me know if you have any questions. I’ll be happy to address any issues/comments that may be related to your particular circumstances. Also, if you think there are any improvements that could be made to this for future versions, I’ll see what I can do to incorporate them. And again, I'm human, so if you find any errors, let me know and I'll correct them. Enjoy and let me know what you think.


Attachments:
File comment: Value of an MBA v2.0
Value of an MBA v2.0.xls [70 KiB]
Downloaded 1362 times
File comment: Value of an MBA
Value of an MBA.xls [62 KiB]
Downloaded 1451 times

_________________
The True Value of YOUR MBA: 103-t64239
GMATClub's Unofficial Chartered Financial Analyst thread: 103-t63245
How Much Weight Does the CFA Carry with Admissions: 103-t68059
Top
 Profile  
 
 Post subject: Re: The True Value of YOUR MBA [#permalink]
PostPosted: Tue May 20, 2008 4:39 pm 
Offline
Major Shareholder
Major Shareholder
User avatar

Joined: Wed Feb 20, 2008
Posts: 809
Location: Texas
Concentration: Finance
Schools: Kellogg Class of 2011

Kudos (?): 118 (0), given: 9

It's amazing how soon the breakeven year is if you get into i-banking. I think mine is 2-2.5 years out or so vs. not getting an MBA and staying in my current non banking career.

+2 for you.


Top
 Profile E-mail  
 
 Post subject: Re: The True Value of YOUR MBA [#permalink]
PostPosted: Tue May 20, 2008 5:38 pm 
Offline
Major Shareholder
Major Shareholder
User avatar

Joined: Thu Jan 17, 2008
Posts: 594
Location: Ann Arbor, MI
Concentration: Sustainable Development
Schools: Ross '12 (MBA/MS)

Kudos (?): 52 (0), given: 32

That's pretty neat. Thanks for sharing!

_________________
Profile | GMAT | Erb Institute


Top
 Profile E-mail  
 
 Post subject: Re: The True Value of YOUR MBA [#permalink]
PostPosted: Tue May 20, 2008 6:10 pm 
Offline
CEO in training
CEO in training
User avatar

Joined: Tue Mar 11, 2008
Posts: 1753
Location: Southern California
Concentration: Investment Banking
Schools: Chicago (dinged), Tuck (November), Columbia (RD)

Kudos (?): 138 (0), given: 0

Impressive indeed - Thank you sir

_________________
Check out the new Career Forum
http://gmatclub.com/forum/133


Top
 Profile E-mail  
 
 Post subject: Re: The True Value of YOUR MBA [#permalink]
PostPosted: Tue May 20, 2008 7:18 pm 
Offline
CEO
CEO
User avatar

Joined: Wed Apr 05, 2006
Posts: 5568
Concentration: Finance, Entrepreneurship, Strategic Management, Managerial and Organizational Behavior
Schools: Booth

Kudos (?): 743 (1), given: 2

You belong in an MBA program.


Top
 Profile  
 
 Post subject: Re: The True Value of YOUR MBA [#permalink]
PostPosted: Tue May 20, 2008 7:23 pm 
Offline
Senior Manager
Senior Manager
User avatar

Joined: Tue Feb 05, 2008
Posts: 318
Location: Texas

Kudos (?): 55 (0), given: 4

Great spreadsheet!

This will help me out in the near future, kudos!


Top
 Profile E-mail  
 
 Post subject: Re: The True Value of YOUR MBA [#permalink]
PostPosted: Tue May 20, 2008 9:51 pm 
Offline
Manager
Manager
User avatar

Joined: Sat Dec 01, 2007
Posts: 198

Kudos (?): 9 (0), given: 0

Interesting spreadsheet there! Good Stuff...Kudos!


Top
 Profile  
 
 Post subject: Re: The True Value of YOUR MBA [#permalink]
PostPosted: Wed May 21, 2008 5:41 am 
Offline
Major Shareholder
Major Shareholder
User avatar

Joined: Fri Sep 14, 2007
Posts: 879
Schools: Kellogg '10

Kudos (?): 59 (0), given: 13

As I suspected...lower NPV for getting an MBA. :cry:

_________________
www.fantasticcontraption.com


Top
 Profile  
 
 Post subject: Re: The True Value of YOUR MBA [#permalink]
PostPosted: Wed May 21, 2008 6:30 am 
Offline
Manager
Manager
User avatar

Joined: Tue Jan 24, 2006
Posts: 221

Kudos (?): 2 (0), given: 0

gr8 spreadsheet..... kudos to you

_________________
Eat like a Pig, Lift like a Demon & Sleep like Dead.............


Top
 Profile  
 
 Post subject: Re: The True Value of YOUR MBA [#permalink]
PostPosted: Wed May 21, 2008 6:37 am 
Offline
Manager
Manager

Joined: Thu Mar 13, 2008
Posts: 85

Kudos (?): 12 (0), given: 0

Great stuff! +1


Top
 Profile E-mail  
 
 Post subject: Re: The True Value of YOUR MBA [#permalink]
PostPosted: Wed May 21, 2008 1:00 pm 
Offline
Major Shareholder
Major Shareholder
User avatar

Joined: Thu Feb 08, 2007
Posts: 647
Location: New Haven, CT

Kudos (?): 15 (0), given: 0

This is one of the most valuable posts i have seen on GMATclub...kudos.

_________________
Lanter 1

"Lunch is for wimps."


Top
 Profile  
 
 Post subject: Re: The True Value of YOUR MBA [#permalink]
PostPosted: Wed May 21, 2008 1:03 pm 
Offline
Senior Manager
Senior Manager
User avatar

Joined: Wed Jan 23, 2008
Posts: 498

Kudos (?): 44 (0), given: 0

nice.


Top
 Profile E-mail  
 
 Post subject: Re: The True Value of YOUR MBA [#permalink]
PostPosted: Wed May 21, 2008 3:38 pm 
Offline
Intern
Intern

Joined: Fri Nov 09, 2007
Posts: 18

Kudos (?): 1 (0), given: 0

Great stuff man. Now that I looked at the numbers, I am rethinking whether going for the MBA is a good move or not.

What would you guys pick: MBA from Ross/Tauber institute with $0 Scholarship or $170K/year salary in bay area with loads of stock options?


Top
 Profile  
 
 Post subject: Re: The True Value of YOUR MBA [#permalink]
PostPosted: Wed May 21, 2008 3:54 pm 
Offline
Senior Manager
Senior Manager
User avatar

Joined: Tue Feb 05, 2008
Posts: 318
Location: Texas

Kudos (?): 55 (0), given: 4

sensation wrote:
Great stuff man. Now that I looked at the numbers, I am rethinking whether going for the MBA is a good move or not.

What would you guys pick: MBA from Ross/Tauber institute with $0 Scholarship or $170K/year salary in bay area with loads of stock options?


For me, an MBA is a set goal of mine, so to simply make a pick between the two without further information would be incorrect. If I was you, I would make a list of pros and cons, then decide which side it favors.


Top
 Profile E-mail  
 
 Post subject: Re: The True Value of YOUR MBA [#permalink]
PostPosted: Wed May 21, 2008 4:03 pm 
Offline
Intern
Intern
User avatar

Joined: Thu Oct 05, 2006
Posts: 43

Kudos (?): 4 (0), given: 0

sensation, i was in the same boat as you. roughly 160k/yr and stock grants that would have been vested in a year and a half. i ultimately decided that i want a mba.

it really is a matter of want. how badly do you want a masters degree, and pursue higher education. do your homework in realizing what a mba can and can not provide you.


Top
 Profile  
 
 Post subject: Re: The True Value of YOUR MBA [#permalink]
PostPosted: Wed May 21, 2008 5:57 pm 
Offline
VP
VP
User avatar

Joined: Tue Aug 07, 2007
Posts: 1063

Kudos (?): 27 (0), given: 0

Absolutely great spreadsheet Ryguy! Kudos coming your way. Just had a question - if I had to include my internship $'s in this sheet, is there a "right" place to do so?

Thanks again!


Top
 Profile  
 
 Post subject: Re: The True Value of YOUR MBA [#permalink]
PostPosted: Wed May 21, 2008 8:27 pm 
Offline
Major Shareholder
Major Shareholder
User avatar

Joined: Fri Jul 27, 2007
Posts: 875
Location: Sunny So Cal
Concentration: Investment Management
Schools: CBS, Cornell, Duke, Ross, Darden

Kudos (?): 115 (0), given: 4

dosa_don wrote:
Absolutely great spreadsheet Ryguy! Kudos coming your way. Just had a question - if I had to include my internship $'s in this sheet, is there a "right" place to do so?

Thanks again!


DD-
Thanks for the kind words! I totally forgot about the internship! I'll have a special input for that in version 2.0. :) In the meantime, the easiest way would probably be to do a "manual override" in Year 2 (2009). Simply reduce your tuition fees for that year by the expected amount to be earned from your internship. For instance, say you expect to earn $15,000. You can change cell D12 to read "=D30 + 15000." Notice this would be a plus sign since it is a positive cash flow. Hope that helps and thanks for the great suggestion. I'll post an update in the next day or so.
-RG


Top
 Profile  
 
 Post subject: Re: The True Value of YOUR MBA [#permalink]
PostPosted: Wed May 21, 2008 8:33 pm 
Offline
VP
VP
User avatar

Joined: Tue Aug 07, 2007
Posts: 1063

Kudos (?): 27 (0), given: 0

No problem- I sort of did work around it in a similar manner but wanted to make sure! Great spreadsheet and looking forward to V2.0


Top
 Profile  
 
 Post subject: Re: The True Value of YOUR MBA [#permalink]
PostPosted: Thu May 22, 2008 1:51 am 
Offline
Senior Manager
Senior Manager
User avatar

Joined: Wed Mar 21, 2007
Posts: 469

Kudos (?): 11 (0), given: 0

Excellent! Thanks for sharing.


Top
 Profile  
 
 Post subject: Re: The True Value of YOUR MBA [#permalink]
PostPosted: Thu May 22, 2008 8:47 am 
Offline
Manager
Manager

Joined: Tue Oct 30, 2007
Posts: 217
Location: Dallas
Concentration: Technology Management
Schools: Fuqua, Anderson, Johnson, Ross

Kudos (?): 53 (0), given: 2

Awesome! As rhyme said, you are more than ready for B-School :)


Top
 Profile E-mail  
 
Online
gmatclubot
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 49 posts ]  Go to page 1, 2, 3  Next

Related Discussions

Forum

Which of the following must be true? GMAT Problem Solving (PS)
PS-Must Be True- 2 GMAT Problem Solving (PS)
which is true GMAT Math Questions and Intellectual Discussions
PS-Must Be True GMAT Problem Solving (PS)
CR: Must be true Verbal GMAT Questions


Who is online

Users browsing this forum: aam2005, Aenigma, asimov, fiver5, mbachallenge, radicalchange, shana22, ykostyuk and 14 guests


Search for:
Jump to:




cron
GMAT Club MBA Forum Home | Sitemap | About | Privacy Policy | Terms and Conditions | GMAT Club Rules | Contact
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
Kindly note that GMAT (C) is a registered trademark of the Graduate Management Admission Council, and this site has neither been reviewed nor endorsed by GMAC.