Question

In: Finance

Eugenia Monroe, 30 years old, is currently employed at an IT firm where she earns $38,000...

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?

Solutions

Expert Solution

Hello:

Attaching the excel images used to calculate

Discounting factor is calculated using the formula 1 / ((1+ discounting factor)^n)), where n is the year

Present value = salary * discounting factor

PV of total salary = Sum of all the PV for salaries

1. Present value of the salary differential for completing the certification program -

$1,625,990.94

2. Subtract the present value of the cost of the program to get the net present value -

$1,620,990.94

3. Present value of the salary differential for completing the MBA program -

$1,876,659.91

4. Subtract the present value of the cost of the program to get the net present value -  

For this we first find the PV of MBA program cost which comes out to be = 72,871.43

$1,803,788.48

Based on your answers above, which choice would you recommend to Eugenia Monroe? - Option 2 - Go for MBA as the NPV is larger. Also we can add 75000 to the NPV(answer 2 ans answer 3) to get the exact amount today


Related Solutions

Donna, a registered nurse, earns $50,000 annually. She is 30 years old (date of birth is...
Donna, a registered nurse, earns $50,000 annually. She is 30 years old (date of birth is April 30, 1990) and her plans are to get married, raise a family and continue to work because she likes her job and enjoys the financial freedom. She is planning to retire at age 67 at which time she expects to receive Social Security retirement benefits and her own retirement benefits that she hopes to be able to accumulate between now and her retirement...
Suppose that a worker currently earns $40,000 per year. He is 60 years old and has...
Suppose that a worker currently earns $40,000 per year. He is 60 years old and has been with the firm for 20 years. You believe that he is so skilled that in order to replace him, you will have to hire two individuals, each of whom earns $30,000 per year. His pension plan offers him the following benefits upon retirement: the worker receives an annual pension of 1.25% of final salary times years of service at retirement. (Assume the relevant...
1. Suppose that a worker currently earns $40,000 per year. He is 60 years old and...
1. Suppose that a worker currently earns $40,000 per year. He is 60 years old and has ben with the firm for 20 years. You believe that he is so skilled that in order to replace him, you will have to hire two individuals, each of whom earns $30,000 per year. His pension plan offers him the following benefits upon retirement: the worker receives an annual pension of $1.25% of final salary times years of service at retirement. (Assume the...
Reba Dixon is a fifth-grade school teacher who earned a salary of $38,000 in 2020. She is 45 years old and has been divorced for four years.
Reba Dixon is a fifth-grade school teacher who earned a salary of $38,000 in 2020. She is 45 years old and has been divorced for four years. She receives $1,200 of alimony payments each month from her former husband (divorced in 2016). Reba also rents out a small apartment building. This year Reba received $50,000 of rental payments from tenants and she incurred $19,500 of expenses associated with the rental. Reba and her daughter Heather (20 years old at the...
1. George is currently 30 years old, plans to retire at the age of 65 and...
1. George is currently 30 years old, plans to retire at the age of 65 and to live to the age of 85. His labor income is $25,000 per year, and he intends to maintain a constant level of real consumption spending over the next 55 years. Assume no taxes, no growth in real salary, and a real interest rate of 3% per year. a. What is the value of George’s human capital? b. What is his permanent income? c....
Sarah Allen is a sales executive at a Baltimore firm. She is 25 years old and...
Sarah Allen is a sales executive at a Baltimore firm. She is 25 years old and plans to invest $2,200 each year in an IRA account until she is 65 at which time she will retire (a total of 40 payments). If Sarah invests at the beginning of each year, and the IRA investment will earn 9.40 percent annually, how much will she have when she retires? Assume that she makes the first payment today. (Round factor values to 4...
Debra King is a sales executive at a Baltimore firm. She is 25 years old and...
Debra King is a sales executive at a Baltimore firm. She is 25 years old and plans to invest $2,600 each year in an IRA account until she is 65 at which time she will retire (a total of 40 payments). If Debra invests at the beginning of each year, and the IRA investment will earn 11.90 percent annually, how much will she have when she retires? Assume that she makes the first payment today. (Round factor values to 4...
Jennifer Davis is a sales executive at a Baltimore firm. She is 25 years old and...
Jennifer Davis is a sales executive at a Baltimore firm. She is 25 years old and plans to invest $3,100 each year in an IRA account until she is 65 at which time she will retire (a total of 40 payments). If Jennifer invests at the beginning of each year, and the IRA investment will earn 11.40 percent annually, how much will she have when she retires? Assume that she makes the first payment today. (Round factor values to 4...
Jennifer Davis is a sales executive at a Baltimore firm. She is 25 years old and...
Jennifer Davis is a sales executive at a Baltimore firm. She is 25 years old and plans to invest $3,100 each year in an IRA account until she is 65 at which time she will retire (a total of 40 payments). If Jennifer invests at the beginning of each year, and the IRA investment will earn 11.40 percent annually, how much will she have when she retires? Assume that she makes the first payment today. (Round factor values to 4...
Barbara Jones is a sales executive at a Baltimore firm. She is 25 years old and...
Barbara Jones is a sales executive at a Baltimore firm. She is 25 years old and plans to invest $4,000 each year in an IRA account until she is 65 at which time she will retire (a total of 40 payments). If Barbara invests at the beginning of each year, and the IRA investment will earn 9.95 percent annually, how much will she have when she retires? Assume that she makes the first payment today. (Round factor values to 4...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT