Question

In: Finance

The following information has been extracted from the financial statements of YDI Limited: Extract of Statement...

The following information has been extracted from the financial statements of YDI Limited: Extract of Statement of Comprehensive Income for the year ended 31 December 2019 2018 R R Sales 2 000 000 1 600 000 Cost of sales 940 000 800 000 Operating profit 600 000 520 000 Profit before tax 520 000 450 000 Profit after tax 364 000 315 000 Extract of Statement of Financial Position as at 31 December Assets 2019 2018 R R Non-current assets 2 000 000 1 400 000 Inventories 600 000 800 000 Accounts receivable 400 000 400 000 Cash and cash equivalents 2 000 2 000 3 002 000 2 602 000 R R Equity and liabilities Shareholders’ equity 2 000 000 1 500 000 Long-term loan 700 000 800 000 Accounts payable 182 000 142 000 Bank overdraft 120 000 160 000 3 002 000 2 602 000

Note: 1. All purchases and sales of inventories are on credit. 2. Dividends paid during the year amounted to R218 400. 3. The issued share capital consisted of 500 000 ordinary shares. Required:

5.1 Calculate the following ratios for the year ended December 2019. Where applicable, round off answers to two decimal places.

5.1.1 Operating margin (2)

5.1.2 Debtors collection period (2)

5.1.3 Acid test ratio (2)

5.1.4 Return on equity (2)

5.1.5 Debt to equity (2)

5.1.6 Earnings retention ratio (2)

5.2 Earnings per share (2) 5.2 Suggest two (2) ways in which YDI Limited can improve on its collections from debtors. (2)

5.3 Comment on the current ratio which dropped from 3.98:1 in 2018 to 3.32:1 in 2019. (2)

5.4 Recommend two (2) ways in which YDI Limited can improve its profitability. (2)

Solutions

Expert Solution

Operating margin = Operating profit / Sales * 100 = 600,000 / 2,000,000 * 100 = 30 %

Debtors collection period = ( 365 / Sales ) * Average Accounts Receivable = ( 365 / 2,000,000) * 400,000 = 73 days

Acid test ratio = ( Cash + Accounts Receivable ) / Accounts Payable = ( 2,000 + 400,000 ) / 182,000 = 2.21 : 1

Return on Equity = Profit After Tax / Average Shareholders Equity = 364,000 / 1,750,000 * 100 = 20.8 %

Debt to Equity = Total Liabilities / Shareholders Equity = 1,002,000 / 2,000,000 = 0.501 or 50.1 %

Earnings retention ratio = ( Profit after tax - Dividends) / Profit after tax = ( 364,000 - 218,400 ) / 364,000 * 100 = 40 %

Earnings per share = Profit After Tax / Ordinary Shares Outstanding = 364,000 / 500,000 = R 0.73 per share

Two ways of improving collection from debtors:

  • Making an offer of early payment discount to debtors
  • Charging interest on outstanding debt

Current ratio has dropped mainly because inventories have dropped from 800,000 to 600,000 from 2018 to 2019. Current ratio can be improved by improving collection from debtors, and by repaying the bank overdraft.

Two ways for improving profitability:

  • Better control on operating expenses
  • Increasing selling price if the firm has pricing power.
  • Improving asset turnover

Related Solutions

