Assessment Type: Case Study – individual assessment. 2,500 +/- 10% words.Purpose: To allow students to demonstrate an understanding of the various portfolio analysis techniques applicable to real world situations, enabling them to analyse the performance of selected shares and the overall portfolio against a market benchmark. Students will also be required to communicate their findings in a written report. The assessment will reflect the advice that would be expected from students when, after graduation, they are working in a modern accounting practice. This assessment relates to learning outcomes a, b, c and d.Value: 30% Due Date: Week 10 – in TutorialSubmission: Upload a soft copy to Turnitin located on KOI’s Moodle subject homepage by Monday, Week 10. Submit a hard copy in that week’s Tutorial (see Due Date).Topic: Analysis of an Investment Portfolio and Recommendations for the Future.At the end of 2009, on the advice of a friend, your uncle invested $600,000 in a portfolio of 3 shares - $200,000 in BHP, $200,000 in CSL (Commonwealth Serum Laboratories) and $200,000 in WBC (Westpac). The share prices than, and at the end of each year since, are shown below.As at 31 December, Year20092010201120122013201420152016201720182019Share Prices ($.c) BHP CSL 37.14 31.5639.27 36.30 30.83 32.18 31.21 53.79 31.88 67.42 25.39 86.36 16.81 101.55 24.38 97.16 26.96 141.91 31.32 181.08 38.85 280.78WBC 24.91 22.21 20.55 25.58 31.39 32.42 32.24 32.15 31.37 24.95 24.35Each year since 2009, your uncle received and spent the dividends received from these shares, and did not alter the portfolio over this period. In fact, he has little knowledge of shares and investments generally.Now your uncle seeks your advice as to whether he should retain his existing shares, or sell some or all of his portfolio and buy shares in another company or companies, or switch to another asset class. YourFIN201 INVESTMENT MANAGEMENT T120 24/02/2020 15:56 PAGE 8 OF 15 *AUSTRALIAN INSTITUTE OF BUSINESS AND MANAGEMENT PTY LTD © ABN: 72 132 629 979 CRICOS 03171A Approved by KOI Academic Board for T1 2020
FIN201uncle is a widower with no children. He expects to live another 10 years, and you are his only beneficiary under his will.You are required to track the annual performance of the value of the individual share investments, and of the overall portfolio, each year at 31 December, from 31 December, 2010 to 31 December, 3019. Your brief requires you to submit a 2 parts report – first, to report on the annual and overall performance of each share investment, and of the portfolio, against the bench mark market index (as a benchmark, you may choose either the All Ordinaries Index or the ASX200 Index); and secondly, to make recommendations, supported by reasons, for any change in strategy going forward.Task Details:Part 1. You are required to prepare a schedule showing the value of each shareholding, and of your unvcle’s overall investment portfolio at 31 December each year, from 2009 to 2019 inclusive. Include two extra columns in the schedule, one showing the value of your selected All Ordinaries Index or ASX200 Index (which you will need to resear4ech and discover) and the second showing the calculated value of your uncle’ portfolio if instead he had invested the $600,000 in this Index.at 31 December, 2009.Part 2. From the foregoing schedule, calculate the annual percentage returns (correct to 2 decimal places) of each share, the portfolio and the selected market Index for each year over the decade from 2010 to 2019 inclusive, and present in appropriate tables.Further, calculate and present in tables, for the decade, the following:a. The arithmetic annual return and the geometric annual return for each share, the portfolio and the selected market Index.b. The standard deviation and the co-efficient of variation of each share, the portfolio and the market Index.c. The covariance of the average annual returns on each share with that of each of the other shares in the portfolio, i.e., the covariance of BHP with CSL, of BHP with WBC, and of CSL with WBC.d. The correlation coefficients of the average annual returns on each share with each of the other shares in the portfolio, i.e., the correlation coefficient of BHP with CSL, of BHP with WBC, & of CSL with WBC.e. The covariances and correlation coefficients of the average annual returns of the portfolio with those of the selected market Index.f. The Sharpe Index or ratio for each share, the portfolio and the market Index. Assume a risk- free rate of 4% p.a. operated over the decade.Part 3. Prepare a detailed report on the performance of your uncle’s portfolio, noting any over- or under- performance in relation to each share individual, and of the portfolio overall, all compared with the performance of the selected market Index (the benchmark) and note the reasons for these variations. Your report should then extend to include (with reasons) recommendations as to whether, going forward for the next 10 years, you would make any changes to the portfolio now. (May, 2020). These recommendations would include which holdings you would increase, decrease, retain or replace, along with the identification of – and reasons for selecting – the recommended replacement investments. In making your recommendations, you may relax the requirement that 100% of the portfolio be invested fully and equally in 3 shares, and include other asset classes in your recommended investment mix (even zero amounts in shares, if desired).Presentation: 2,500 +/- 10% words, in short Report format. The word count excludes the coversheet, contents page, references, appendices, and illustrations (e.g., diagrams, graphs and tables).Students need to stay within the assigned word limits, and indicate the word count on the cover page of the Assignment. Marks will be reduced for Assignments shorter than or greater than the minimum word count.Every page should be clearly numbered. The Assignment, when lodged, should include the following, in order:FIN201 INVESTMENT MANAGEMENT T120 24/02/2020 15:56 PAGE 9 OF 15 *AUSTRALIAN INSTITUTE OF BUSINESS AND MANAGEMENT PTY LTD © ABN: 72 132 629 979 CRICOS 03171A Approved by KOI Academic Board for T1 2020
FIN201(a) A KOI Cover Sheet for an Individual Assignment(b) A title page, which indicates Subject title, Subject code, trimester number, Assignment title,your full name and KOI student number, word count and Tutor’s name. (c) Executive Summary.(d) Table of Contents.(e) Body (main contents).- Introduction – a brief introduction as to what the report is about, the methodology and key finding.- Research – this should consist of a review of the literature you have discovered on the topic (see research requirements above) – each identified and described item in your literature review should be source referenced with “(Author(s), date of publication and page number(s)”. - Analysis – this will be the major part of your Assignment and may require a number of sub- sections and the inclusion of Appendices – see under (f) below.- Recommendations- Conclusion.(f) Appendices (if any) – you may prefer to include the tables required in Parts 2 and / or 3 above as Appendices, so that your report flows more freely, making appropriate reference/s in your report to each Appendix as required .(g) References (using Harvard – Anglia style)(h) A TURNITIN validation page, including the Similarity score for your Assignment. (i) A copy of the Marking Rubric (see page 10 below)Please prepare a soft copy for submission to TURNITIN by Sunday evening 11.59 pm of Week 10, and a hard copy of your Assignment, containing the requirements specified in items (a) to (i) above, which needs to be lodged with your Tutor by the start of your Week 10 Tutorial.Marking Guide: Marks will be awarded as follows, out of 30 marks.Element Marks Research – extent and application 30 Analysis of the topic 30 Recommendations and Conclusion 20 Presentation 20 Total 100The total will be converted to a mark (correct to the nearer whole number) out of 30%.