Question i. Find the monthly holding period returns for 2016 for National Australia Bank (NAB), BHP Billiton (BHP) and the market (MKT) as proxied by...

Question

i. Find the monthly holding period returns for 2016 for National Australia Bank (NAB), BHP Billiton (BHP) and the market (MKT) as proxied by the All Ordinaries index. The monthly holding period return 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). Using Excel, graph your % return results on one graph with returns on the y axis and time on the x axis to enable comparison between options. (Use 'Close' rather than 'Adjusted Close' for the selling price.) Note: Opening price MUST equal previous month closing price (12 marks).