Task: Based on the same company chosen for the group and first individual assignment, produce an individual professional report on the prospective analysis of the company. Forecast the future financial performance of your company for the next five years and beyond. Use four valuation models, i.e. Dividend Discount Model, Residual Income Model, Residual Operating Income Model and Free Cash Flow Model, to produce an estimate of the firm’s share value, and compare to its current stock price. Perform sensitivity analysis on key forecasting assumptions using only Residual Operating Income Model and discuss the results. Based on sensitivity analysis and as a potential management consultant to your chosen firm, provide a discussion as to the possible opportunities for improvement, and potential challenges for the firm. Provide specific and reasonable remedies for these concerns. The report should cover: Forecasting:(allocated 10 marks) 01/03/2018 (Autumn 2018) © University of Technology Sydney Page 7 of 13 Prepare your forecasts in an excel spreadsheet following a 10-step forecasting template. The forecasting table should include your specific forecasts for the next five years and should be included as an appendix in the report. Explain the reasons for your initial forecast assumptions, i.e. assumptions for sales growth, ATO, PM, net dividend payout ratio, cost of debt and cost of equity. Valuation:(allocated 4 marks) Provide the calculation and results of four valuation models in a table and include it as an appendix in the report. Compare and discuss the estimates obtained from the four models. Compare the estimates with the actual share price to see whether the firm is currently overvalued or undervalued. Sensitivity Analysis:(allocated 6 marks) Adjust your initial forecast assumptions to reflect your optimistic and pessimistic outcomes for sales growth, ATO, PM, net dividend payout ratio, cost of debt and cost of equity and recalculate the estimated share value from the residual operating income model. Provide the sensitivity analysis results in a table. Provide explanations of how the optimistic and pessimistic outcomes for forecasting assumptions are chosen. Identify and discuss the key assumptions that the valuation is most sensitive to. Management Consulting Advice: (allocated 8 marks) Based on sensitivity analysis and the key factors that have significant impact on valuation, discuss potential opportunities and challenges for the firm to maintain or improve current profitability. Provide creative advice on what business strategies and measures specific to your firm that can be adopted to improve value. Overall Report Quality: The report should be readily comprehensible, condensed and within the word limit. Information should be collected from various reliable sources to inform analysis and references are properly cited. Tables and graphs should be used to effectively present information. (allocated 2 marks) Length: 5000 words (exclusive of references and appendices). +/- 10% is acceptable. Appendices are limited to a maximum of 10 pages. Please use a font size of 11, 2.5 cm page margins and a line spacing of 1.5. Submission 1. A PDF file of the individual report should be submitted through TurnitIn on UTS Online. Students should name both the assignment submission and individual reports in the format “{companyticker}_{studentID}”. For example, “QAN_12345678”. Assignments that are not correctly named will not be marked. 2. All individual reports should have a cover page which includes the chosen company name, student name and ID and a word count. All reports should have an introduction and a conclusion. Table of content and executive summary are optional. Harvard referencing style should be used. 3. Students may submit their individual reports to TurninIn as many times as they like prior to the submission deadline. Students are able to submit late assignments to TurnitIn only once after the submission deadline. For each day that the assignment is late, the assignment will lose 10% of the raw assignment mark. Special considerations are approved only if they are applied before the submission deadline for serious medical or personal reasons with supporting documents. 4. TurnitIn checks % similarity to materials from other assignments, websites and journal articles within the Business School and from world-wide institutions. Students are warned that copying materials from their own assignments submitted for other subjects or in previous semesters is also an academic offence
