Question

In: Accounting

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 age. Her target retirement income replacement ratio for when she starts retirement is at least to have 90% of her last year’s salary. She expects to earn 9% on her investments during her working years and believes that her current annual income will kept pace with inflation during her working years. She estimates that inflation will average 3% annually between now, her retirement, and after into retirement. Assume that currently Donna has no other sources of retirement income and plans to use an Individual Retirement Account, until she is able to obtain a better job which has a 401 (k) investment plan sometime in the future.

  1. If her salary increases at 3% annually until she retires, what is her expected annual salary at  

Age 67? $____________________.

  1. What is Donna’s estimated monthly and annual income expected from Social Security based upon the Social Security website using the quick calculator at www.ssa.gov/OACT.

Use inflation adjusted dollars in the Social Security Estimates.

Monthly Social Security retirement benefit at age 67$______________

Annual Social Security retirement benefit at age 67$______________.

  1. What percentage of her final year’s annual income will Social Security replace, if she begins Social Security benefits

At age 67___________%

d) How much additional annual income in retirement is needed per year in retirement to meet the 90% replacement ratio that she would like to achieve?   

              At age 67 $______________________

e)    What total investment portfolio amount does she need at age 67 in order to produce her desired 90% income replacement for the rest of her life in retirement?

Required Investment Portfolio Amount needed at retirement age 67?   _______________

Donna currently does not have a retirement plan at work and her retirement income from Social Security is all she currently has. How per month does she need to start saving for retirement to reach the needed investment portfolio amount, what type of retirement account and what types of investments should she use in order to reach her goal of 90% income replacement in retirement for retiring at age 67?

Be specific in your recommendations.

Solutions

Expert Solution

a. If her salary increases at 3% annually until she retires, what is her expected annual salary at  
Age 67? $ 149261.3.
The compound interest formula is ((P*(1+i)^n) - P), where P is the current salary, i is the annual inflation rate, and n is the number of periods.
a. What is Donna’s estimated monthly and annual income expected from Social Security based upon the Social Security website using the quick calculator at www.ssa.gov/OACT.
Use inflation adjusted dollars in the Social Security Estimates.
Monthly Social Security retirement benefit at age 67 $ 6,421
Annual Social Security retirement benefit at age 67 $ 77,052.
a. What percentage of her final year’s annual income will Social Security replace, if she begins Social Security benefits
At age 67 51.62%
Annual Salary at Retirement    149,261.33
Socuial Security Benefit      77,052.00
% of Annual Salary              51.62
d) How much additional annual income in retirement is needed per year in retirement to meet the 90% replacement ratio that she would like to achieve?   
              At age 67    $ 57,283
90% of Annual Salary    134,335.20
Received from Social Security      77,052.00
Additional inccome in retirement      57,283.20
Required Investment Portfolio Amount needed at retirement age 67?  $ 636,480
Additional inccome in retirement      57,283.20
Return on Investment 9%
Investment Required    636,480.01

Related Solutions

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...
On a loan of 50,000 for 30 years at 6.8% annually the lender wants the interest...
On a loan of 50,000 for 30 years at 6.8% annually the lender wants the interest paid annually and the principal repaid at the end of the 20 years. The borrower makes annual level payments into a sinking fund to raise the 50,000. The fund earns 5.8% annually. What are the borrowers total annual payments?
Assume that Annie makes $50,000 a year for the next 30 years (she works for 30...
Assume that Annie makes $50,000 a year for the next 30 years (she works for 30 years total). During her entire career, she contributes 8% of her salary to her 401K, and her employer matches 4% of her salary (meaning her total contribution to her 401K is 12% of her salary annually). What is the FV (value in 30 years, or value upon her retirement) of all of Annie’s annual 401K contributions over the 30-year period assuming she earns 9%...
a. Jasmine, age 42, is a single parent with an eight-year-old daughter. She earns $600,000 annually...
a. Jasmine, age 42, is a single parent with an eight-year-old daughter. She earns $600,000 annually as a marketing manager in a software house. As part of her remuneration package, Jasmine’s employer also provides her with a group life insurance protection in the amount of $1,000,000. Jasmine has decided to purchase additional life insurance so that her daughter will be financially protected if she suffers from premature death. Currently, Jasmine has the following financial needs for her family if she...
You are 20 years old now and you will save $10,000 annually for the next 30...
You are 20 years old now and you will save $10,000 annually for the next 30 years and the interest rate is 9%. How much money you will have when you are 50 years old? A. $1,363,075.39 B. $899,937.73 C. $1,112,577.83 D. $998,181.47 What is the PV of $2,000 to be received in 10 years at an interest rate of 8%? A. $980.25 B. $926.39 C. $783.12 D. $1,000
Leah works for Toffolon Technicians in New Hampshire, where she earns $29,400 annually. She contributes 3.5%...
Leah works for Toffolon Technicians in New Hampshire, where she earns $29,400 annually. She contributes 3.5% to her 401(k), of which her employer matches 1.75%. Her employer contributes $150 per month for her health insurance, $40 per month for her life insurance, and $30 per month for her AD&D insurance. Toffolon Technicians pays employer-only taxes and insurance that comprises an additional 17% of Leah’s annual salary. What is Leah’s total annual compensation? A. 37552.5 B. 38581.5 C. 29400 D. 36523.5
Christine Boone is an employee at Americamp Vehicles. She earns a salary of $34,750 annually, paid...
Christine Boone is an employee at Americamp Vehicles. She earns a salary of $34,750 annually, paid biweekly. She contributes to the following fringe benefits and other deductions: Medical insurance: $80 per pay period Dental insurance: $15 per pay period 401(k): 5% of gross pay Union dues: $100 per month Additional withholding: $75 per month Fringe benefits Amount Medical insurance Dental insurance 401(k) Union dues Additional withholding Total amount of Christine's fringe benefits and other deductions $0.00
Beth, a newlywed, just graduated from university as a Registered Nurse. She was just hired by...
Beth, a newlywed, just graduated from university as a Registered Nurse. She was just hired by a large hospital in Toronto that employs over 500 workers. She is hired at a rate of $40 per hour and has a probationary period of one-year. When she was hired, her employment offer was to get a minimum of 32 hours per week, but depending on the hospitals needs, may be up to 60 hours per week. Because of COVID-19, the hospital demands...
Donna Clark has $15,000 that she can deposit into a savingsaccount for five years. Bank...
Donna Clark has $15,000 that she can deposit into a savings account for five years. Bank A compounds interest annually, Bank B twice a year, and Bank C quarterly. Each bank has a stated interest rate of 5 percent. What account balance would Donna have at the end of the fifth year if she left all the interest paid on the deposit in each bank? (Round answers to 2 decimal places, e.g. 52.75.)Bank ABank BBank CFuture Value
Lindsay is 30 years old and has a new job in web development. She wants to...
Lindsay is 30 years old and has a new job in web development. She wants to make sure that she is financially sound by the age of 55, so she plans to invest the same amount into a retirement account at the end of every year for the next 25 years. (a) Construct a data table in Excel that will show Lindsay the balance of her retirement account for various levels of annual investment and return. If Lindsay invests $10,000...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT