with attached Excel Spreadsheet showing calculationsPV of Life Style(Given)Avera

with attached Excel Spreadsheet showing calculationsPV of Life Style(Given)Average Rate of Inflation(RATE)Years to Retirement(NPER)Find FV of Life Style$1000003.0%Top 500 Stocks Value 5 yrs. ago (PV)Top 500 Stocks Value Now (FV)Number of Periods (NPER)5-Year Return on Top 500 Stocks (RATE)5FV of Account(Given)5-Year Return on Top 500 Stocks(RATE)Years to Retirement(NPER)Find PV of Investment$ 3000000FV of Life Style (PMT)Given Expected Rate of Return (RATE)Years in Retirement (NPER)Required Value at Retirement(Find PV of Annuity)12.0%23FV of Account (Use PV of Annuity from above)5-Year Return on Top 500 Stocks (Rate)Years to Retirement(NPER)Annual Contribution Required to meet goal (Find PMT)