Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can you please help me with this question You just graduated and received a job offer from a major corporation. Thecompany offers a 401K where

image text in transcribed

can you please help me with this question

image text in transcribed
You just graduated and received a job offer from a major corporation. Thecompany offers a 401K where they will match your monthly contribution. You are currently 20 year old. Although just entering the work force, you are contemplating retirement and you are thinking about the amount of money you would like to have when you retire (your nest egg). You plan to retire at age 68. You are unable to come up with a number for your nest egg, however you do know that you want to draw on your nest egg to the tune of $75,000 per year until your reach the age of 85. 1. How big of a nest egg do you need to meet your retirement goal of $60,000? Assume an annual interest rate of 6%. Please show work in Excel 2. How much to you have to contribute to your 401K plan each year to reach the above nest egg. Remember that your employer is matching your contribution. Assume an annual interest rate of 5% Please show work in Excel

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

Real Estate Finance

Authors: John P. Wiedemer, ‎ Keith J. Baker

9th edition

324181426, 324181425, 978-0324181425

More Books

Students also viewed these Finance questions

Question

=+e) State the hypotheses (in words, not symbols).

Answered: 1 week ago

Question

1. Let a, b R, a Answered: 1 week ago

Answered: 1 week ago

Question

calculate the optimum selling price using simple calculus; LO1

Answered: 1 week ago