Question
Please show me the EXCEL functions that was used to help me better understand was equals what. Using only Excel finance formulas ( PV, FV,
Please show me the EXCEL functions that was used to help me better understand was equals what.
Using only Excel finance formulas ( PV, FV, PMT, NPER or RATE)
By the end of each year, you contribute an equal amount of $3,000 to your retirement fund portfolio, which on average earns an annual return of 12.5%. The contribution continues until your retirement.
(a) 30 years later you retire, how much money do you have in your portfolio by then?
(b) For your post-retirement life (which last approximately another 20 years), every year you withdraw and spend an equal amount of annuity payment from your trust fund account. What would be the annual payment amount you receive if you plan to leave no money to your heirs?
(c) Considering the long-term inflation rate amounts to 3.5% annually, how much money at real purchasing power will you actually have when you retire? How much should you withdraw and spend per year at real purchasing power for your post-retirement life? (Hints: Your annual return of 12.5% earned in the market is just nominal as stated in this case, but the annual real return will be less than the given nominal return with the annual inflation being adjusted for. For example, even if your boss grants you an annual salary raise of 3%, but you are not actually getting 3% richer each year. Even if your bank pays your savings account an APR of 0.25% annual interest rate, but your real fortune of savings is not really growing 0.25% per year --- because the inflation is eating up your money growth each period. In case the annual inflation indicator CPI is 3%, your bank savings account is actually earning approximately real rate = nominal rate inflation = 0.25% - 3% = -2.75% in real purchasing power, you are getting poorer instead of richer on your bank deposits!)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started