MANAGERIAL FINANCE plz help!!
posted by Natacha .
Hi, i need some help on my managerial finance course.
You are 25 and just about to graduate from college. You are considering whether to go to Business School right after college or take the job that you have been offered. Being finance major, you reckon that in order to make the most optimal decision you need to do a financial analysis of the two options available to you. The salary offer for your new job is $70,000 which is expected to grow at the rate of 3% per annum. MBAs typically make around $95,000 upon graduation, with salaries growing at a rate of 4% per annum. The MBA program costs $20,000 per year in tuition, payable at the end of each year of study. You hope to retire when you reach age 60. Your relevant discount rate is 7.5%. Using the above information and Excel modeling, please answer the following questions:
a. Is it worthwhile for u to decline the job offer and go straight to school?
b. What is the internal rate of return for the MBA program?
c. What rate of return would make you indifferent between the 2 options?

MANAGERIAL FINANCE plz help!! 
economyst
Think it through,
In Excel, calculate the present value of the income stream till age 60 under both options.
A coupla a complications to think about. First, I personally would think that tuition costs ought to be paid for with borrowed money. So, I would add borrowing costs to the MBA tuition. Second, I might think about factoring in some probability of dying. Third, I might think about adding some risk probabilities.
Respond to this Question
Similar Questions

MANAGERIAL FINANCE. Please help
Hi, I have some questions about managerial finance. I do not really understand them so can u plz help me out!! Thx Here are the questions: 1. High earnings per share (EPS) do not necessarily translate into a high fundamental stock … 
persuasive essay!!
Is it better to go to college and be successful or open your own business without a college degree? 
english
how about this for starters? The shift from being a high school student to a college student can be both pleasurable and discomforting at the same time for the simple fact that college is nothing like high school. In college there 
finance
Anne is planning to attend college when she graduates from high school in 7 years from now. She anticipates that she will need $10,000 at the beginning of each college year to pay for tuition and fees, and have some spending money. … 
Finance
5. John and Daphne are saving for their daughter Ellen's college education. Ellen just turned 10 (t=0), and she will be entering college 8 years from now (at t=8). College tution and expenses at State U. are currently $14,500 a year, … 
Finance
Professor Anderson has a daughter who is 3 years old. In 15 years she will go to college and he is uncertain whether he has saved enough to finance her college education. Based on his reading, he believes that it will cost $208,000 … 
Finance
Professor Anderson has a daughter who is 3 years old. In 15 years she will go to college and he is uncertain whether he has saved enough to finance her college education. Based on his reading, he believes that it will cost $208,000 … 
finance
You have chosen biology as your college major because you would like to be a medical doctor. However, you find that the probability of being accepted to medical school is about 6 percent. If you are accepted to medical school, then … 
COURSE HELP MEEE
Hi i want to be a pediatrician when i grw up so what course should i take in college ? 
Managerial Finance
Isabelle wants to save up an amount of $150,000 for her son's college education fees, coming up in 5 years. Find the amount that should be invested today if the bank pays an interest rate of 5% compounded annually