After graduating from university last year with a degree in accounting and finance, Jim Hale took a job as a trainee analyst for an investment company in Melbourne. Jims first few weeks were filled with a series of rotations throughout the firms various operating units, but this week he was assigned to one of the firms traders as an analyst. On Jims first day, his boss called Jim in and told him he wanted to do some rudimentary analysis of the investment returns of the regional airline Regional Express Holdings Ltd (REX). Specifically, Jim was given the following month-end closing prices for the company spanning the months from September 2019 to August 2020:

Date	Closing Price	Date	Closing Price
30 Aug 13	1.11	31 Mar 14	0.81
30 Sep 13	1.04	30 Apr 14	0.77
31 Oct 13	1.03	30 May 14	0.75
29 Nov 13	0.92	30 Jun 14	0.75
31 Dec 13	0.93	31 Jul 14	0.89
31 Jan 14	0.91	29 Aug 14	0.82
28 Feb 14	0.82

Jim was then instructed by his boss to complete the following tasks using the REX price data (note that REX paid no dividend during 2008).

1. Compute the monthly realized rates of return earned by REX for the entire year.

2. Calculate the average monthly rate of return for REX, using both the arithmetic and geometric averages.

3. Calculate the year-end price for REX, computing the compound value of the beginning-of-year price of $ 1.11 per share for 12 months at the geometric average monthly rate of return calculated earlier: End-of-year stock price = Beginning-of-year stock price X (1+ Geometric average monthly rate of return)¹²

4. Compute the annual rate of return for REX using the beginning share price for the period and the ending price (i.e. $1.11 and $0.82).

5. Use the geometric average monthly rate of return and the following relationship to calculate the annual rate of return: Compound annual rate of return= (1+ Geometric average monthly rate of return)¹² -1

6. If you were given annual rate of return data for REX or any other companys shares and you were asked to estimate the average annual rate of return an investor would have earned over the sample period by holding the shares, would you use an arithmetic or geometric average of the historical rates of return? Explain your response as if you were talking to a client who has had no formal training in finance or investments.

(NOTE:- THE SOLUTION IS NOT TO BE DONE ON MS EXCEL)