QUESTION 5: The following information has been extracted from the financial statements of YDI Limited: Extract...
QUESTION 5: The following information has been extracted from the financial statements of YDI Limited: Extract of Statement of Comprehensive Income for the year ended 31 December:                                       2019          2018                                         $                   $ Sales                       2 000 000 1 600 000 Cost of sales              940 000      800 000 Operating profit       600 000      520 000 Profit before tax      520 000     450 000 Profit after tax           364 000    315 000 Extract of Statement of Financial Position as at 31 December: Assets                                   2019              2018...
FINANCIAL STATEMENT ANALYSIS AND INTERPRETATION The following information has been extracted from the financial statements and...
FINANCIAL STATEMENT ANALYSIS AND INTERPRETATION The following information has been extracted from the financial statements and notes of Brown Ltd. 2014 2013 Revenue $ 870 000 $ 862 500 Interest expense 34 500 39 750 Income tax expense 66 900 39 750 Profit 78 750 84 150 Dividends 42 000 42 000 Total assets 810 000 832 500 Total debt 429 750 458 250 Share capital 258 000 243 000 Retained earnings 122 250 131 250 Required: Using the above...
QUESTION FIVE [20] The following information has been extracted from the financial statements of YDI Limited:...
QUESTION FIVE [20] The following information has been extracted from the financial statements of YDI Limited: Extract of Statement of Comprehensive Income for the year ended 31 December 2019 2018 R R Sales 2 000 000 1 600 000 Cost of sales 940 000 800 000 Operating profit 600 000 520 000 Profit before tax 520 000 450 000 Profit after tax 364 000 315 000 Extract of Statement of Financial Position as at 31 December Assets 2019 2018 R...
The following extract appeared in the financial statements of Sihle Limited: Sihle Limited Extract from the...
The following extract appeared in the financial statements of Sihle Limited: Sihle Limited Extract from the Statement of Comprehensive Income for the year ended 31 December 2019: R Sales 4 140 000 Cost of sales (3 490 000) Opening inventory 710 000 Purchases 3 630 000 Gross profit 650 000 Operating expenses (429 000) Operating profit 221 000 Interest  expense (35 000) Profit before tax 186 000 Taxation (52 800) Profit after tax 133 200 Additional information: Dividends paid during the...
The following information has been extracted from the financial statements of a company. Use it to...
The following information has been extracted from the financial statements of a company. Use it to answer the 4 questions that follow it. When answering the questions (filling in the blanks), DO NOT use dollar signs, USE commas to separate thousands, DO NOT use parenthesis to denote negative numbers, USE the negative sign in front of first digit for negative numbers. Round to the nearest dollar. Earnings before interests and taxes: EBIT in 2020 = 600 Tax rate: T =  ...
The following information has been extracted from the financial statements of a company. Use it to...
The following information has been extracted from the financial statements of a company. Use it to answer the 4 questions that follow it. When answering the questions (filling in the blanks), DO NOT use dollar signs, USE commas to separate thousands, DO NOT use parenthesis to denote negative numbers, USE the negative sign in front of first digit for negative numbers. Round to the nearest dollar. Earnings before interests and taxes: EBIT in 2020 = 400 Tax rate: T =  ...
Question (i) The following information is extracted from the financial statements of XERO Limited: Cash $677,423...
Question (i) The following information is extracted from the financial statements of XERO Limited: Cash $677,423 Accounts Payable $1,721,669 Accounts Receivable $1,845,113 Notes Payable $2,113,345 Inventories $1,312,478 Total Current Assets $3,835,014 Total Current Liabilities $3,835,014 Net Sales $9,912,332 Cost $5,947,399 (b) What is the operating cycle for XERO Limited? (c) What can you say about XERO Limited’s accounts receivable and inventory management if it is known that the industry average operating cycle is 72 days? (d) Briefly explain what you...
i) The following information is extracted from the financial statements of XERO Limited: Cash $677,423 Accounts...
i) The following information is extracted from the financial statements of XERO Limited: Cash $677,423 Accounts Payable $1,721,669 Accounts Receivable $1,845,113 Notes Payable $2,113,345 Inventories $1,312,478 Total Current Assets $3,835,014 Total Current Liabilities $3,835,014 Net Sales $9,912,332 Cost $5,947,399 (a) Briefly explain what you understand by the term ‘operating cycle’. ​(1 mark) b) What is the operating cycle for XERO Limited? ​(1 marks c) What can you say about XERO Limited’s accounts receivable and inventory management if it is known...
The following information has been extracted from the books of M & M limited company, an...
The following information has been extracted from the books of M & M limited company, an entity that is listed on the Exchange market, for the year ending December 2019. CapitalComponent Contribution [$] Component       Cost(%) $2 Ordinary Shares 2 000 000 34 Retained Earnings 800 000 34 $1 Cumulative Preference Shares 1 400 000 32 Convertible       Loan Notes 800 000 25 Total Financing 5 000 000 The convertible loan notes were issued two years ago at a face value of...
The following information has been extracted from the books of M & M limited company, an...
The following information has been extracted from the books of M & M limited company, an entity that is listed on the Exchange market, for the year ending December 2019. CapitalComponent Contribution [$] Component       Cost(%) $2 Ordinary Shares 2 000 000 34 Retained Earnings 800 000 34 $1 Cumulative Preference Shares 1 400 000 32 Convertible       Loan Notes 800 000 25 Total Financing 5 000 000 The convertible loan notes were issued two years ago at a face value of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT