Answered step by step
Verified Expert Solution
Link Copied!

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

  1. 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.
  2. 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.
  3. Calculate annual holding period returns of CBA and WOW for the year 2023.
  4. 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:
    1. 40% of funds are invested in CBA and rest in WOW.
    2. 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

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

Fundamentals of Investments Valuation and Management

Authors: Bradford D. Jordan, Thomas W. Miller

5th edition

978-007728329, 9780073382357, 0077283295, 73382353, 978-0077283292

More Books

Students also viewed these Finance questions