Financial Analysis and Valuation Report: Company XYZ

The contents of the report will be evaluated based on the quality of the answers to the following:Question 1(a)In the preparation of your report, indicate the assumptions used about the company’s business environment. (b)Calculate the following financial indicators for the last five financial years. Calculations up to one (1) decimal place would be sufficient. Answers including the formula to compute the indicators should be provided in the report appendix.(i)Compounded average revenue (Sales) growth over 5 years(ii)Compounded average net income growth over 5 years(iii)Gross profit margin(iv)Operating profit margin(v)Asset turnover ratio (vi)Return on revenue (Sales)(vii)Return on equity(viii)Return on total assets(ix)Current ratio(x)Debt ratio(c)Describe and appraise one (1) key strength of the company. Select two (2)financial indicators and explain why your computations of these indicators support your assessment of the company. (You may use indicators that are not included in part (b)).Question 2Appraise and choose the appropriate valuation method to assess the fair value of the company under study and explain the rationale and approach.

Question 3Compute the cost of capital. You must provide your source of data and show all workings in the report appendix.Question 4Analyse the valuation of the company and summarise results in a table. Support your findings with workings (to be attached in the Appendix), stating clearly all assumptions used in the valuation model adopted. Assign an appropriate rating to your analysis with the in-house rating categories and definitions below. Recommendations are based on an Absolute Total Return Rating system, defined as follows:BUYShare price may exceed 10% over the next 12 monthsHOLDShare price may fall  over the next 12 monthsSELLShare price may fall by more than 10% over the next 12 monthsQuestion 5 Organise your analysis and present your recommendation in a professional research report. Develop and formulate your report with relevant justification to back your analysis. Include in your executive summary key data of the company, the investment thesis, the target price, investment horizon and target total return