with attached Excel Spreadsheet showing calculations
PV of Life Style 
Average Rate of Inflation 
Years to Retirement 
Find FV of Life Style 
$100,000 
3.0% 


Top 500 Stocks Value 5 yrs. ago (PV) 
Top 500 Stocks Value Now (FV) 
Number of Periods (NPER) 
5Year Return on Top 500 Stocks (RATE) 


5 

FV of Account 
5Year Return on Top 500 Stocks 
Years to Retirement 
Find PV of Investment 
$ 3,000,000 



FV of Life Style (PMT) 
Given Expected Rate of Return (RATE) 
Years in Retirement (NPER) 
Required Value at Retirement 

12.0% 
23 

FV of Account (Use PV of Annuity from above) 
5Year Return on Top 500 Stocks (Rate) 
Years to Retirement 
Annual Contribution Required to meet goal (Find PMT) 




Are you overwhelmed by an intense schedule and facing difficulties completing this assignment? We at GrandHomework know how to assist students in the most effective and cheap way possible. To be sure of this, place an order and enjoy the best grades that you deserve!
Post Homework