Answered step by step
Verified Expert Solution
Link Copied!

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

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

Financial Theory and Corporate Policy

Authors: Thomas E. Copeland, J. Fred Weston, Kuldeep Shastri

4th edition

321127218, 978-0321179548, 321179544, 978-0321127211

More Books

Students also viewed these Finance questions

Question

A diagram showing the activities that support a companys strategy.

Answered: 1 week ago

Question

A measure calculated by taking the ratio of output to input.

Answered: 1 week ago