Cigalles Ltd. has carried on business for a number of years as a retailer of a...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Cigalles Ltd. has carried on business for a number of years as a retailer of a wide variety of consumer products. The entity operates from a number of stores around the country. In recent years the entity has found it necessary to provide credit facilities to its customers in order to maintain growth in revenue. As a result of this decision the liability to its bankers has increased substantially. The statutory financial statements for the year ended 30 June 2016 have recently been published and extracts are provided below, together with comparative figures for the previous two years. STATEMENTS OF PROFIT OR LOSS FOR THE YEARS ENDED 30 JUNE 2015 2016 Em 2014 Em Sales revenue 1,850 (1.250) 2.200 (1,500) 700 2,500 (1.750) 750 Cost of sales Gross profit Other operating costs Operating profit Interest revenue from credit sales Profit before interest and tax Interest expense Profit before taxation Taxation Profit for the year 600 (550) 50 45 (640) 60 60 (700) 50 90 95 120 140 (25) 70 (110) 30 (60) 60 (20) 40 (10) 20 (23) STATEMENTS OF FINANCIAL POSITION AT 30 JUNE 2015 €m 2014 2016 Em Em Property, plant and equipment Inventories 322 620 278 290 400 492 540 Trade receivables 550 633 12 1,182 15 1,590 Cash 12 Totai assets 1,392 Share capital Reserves Total aquity 90 282 372 90 292 382 90 282 372 Bank loans Other interest bearing borrowings 200 Trade payables Тах раyable Total liabilities and equity 520 200 270 20 320 610 320 280 270 20 1,182 1,392 1,590 Other information (a) Depreciation charged for the three years in question was: Year ended 30 June 2014 2015 2016 Em Em 70 Em 55 60 (b) The other interest bearing borrowings include €50m of 6% convertble loan stock. This stock is convertible into a total of 15 million ordinary shares in 2018. The repayment of the non-convertible interest bearing borrowings other than the convertible loan stock is due on 30 June 2020. (e) Dividends of €30m were paid in 2014 and 2015. A dividend of €20m has been proposcd. Issued capital consisted of 90 million ordinary shares at the nominal value of €l at 1 July 2013, No shares have been issued or reacquired after that. (d) The bank loans are unsecured. The maximum lending facility the bank will provide is €630m. (e) Over the past three years the level of credit sales has been: Year ended 30 June 2014 2015 2016 Em Em Em 300 400 600 () The income tax rate is 33%. The entity offers extended credit terms for certain products to maintain market share in a highly competitive environment. Grven the steady increase in the level of bank loans which has taken place in recent years, the entity has recently written to its bankers to request an increase in the lending facility. The request was received by the bank on 15 October 2016, two weeks after the financial statements were published. The bank is concerned at the steep escalation in the level of the loans and has asked for a report on the financial performance of Cigalles Ltd. for the last three years. Required: 1. Calculate the following ratios for the three years (show the formulae and your workings): • Gross profit margin and profit margin before interest and tax • ROCE • Operating costs to sales • Inventory tumover • Trade receivable days • Interest cover • Gearing • Asset turnover Cigalles Ltd. has carried on business for a number of years as a retailer of a wide variety of consumer products. The entity operates from a number of stores around the country. In recent years the entity has found it necessary to provide credit facilities to its customers in order to maintain growth in revenue. As a result of this decision the liability to its bankers has increased substantially. The statutory financial statements for the year ended 30 June 2016 have recently been published and extracts are provided below, together with comparative figures for the previous two years. STATEMENTS OF PROFIT OR LOSS FOR THE YEARS ENDED 30 JUNE 2015 2016 Em 2014 Em Sales revenue 1,850 (1.250) 2.200 (1,500) 700 2,500 (1.750) 750 Cost of sales Gross profit Other operating costs Operating profit Interest revenue from credit sales Profit before interest and tax Interest expense Profit before taxation Taxation Profit for the year 600 (550) 50 45 (640) 60 60 (700) 50 90 95 120 140 (25) 70 (110) 30 (60) 60 (20) 40 (10) 20 (23) STATEMENTS OF FINANCIAL POSITION AT 30 JUNE 2015 €m 2014 2016 Em Em Property, plant and equipment Inventories 322 620 278 290 400 492 540 Trade receivables 550 633 12 1,182 15 1,590 Cash 12 Totai assets 1,392 Share capital Reserves Total aquity 90 282 372 90 292 382 90 282 372 Bank loans Other interest bearing borrowings 200 Trade payables Тах раyable Total liabilities and equity 520 200 270 20 320 610 320 280 270 20 1,182 1,392 1,590 Other information (a) Depreciation charged for the three years in question was: Year ended 30 June 2014 2015 2016 Em Em 70 Em 55 60 (b) The other interest bearing borrowings include €50m of 6% convertble loan stock. This stock is convertible into a total of 15 million ordinary shares in 2018. The repayment of the non-convertible interest bearing borrowings other than the convertible loan stock is due on 30 June 2020. (e) Dividends of €30m were paid in 2014 and 2015. A dividend of €20m has been proposcd. Issued capital consisted of 90 million ordinary shares at the nominal value of €l at 1 July 2013, No shares have been issued or reacquired after that. (d) The bank loans are unsecured. The maximum lending facility the bank will provide is €630m. (e) Over the past three years the level of credit sales has been: Year ended 30 June 2014 2015 2016 Em Em Em 300 400 600 () The income tax rate is 33%. The entity offers extended credit terms for certain products to maintain market share in a highly competitive environment. Grven the steady increase in the level of bank loans which has taken place in recent years, the entity has recently written to its bankers to request an increase in the lending facility. The request was received by the bank on 15 October 2016, two weeks after the financial statements were published. The bank is concerned at the steep escalation in the level of the loans and has asked for a report on the financial performance of Cigalles Ltd. for the last three years. Required: 1. Calculate the following ratios for the three years (show the formulae and your workings): • Gross profit margin and profit margin before interest and tax • ROCE • Operating costs to sales • Inventory tumover • Trade receivable days • Interest cover • Gearing • Asset turnover
Expert Answer:
Related Book For
South western Federal Taxation 2018 Essentials of Taxation Individuals and Business Entities
ISBN: 9781337386173
21st edition
Authors: William A. Raabe, James C. Young, Annette Nellen, David M. Maloney
Posted Date:
Students also viewed these accounting questions
-
Arizona pic has carried on business for a number of years as a retailer of a wide variety of do-it-yourself goods. The company operates from a number of stores around the United Kingdom. In recent...
-
In preparing the financial statements for the year ended 30 June 2018 the accountant of Windsor Ltd, a tobacco manufacturer and wholesaler, has come to you with the following information and request...
-
Sales had slowed down for a number of periods, but managers kept pushing inventory onto drug store customers. The company was hit with several rounds of income restatements and legal inquiries. In...
-
How do items discussed in the critical audit matters section differ from items in an unqualified opinion with an emphasis-of-matter paragraph? Question 1: (20) A. On November 1, 2019. James Andersun...
-
Explain the ways in which a reduction in fertility can improve women's status.
-
A highway overpass has a shape that can be modelled by the equation of a parabola. If the edge of the highway is the origin and the highway is 15 m wide, what is the equation of the parabola if the...
-
Why is the speed of sound slower at 30,000 feet than at 10,000 feet?
-
On March 20, Shelton Fireworks purchases on account $12,000 of fireworks with a list price of $13,000. Shelton pays the vendor on March 30, which qualifies Shelton for a 2% discount. Shelton uses a...
-
Add more relevant law and law sections. Also add relevant case law. Issue: Is Earth Care, in its capacity as a GreenCo shareholder, able to contest the contact's validity on the grounds of violation...
-
Kathy wants to buy a condominium selling for $95,000. The taxes on the property are $1500 per year, and homeowners insurance is $336 per year. Kathys gross monthly income is $4000. She has 15 monthly...
-
Which of these comes closest in structure to that of a hierarchical database? a) Organization chart b) List of students and their classes c) List of specialty doctors and their patients d) A map of a...
-
Who should you select for your systems-testing team? What skills should they have?
-
Why are human factors important in input design? What principles need to be considered in input design?
-
What is the most commonly accepted notation standard for object modeling?
-
Why is smart card technology able to store a tremendous amount of information? What are some examples of the applications of smart card technology?
-
In terms of aggregation relationships, what is the difference between the use of a hollow diamond and the use of a solid diamond?
-
The sheet of wood with mass [m] kg is used to cover a hole in the floor. The small block at C is used to keep the wood just above floor level. f) Determine the vertical component FA of reaction at...
-
Subprime loans have higher loss rates than many other types of loans. Explain why lenders offer subprime loans. Describe the characteristics of the typical borrower in a subprime consumer loan.
-
In 2017, McKenzie purchased qualifying equipment for his business that cost $212,000. The taxable income of the business for the year is $5,600 before consideration of any 179 deduction. Calculate...
-
Freys, Inc., sells a 12-year franchise to Red Company. The franchise contains many restrictions on how Red may operate its store. For instance, Red cannot use less than Grade 10 Idaho potatoes; must...
-
Benny purchased $400,000 of Peach Corporation face value bonds for $320,000 on November 13, 2016. The bonds had been issued with $80,000 of original issue discount because Peach was in financial...
-
Where does the management accounting function fit into an organizations structure?
-
What are the ethical responsibilities of management accountants?
-
Diana Corporation provides the following information for 2017: Calculate (a) Cost of goods manufactured in 2017 and (b) Cost of goods sold in 2017 Beginning work-in-process inventory, 1/1/2017 Total...
Study smarter with the SolutionInn App