Find all School-related info fast with the new School-Specific MBA Forum

It is currently 20 Oct 2014, 13:40

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.

Events & Promotions

Events & Promotions in June
Open Detailed Calendar

HELP-ROI/Break Even Calculator

  Question banks Downloads My Bookmarks Reviews Important topics  
Author Message
Senior Manager
Senior Manager
avatar
Joined: 02 May 2004
Posts: 313
Followers: 1

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

HELP-ROI/Break Even Calculator [#permalink] New post 25 Mar 2008, 08: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
Current Student
User avatar
Joined: 27 Jul 2007
Posts: 874
Location: Sunny So Cal
Schools: CBS, Cornell, Duke, Ross, Darden
Followers: 12

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

Re: HELP-ROI/Break Even Calculator [#permalink] New post 25 Mar 2008, 09:08
Not sure what your specific needs are, but give this a shot.

http://dinkytown.net/business.html
Senior Manager
Senior Manager
User avatar
Joined: 23 Jan 2008
Posts: 498
Followers: 1

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

Re: HELP-ROI/Break Even Calculator [#permalink] New post 25 Mar 2008, 14: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.
GMAT Club Legend
GMAT Club Legend
User avatar
Joined: 10 Apr 2007
Posts: 4320
Location: Back in Chicago, IL
Schools: Kellogg Alum: Class of 2010
Followers: 78

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

Re: HELP-ROI/Break Even Calculator [#permalink] New post 25 Mar 2008, 15: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.
Get the best GMAT Prep Resources with GMAT Club Premium Membership

Senior Manager
Senior Manager
avatar
Joined: 02 May 2004
Posts: 313
Followers: 1

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

Re: HELP-ROI/Break Even Calculator [#permalink] New post 25 Mar 2008, 20: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.
SVP
SVP
User avatar
Joined: 01 Nov 2006
Posts: 1855
Schools: The Duke MBA, Class of 2009
Followers: 16

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

Re: HELP-ROI/Break Even Calculator [#permalink] New post 25 Mar 2008, 20: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.
Senior Manager
Senior Manager
User avatar
Joined: 23 Jan 2008
Posts: 498
Followers: 1

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

Re: HELP-ROI/Break Even Calculator [#permalink] New post 25 Mar 2008, 21:36
Sorry bout that. Came out a little different then I intended! Oh the hazards of posting from work! :oops:

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!
Senior Manager
Senior Manager
avatar
Joined: 02 May 2004
Posts: 313
Followers: 1

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

Re: HELP-ROI/Break Even Calculator [#permalink] New post 26 Mar 2008, 14: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?
SVP
SVP
User avatar
Joined: 01 Nov 2006
Posts: 1855
Schools: The Duke MBA, Class of 2009
Followers: 16

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

Re: HELP-ROI/Break Even Calculator [#permalink] New post 26 Mar 2008, 14: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.)
Senior Manager
Senior Manager
avatar
Joined: 02 May 2004
Posts: 313
Followers: 1

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

Re: HELP-ROI/Break Even Calculator [#permalink] New post 26 Mar 2008, 16: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?
VP
VP
avatar
Joined: 11 Dec 2006
Posts: 1430
Location: New York, NY
Schools: NYU Stern 2009
Followers: 38

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

Re: HELP-ROI/Break Even Calculator [#permalink] New post 28 Mar 2008, 17: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!
_________________

Get the best GMAT Prep Resources with GMAT Club Premium Membership

Re: HELP-ROI/Break Even Calculator   [#permalink] 28 Mar 2008, 17:34
    Similar topics Author Replies Last post
Similar
Topics:
Experts publish their posts in the topic No Calculator herbertvl 3 01 Nov 2013, 05:02
4 Experts publish their posts in the topic Is a even? cyberjadugar 12 24 May 2012, 02:38
Calculators GoMannschaftGo 9 23 Jun 2010, 18:39
Experts publish their posts in the topic calculators? phdprospect 7 01 Jun 2010, 09:58
3 To calculate matematikconsultant 7 24 Feb 2009, 02:20
Display posts from previous: Sort by

HELP-ROI/Break Even Calculator

  Question banks Downloads My Bookmarks Reviews Important topics  

Moderator: threestripes



GMAT Club MBA Forum Home| About| Privacy Policy| Terms and Conditions| GMAT Club Rules| Contact| Sitemap

Powered by phpBB © phpBB Group and phpBB SEO

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®.