Optimal complete portfolio and systematic risk of Australian firms: Impact of Global Financial Crisis (GFC)

    There are two parts of this topic: first part is about constructing optimal complete portfolio during and after the GFC. Sixty per cent (60%) mark is allocated for this part. In second part you are required to calculate systematic risks of the firms (selected for part A) during and after the GFC. Forty per cent (40%) mark is allocated for this part.
    What will you need to do in this assignment?
    (i) You will need to form optimal complete portfolios with two risky and one riskfree asset during GFC and post-GFC periods. Please see Assignment: How to download data from Yahoo Finance for more details. (ii) You will also need to calculate systematic risks of two risky assets (i.e. two stocks) during GFC and post-GFC periods.TOTAL ASSIGNMENT SHOULD BE MORE THAN 600 WORDS!!!!I’ve uploaded steps on how to download data from Yahoo Finance for more details.PLEASE ALSO REFER TO BELOW WEBSITES FOR HELP
    https://au.finance.yahoo.com/quote/ASX.AX/history?ltr=1 (Yahoo Finance website to download symbol)
    http://www.rba.gov.au/statistics/tables/#interest-rates (Reserve Bank Of Australia Website For Download Risk-Free Data)
    http://www.asx.com.au/asx/research/listedCompanies.do (Website To get stock symbols)
    https://www.youtube.com/results?search_query=how+to+calculate+variance%2C+covariance+in+excel (How to calculate variance covariance in excel)
    URL)
    Structure of the assignment

                                                                                                                                      Order Now