Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Assume you have exist1 million now, and you have just retired from your job. You expect to live for 20 years, and you want to

image text in transcribed

Assume you have exist1 million now, and you have just retired from your job. You expect to live for 20 years, and you want to have the same level of consumption (i.e., purchasing power) for each of these 20 years, after adjusting for inflation. You also wish to leave the purchasing power equivalent of exist100,000 today to your kids at the end of the 20 years as a bequest (or to pay them to take care of you). You expect inflation to be 3% per year for the next 20 years, and nominal interest rates are expected to stay around 8% per year. A. Calculate the actual amount of consumption, In nominal dollars, using the stated assumptions. i. How much do you need for your kids? II. If you plan to consume exist1.03 in year 1, how much will you need to have to keep the same real consumption In year 2? In year 10? In year 20? III. How much, In nominal dollars, will exist1 of retirement funds earn in year 1? Year 2? Year 10? Year 20? iv. In an Excel spreadsheet (or in a manual table), calculate the following: a. annual investment earnings for each year b. total savings after investment earnings for each year c. subtract annual consumption from total savings each year d. by trial and error, or with the Goal Seek command, determine the amount of consumption that will give you exactly exist100,000, In today's purchasing power, at the end of 20 years B. Do the calculation again using real rates, and setting inflation to equal 0. If you set up your Excel spreadsheet carefully, you should be able to set the inflation rate to equal 0 and enter the real rate of return as the Investment earning rate. Feel free to use a spreadsheet called "5.1 template" (link is provides on the Assignment 2 page) to help you answer this question. I. What is the amount of real consumption In year 1? In year 2? In year 10? In year 20? II. Show that this is consistent with your calculation using nominal rates. III. How much, In real dollars, does that leave for your kids? IV. Show that your bequest is consistent with the nominal rate results above

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

Chains Of Finance How Investment Management Is Shaped

Authors: Diane-Laure Arjalies, Philip Grant, Iain Hardie, Donald MacKenzie, Ekaterina Svetlova

1st Edition

0198802943, 978-0198802945

More Books

Students also viewed these Finance questions