Question: IN EXCEL (SHOW FUNCTION) Question 2: John is 40 years old today (this is time 0). He is hoping to retire at age 65 (exactly

IN EXCEL (SHOW FUNCTION)

Question 2: John is 40 years old today (this is time 0). He is hoping to retire at age 65 (exactly on his 65th birthday) and actuarial tables suggest that he is likely to live until the age of 85. He wants to move to a Caribbean Island when he retires at age 65 (on his 65th birthday). He estimates that it will cost him $50,000 to make the move on his 65th birthday. Starting on his 65th birthday and ending on his 84th birthday (all withdrawals are at the beginning of the year), he will withdraw $40,000 per year for annual living expenses. Assume interest rate to be 5.5% for all calculations.

Use the timeline method to solve this question. (16) What is the total amount required on the 65th birthday so that this amount can be used to make all the expenditures in retirement?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

John is 40 years old today (this is time 0). He is hoping to retire at age 65 (exactly on his 65th birthday) and actuarial tables suggest that he is likely to live until the age of 85. He wants to...

In excel John is 40 years old today (this is time 0). He is hoping to retire at age 65 (exactly on his 65th birthday) and actuarial tables suggest that he is likely to live until the age of 85. He...

John is 40 years old today (this is time 0). He is hoping to retire at age 65 (exactly on his 65th birthday) and actuarial tables suggest that he is likely to live until the age of 85. He wants to...

GUIDELINES - Work on each question in a separate worksheet of the same Excel file. Name the sheets Q 1 , Q 2 , etc. Clearly indicate where you have the answer to each part ( A , B , C , etc. ) ....

Question 2: Jenny is 23 years old today (this is time 0). She is hoping to retire at age 62 (exactly on her 62nd birthday) and actuarial tables suggest that she is likely to live until the age of 86....

Hello, I study accounting and I have couple practice questions to be answered. I would appreciate it if you could check and let me know if you could help me out on these and I have more. I look...

Please Help, my team and I have different answers. Problem 6.34 Present Value Tirade Owens, a professional athlete, currently has a contract that will pay him a large amount in the first year of his...

I am short on time and need assignment 6.34 done, before 6 if possible. If someone can help. Problem 6.34 Present Value Tirade Owens, a professional athlete, currently has a contract that will pay...

Why should the growth and variability of earnings affect the value of a companys common stock? Explain.

Question a) to g) are based on the following Arduino Uno figure. B E A D4 F 9000 9A5 DIGITAL (PWM-) E O UNO ARDUINO NOVES HERMAN POWER O www.ARDUINO.CC MADE IN ITALY JK L ON 8 G ANALOG ICSP H Input...

If the market value of inventory is less than its cost, then application of the lower - of cost - or - market rule would do what to earnings and current ratio

The current training process is as follows: None of the jobs has a training manual per se, although several have somewhat out-of-date job descriptions. The training for new employees is on-the-job....

=+would you use if a major client wanted you to demonstrate your CSR commitment?

=+5. Have a look at this article by Timothy Ogden (http://www.millermccune.com/business_economics/ computer-error-1390).317 What are some of the criticisms of OLPC?

=+Do you think it is an effective way of improving the education of children in developing countries?