Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can these be done using excel functions please? By the end of each year, you contribute an equal amount of $3,500 per year to your

Can these be done using excel functions please?

By the end of each year, you contribute an equal amount of $3,500 per year to your retirement fund portfolio, which earns an annual nominal return of 11.57% averagely in the long term. The annual contribution continues for 36 years until you retire. (Note: All tax concerns are ignored.)

(a) Ignoring the annual inflation. By the time of your retirement, how much nominal money value would you have in your portfolio?

(b) Again, ignoring the annual inflation. For your post-retirement life (which would last another 28 years), by the end of every year you withdraw and spend an equal amount of annuity payment from your retirement fund account. What should be the nominal annual payment amount you withdraw if you do not plan to leave any money to your heirs?

(c) This time, considering the long-term annual inflation averages 3.15%. By your retirement, how much real money (at deflated real purchasing power) will you actually have in the account? How much equal amount (also at deflated real purchasing power) should you withdraw and spend by the end of each year for your retirement life, provided that you do not plan to leave any money to your heirs?

(d) Again, consider the long-term annual inflation 3.15%. By your retirement, how much real money (at deflated real purchasing power) will you actually have in the account? How much equal amount should you and your heirs withdraw and spend (at deflated real purchasing power) by the end of each year, provided that you plan to allow both you and your heirs to benefit from this fund, generations after generations infinitely?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Accounting questions