Assume that today is January 19, 2021. Natasha Kingery is 30 years old and has a Bachelor of Science degree in computer science. She is currently...
This question has been answered
Question

Assume that today is January 19, 2021. 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 telephone corporation located in Seattle, Washington, and earns $35,000 a year that she anticipates will grow at 4% per year. Natasha hopes to retire at age 65 and has just begun to think about the future.
 
Natasha has $70,000 that she recently inherited from her aunt. She invested this money in 10-year Treasury bonds. She is considering whether she should further her education and would use her inheritance to pay for it.
 
She has investigated a couple of 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 two 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 $8,000 more than the salary of a Tier 2 representative, and she anticipates that this salary differential will grow at a rate of 4% a year for as long as she remains employed. The certification program requires the completion of 20 Web-based courses and a score of 80% or better on the final exam. She has learned that the average amount of time necessary to finish the program is one year. The total cost of the program is $8000, due when she enrolls in the program. Because she will the work for the certification on her own time, Natasha does not expect to lose any  income during the certification process.
 
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 4% per year for as long as she keeps working. The evening program, which will take three years to complete, costs $35,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 it.
 
1.   Determine the interest rate Natasha is currently earning on her inheritance by going to Yahoo! Finance (http://finance.yahoo.com) and clicking the 10 Yr Bond link in =the Market Summary section or enter ^TNX in the symbol lookup field. Then go to the Historical Prices link and enter the appropriate date, Jan 19, 2021, to obtain the closing yield or interest rate that she is earning. Use this interest rate as the discount rate for the remainder of this problem.
 
2.   timeline in Excel for Natasha's current situation, as well as 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 upon graduating from the MBA program or being 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.
 
3.   Calculate the present value of the salary differential for completing the certification program. Subtract the cost of the program to get the value of undertaking the certification program.
 
4.   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 value of undertaking the MBA.
 
5.   Based on your answers to Questions 3 and 4, what advice would you give to Natasha? What if the two programs are mutually exclusive? If Natasha undertakes one of the programs, there is no further benefit to undertaking the other program. Would your advice change?

Answered by Expert Tutors

ff

s ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur a

gue

fficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, c

s a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, c

ongue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dol

icitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequ

o. Don

ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae od

gue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit

ur laoreet. Nam risus an

gue

Step-by-step explanation

pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel

m risus ante, dapibus

gue

aciniam risus ante, dm risus ante, dacinia pulvinar
xsusscing
lultrisusus
xsuscingnec
lsucellen
,cingssus
lsfcong
ocongfficsu
lcecingec a
,ng eng esu
,ac,cece
xcesce
ffficsucong
xec asusce
tcingec aac,
usussuscing
loneccingcing
fnecametec fac
tsususacinia
xcingec aec fac
,ec acingacinia
fceceec fac
oceec facsum do
ong eaciniaentesq
icac,ec facacinia
xnecec facec fac
lftricesec fac
fec acesum do
tsum doceec fac
xec facec facec fac
xametaciniaacinia
,ametentesqm risu
icur lasusm risu
xceng elec fac
ssum doec asus
icaciniaec factrices
susususu
susususu
su

u

s

gue

, consectetur adipiscing elit. Nam la

ipsum dolor sit amet, c

ce dui lectus, congue vel laor

ipsum dolor sit amet, c

amet, co

gue

gue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem i

gue

m ipsum dolor sit ame

gue

itur laoreet. Nam risus ante, da

pulvinar tortor nec facilisis. Pellentesque dapibus effi

ipiscing elit. Nam lacinia pulvinar t

consectetur adipiscing elit. Nam lac

ec facilisis. Pellentesque dapibu

e vel laoreet ac, dictum vitae odio. Donec al

gue

iscing elit. Nam lacinia pulvinar tortor nec fac

gue

gue

ipisci

e vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor ne

gue

gue

gue

gue

gue

gue

gue

gue

gue

gue

gue

gue

gue

gue

gue

gue

gue

The student who asked this found it Helpful
Overall rating 100%
Subject: Business, Management
Get unstuck

487,593 students got unstuck by Course
Hero in the last week

step by step solutions

Our Expert Tutors provide step by step solutions to help you excel in your courses