ECONM2027 Financial Statement Analysis and Valuation 2022
Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit
2022
ECONM2027
Financial Statement Analysis and Valuation
Overview Your summative coursework represents 75% of the final mark for the unit.
The coursework is in the form of an essay.
Penalties will apply if the coursework is submitted late.
The coursework is an individual piece of work – you should work on this yourself and not as a group. You will be required to make a plagiarism statement and your submission will be tested for originality.
Overview:
This is your individual coursework worth 75% of the overall mark. There are three
questions to answer.
Required:
Answer all questions.
Rules:
1. There is no word count limit, but your answers should be thorough, yet concise.
2. You need to show detailed calculations to receive full marks – Excel spreadsheets are not acceptable.
3. The cover page should include your name and student number.
4. The deadline for submission is 9 May 2022 at or before 13:00 British Summer Time.
Question 1 – Cash flows
Below you will find a statement of cash flows for a fictitious listed company in 2018- 2020.
Required
a. Prepare a standardised (analytical) statement of cash flows for 2020.
(8 marks)
b. Calculate the free cash flow measure using CAPEX. Explain what this figure implies.
(8 marks)
c. Discuss the evolution of quality of earnings in 2018-2020, as inferred from the statements of cash flow.
(4 marks)
d. Calculate the following ratios for 2019 and 2020 and interpret them:
1. Cash from operations to CAPEX
2. Cash from operations to repayment of debt (including leases) and payment of interest.
(2 x 2.5 marks)
e. Based on academic research discussed in the course, discuss what variables can help predict future operating cash flows using a statistical approach.
(9 marks)
(Total 34 marks)
Further guidance:
Assume tax rate is 19%.
Note below the assumptions you should make about discontinued operations.
You may need to reclassify certain item(s).
Statement of cash flows
€m for the year ending at 31 March Operating cash flows
Operating profit
Cash flows from discontinued operations
2020
6601
2019
-50
-71
2018
4326
858
Depreciation and amortisation 14174 9795 10409
Share-based payments and other non-cash charges 146 147 128
Loss on disposal of PP&E and intangible assets 51 33 36
Impairment losses 1685 3525
Other (income)/expense -4278 155 -181 Decrease/(increase) in inventory 68 -131 -26 (Increase)/decrease in trade and other receivables -38 -31 -1118 (Decrease)/increase in trade and other receivables -100 739 286
18309 14111 14718
Net tax paid -930 -1131 -1118
17379 12980 13600
Investing cash flows
Purchase of interests in subsidiaries, net of cash acquired Purchase of interests in associates and joint ventures Purchase of intangible assets
Purchase of PP&E
Purchase of financial investments
Disposal of interests in subsidiaries, net of cash disposed Disposal of interests in associates and joint ventures Disposal of PP&E
Disposal of financial investments
Dividends received from associates and joint ventures Interest received
Cash flows from discontinued operations (assume similar to
-10295
-1424
-2423
-5182
-1832
4427
61
7792
417
371
-87
-3098
-5053
-3629
-412
45
2269
498
622
-9
-33
-3246
-4917
-3901
239
115
41
1250
489
378
purchase of PP&E) -372 -247
-8088 -9217 -9841
Financing cash flows
Issue of share capital
Short-term borrowing
Proceeds from issue of long-term borrowing
Repayment of borrowings
Purchase of own shares
Issue of convertible bonds
Dividends paid
Net repayment of loans by (lending to) associates and joint ventures
Interest paid
Cash flows from discontinued operations (assume equity
7
2586
9933
-16028
-821
-2644
-101
-2284
7
-541
14681
-6180
-475
3848
-4648
-179
-1297
20
-534
4440
-4664
-1766
-4230
903
-991
financing) -779 -412
-9352 4437 -7234
Net cash (outflow)/inflow -61 8200 -3475
Question 2 – Valuation
It is now 31st December 2020 and the market value of Naudi PLC is £3,632m. Its book value of equity is £1,200m. Naudi is forecast to make profits of £230m in the year to 31st December 2021, which is then expected to grow at a rate of 7% over the next three years (i.e., until the end of March 2024). Naudi’s cost of equity is 9%. Naudi’s dividend policy is to pay 15% of its profit each year. For simplicity assume the dividend is paid on 31st December.
Required
a) Assume residual earnings in 2025 onward will be equal to the 2024 residual earnings plus 5% in perpetuity. Using the residual earnings model, value Naudi’s equity as at 31/12/2020.
(10 marks)
b) Issue a recommendation as to whether you think Naudi’s shares are over or
undervalued.
(5 Marks)
c) Using your answer from part a) and the select information provided below, calculate
the entity value of Naudi PLC as at 31/12/2020
£m
Current assets
Cash
Financial investments
Current liabilities
Borrowings (inclusive of overdraft)
Other financial liabilities
Non-current liabilities
Borrowings
(5 marks) 31/12/2020
27
118
182
85
489
d) Assume that the weighted average cost of capital (WACC) is 7.75%. Find the
free cash flow figure that, if generated in perpetuity, will equal the entity valuation you calculated in part c.
(6 marks) (Total 26 mark)
Question 3 – Effect of R&D Capitalisation
This question is based on the following select information for Roche Group, a Swiss pharmaceutical firm. Roche immediately expenses R&D costs.
Roche CHF Mil
Sales
Research and development
Net profit
Non-current assets
Total assets
Equity
Required
When needed, use tax rate of 20%.
ECONM2027
2019
61466
12774
13497
51837
83091
35867
4
2018
56846
12092
10500
46273
78517
30366
2017
53299
11292
8633
45104
76676
29007
2016
50576
11532
9576
48149
76819
26402
2015
48145
9581
8863
47581
28182
23300
Turn Over
a) Assess the evolution of the intensity of the investment in R&D based on the above numbers for the period 2015-2019.
(6 marks)
b) Calculate the R&D asset under the alternative accounting treatment of capitalisation and amortisation for 2019 & 2018. Assume R&D expenditures are incurred in the middle of the year and have useful life of 4 years.
(10 marks)
c) Complete the table below with a simplified common-size balance sheet using reported numbers and then adjusted numbers.
Prepare a second version of the table with the revised numbers for R&D capitalization, assuming that recognising an R&D asset requires the recognition of deferred tax liability.
(8 marks)
|
2019 |
2018 |
Non-current assets |
|
|
Current assets |
|
|
|
|
|
Liabilities |
|
|
Equity |
|
|
|
|
|
d) Using your answer to part c, discuss the effect of R&D capitalisation and amortisation on the structure of the balance sheet.
(6 marks)
e) Calculate the revised profit in 2019 and 2018 under the alternative treatment of capitalisation and amortisation of R&D expenditure.
(10 marks) (Total 40 marks)
Your final essay must be submitted on Blackboard before the date and time stated above. If you have any queries when submitting your work, please contact the Accounting and Finance Postgraduate Student Administration Office (acfi- [email protected])
If you require a coursework extension, please complete the online form. You must provide supporting evidence for an extension request. Please see the University website for information on how to submit an extension request.
You must submit assessed work before the deadline. Work that has been submitted late without extenuating circumstances is penalised by a reduction of ten marks (out of 100) for each 24-hour period after the agreed deadline, not including UK public holidays or University closure days. If the work is submitted late such that at least five such 24-hour periods have elapsed, the mark awarded will automatically default to zero. (Please see section 17 of the University Regulations and Code of Practice for further details)
If you experience circumstances that may impact your ability to submit the essay by the deadline, please submit extenuating circumstances via the online form. Please see the University website for information on how to submit extenuating circumstances.
Plagiarism and Cheating The University rules and guidance about plagiarism and cheating, and how they are dealt with by the university in the regulations.
The University rules and guidance about Marking Criteria and Scales via this link.
2022-05-07