Explanation & Answer length: 1 Solutions Worksheet 3 Excel Finance Data Sheets5 attachmentsSlide 1 of 5

•  attachment_1attachment_1  •  attachment_2attachment_2  •  attachment_3attachment_3  •  attachment_4attachment_4  •  attachment_5attachment_5  ### UNFORMATTED ATTACHMENT PREVIEW

TSN: Risk Analysis Single-Factor Model 𝑹(𝒕) − 𝑹𝒇(𝒕) = 𝟎. 𝟎𝟏𝟒 + 𝟎. 𝟑𝟕𝟕[𝑴𝑲𝑻𝑹𝑭(𝒕)] + 𝒆(𝒕) The single-factor CAPM R-Squared is 2.71%. This means that the equation explains 2.71% of TSN’s return variance. The alpha is positive, providing about 1.42% above what was expected. However, we see that the P-value is greater than 5% and T-Stat is 1.67, therefore the alpha is significant at the 10% level. Based on this CAPM model, the security did earn a greater return than it should have. However, it is not strongly significant. Fama-French Three-Factor Model 𝑹(𝒕) − 𝑹𝒇(𝒕) = 𝟎. 𝟎𝟏𝟒 + 𝟎. 𝟑𝟒𝟑[𝑴𝑲𝑻𝑹𝑭(𝒕)] + 𝟎. 𝟐𝟎𝟒[𝑺𝑴𝑩(𝒕)] − 𝟎. 𝟑𝟑𝟖[𝑯𝑴𝑳(𝒕)] + 𝒆(𝒕) The Fama-French 3 Factor Model R-Squared is 4.26%. This means that the equation explains 4.26% of TSN’s return variance. The alpha is positive, providing about 1.41% above what was expected. However, we

Do you similar assignment and would want someone to complete it for you? Click on the ORDER NOW option to get instant services at essayloop.com