e. (4 marks) Suppose that you invest 20% in Singapore Airlines Limited, 50% in Qantas Airways Limited and 30% in Cathay Pacific Airlines. Calculate the portfolio expected return, variance and standard deviation.

f. (4 marks) How does the expected return and standard deviation change if you decide to invest 30% in Singapore Airlines Limited, 60% in Qantas Airways Limited, and 10% in Cathay Pacific Airlines? Explain your answers.

g. (5 marks) Find the weights of Singapore Airlines Limited, Qantas Airways Limited and Cathay Pacific Airlines that will provide a daily return of 0.01% with the lowest level of risk. h. (5 marks) Plot a scatter diagram showing the portfolios from parts (e), (f) and (g), with the X-axis displaying standard deviation and the Y-axis displaying daily returns.

i. (4 marks) If the daily risk-free rate is 0.1%, estimate the Sharpe ratio for the portfolios mentioned in parts (e), (f) and (g) and highlight the highest Sharpe ratio using conditional formatting.

Qantas

Average return 0.1%

standard deviation 0.016237584

SAL

Averaeg return -0.04

standard deviation 0.018789358

CPA

Average return -0.1

Standard deviation 0.01740578

correlation

QAN TO SAL -0.342312776

SAL TO CPA 0.281277365

CPA TO QAN -0.224412818

IN EXCEL PLEASE