Calculate the present value of the salary differential

Assignment Help Accounting Basics
Reference no: EM133186778

Question - Assume that today is April 1, 2022. Natasha Kingery is 30 years old and has a Bachelor of Science degree in computer science. She is currently employed as a Tier 2 field service representative for a telephony corporation located in Seattle, Washington, and earns $38,000 a year that she anticipates will grow at 3% per year. Natasha hopes to retire at age 65 and has just begun to think about the future.

Natasha recently inherited $75,000 from her aunt. She invested this money in 30-year Treasury Bonds. She is considering whether she should further her education; she would use her inheritance to pay for it.

She has investigated a couple of education options and is asking for your help as a financial planning intern to determine the financial consequences associated with each option. Natasha has already been accepted to both programs and could start either one soon.

One alternative that Natasha is considering is attaining a certification in network design. This certification would automatically promote her to a Tier 3 field service representative in her company. The base salary for a Tier 3 representative is $10,000 more than what she currently earns, and she anticipates that this salary differential will grow at a rate of 3% per year as long as she keeps working. The certification program requires the completion of 20 Web-based courses and a score of 80% or better on an exam at the end of the course work. She has learned that the average amount of time necessary to finish the program is one year. The total cost of the program is $5000, due when she enrolls in the program. Because she will do all the work for the certification on her own time, Natasha does not expect to lose any income during the certification.

Another option is going back to school for an MBA degree. With an MBA degree, Natasha expects to be promoted to a managerial position in her current firm. The managerial position pays $20,000 a year more than her current position. She expects that this salary differential will also grow at a rate of 3% per year for as long as she keeps working. The evening program, which will take three years to complete, costs $25,000 per year, due at the beginning of each of her three years in school. Because she will attend classes in the evening, Natasha doesn't expect to lose any income while she is earning her MBA if she chooses to undertake the MBA.

1. Make timeline in Excel for her current situation, as well as for the certification program and MBA degree options, using the following assumptions:

Salaries for the year are paid only once, at the end of the year.

The salary increase becomes effective immediately after she graduates from the MBA program or is certified. That is, because the increases become effective immediately, but salaries are paid at the end of the year, the first salary increase will be paid exactly one year after graduation or certification.

2. Calculate the present value of the salary differential for completing the certification program. Subtract the cost of the program to get the NPV of undertaking the certification program.

3. Calculate the present value of the salary differential for completing the MBA degree. Calculate the present value of the cost of the MBA program. Based on your calculations, determine the NPV of undertaking the MBA.

4. Based on your answers to Questions 3 and 4, what advice would you give to Natasha? What if the two programs are mutually exclusive? (That is, if Natasha undertakes one of the programs, there is no further benefit to undertaking the other program.) Would your advice be different?

Reference no: EM133186778

Questions Cloud

Principle of distributive justice : Name and explain one principle of distributive justice according to which it can be fair for some people to give to the community less than they receive from th
Guidance on stakeholder engagement : American company Tesla produces electric cars, energy storage systems, solar panels, and solar roof tiles. New employees and customers are generally required to
Understanding of sport and gender in society : Many contact sports, such as tackle football in the United States, are seen as some of the last bastions of masculinity.
What is the total cost of the equipment : Estimated dismantling cost that may be incurred upon retirement 300,000 - What is the total cost of the equipment
Calculate the present value of the salary differential : Calculate the present value of the salary differential for completing the certification program. Subtract the cost of the program to get the NPV
Providing Financial Analysis and Calculation for All Parts : In 2021, the revenues totaled $428,600 and expenses were $181,300. Please Help by providing Financial Analysis and Calculation for All the Parts
What amount should be reported as inventory : The manufacture of items of inventory has been completed but no selling costs have yet been incurred. What amount should be reported as inventory
Calculate Margaret severance pay : Margaret is employed in Ontario by a manufacturing company whose Ontario annual payroll is $5,250,000.00. Calculate Margaret severance pay
Prepare all necessary entries until repayment of the grant : The grant has a fair value of P 500,000. Prepare all necessary entries on 2022 until the repayment of the grant

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd