Question

In: Finance

You currently make $100,000 a year and expect your salary increase by 10% a year for...

You currently make $100,000 a year and expect your salary increase by 10% a year for 20 years.   You are considering an MBA which will cost you $120,000 for the entire education. If you take the MBA, you will have to pay the full tuition today (all upfront) and you will make zero earnings at the end of years 1 and 2. However, after graduation you’ll have an opportunity to join an investment bank, which promises $130,000 a year, which will grow by 15% for 18 years after graduation. Is the MBA a good deal? Assume a constant discount rate of 15%. What if rates fall to 10%? What if rates rise to 17%, how does your answer change? Show your detailed spreadsheet calculations using Excel.

Solutions

Expert Solution

Year Not doing MBA Doing MBA PV @ 15% PV @ 10% PV @ 17% Not doing MBA Doing MBA Not doing MBA Doing MBA Not doing MBA Doing MBA
0 -$120,000.00 1.0000 1.0000 1.0000 0 -$120,000.00 0 -$120,000.00 0 -$120,000.00
1 $100,000.00 0 0.8696 0.9091 0.8547 $86,956.52 $0.00 $90,909.09 $0.00 $85,470.09 $0.00
2 $110,000.00 0 0.7561 0.8264 0.7305 $83,175.80 $0.00 $90,909.09 $0.00 $80,356.49 $0.00
3 $121,000.00 $130,000.00 0.6575 0.7513 0.6244 $79,559.46 $85,477.11 $90,909.09 $97,670.92 $75,548.84 $81,168.17
4 $133,100.00 $149,500.00 0.5718 0.6830 0.5337 $76,100.36 $85,477.11 $90,909.09 $102,110.51 $71,028.82 $79,780.68
5 $146,410.00 $171,925.00 0.4972 0.6209 0.4561 $72,791.65 $85,477.11 $90,909.09 $106,751.90 $66,779.23 $78,416.91
6 $161,051.00 $197,713.75 0.4323 0.5645 0.3898 $69,626.79 $85,477.11 $90,909.09 $111,604.26 $62,783.90 $77,076.45
7 $177,156.10 $227,370.81 0.3759 0.5132 0.3332 $66,599.54 $85,477.11 $90,909.09 $116,677.18 $59,027.59 $75,758.90
8 $194,871.71 $261,476.43 0.3269 0.4665 0.2848 $63,703.91 $85,477.11 $90,909.09 $121,980.69 $55,496.03 $74,463.88
9 $214,358.88 $300,697.90 0.2843 0.4241 0.2434 $60,934.17 $85,477.11 $90,909.09 $127,525.26 $52,175.75 $73,190.99
10 $235,794.77 $345,802.58 0.2472 0.3855 0.2080 $58,284.86 $85,477.11 $90,909.09 $133,321.87 $49,054.13 $71,939.86
11 $259,374.25 $397,672.97 0.2149 0.3505 0.1778 $55,750.74 $85,477.11 $90,909.09 $139,381.95 $46,119.26 $70,710.12
12 $285,311.67 $457,323.92 0.1869 0.3186 0.1520 $53,326.79 $85,477.11 $90,909.09 $145,717.49 $43,359.99 $69,501.40
13 $313,842.84 $525,922.51 0.1625 0.2897 0.1299 $51,008.24 $85,477.11 $90,909.09 $152,341.02 $40,765.80 $68,313.35
14 $345,227.12 $604,810.88 0.1413 0.2633 0.1110 $48,790.49 $85,477.11 $90,909.09 $159,265.61 $38,326.82 $67,145.60
15 $379,749.83 $695,532.51 0.1229 0.2394 0.0949 $46,669.16 $85,477.11 $90,909.09 $166,504.95 $36,033.77 $65,997.81
16 $417,724.82 $799,862.39 0.1069 0.2176 0.0811 $44,640.07 $85,477.11 $90,909.09 $174,073.36 $33,877.90 $64,869.64
17 $459,497.30 $919,841.75 0.0929 0.1978 0.0693 $42,699.19 $85,477.11 $90,909.09 $181,985.79 $31,851.02 $63,760.76
18 $505,447.03 $1,057,818.01 0.0808 0.1799 0.0592 $40,842.71 $85,477.11 $90,909.09 $190,257.87 $29,945.40 $62,670.83
19 $555,991.73 $1,216,490.71 0.0703 0.1635 0.0506 $39,066.94 $85,477.11 $90,909.09 $198,905.95 $28,153.80 $61,599.53
20 $611,590.90 $1,398,964.32 0.0611 0.1486 0.0433 $37,368.37 $85,477.11 $90,909.09 $207,947.13 $26,469.38 $60,546.55
Present Value $1,177,895.75 $1,418,587.98 $1,818,181.82 $2,514,023.71 $1,012,624.01 $1,146,911.44
Doing MBA is a good deal

