Essay 16657: Property Investment & Portfolio Management – Economics Assignment Help

Assignment Task:

TASK:

Part A

Question 1 5 Marks The appendix contains total return indices on a monthly basis for the following asset sectors for the period 31 December 2010 to 31 December 2020.

• Cash

• Australian Bonds

• Australian Equities

• AREITS

• International

• Australian Direct Property Using this information calculate the following

• Monthly Returns

• Average Annual Return

• Standard Deviation

• Correlation Coefficient Create a chart of the Average Annual Return and the Standard Deviation for all the asset sectors. Instructions Instructions on how to undertake these calculations are contained in a series of videos on UTS Canvas. You are to use the same formulas as in the videos and you are to use the same layout for your calculations and the chart as shown in these videos Question 1 is to be submitted as a single Excel self-contained document, there are to be no external links. The Excel document is to be fully functional (means all the formulas work); this is not an exercise in word processing. The Excel document is to have the following tabs

• Total Return
• Correlation

• Chart – Risk & Return