It is currently 21 Oct 2017, 12:49

### 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

# Events & Promotions

###### Events & Promotions in June
Open Detailed Calendar

# HELP-ROI/Break Even Calculator

 new topic post reply Question banks Downloads My Bookmarks Reviews Important topics
Author Message
Senior Manager
Joined: 02 May 2004
Posts: 311

Kudos [?]: 7 [0], given: 0

HELP-ROI/Break Even Calculator [#permalink]

### Show Tags

25 Mar 2008, 09:58
Anyone know of a good ROI Calculator for MBA-I need to know my break even point..
I can only find one-on Forbes and my school is not listed and not sure how up to date it is..
Any assistance would be appreciated..

Jim

Kudos [?]: 7 [0], given: 0

Current Student
Joined: 27 Jul 2007
Posts: 872

Kudos [?]: 206 [0], given: 4

Location: Sunny So Cal
Schools: CBS, Cornell, Duke, Ross, Darden
Re: HELP-ROI/Break Even Calculator [#permalink]

### Show Tags

25 Mar 2008, 10:08
Not sure what your specific needs are, but give this a shot.

http://dinkytown.net/business.html

Kudos [?]: 206 [0], given: 4

Senior Manager
Joined: 23 Jan 2008
Posts: 498

Kudos [?]: 52 [0], given: 0

Re: HELP-ROI/Break Even Calculator [#permalink]

### Show Tags

25 Mar 2008, 15:29
YOu should be able to hack something together in excel with the data on expected graduate salary, your current salary, expected cost of schools. You could add in a weighting based on % of students with jobs lined up at graduation if you want to get fancy.

If you can't create a rough spreadsheet for this in .. say.. an hour, you should maybe re-evaluate your quantitative skills and try to improve them before applying to b-school.

Kudos [?]: 52 [0], given: 0

GMAT Club Legend
Joined: 10 Apr 2007
Posts: 4318

Kudos [?]: 762 [0], given: 5

Location: Back in Chicago, IL
Schools: Kellogg Alum: Class of 2010
Re: HELP-ROI/Break Even Calculator [#permalink]

### Show Tags

25 Mar 2008, 16:51
Your school may not show up on their listing but you may find one thats fairly close in standing.

http://www.forbes.com/2007/08/15/busine ... _calc.html
_________________

Kellogg Class of 2010...still active and willing to help. However, I do not do profile reviews, don't offer predictions on chances and am far to busy to review essays, so save the energy of writing me a PM seeking help for these. If I don't respond to a PM that is not one of the previously mentioned trash can destined messages, please don't take it personally I get so many messages I have a hard to responding to most. The more interesting, compelling, or humorous you message the more likely I am to respond.
GMAT Club Premium Membership - big benefits and savings

Kudos [?]: 762 [0], given: 5

Senior Manager
Joined: 02 May 2004
Posts: 311

Kudos [?]: 7 [0], given: 0

Re: HELP-ROI/Break Even Calculator [#permalink]

### Show Tags

25 Mar 2008, 21:08
westsider wrote:
YOu should be able to hack something together in excel with the data on expected graduate salary, your current salary, expected cost of schools. You could add in a weighting based on % of students with jobs lined up at graduation if you want to get fancy.

If you can't create a rough spreadsheet for this in .. say.. an hour, you should maybe re-evaluate your quantitative skills and try to improve them before applying to b-school.

My quant skills are fine. I just have not had finance yet to do such a calculation, and I am not an excel wiz. I was trying to find something a little more concrete that would take cost of student loans, etc, into consideration. I figured out my loan payments would be close to 780 dollars a month for the 10 year payment plan and about 500 for the 25 year plan.

I think someone had some type of spreadsheet posted on here somewhere last year, but I can't locate it.

Kudos [?]: 7 [0], given: 0

SVP
Joined: 01 Nov 2006
Posts: 1855

Kudos [?]: 208 [0], given: 2

Schools: The Duke MBA, Class of 2009
Re: HELP-ROI/Break Even Calculator [#permalink]

### Show Tags

25 Mar 2008, 21:47
westsider wrote:
YOu should be able to hack something together in excel with the data on expected graduate salary, your current salary, expected cost of schools. You could add in a weighting based on % of students with jobs lined up at graduation if you want to get fancy.

If you can't create a rough spreadsheet for this in .. say.. an hour, you should maybe re-evaluate your quantitative skills and try to improve them before applying to b-school.

be nice. lots of people go into b-school without having much quant or biz background...myself included. and i am doing just fine, thank you.

Kudos [?]: 208 [0], given: 2

Senior Manager
Joined: 23 Jan 2008
Posts: 498

Kudos [?]: 52 [0], given: 0

Re: HELP-ROI/Break Even Calculator [#permalink]

### Show Tags

25 Mar 2008, 22:36
Sorry bout that. Came out a little different then I intended! Oh the hazards of posting from work!

Anyhow, I was trying to say its a good exercise for practice in excel since it isn't too intensive. I made one sometime back for my own personal use. I'll post it here if i can find it!

Kudos [?]: 52 [0], given: 0

Senior Manager
Joined: 02 May 2004
Posts: 311

Kudos [?]: 7 [0], given: 0

Re: HELP-ROI/Break Even Calculator [#permalink]

### Show Tags

26 Mar 2008, 15:40
Ok I finally figured out how to drag an equation down an entire row in Excel so I was able to do salary increases without having to type the formula into each individual cell.

I am just slightly confused as to what figure I should use in terms of "costs" for MBA...more specifically. how I should factor in the cost of attendance. The tuition/living costs for two years is 63,000. However, taking into account the fact interest will be capitalizing on the loans during my time there, the final loan balance would be around \$70,000. If I do the extended repayment plan for 30 years, the sum of payments would be \$170,073.10. That would keep the payments under 500 a month. If I do the 10 year plan, it would be 96.605..
What would be the best figure to use or am I totally off by doing it this way?

Kudos [?]: 7 [0], given: 0

SVP
Joined: 01 Nov 2006
Posts: 1855

Kudos [?]: 208 [0], given: 2

Schools: The Duke MBA, Class of 2009
Re: HELP-ROI/Break Even Calculator [#permalink]

### Show Tags

26 Mar 2008, 15:45
you want to do a differential analysis. in other words, only include things that are different in the two scenarios: you would have cost of living expenses anyway, so don't put those in. (Do put in, though, the interest. And if there are differences in your living expenses between the two scenarios, do include those.)

Kudos [?]: 208 [0], given: 2

Senior Manager
Joined: 02 May 2004
Posts: 311

Kudos [?]: 7 [0], given: 0

Re: HELP-ROI/Break Even Calculator [#permalink]

### Show Tags

26 Mar 2008, 17:11
Ok if I subtract my living expenses for the two years, I guess I will come up with about with around 30k for the area..the budget allowed by the school is 6245 per semester and then I would have to factor in the summer living expenses. ...

So this is what I have. I would have to do the 30 year option to pay back the loans..no way I am going to be able to swing 850 a month. Total costs for the school would be 170,073.10.-30000 for living expenses so 140,073 plus two years salary after taxes which would be around 38,000 per year for me.

Total cost of school would be 216,000?

Kudos [?]: 7 [0], given: 0

VP
Joined: 11 Dec 2006
Posts: 1430

Kudos [?]: 223 [0], given: 6

Location: New York, NY
Schools: NYU Stern 2009
Re: HELP-ROI/Break Even Calculator [#permalink]

### Show Tags

28 Mar 2008, 18:34
Well, summer costs should be offset by a summer internship - I would say assuming neutral for summer would be conservative. Otherwise your future career plans clearly throw your lifestyle into question!
_________________

Kudos [?]: 223 [0], given: 6

Re: HELP-ROI/Break Even Calculator   [#permalink] 28 Mar 2008, 18:34
Display posts from previous: Sort by

# HELP-ROI/Break Even Calculator

 new topic post reply Question banks Downloads My Bookmarks Reviews Important topics

 Powered by phpBB © phpBB Group | Emoji artwork provided by EmojiOne Kindly note that the GMAT® test is a registered trademark of the Graduate Management Admission Council®, and this site has neither been reviewed nor endorsed by GMAC®.