Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You are interested in investing in Australian shares and decide to investigate the shares of two Australian companies: Commonwealth Bank of Australia (CBA.AX) and Woolworths
You are interested in investing in Australian shares and decide to investigate the shares of two Australian companies: Commonwealth Bank of Australia (CBA.AX) and Woolworths Group Limited (WOW.AX). Below are the opening prices for CBA and WOW for 2023 and dividends paid by CBA and WOW during 2023.
CBA | WOW | |||
month | Opening price | Closing price | Opening price | Closing price |
Jan | 102.60 | 110.06 | 33.56 | 36.08 |
Feb | 110.49 | 100.69 | 36.29 | 36.92 |
Mar | 99.95 | 98.32 | 36.78 | 37.90 |
Apr | 98.59 | 99.36 | 38.07 | 38.83 |
May | 99.96 | 96.78 | 38.84 | 37.54 |
June | 96.52 | 100.27 | 37.54 | 39.73 |
July | 100.30 | 105.71 | 39.73 | 38.62 |
Aug | 105.22 | 102.18 | 38.70 | 38.13 |
Sep | 101.70 | 99.97 | 38.05 | 37.32 |
Oct | 99.36 | 96.56 | 37.19 | 35.22 |
Nov | 96.90 | 104.66 | 35.23 | 34.90 |
Dec | 104.65 | 111.80 | 34.90 | 37.20 |
Share | Date | Dividend | Date | Dividends |
CBA | 21/02/2023 | 2.10 | 10/08/2023 | 2.40 |
WOW | 1/03/2023 | 0.46 | 31/08/2023 | 0.58 |
- Using the prices above calculate for CBA and WOW the percentage return for each month for the period Jan 2023- Dec 2023. The percentage return (%) for each month is the return you would receive if you bought an asset on the first day of the month (opening price) and sold it on the last day of the month (closing price) and include any dividends paid in that month.
- Using the percentage returns calculated in part 1, calculate the standard deviation of the monthly percentage return for the CBA and WOW for the period Jan 2023 - Dec 2023.
- Calculate annual holding period returns of CBA and WOW for the year 2023.
- Now assume we have portfolio consisting of only CBA and WOW shares. If the covariance between CBA and WOW is 0.000851, calculate the return and standard deviation of a portfolio where:
- 40% of funds are invested in CBA and rest in WOW.
- 80% of funds are invested in CBA and rest in WOW.
(Hint: use annual holding period returns for calculation of portfolio returns)
please give me more detailed clearly calculations each section.
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