Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Eugenia Monroe, 30 years old, is currently employed at an IT firm where she earns $38,000 a year. She expects that her salary will grow

Eugenia Monroe, 30 years old, is currently employed at an IT firm where she earns $38,000 a year. She expects that her salary will grow by 3% per year. She expects to retire at age 65. She has recently inherited $75,000 and is now considering what to do with the sum. She has two options: First, she could enroll in a certification program in net work design. The program requires completing 20 Web-based courses over one year. The total cost of the program is $5,000, payable when she enrolls. She will not lose any income because she can study while working. When she obtains the certification, she can expect an increase in salary of $10,000 compared to her current job, and this differential will grow at 3% per year so long as she keeps working in that new position. Second, she could enroll for an MBA. It will be an evening program, and it will cost $25,000 per year, due at the beginning of each of her three years in school. Because it is an evening program, she will not lose any income because she can study while working. When she obtains the MBA degree, she can expect a promotion to manager and an increase in salary of $20,000 compared to her current job, and this differential will grow at 3% per year so long as she keeps working in that managerial position. Using a discount rate of 2.95%, please answer the following questions: Create worksheets in Excel showing the timelines for her two alternatives. Assume that salaries are paid only once, on January 1 of the next year. Hence, when she obtains a qualification in, say, 2018, the higher salary does not kick in until 2019. Calculate the present value of the salary differential for completing the certification program. Subtract the present value of the cost of the program to get the net present value. Calculate the present value of the salary differential for completing the MBA program. Subtract the present value of the cost of the program to get the net present value. Based on your answers above, which choice would you recommend to Eugenia Monroe?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Finance questions