Excel Formula - Annualized Compound Returns

IN PROGRESS
Bids
21
Avg Bid (USD)
$117
Project Budget (USD)
$30 - $250

Project Description:
This short simple project is to take a series of daily returns for the S&P 500 ( that I have provided) and provide the formula to reach the annualized compound return. The goal is to show the annualized compound return of the time frame if you were to buy and hold, growth of $1MM and the annualized compound return if you were to remove the 40 best days and if you remove the 40 worst days. This is a take off of an old Forbes article suggesting that one must buy and hold stocks in order to reach your investment goals because if you missed the 40 best days your return would be much less. What I am showing is that if you miss the 40 worst days your return would be MUCH better. I do not know how to input the formula. I would like this to be my template to update on a quarterly basis. I need the formula in the spreadsheet for the supplied time frame as well as detailed instructions on how to update for future dates.

Skills required:
Data Entry, Data Processing, Excel
Additional Files: Daily Return S&P 500.xlsx
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 147
in 5 days
$ 60
in 1 days
$ 105
in 3 days
$ 35
in 1 days
Hire gallyn
$ 111
in 7 days
Hire Aldo21
$ 90
in 3 days
$ 166
in 5 days
Hire dviruki
$ 30
in 0 days
Hire pratiktulsiyan13
$ 111
in 2 days
Hire francisco49
$ 155
in 3 days