Last visit was: 19 Nov 2025, 14:30 It is currently 19 Nov 2025, 14:30
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.
Close
Request Expert Reply
Confirm Cancel
User avatar
ryguy904
User avatar
Current Student
Joined: 27 Jul 2007
Last visit: 10 Sep 2013
Posts: 859
Own Kudos:
216
 [97]
Given Kudos: 4
Location: Sunny So Cal
Concentration: Investment Management
Schools:CBS, Cornell, Duke, Ross, Darden
Posts: 859
Kudos: 216
 [97]
88
Kudos
Add Kudos
9
Bookmarks
Bookmark this Post
User avatar
isa
User avatar
Current Student
Joined: 04 Dec 2007
Last visit: 21 Jan 2010
Posts: 1,687
Own Kudos:
Given Kudos: 31
Concentration: Healthcare, Strategy, MC
Schools:Kellogg '11
Posts: 1,687
Kudos: 224
Kudos
Add Kudos
Bookmarks
Bookmark this Post
User avatar
bherronp
User avatar
Current Student
Joined: 24 Apr 2007
Last visit: 30 Mar 2010
Posts: 588
Own Kudos:
Posts: 588
Kudos: 17
Kudos
Add Kudos
Bookmarks
Bookmark this Post
avatar
sudden
Joined: 31 Oct 2007
Last visit: 29 Jan 2012
Posts: 242
Own Kudos:
Posts: 242
Kudos: 27
Kudos
Add Kudos
Bookmarks
Bookmark this Post
great model. i had set up a similar one before applying but yours is even more detailed.

the only thing i would add is that these types of models have a difficult time incorporating option value. there's obvious option value in completing an MBA program and getting a job you otherwise would not have been able to get, but there is a lot of "unknown" option value as well. to the extent that you meet the right people and get connected into amazing opportunities, so much the better. my point is that if the model is close on an after cost basis (as might be the case if you are not an aspiring finance baller), it's probably worth rolling the dice if you can get into a good school -- you never know what might come your way.
avatar
perfectexamscore
Joined: 12 Jul 2008
Last visit: 17 Jul 2008
Posts: 69
Own Kudos:
Posts: 69
Kudos: 4
Kudos
Add Kudos
Bookmarks
Bookmark this Post
thanks for providing this.
User avatar
sam77sam7
User avatar
Current Student
Joined: 02 Jan 2008
Last visit: 06 Mar 2012
Posts: 597
Own Kudos:
Location: Detroit, MI
Concentration: Consulting
Posts: 597
Kudos: 30
Kudos
Add Kudos
Bookmarks
Bookmark this Post
Ryguy,

Great tool, very comprehensive!

Thanks!

~Sam
User avatar
zakk
Joined: 17 Jul 2007
Last visit: 28 Jul 2008
Posts: 230
Own Kudos:
Location: The 408
Posts: 230
Kudos: 7
Kudos
Add Kudos
Bookmarks
Bookmark this Post
great tool! How you would suggest us PT'ers edit it to make our situation reflect the results!

Either way, +1!!
User avatar
ryguy904
User avatar
Current Student
Joined: 27 Jul 2007
Last visit: 10 Sep 2013
Posts: 859
Own Kudos:
216
 [1]
Given Kudos: 4
Location: Sunny So Cal
Concentration: Investment Management
Schools:CBS, Cornell, Duke, Ross, Darden
Posts: 859
Kudos: 216
 [1]
1
Kudos
Add Kudos
Bookmarks
Bookmark this Post
zakk
great tool! How you would suggest us PT'ers edit it to make our situation reflect the results!

Either way, +1!!

Great question, perhaps something that I can work on for Version 2.0. :)

I think the easiest way would be to manually override the cash flows for the first three years. For instance, the average full-time MBA does not have any income in Yr 1 and Yr 2 (with the exception of an internship), so his/her cash flow is negative and simply the amount of tuition. In your case, your tuition will be offset by your income (sweet!), so you will have positive cash flow in those years (salary - tuition + any company reimbursement = cash flow). You can use that as a starting point for your years 1 and 2. The other adjustment that you will need to make is for "salary upon graduation." I assume that the PT program is three years, instead of two, so you will need an override adjustment in year 3 (again, this is the aforementioned formula). From there it should work, since the stages are set up to increase your salary by the percentage that you designate.

Hope that helps. Let me know if you have any more questions or would like some clarity on this.
User avatar
bobinabob2
Joined: 23 Nov 2006
Last visit: 08 Oct 2010
Posts: 127
Own Kudos:
Location: Philadelphia, PA
Posts: 127
Kudos: 63
Kudos
Add Kudos
Bookmarks
Bookmark this Post
great tool! +1!
User avatar
solaris1
Joined: 05 Aug 2007
Last visit: 09 Aug 2011
Posts: 1,431
Own Kudos:
Given Kudos: 22
Concentration: General Management
Schools:NYU Stern '11
Posts: 1,431
Kudos: 223
Kudos
Add Kudos
Bookmarks
Bookmark this Post
yikes, 6-7 years to recoup my investment in the best case scenario. Anybody want to try making an argument about how pursuing an MBA has significant intangible value not reflected in ryguy's mad awesome spreadsheet? :?

