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

Get your college paper done by experts

Do my question How much will it cost?

Place an order in 3 easy steps. Takes less than 5 mins.

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *