Annualized Returns Workings Excel Spreadsheet
Description
I have monthly returns of an ETF i need to find the annualized returns such as the returns since inception, 5 year, 3 year, 1 year, YTD. I also need the Multi factor regression i.e. Fama-French 3 factor model, multi-factor model etc. I also need risk factor analysis such as size bias and value bias.
R1=Russel 1000
R2= Russell 2000
R1V= Russell 1000 value
R1G=Russell 1000 Growth
Finally I need capture analysis of the ETF vs the S&P 500 i.e. upside capture and downside capture.
I also provided a screenshot of what the answers should be, the numbers on the screenshot are NOT the answers its just a sample
Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."
Complete the 
Complete the order payment after filling in the order form. We’ll receive your order and assign it to a writer.
The assigned writer will complete your paper and forward it to our Editing Team for review and approval.
Once approved by the editor, the completed paper will be uploaded to your account for you to download, review and approve.