Certainly puts a lot of things into perspective.
User avatar
westsider
Joined: 23 Jan 2008
Last visit: 17 Dec 2009
Posts: 498
Own Kudos:
Posts: 498
Kudos: 62
Kudos
Add Kudos
Bookmarks
Bookmark this Post
solaris1
yikes, 6-7 years to recoup my investment in the best case scenario. Anybody want to try making an argument about how pursuing an MBA has significant intangible value not reflected in ryguy's mad awesome spreadsheet? :?

Certainly puts a lot of things into perspective.
First off, hopefully you are also looking to enter a field that in some way you will find more enjoyable post-mba. That is some of the intangible value. Then, on the financial side you need to consider the spreadsheet is the average number. You will do better or worse than this, but will almost certainly not hit the exact number. The big thing here is,as "Sudden" said above:
"the only thing i would add is that these types of models have a difficult time incorporating option value"
I found this very well stated - Option value is very tough to predict. Basically, while not necessarily likely, you have a vastly increased chance of doing something that will make you filthy rich.

I think that sums up the 2 main intangibles - did I miss any?
User avatar
icon
User avatar
Current Student
Joined: 16 Jun 2008
Last visit: 02 Jan 2010
Posts: 104
Own Kudos:
Concentration: Finance
Schools:Texas
Posts: 104
Kudos: 11
Kudos
Add Kudos
Bookmarks
Bookmark this Post
Great spreadsheet ryguy! Haven't had a chance to really pour into it but looks like a fun tool.

I would like to add a potential question to those that are trying to calculate a precise ROI using this model. How does tax-affecting cash flows change the end result of your calculations? I'm not sure if the impact will be material or not but I'm looking forward to playing around with the model a bit to see.
User avatar
zakk
Joined: 17 Jul 2007
Last visit: 28 Jul 2008
Posts: 230
Own Kudos:
Location: The 408
Posts: 230
Kudos: 7
Kudos
Add Kudos
Bookmarks
Bookmark this Post
ryguy904
zakk
great tool! How you would suggest us PT'ers edit it to make our situation reflect the results!

Either way, +1!!

Great question, perhaps something that I can work on for Version 2.0. :)

I think the easiest way would be to manually override the cash flows for the first three years. For instance, the average full-time MBA does not have any income in Yr 1 and Yr 2 (with the exception of an internship), so his/her cash flow is negative and simply the amount of tuition. In your case, your tuition will be offset by your income (sweet!), so you will have positive cash flow in those years (salary - tuition + any company reimbursement = cash flow). You can use that as a starting point for your years 1 and 2. The other adjustment that you will need to make is for "salary upon graduation." I assume that the PT program is three years, instead of two, so you will need an override adjustment in year 3 (again, this is the aforementioned formula). From there it should work, since the stages are set up to increase your salary by the percentage that you designate.

Hope that helps. Let me know if you have any more questions or would like some clarity on this.

Worked like a charm! Just took a bit of work.

Looks like 8 years to work mine off, but the opportunity this presents is simply too much to pass over, even if it is a year later than I'd like to start.

Thanks again!
User avatar
ryguy904
User avatar
Current Student
Joined: 27 Jul 2007
Last visit: 10 Sep 2013
Posts: 859
Own Kudos:
Given Kudos: 4
Location: Sunny So Cal
Concentration: Investment Management
Schools:CBS, Cornell, Duke, Ross, Darden
Posts: 859
Kudos: 216
Kudos
Add Kudos
Bookmarks
Bookmark this Post
zakk

Worked like a charm! Just took a bit of work.

Looks like 8 years to work mine off, but the opportunity this presents is simply too much to pass over, even if it is a year later than I'd like to start.

Thanks again!

Hey Zakk,

Glad that worked. I will definitely incorporate a PT feature in the next version.

As far as *your* payback goes, there is NOTHING wrong with 8 years. The way that NPV and the time value of money works is that if you are comparing project A (or no MBA in this case)and project B (MBA), you will choose the project that has the highest NPV (which for you is earning an MBA). If it said the payback was 45 years and you are 70 years old now, well, then that would be a problem. But for any of us in our 20's or even early 30's, there is nothing wrong with an 8 year or even a 10 year payback. If you include the intangibles, which unfortunately I'm not capable of quantifying - your payback will be even sooner!

