Question

In: Finance

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 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 17 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.1.7 Earnings per share (2) POSTGRADUATE DIPLOMA IN MANAGEMENT – ACADEMIC AND ASSESSMENT CALENDAR REGENT BUSINESS SCHOOL (RBS) July 2020 18 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.

Solutions

Expert Solution

5.1.1 Operating Margin

= Operating Profir / Net sales

= 600,000 / 2,000,000

= 0.3 or 30%

5.1.2 Debtors Collection Period

= 365 / (Credit Sales / Average Debtors)

= 365 / (2,000,000 / 400,000)

= 73 Days

5.1.3 Acid Test Ratio

= (Current Assets - Stock) / Current Liabilities

= 402,000 / 302,000

= 1.33

5.1.4 Return on Equity

= Profit After Tax / Equity

= 364,000 / 2,000,000

= 0.182 or 18.2%

5.1.5 Debt to Equity

= Total Debt / Equity

= 700,000/ 2,000,000

= 0.35 or 35%

5.1.6 Earnings Retention Ratio

=( Profit After Tax - Dividend ) / Profit After Tax

= 145600 / 364000

= 0.4 or 40 %

5.1.7 Earning per share

= Profit after Tax / Number of shares

= 364,000 / 500,000

= 0.728

5.2 Ways of Improving Collections from Debtors

1. Offer better terms for payment upfront

Consider discounts for payments upfront (be careful with this one as you need to weigh up the benefits versus costs - redo your budgets).

2. Reduce Trading Terms

What are your trading terms at the moment? Can you reduce them from say 30 days to 7 days? Be sure to give notice to your existing customers. For new customers it should be a no-brainer.

3. Hire a part-time debt collector or restructure

Determine whether any of your admin staff have time to set aside to chase debtors. If not, consider hiring a part time person to perform this role.

5.3 Comment on Current Ratio

The Company's current ratio has changes from 3.98 to 3.32

Ideal Current ratio is between 1.2 to 2.

YDI Ltd is far away from Ideal ratio but it's moving towards it. YDI ltd should try harder to bring it to ideal level

5.4 Ways to Improve Profitability

1) Prepare a strategic plan with 1-year, 3-year, and 5-year goals

Business takes time to develop, therefore, you need to create a strategy that has a five-year outlook at the minimum. Each year needs to define how your business will grow over the years. As your business grows over the years, it will become more complex, which means your financial plan needs to grow with your business.

2) Determine up to five key success factors for your business

Your business will need to operate under five principles that will determine its success. Once these principles are determined, you will need to monitor these factors weekly to ensure that your actions align with them. These key factors should focus on growth and prosperity. Sales and expense controls should definitely be two factors that are also within your success factors. Without these two factors, you will find it hard for your business to be profitable.


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...
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...
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...
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 =  ...
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...
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...
accounting question The following information has been extracted from the financial records of Associate Ltd     at...
accounting question The following information has been extracted from the financial records of Associate Ltd     at 1 April 2004 and at 31 March 2017. Associate Ltd 1 April 2004 Associate Ltd 31 March 2017 $ $ Sales 1 800 000 Less cost of goods sold 1 200 000 Gross profit 600 000 Less expenses 328 400 Profit before tax 271 600 Plus rental income 26 000 Less income tax expense 71 880 Profit after tax 225 720 Retained earnings- opening...
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