QuestionsSelect a public company which is in the business of producing and marketing fast moving consumer goods (e.g. Unilever). Be sure to timely enlist the company of your choice with your teacher, as a company can only be used once in each class. The enlisting will be done on a first come, first served basis. To execute the tasks below consult the company’s annual report over the 3 year period 2017-2019. In addition to the requirements for each question, ensure to provide formulas, assumptions and models as appropriate. Analysis or conclusions which are not based on the applicable theory will consequently limit your marks. (THE COMPANY CHOSEN is WILMAR INTERNATIONAL)Task 1. Ratio analysis (30 marks) You are required to:I. Analyse the company’s consolidated financial statements over 2017-2019 using the following ratios as defined in the book (Financial Management for Decision Makers, Peter Atrill, 9th edition):A. 4 Profitability ratiosB. 5 Efficiency ratiosC. 2 Liquidity ratiosD. 2 Financial gearing ratios
II. Reflect on these ratio outcomes over the 3 year period, and provide your conclusions and recommendations to the Board.
Task 2. Sensitivity analysis (35 marks) Treat the figures in the 2017-2019 Income Statement and Balance Sheet of the company of your choice as if it were a 3 year prognosis. You are asked to execute a separate sensitivity analysis on the original figures as presented in the company’s annual report with each of the following 4 items:
A. Sales in each of the 3 years are 10% higher than currently “forecasted”; use the ‘percentof-sales’ methodB. Sales in each of the 3 years are 10% lower than currently “forecasted”; use the ‘percentof-sales’ methodC. Operating costs in each of the 3 years are 7% higher than currently “forecasted”D. Operating costs in each of the 3 years are 7% lower than currently “forecasted”
For each of the situations A, B , C , and D you are required to:I. Show the effects on the total 3-year Income Statements and Balance Sheets, including the effect on the required financing.
II. Discuss the implications of each of these effects with the Board and draw conclusions with respect to the main risks in the business over this “prognosis” period.
Task 3. Working capital analysis (20 marks) In this task you are also to assume that the figures in the 2017-2019 Income Statement and Balance Sheet of the company of your choice are a 3 year prognosis. Consider the following 6 deviations from the original figures :A. Trade receivables of each of the 3 years are 20% higher than currently “forecasted” B. Trade receivables of each of the 3 years are 20% lower than currently “forecasted” C. Trade payables of each of the 3 years are 30% higher than currently “forecasted”D. Trade payables of each of the 3 years are 15% lower than currently “forecasted”E. Inventories of each of the 3 years are 40% higher than currently “forecasted”F. Inventories of each of the 3 years are 20% lower than currently “forecasted”
You are required to:I. Discuss the effects of each of these 6 deviations on the operating cash cycle in all 3 years.
II. Provide recommendations to the Board on what the focus of their working capital management should be for each of the six (6) scenarios above.
Task 4. Capital structure analysis (15 Marks) Discuss the capital structure of the company over the years 2017-2019.You are required to:
I. Relate the term of the different sources of funds to the term of the different uses of funds.II. Provide a rationale for your conclusions for each of the ‘’term of sources and application (uses)of funds” based on the appropriate concepts used in capital budgeting.