All the best,
ryguy
User avatar
mojoman
Joined: 16 Jul 2008
Last visit: 25 Apr 2011
Posts: 22
Own Kudos:
Given Kudos: 1
Location: USA
Schools:MIT, Chicago, Columbia, Yale, Kellogg
Posts: 22
Kudos: 1
Kudos
Add Kudos
Bookmarks
Bookmark this Post
+1 for you, RyGuy. Very, very helpful stuff. Must have taken quite a bit of time and effort to set this up, so much appreciated!
avatar
falibay
avatar
Current Student
Joined: 28 Feb 2008
Last visit: 29 Dec 2009
Posts: 370
Own Kudos:
Given Kudos: 2
Location: New York, Paris
Concentration: Finance, Entrepreneurship
Schools:Wharton '11
Posts: 370
Kudos: 6
Kudos
Add Kudos
Bookmarks
Bookmark this Post
Nice spreadsheet!! Just one thing to note, your salaries are pre-tax and the tuition cost are post-tax. It may make more sense to convert tuitions cost to a pre-tax number (e.g $45K becomes 45/(1-0.40) = 75)


Crap, my breakeven is 10 years + .
User avatar
Manbehindthecurtain
Joined: 06 Jan 2008
Last visit: 28 Sep 2011
Posts: 203
Own Kudos:
Given Kudos: 1
Posts: 203
Kudos: 543
Kudos
Add Kudos
Bookmarks
Bookmark this Post
Nice job. I did a similar exercise for my wife's medical school and physician career. Considers yourselves lucky, ladies and gentlemen, in an unspecialized medical practice (ie internal medicine), one never breaks even.

Also, I did not notice a section in this model for debt service, which would add at least a few years onto the breakeven.
User avatar
msday
Joined: 25 Dec 2007
Last visit: 09 Jul 2014
Posts: 515
Own Kudos:
Given Kudos: 28
Concentration: General Management
Schools:Harvard '11
GMAT 1: 790 Q51 V48
Posts: 515
Kudos: 64
Kudos
Add Kudos
Bookmarks
Bookmark this Post
In a 40+ year career, a breakeven point of 10 years is not bad at all! Let's say you work for 3 years, get your MBA, and then spend the next 10 years getting back to even. Then you spend the next 25 years making great money and living the good life.
avatar
edwarise
Joined: 26 Jan 2008
Last visit: 08 Oct 2008
Posts: 19
Own Kudos:
9
 [2]
Posts: 19
Kudos: 9
 [2]
2
Kudos
Add Kudos
Bookmarks
Bookmark this Post
interesting analysis, thank you. but why you are so pessimistic about your future? growth rates look a quite low. is it really than even in 2020 (12 years ahead) you can get only 186k with MBA and 90 without? what is your country and industry? I think you should believe in yourself more!

P.S. what about taxation and inflation? do you estimate incomes after it? What about economic cycle? maybe changing career in the future?

P.S.2: My ROI is definitely very negative, but I'm not worried about it. I think education can not be measured just in money. personal effect more important and can not be measured.
User avatar
subarao
Joined: 11 Apr 2008
Last visit: 11 Aug 2009
Posts: 169
Own Kudos:
Given Kudos: 1
Posts: 169
Kudos: 21
Kudos
Add Kudos
Bookmarks
Bookmark this Post
This is a very good source of information but I think it is highly empirical,
So I have several questions and I hope somebody will address to these.

1. Does this equation holds good for all MBA program? Or only from top 15 schools from US?
2. And the break even has been calculated taking 60k as current salary. What about those cases or people who are already making more than 60K?
3. Does this calculation addresses the increased tax and expenditure due to increase in salary in future?
sorry to ask such basic or preliminary questions as I am from pure science background ( a very little idea on business and finance)
thanks all
User avatar
ryguy904
User avatar
Current Student
Joined: 27 Jul 2007
Last visit: 10 Sep 2013
Posts: 859
Own Kudos:
216
 [2]
Given Kudos: 4
Location: Sunny So Cal
Concentration: Investment Management
Schools:CBS, Cornell, Duke, Ross, Darden
Posts: 859
Kudos: 216
 [2]
2
Kudos
Add Kudos
Bookmarks
Bookmark this Post
subarao
This is a very good source of information but I think it is highly empirical,
So I have several questions and I hope somebody will address to these.

1. Does this equation holds good for all MBA program? Or only from top 15 schools from US?
2. And the break even has been calculated taking 60k as current salary. What about those cases or people who are already making more than 60K?
3. Does this calculation addresses the increased tax and expenditure due to increase in salary in future?
sorry to ask such basic or preliminary questions as I am from pure science background ( a very little idea on business and finance)
thanks all
The numbers that I have plugged in are as a sample (i.e., illustrative purposes only) so that you know which data points you should enter ON YOUR OWN. As I said in my original post and in the directions tab, this is supposed to look at the value of YOUR MBA. So plug in YOUR numbers. It doesn't matter if you go to top 50 or top 5, it's all based on the assumptions that you put in. However, if you are assuming $140,000 starting salary for a top 50 school, well then "garbage in, garbage out."

Currently it does not account for taxes. The easy way to get around that is to simply enter all of your info in net tax (after tax) dollars.

And again, this is not designed to be the ultimate solution for everyone. The main point is to give you an idea what your situation looks like. If your NPV is 5 years - great. If it's 10, that's also great, since we are all concerned with the long run. Even if it's >20years, that may be OK for some people because of the intangible aspects of going to school (e.g., network, formal business education, career switch, etc.).

Hope that helps.
   1   2   3   4