Calculate actual amount of consumption-in nominal dollars

Assignment Help Financial Management

Reference no: EM131953340

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? (180,611.12??)

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.

Reference no: EM131953340

Questions Cloud

Different forms of human resources : Discuss how the flexible firm model makes use of different forms of human resources. Illustrate your answer with examples.

Discussion on the social responsibilities of business : How does Dr. Friedman characterize discussions on the "social responsibilities of business"? Why?

What is the dollar value of inventory held by the firm : Calculate the firm's operating cycle and cash conversion cycle. What is the dollar value of inventory held by the firm

Various reasons why training is needed : There are various reasons why training is needed. Identify some causes, and pick one to explain in detail.

Calculate actual amount of consumption-in nominal dollars : Calculate the actual amount of consumption, in nominal dollars, using the stated assumptions.

Health care organization for treatment : Many times when a patient presents to a health care organization for treatment (inpatient or outpatient) they will bring their PHR, sometimes called outside

What would you identify as the major issues and concerns : Accepting the offer from the Tanzanian firm would allow for substantial cost savings compared to the current supplier.

Security of electronic health information : Identify an article in health-care journals concerning the security of electronic health information. Provide a brief, one-paragraph summary of the article.

Explain how organizations use social media to communicate : Explain how organizations use social media to communicate with their consumers through a crisis and evaluate how the negative comments were handled.

User Account

All Pages