AZ FS Spreadsheet
AZ FS Spreadsheet
AZ FS Spreadsheet
7,688 8,251
647 666
11,668 11,845
20,833 20,947
58 39
1,401 1,108
61 171
740 720
2,718 3,438
45,814 47,185
3,193 4,024
5,761 7,022
849 160
36 142
285 364
5,369 7,832
70 -
15,563 19,544
61,377 66,729
(1,822) (2,194)
(188) (192)
(13,987) (15,785)
(36) (33)
(723) (976)
(1,361) (1,127)
(18,117) (20,307)
(15,730) (17,505)
(487) (489)
(18) (2)
(2,490) (2,918)
(2,807) (3,202)
(841) (584)
(6,291) (6,084)
(28,664) (30,784)
(46,781) (51,091)
14,596 15,638
328 328
7,941 7,971
153 153
448 448
1,445 1,423
2,812 5,299
13,127 15,622
1,469 16
14,596 15,638
1 23.44%
2
2018 2019
Cash flows from operating activities
1,993 1,548
Profit before tax
Finance income and expense 1,281 1,260
Share of after tax losses of associates and joint ventures 113 116
Depreciation, amortisation and impairment 3,753 3,762
Increase in trade and other receivables (523) (898)
Increase in inventories (13) (316)
Increase/(decrease) in trade and other payables and provisions (103) 868
Gains on disposal of intangible assets (1,885) (1,243)
Fair value movements on contingent consideration arising from business (495) (614)
combinations
Non-cash and other movements (290) 378
Cash generated from operations 3,831 4,861
Interest paid (676) (774)
Tax paid (537) (1,118)
Net cash inflow from operating activities1 2,618 2,969
Cash flows from investing activities
(349) (709)
Payment of contingent consideration from business combinations
Purchase of property, plant and equipment (1,043) (979)
Disposal of property, plant and equipment 12 37
Purchase of intangible assets (328) (1,481)
Disposal of intangible assets 2,338 2,076
Movement in profit-participation liability – 150
Purchase of non-current asset investments (102) (13)
Disposal of non-current asset investments 24 18
Movement in short-term investments, fixed deposits and other investing 405 194
instruments
Payments to associates and joint ventures (187) (74)
Interest received 193 124
Net cash (outflow)/inflow from investing activities 963 (657)
Net cash inflow before financing activities 3,581 2,312
Cash flows from financing activities
34 3,525
Proceeds from issue of share capital
Issue of loans 2,971 500
Repayment of loans (1,400) (1,500)
Dividends paid (3,484) (3,592)
Hedge contracts relating to dividend payments (67) 4
Repayment of obligations under leases – (186)
Movement in short-term borrowings (98) (516)
Net cash outflow from financing activities (2,044) (1,765)
Net increase in Cash and cash equivalents in the period 1,537 547
Cash and cash equivalents at the beginning of the period 3,172 4,671
Exchange rate effects (38) 5
Cash and cash equivalents at the end of the period 4,671 5,223
2020
3,916
1,219
27
3,149
(739)
(621)
1721
(1,030)
(272)
-276
7,094
(733)
(1,562)
4,799
(822)
(961)
106
(1,645)
951
40
(119)
1381
745
(8)
47
(285)
4,514
30
2968
(1,609)
(3,572)
-101
(207)
288
(2,203)
2311
5,223
12
7,546
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
What proportion of total assets was funded by owners in 2020
What proportion of current assets was funded by suppliers in 2020
What proportion of liabilities need to be repaid within one year?
Wages paid to factory workers will be reflected in
Main source of improvement in Operating profit margin for FY 2020 is driven by
What is the EBITDA for the FY 2020
Which investing activity consumes the most cash
How much dividends were paid during the FY 2020
Why is Share of after tax losses of associates and joint ventures
On average how long does AZ take to collect cash from its customers
Inventory write-off
Provision for doubtful debt / Gross AR
Fixed asset turnover
What is the Gross PP&E as on 31/12/2020
What is the approximate average age of PP&E as on 31/12/2020
Comments
23% SE / A
81% Trade & other payable / current assets
40% Current liabilities / total liabilities
Cost of sales
Reduction in SG&A
8,371
Purchase of intangible assets from statement of cash flows
3572 from statement of cash flows
There is no actual cash outflow
50.6765413081865 Refer note 16 for trade receivable data
149 Refer note 15
0.60% Refer note 16 for trade receivable data
3.34 3.33985820942343
16,067
11.34
Taxes 321
Taxes / Total revenue 1.3
Share of after-tax losses of associates and joint ventures is added back to net income There is
while calculating cash flow from operations. Associates and Joint Ventures are entities
partly owned by AZ and other pharma companies in order to develop specific therapies no actual
and medicines. Which of the following could be the most plausible explanation. cash
outflow
9
10 For this question, assume that Product sales and Collaboration revenue are all on credit
(that is, Trade receivables). Approximately how many days did AZ take to collect its trade
receivables in FY 2020?
For the FY 2020, what is the provision for doubtful debts as a percentage of gross trade
receivables?
11
Provision/ Gross AR (Refer to note 16)
Gross AR for 2020 3606
Provision 21
Provison as a % of AR 0.6
12 What is the amount of inventory write-offs during the year ended 31/12/2020?
Refer to footnotes under note 15 149
On average each dollar invested in Property, Plant & Equipment (PP&E) generates how
much total revenue in FY 2020?
13
Computing Total Revenue/ Average PPE
Total revenue for 2020
Compuing Average PPE
Opening PPE 7688
Closing 8251
Average PPE 7969.5
Total revenue/ Avg PPE 3.34
21,318
26,617
80 0
(11,294)
26,617
42
6
-399
1.5
0.1
772
2.9 1.6
2020
3606
-21
3585
26,617