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
Please use excel to solve this.
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

Venture Capital And The Finance Of Innovation

Authors: Andrew Metrick

1st Edition

0470074280, 9780470074282

More Books

Students also viewed these Finance questions

Question

What are the steps involved in conducting discriminant analysis?

Answered: 1 week ago