Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Part 1: Risk and Beta Year Apple Stock Price Kroger Stock Price S&P 500 Index (Market Proxy) 2023 $125.07 $45.74 3,895.08 2022 $176.16 $48.12 4,677.03
Part 1: Risk and Beta | ||||
Year | Apple Stock Price | Kroger Stock Price | S&P 500 Index (Market Proxy) | |
2023 | $125.07 | $45.74 | 3,895.08 | |
2022 | $176.16 | $48.12 | 4,677.03 | |
2021 | $128.94 | $31.63 | 3,824.68 | |
2020 | $74.36 | $28.70 | 3,234.85 | |
2019 | $37.07 | $27.66 | 2,531.94 | |
2018 | $44.27 | $27.14 | 2,810.30 | |
Question 1) | AVERAGE Function Excel | |||
Year | Apple Returns | Kroger Returns | S&P 500 Index Returns | |
2023 | ||||
2022 | ||||
2021 | ||||
2020 | ||||
2019 | ||||
Average Returns | ||||
Question 2) | STDEV Function Excel | |||
Stan. Dev. of Apple Returns | Stan. Dev. Of Kroger Returns | Stan. Dev. of S&P 500 Returns | ||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started