Related Solutions

Problem 3.  You currently make $100,000 a year and expect your salary increase by 10% a year...
Problem 3.  You currently make $100,000 a year and expect your salary increase by 10% a year for 20 years.   You are considering an MBA which will cost you $120,000 for the entire education. If you take the MBA, you will have to pay the full tuition today (all upfront) and you will make zero earnings at the end of years 1 and 2.  However, after graduation you’ll have an opportunity to join a premier investment bank, which promises $130,000 a year, which...
Assume that you make $50,000 per year. You expect your pay to increase by 2.5% year...
Assume that you make $50,000 per year. You expect your pay to increase by 2.5% year from now until you retire in 30 years. Your goal is to withdraw an amount equal to 80% of your annual income at retirement each year for 25 years (assume withdrawals are made at the end of each year in retirement). How much would you have to invest each year from now until retirement if your investment returns are 8% per year while working...
Your salary next year is expected to be $40,000. Assume you expect your salary to grow...
Your salary next year is expected to be $40,000. Assume you expect your salary to grow at a steady rate of 4% per year for another 27 years. If the appropriate cost of capital (aka discount rate) is 11.2%, what is the PV today of your future salary cash flow stream? For simplicity, assume the salary amounts are at the end of each of the next 27 years. Answer to zero (0) decimal places.
Your salary next year is expected to be $40,000. Assume you expect your salary to grow...
Your salary next year is expected to be $40,000. Assume you expect your salary to grow at a steady rate of 4% per year for another 25 years. If the appropriate cost of capital (aka discount rate) is 9%, what is the PV today of your future salary cashflow stream? [For simplicity, assume the salary amounts are at the end of each of the next 25 years.] Please provide calculations using excel and financial calculator.
The price of oil is currently at $24 but you expect it to either increase by...
The price of oil is currently at $24 but you expect it to either increase by 18 percent or decrease by 7 percent over the next 6 months. The 6-month risk-free rate of interest is 1.98 percent. What is the risk-neutral probability that the price will increase? Group of answer choices 35.92% 32.47% 37.94% 38.06% 36.03% 2 Executive stock options generally have all of the following characteristics except: Group of answer choices putting executive pay at risk. providing tax efficiency....
Starting with your identified 2019 level of revenue, you expect that revenue will increase by 10%...
Starting with your identified 2019 level of revenue, you expect that revenue will increase by 10% in 2020. You anticipate annual revenue growth will slow by 1% per year to the long-run industry growth rate of 5% by 2025. • You expect EBIT to be 12.5% of sales each year. • You expect any increase in net working capital requirements each year to be 10% of any year-on-year annual increases in revenue. • You expect capital expenditures to equal depreciation...
Suppose you invest $100,000 in a C corporation for 10 years. You expect the corporation to...
Suppose you invest $100,000 in a C corporation for 10 years. You expect the corporation to earn 8% pa before any corporate taxes and any investor level taxes.  The firm does not plan to pay any dividends over the 10 year period. You currently face a 40% tax rate on ordinary income, and 20% tax rate on capital gains.  The corporation faces a tax rate of 35%.  The tax rates are not expected to change. What is your after-tax dollar accumulation at the...
You are planning for your retirement. You expect to earn a monthly salary of $7,000 starting...
You are planning for your retirement. You expect to earn a monthly salary of $7,000 starting on the 1st month after you retire, which will be able to provide comfortably for your daily expenses through your retirement years. You are currently 33 and plan on retiring when you become 64, and you expect to live 20 years after retirement. In addition to providing a salary for your retirement you would like to buy a house by the time you reach...
You are planning for your retirement. You expect to earn a monthly salary of $7,000 starting...
You are planning for your retirement. You expect to earn a monthly salary of $7,000 starting on the 1st month after you retire, which will be able to provide comfortably for your daily expenses through your retirement years. You are currently 33 and plan on retiring when you become 64, and you expect to live 20 years after retirement. In addition to providing a salary for your retirement you would like to buy a house by the time you reach...
Suppose that your salary is $35,000 in year one, will increase 6% per year through year...
Suppose that your salary is $35,000 in year one, will increase 6% per year through year 4, and is expressed in actual dollars as follows: EOY Salary$ 1 35,000 2 37,100 3 39,326 4 41,685 If the general price inflation is expected to average 8% per year for the first two years and 7% per year for the last two years. A. What is the real dollar equvalent of these actual dollar salary amounts? Assume that base period is year...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT