Q1:

Go to worksheet Results.

For each security, calculate the following metrics in the cells provided.

• Coefficient of Variation (enter results in cells B3:AG3)
• Sharpe Ratio - assume the risk-free rate of return is 2% (enter results in cells B4:AG4)

HINT: Use the annualised return and standard deviation provided for each investment.

Your final answer should have 32 columns of data in range A1:AG5

Using your results, fill in the following table (round your answers to 2 decimal places):

CODE	DESCRIPTION	Annualised Return	Standard Deviation	Coefficient of Variation	Sharpe Ratio
AUST	BETASHARES MANAGED RISK AUST SHARE FUND	0.03	0.09	2.76	0.15
FOOD	BETASHARES GLOBAL AGRI ETF - HEDGED	0.04	0.12	3.00	0.18
HACK	BETASHARES GLOBAL CYBERSECURITY ETF	0.12	0.19	1.56	0.53
OOO	BETASHARES CRUDE OIL INDEX ETF- HEDGED ...	0.04	0.27	6.50	0.08
QRE	BETASHARES AUSTRALIAN RESOURCES ETF	0.14	0.18	1.31	1.16
STT:FR	SPDR MSCI World Comms. Service UCITS ETF	-0.00	0.13	-69.84	-0.17

Note: Your results are in range A1:AG5