I have calculated parts A through to D as below and am unsure how to tackle questions d to k

a.Search for the stocks of APA Group and Transurban. Download historical daily price data over the last 501 trading days (approx. 2 years).

b.Calculate with Excel the daily returns of the stocks of companies APA and Transurban.

Historical simulation:

c.Based on the 500 returns for each stock calculated in b., calculate 500 alternative scenarios for the $ value of the $350,000 investment in APA stock and the $650,000 investment in Transurban stock, respectively. Sum these two for each scenario to obtain 500 simulations for the $ value of your portfolio consisting of stock APA and stock Transurban.

d.Based on the 500 scenarios for the $ value of your portfolio consisting of stock APA and stock Transurban, calculate the 500 alternative gains/losses for your portfolio.