Assume you have 1 million now and you have just retired

Reference no: EM13381733

Assume you have $1 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 $100,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 $1.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 $1 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 $100,000, in today's purchasing power, at the end of 20 years

Hint: You will need to make your annual consumption column dependent on the inflation rate, your investment earnings will grow at the nominal rate, and the bequest of $100,000 will grow at the inflation rate.

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 the spreadsheet below 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.

Reference no: EM13381733

Questions Cloud

1 sixty-five years old ashley taylor has received 300000 as : 1. sixty-five years old ashley taylor has received 300000 as a lump sum pension settlement. she has invested the money

You and your friends are thinking about starting a : you and your friends are thinking about starting a motorcycle company named apple valley choppers. your initial

Are you better off playing the lottery or saving the money : are you better off playing the lottery or saving the money? assume you can buy one ticket for 5 draws are made monthly

Linus is 18 years old now and is thinking about taking a : linus is 18 years old now and is thinking about taking a 5-year university degree. the degree will cost him 25000 each

Assume you have 1 million now and you have just retired : assume you have 1 million now and you have just retired from your job. you expect to live for 20 years and you want to

General battery company gbc is formulating plans to open : general battery company gbc is formulating plans to open battery exchange centers throughout the u.s. where

Problem 1 what is the price of a bond that has the : problem 1 what is the price of a bond that has the following characteristics a years until maturity 20 b coupon

Does michael porters concept of corporate shared value end : does michael porters concept of corporate shared value end the debate on shareholder primacy versus stakeholder primacy

Given a firm beta of 14 does capm predict a firm expected : given a firm beta of 1.4 does capm predict a firm expected return higher than the sampp500?what does a firms beta

User Account

All Pages