Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

For all steps, show your Excel formulas and implications behind the result: Annual Returns on Market, HML, SMB, UMD, and each component portfolio Based on

For all steps, show your Excel formulas and implications behind the result:

Annual Returns on Market, HML, SMB, UMD, and each component portfolio
Based on Book Value-to-Market Value Based on Market Capitalization Based on past year performance (t-2 to t-12 months)
High (Value) Low (Growth) High-Low Small Big Small-Big Up Down Up-Down
Year Market Riskfree H L HML S B SMB U D UMD
2015 0.09% 0.02% -8.79% 0.74% -9.53% -5.22% -1.29% -3.93% 3.28% -17.34% 20.61%
2016 13.50% 0.20% 31.26% 8.62% 22.64% 22.77% 16.14% 6.63% 8.40% 29.74% -21.35%
2017 22.31% 0.80% 13.78% 27.25% -13.48% 16.06% 21.01% -4.95% 21.85% 17.23% 4.61%
2018 -5.12% 1.81% -13.70% -3.90% -9.80% -10.48% -7.14% -3.34% -4.24% -13.99% 9.75%
2019 30.42% 2.14% 21.35% 31.84% -10.48% 23.57% 29.63% -6.06% 26.44% 28.25% -1.80%
2020 24.11% 0.44% 0.25% 46.85% -46.60% 24.21% 11.32% 12.89% 30.88% 23.11% 7.77%
2021 23.61% 0.04% 39.41% 14.08% 25.33% 23.58% 27.38% -3.80% 21.04% 23.36% -2.32%

Calculate the correlation between the market portfolio, SMB, HML, and UMD. Calculate the correlation for all possible pairs.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Meetings Expositions Events And Conventions An Introduction To The Industry

Authors: George Fenich

5th Edition

0134735900, 9780134735900

More Books

Students also viewed these Finance questions

Question

What are some of the reasons for avoiding an auction process?

Answered: 1 week ago

Question

Describe Balor method and give the chemical reaction.

Answered: 1 week ago

Question

How to prepare washing soda from common salt?

Answered: 1 week ago