Case summary:
Person B has completed his graduation six years before, with an undergraduate degree in finance. His aim is to become an investment banker; however, he is satisfied with his present job. Person B was searching for the best college to do an MBA program, which he thinks would assist him in achieving his aim. He was looking for University W and College M. The details of Person B's current job and his course structure are provided.
Characters in the case:
- Person B
- University W
- College M
- Company DL
- College R
- College M
- School B
Adequate information:
- Person B is not allowed to work anywhere until the completion of the MBA program.
- The salaries are not paid for the internship course.
To calculate: The best option for Person B assumes that the increase in salary payment occurs at the end of every year.
Answer to Problem 3MC
Solution:
As the computed total value for each option is greater in the second option, the best option for Person B is to pursue an MBA at University W.
Explanation of Solution
Given information:
Person B currently works at a money management Company DL, whose salary is $65,000 for a year and is expected to rise to 3% in a year, until retirement. He is 28 years old and expects to be in employment for 40 more years. The average rate of tax payable by Person B is 26%.
College R at University W is one of the best programs for an MBA. It is a two-year full-time course. The fee is $70,000 annually and the cost of the book and other supplies is $3,000 for a year. After graduation, he will be employed for $110,000 with a bonus of $20,000. The salary will increase by 4% in a year and the rate of tax will rise by 31%.
School B at College M is less familiar than College R. It provides an accelerated program for one year with an annual fee of $85,000. The cost of books and other supplies for the program is expected to be $4,500. Person B would get an offer of $92,000 for a year after graduation, with a bonus of $18,000. The salary would rise to 3.5% for a year and the average rate of tax will be 29%.
Both the schools provide health insurance plans for the cost of $3,000 for a year, which must be paid at the beginning of the year. The board and room expenses will be $2,000 more for a year in both the schools. The rate of discount is 6.3%.
Note: Here, Person B has three choices; one is to remain in the same job, or to pursue an MBA at University W or at College M. As the board and room costs are not relevant, they will be the same even if Person B stays in his present job or attends the college. Compute the after-tax value under each choice.
If Person B chooses to remain at the present job, then his present after-tax value will be the following:
Formula to calculate after-tax value:
Compute the after-tax salary:
Hence, the after-tax value is $48,100.
Formula to calculate the
Note: g denotes the growing rate of annuity,
r denotes the rate of discount,
t denotes the number of years.
Compute the present value for a growing annuity:
Hence, the present value is $1,044,728.37.
If Person B chooses to pursue an MBA at University W, then his total value will be the following:
Formula to calculate the total direct costs:
Compute the total direct costs:
Hence, the total direct cost is $78,000.
Formula of present value of direct costs:
Compute the present value of direct costs:
Hence, the present value of the direct costs is $151,377.23.
Formula to calculate the present value of after-tax bonus:
Compute the present value of after-tax bonus:
Hence, the present value of the after-tax bonus of Person B is $12,212.72.
Formula to calculate the after-tax value:
Compute the after-tax value:
Hence, the after-tax value if Person B pursues MBA at University W is $75,900.
Note: As Person B’s salary will increase by 4% a year, compute the present value of after-tax of the increasing salary. Remember that Person B is expected to work for 38 more years.
Formula to calculate the present value for a growing annuity:
Note: g denotes the growing rate of annuity,
r denotes the rate of discount,
t denotes the number of years.
Compute the present value for a growing annuity:
Hence, the present value is $1,862,801.41.
As the initial payment of salary will be obtained three years from the present, discount the number of years to 2 to compute the present value.
Formula to calculate the present value for 2 years:
Compute the present value for 2 years:
Hence, the present value for 2 years is $1,648,542.05.
Formula to calculate the total value:
Compute the total value:
Hence, the total value, if Person B pursues an MBA in the University W is $1,509,377.54.
If Person B chooses to pursue an MBA at College M, then his total value will be the following:
Formula to calculate the total direct costs:
Compute the total direct costs:
Hence, the total direct costs are $94,500.
Note: This is also the present value costs, as they all are paid at present.
Formula to calculate the present value of the after-tax bonus:
Compute the present value of the after-tax bonus:
Hence, the present value of the after-tax bonus of Person B is $12,022.58.
Formula to calculate the after-tax value:
Compute the after-tax value:
Hence, the after-tax value if Person B pursues an MBA at the College M is $65,320.
Note: As Person B’s salary will increase at a rate of 3.5% in a year, compute the present value of after-tax of the increasing salary. Remember that Person B is expected to work for 39 more years.
Formula to calculate the present value for a growing annuity:
Note: g denotes the growing rate of annuity,
r denotes the rate of discount,
t denotes the number of years.
Compute the present value for a growing annuity:
Hence, the present value is $1,509,165.86.
As the initial payment of salary will be obtained two years from the present year, discount the number of years to 1 to compute the present value.
Formula to calculate the present value for 1 year:
Compute the present value for 1 year:
Hence, the present value for 1 year is $1,419,723.29.
Formula to calculate the total value:
Compute the total value:
Hence, the total value, if Person B pursues an MBA in College M is $1,337,245.87.
Want to see more full solutions like this?
Chapter 4 Solutions
UPENN: LOOSE LEAF CORP.FIN W/CONNECT
- Two companies, Blue Plc and Yellow Plc, have bonds yielding 4% and 5.3%respectively. Blue Plc has a credit rating of AA, while Yellow Plc holds a BB rating. If youwere a risk-averse investor, which bond would you choose? Explain your reasoning withacademic references.arrow_forwardB. Using the probabilities and returns listed below, calculate the expected return and standard deviation for Sparrow Plc and Hawk Plc, then justify which company a risk- averse investor might choose. Firm Sparrow Plc Hawk Plc Outcome Probability Return 1 50% 8% 2 50% 22% 1 30% 15% 2 70% 20%arrow_forward(2) Why are long-term bonds more susceptible to interest rate risk than short-term bonds? Provide examples to explain. [10 Marks]arrow_forward
- Don't used Ai solutionarrow_forwardDon't used Ai solutionarrow_forwardScenario one: Under what circumstances would it be appropriate for a firm to use different cost of capital for its different operating divisions? If the overall firm WACC was used as the hurdle rate for all divisions, would the riskier division or the more conservative divisions tend to get most of the investment projects? Why? If you were to try to estimate the appropriate cost of capital for different divisions, what problems might you encounter? What are two techniques you could use to develop a rough estimate for each division’s cost of capital?arrow_forward
- Scenario three: If a portfolio has a positive investment in every asset, can the expected return on a portfolio be greater than that of every asset in the portfolio? Can it be less than that of every asset in the portfolio? If you answer yes to one of both of these questions, explain and give an example for your answer(s). Please Provide a Referencearrow_forwardHello expert Give the answer please general accountingarrow_forwardScenario 2: The homepage for Coca-Cola Company can be found at coca-cola.com Links to an external site.. Locate the most recent annual report, which contains a balance sheet for the company. What is the book value of equity for Coca-Cola? The market value of a company is (# of shares of stock outstanding multiplied by the price per share). This information can be found at www.finance.yahoo.com Links to an external site., using the ticker symbol for Coca-Cola (KO). What is the market value of equity? Which number is more relevant to shareholders – the book value of equity or the market value of equity?arrow_forward
- FILE HOME INSERT Calibri Paste Clipboard BIU Font A1 1 2 34 сл 5 6 Calculating interest rates - Excel PAGE LAYOUT FORMULAS DATA 11 Α΄ Α΄ % × fx A B C 4 17 REVIEW VIEW Alignment Number Conditional Format as Cell Cells Formatting Table Styles▾ Styles D E F G H Solve for the unknown interest rate in each of the following: Complete the following analysis. Do not hard code values in your calculations. All answers should be positive. 7 8 Present value Years Interest rate 9 10 11 SA SASA A $ 181 4 $ 335 18 $ 48,000 19 $ 40,353 25 12 13 14 15 16 $ SA SA SA A $ Future value 297 1,080 $ 185,382 $ 531,618arrow_forwardB B Canning Machine 2 Monster Beverage is considering purchasing a new canning machine. This machine costs $3,500,000 up front. Required return = 12.0% Year Cash Flow 0 $-3,500,000 1 $1,000,000 2 $1,200,000 3 $1,300,000 4 $900,000 What is the value of Year 3 cash flow discounted to the present? 5 $1,000,000 Enter a response then click Submit below $ 0 Submitarrow_forwardFinances Income Statement Balance Sheet Finances Income Statement Balance Sheet Materia Income Statement Balance Sheet FY23 FY24 FY23 FY24 FY23 FY24 Sales Cost of Goods Sold 11,306,000,000 5,088,000,000 13,206,000,000 Current Current Assets 5,943,000,000 Other Expenses 4,523,000,000 5,283,000,000 Cash 211,000,000 328,600,000 Liabilities Accounts Payable 621,000,000 532,000,000 Depreciation 905,000,000 1,058,000,000 Accounts 502,000,000 619,600,000 Notes Payable 376,000,000 440,000,000 Earnings Before Int. & Tax 790,000,000 922,000,000 Receivable Interest Expense 453,000,000 530,000,000 Total Current Inventory 41,000,000 99,800,000 997,000,000 972,000,000 Taxable Income 337,000,000 392,000,000 Liabilities Taxes (25%) 84,250,000 98,000,000 Total Current 754,000,000 1,048,000,000 Long-Term Debt 16,529,000,000 17,383,500,000 Net Income Dividends 252,750,000 294,000,000 Assets 0 0 Fixed Assets Add. to Retained Earnings 252,750,000 294,000,000 Net Plant & 20,038,000,000 21,722,000,000…arrow_forward
- Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning
- Intermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage LearningCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningPfin (with Mindtap, 1 Term Printed Access Card) (...FinanceISBN:9780357033609Author:Randall Billingsley, Lawrence J. Gitman, Michael D. JoehnkPublisher:Cengage Learning