Reference no: EM13210842
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.
|
Nfluenced england''s changing imperial policies
: what factors might have influenced england's changing imperial policies to ward the colonies from neglenc to tightening and the reversing it self again?
|
|
How many cubic meters of water are needed
: Establish a grass cover over a 10ha landfill. The root zone of the grass is 40cm deep. Increase the volumetric water content of root zone from 12% to 24%. How many cubic meters of water are needed?
|
|
State what effect on the lathering ability of soap
: After adding the CaCl2 the solution turned the water " hard". What effect did this have on the lathering ability od the soap? On the lathering abilitiy of detergent?
|
|
What types of quality management tools
: What are two or three quality management tools used in data collection? What types of quality management tools do you utilize to make personal or business decisions? How do you use these tools in the decision-making process?
|
|
What is the amount of real consumption in year
: What is the amount of real consumption in year 1? In year 2? In year 10? In year 20 and show that this is consistent with your calculation using nominal rates.
|
|
Calculate the relative compaction
: A dam project specifies 97% compaction. Lab tests on the soil being used indicate that it has a maximum dry density of 1900 kg/m3 at an optimum water content of 13.2%. Field tests give the following results: Field dry density is 1790 kg/m3 and 16...
|
|
What are the important findings
: What are the important findings in Austin Road Co. v. OSHRC and Builders Steel Co. v. Marshall? Your response should be approximately 200 - 300 words and include a reference citation for your response.
|
|
Determine the moment of the force about line joining points
: the triangular plate ABC is supported by ball and socket joints at B and D and is held in the position shown by cables AE and CF. If the force exerted by cable AE at A is 1000N , determine the moment of the force about line joining points D and B.
|
|
Compute the amount of product that was lost in the filtrate
: Estimate the amount of product that was lost in the filtrate, assuming that the volume of the reaction mixture was 1.0 mL when you collected the product by vacuum filteration.
|