Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You just turn to 3 0 years old. You got a good job and lived the good life but did not contribute to your 4

You just turn to 30 years old. You got a good job and lived the good life but did not contribute to your 401K\table[[A,B,C
or save anything for your future.
You now realize you would like to retire in 30 years (age 60). You are currently making $90K a year. After
your life expenditure and taxes, you are able to save 10% of your salary.
You come from a family with really good genes so you expect to live another 25 years after retirement (to
an age of 85 years old). You do not want to be a burden on your family and its not likely there will be any
social security by the time you retire so youll have to rely totally on your own resources. You believe you
can live comfortably on $70K a year after retirement (this would cover living expenses and taxes).
While you are saving for retirement, your investments will earn 5%, however, after retirement you will
move your funds to a safer investment that will only pay 3%. Assume there is no inflation.
1.(10 points) How much will you need to have saved by the time you retire? Use one function to get
the answer
2.(10 points) According to how much you are saving per year now, how much would you have in
your savings at the time of your retirement? Use one function to get the answer
3.(10 points) To know if your current plan is feasible or not, you subtract what you need (your answer
to Q1) from what you have (your answer to Q2) in B15, and specify whether this plan is feasible
or not in B16
image text in transcribed

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

Financial Management In Construction Contracting

Authors: Andrew Ross, Peter Williams

1st Edition

1405125063, 9781405125062

More Books

Students also viewed these Finance questions

Question

Evaluate the integral. 4* + 10*

Answered: 1 week ago

Question

1. Dont say, This is easy, I know you can do it.

Answered: 1 week ago