Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Fill in all empty boxes on the worksheet B DE F 1 4% 30.00% 8.00% -15.0% 6.0% 2019 Industry average Long-term ratios for Internet based

Fill in all empty boxes on the worksheet

image text in transcribed

image text in transcribedimage text in transcribed

image text in transcribed

B DE F 1 4% 30.00% 8.00% -15.0% 6.0% 2019 Industry average Long-term ratios for Internet based service companies Revenue growth EBITDA margin CAPEX as % of revenue D&A/Beginning PPE&Intangibles OWC as % of revenue 8 Geographic segment 9 Revenue ($000s) 10 Australia 11 New Zealand 12 United Kingdom 13 North America Rest of World 15 Total 16 EBITDA D&A EBI 19 Revenue growth Australia 21 New Zealand 22 United Kingdom 23 North America 24 Rest of World 25 Total 26 EBITDA margins 27 EBIT margins 28 2017 145,496 62,289 49,712 24,817 13,075 295,389 -28,614 42.130 Page 1 2018 197,094 78,807 79,611 31,873 19,274 406,659 48,197 70.318 14 261,468 97,639 119,521 44,270 29,921 552,819 73,171 8 1.848 17 18 20 B DEF 2017 2018 2019 32 33 29 Income Statements 30 12 months ended 31 March 31 $000 Total operating revenue 34 Cost of revenues 35 Gross profit 36 Sales and marketing Product design and development 39 General and administration Total operating expenses 295,389 (69,385) 226,004 406,659 (75,349) 331,310 552,819 (90,915) 461,904 37 38 (166,776) (93,265) (37,877) (297,918) (189,203) (116,305) (46,737) (352,245) (248,014) (137,795) (66,072) (451,881) 40 41 42 43 44 45 Asset impairments Other expenses Other income Operating deficit Finance income Finance expense Net loss before tax Income tax expense Net (loss profit from discontinued operations 42 1,128 (70,744) 3,674 46 (1,550) (723) 1,087 (22,121) 2,440 (4,190) (23,871) (1,043) (24,914) (18,604) (1,183) 1,087 (8,677) 8,035 (22,494) (23,136) (4,007) (27,143) 47 48 49 (67,070) (1,987) (69,057) 50 51 2017 2018 2019 55 A B 52 Balance Sheets 53 As at 31 March 54 $000 Assets Current assets 58 Cash and cash equivalents 59 Trade and other receivables Short-term derivative assets & other current as Total current assets Page 2 113.699 32,564 1,194 147,457 79.955 33,792 3,501 117,248 458.346 49,466 78,806 586,618 40,862 145,539 65 66 Non-current assets Property, plant & equipment Intangible assets Deferred tax benefit Other receivables & Long-term derivatives Total assets 37 61,804 168,816 500 2,248 350,616 91,491 289,731 1,613 865 970,318 1,975 335,870 68 70 73 74 75 Liabilities Current liabilities Trade and other payables Employee entitlements Lease liabilities Income tax payable Derivative liabilities Other current libilities Total current liabilities 31,995 27,336 6,475 1,105 2,397 2,228 71,536 26,285 27,980 7,531 537 822 27,043 37,830 11,541 1,958 147 26,560 105,079 5,494 68,649 80 83 Non-current liabilities Term debt Derivative liabilities Lease liabilities Deferred tax liabilities Other non-current liabilities Total non-current liabilities 37,906 17 21,286 821 2,880 25,004 357,731 77,367 71,308 1,789 3,735 511,930 613 85 86 2,364 40,883 88 Equity Total equity 89 239,330 241,084 353,309 90 91 Total equity and liabilities 335,870 350,616 970,318 Net Debt 93 94 F 95 OWC 96 97 2017 2018 2019 qa 100 102 2017 2018 2019 108 109 110 40,862 37,451 (16,509) 61,804 61,804 47,577 (17,890) 91,491 112 40,862 Non-financial CA Non-financial CL OWC OWC as % of revenue Increase in OWC 103 104 105 PP&E and Intangibles BASE 106 As at 31 March 107 PP&E Opening carrying amount Additions 111 Depreciation Closing carrying amount 113 114 PP&E CAPEX as % of total revenue (from income tatement) Depreciation as % of beginning PPE 116 Intangible Opening carrying amount Additions 120 Amortisation 121 Closing carrying amount 122 123 Intangible CAPEX as % of total revenue (from income statement) 124 Amortisation as % of beginning intangible 125 126 PP&E and Intangible 127 Opening carrying amount Additions 129 D&A 130 Closing carrying amount 131 Total CAPEX as % of total revenue (from income statement) 133 D&A as % of beginning PPE & Intangible Page 3 115 117 118 119 145,539 77,086 (53,809) 168,816 168,816 184,873 (63,958) 289,731 145,539 128 132

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Accounting

Authors: Donald E. Kieso, Jerry J. Weygandt, Terry D. Warfield, Nicola M. Young, Irene M. Wiecek, Bruce J. McConomy

11th Canadian edition Volume 1

1119048532, 978-1119048534

Students also viewed these Accounting questions