Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Looking forward to retirement Joe recently received his business degree and he is now smartly starting to plan for his retirement. Joe plans to invest

Looking forward to retirement

Joe recently received his business degree and he is now smartly starting to plan for his retirement. Joe plans to invest $3000 of his salary into a retirement fund at the end of each year. Assume that returns are paid at the end of each year and that they are based on the beginning-of-year balance.

Suppose that Joe is 30 years old and that his returns each year are normally distributed with a mean of 12.5 % and a standard deviation of 2%. Use EXCEL & simulate for 100 replications. What is the probability that Joe will have at least $500,000 at age 60? Use Excel

Suppose instead that Joe contributes $3000 annually to his retirement fund for eight years and then terminates these annual contributions. Use EXCEL & simulate for 100 replications. How much money did Joe contribute in total and what is the expected value of how much he what he would accumulate from his contributions by age 60? What is the probability that Joe will have at least $500,000 at age 60? Use Excel

Suppose instead that Joe contributes nothing to his retirement for the first eight years, but after that contributes $3000 annually until age 60. Use EXCEL & simulate for 100 replications. How much money did Joe contribute in total and what is the expected value of how much he what he would accumulate from his contributions by age 60? What is the probability that Joe will have at least $500,000 at age 60? Use 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

Finance In America An Unfinished Story

Authors: Kevin R. Brine, Mary Poovey

1st Edition

022650204X, 978-0226502045

More Books

Students also viewed these Finance questions