Question

In: Finance

Some financial information is extracted from financial statements of Global Co. as follows: 2020 2019 £000...

Some financial information is extracted from financial statements of Global Co. as follows:

2020

2019

£000

£000

Sales

21,000

17,500

Current assets

5,000

3,500

Current liabilities

3,800

1,900

Overdraft

1,500

200

Non-current liabilities

6,300

6,000

Operating profit margin

24%

30%

Inventory days

70

60

Receivable days

50

70

Payable days

100

90

Quick ratio

0.6:1

0.7:1

The credit controller of the company considers a new credit policy introduced in 2020 has effectively reduced the receivable days, which provides customers a 1% discount if they make full payment within 30 days. Further review of the policy indicates that the policy also reduced bad debts by £800,000 a year and the cost of financing receivables was covered by a short-term loan at the interest rate of 20% pa.

Required:
a) Is there any sign(s) of overtrading for Global? Explain with appropriate

ratio(s)/figure(s).

b) Calculate the appropriate equivalent annual percentage cost of a discount of 1 per cent, which reduces the time taken by credit customers to pay from 70 days to 50

days.

c) Assuming in 2020 customers either paid in 30 days to receive the discount or still paid in 70 days as they used to, what is the percentage of customers, by value, paid

in 30 days? Calculate the net benefit/cost of the policy.

Solutions

Expert Solution

Answer to Question No.a :
Overtrading happens when a business expands too quickly without having the financial
resources to support such a quick expansion.
If suitable sources of finance are not obtained, overtrading can lead to Business Failure.
Global business is over trading due to the following reasons :
1. Increase in sales from $17,500 to $21,000 but reduction in Operating
profit margin from 30% to 24% compared to previous year.
2. Increase in Current Liabilities & Overdraft loans.
3. Payable ratio increased from 90 days to 100 days.
There is a clear evidence that the business is over trading and there is a liquidity problem.
Ratios to explain liquidity position :
formula 2020 2019
1. Current Ratio : Current Assets/ Current Liabilities           1.32           1.84
2. Quick Ratio           0.60           0.70
3. Operation Profit 24% 30%
Answer to Question No.b :
Equivalent annual discount : (1*(70-50)/(70-30))           0.50
Answer to Question No.C :
If all the customers paid in 30 days
Trade Receivables £ 5,000.00
Discount if paid in 30 days @ 1% £        50.00
Reduction in Bad debts £     800.00
Net Benefit of the policy £     750.00

Related Solutions

The following information was extracted from the 2020 financial statements of Arigato LLC:
The following information was extracted from the 2020 financial statements of Arigato LLC:Income from continuing operations before income tax           $755,123Selling and administrative expenses                                            480,357Income from continuing operations                                            495,951Gross profit                                                                                           1,357,530The amount reported for Other Revenue/Gains and Other Expenses/Losses is: $  Blank 1. Fill in the blank, read surrounding text.Use “-“ sign for negative amount, as needed. Use commas, as needed.
(i) The following information is extracted from the financial statements of XERO
(i) The following information is extracted from the financial statements of XEROLimited:Cash $677,423 Accounts Payable $1,721,669Accounts Receivable $1,845,113 Notes Payable $2,113,345Inventories $1,312,478Total Current Assets $3,835,014 Total Current Liabilities $3,835,014Net Sales $9,912,332Cost $5,947,399 (a) Briefly explain what you understand by the term ‘operating cycle’. (1 mark)Click or tap here to enter text. (b) What is the operating cycle for XERO Limited? Click or tap here to enter text. (c) What can you say about XERO Limited’s accounts receivable and inventorymanagement if...
The condensed financial statements of Murawski Company for the years 2019 and 2020 are presented follows....
The condensed financial statements of Murawski Company for the years 2019 and 2020 are presented follows. (Amounts in thousands.) MURAWSKI COMPANY Balance Sheets December 31 2020 2019 Current assets     Cash and cash equivalents $ 346 $ 370     Accounts receivable (net) 406 442     Inventory 392 470     Prepaid expenses 150 146       Total current assets 1,294 1,428 Investments 12 12 Property, plant, and equipment 390 418 Intangibles and other assets 502 528       Total assets $2,198 $2,386 Current liabilities $ 770 $ 900 Long-term...
The condensed financial statements of Murawski Company for the years 2019 and 2020 are presented follows....
The condensed financial statements of Murawski Company for the years 2019 and 2020 are presented follows. (Amounts in thousands.) MURAWSKI COMPANY Balance Sheets December 31 2020 2019 Current assets     Cash and cash equivalents $ 358 $ 353     Accounts receivable (net) 388 490     Inventory 388 474     Prepaid expenses 170 120       Total current assets 1,304 1,437 Investments 13 12 Property, plant, and equipment 390 418 Intangibles and other assets 492 526       Total assets $2,199 $2,393 Current liabilities $ 800 $ 884 Long-term...
The following information is an extract from the financial statements of Extreme-Experiences Pty Ltd. 2020 2019...
The following information is an extract from the financial statements of Extreme-Experiences Pty Ltd. 2020 2019 Current Assets 409,500 292,500 Non-current Assets 2,275,000 1,768,000 Current Liabilities 221,000 169,000 Non-current Liabilities 764,400 670,800 Total Revenue 728,000 624,000 Total Expenses 500,500 455,000 a)    Calculate the following ratios for both 2019 and 2020. 2020 2019 Profit Margin (Correct your answer to 0.01%) Current Ratio (Correct your answer to 0.1) Debt to Total Assets Ratio (Correct your answer to 0.01%) b)    Comment on the...
The following information is an extract from the financial statements of Extreme-Experiences Pty Ltd. 2020 2019...
The following information is an extract from the financial statements of Extreme-Experiences Pty Ltd. 2020 2019 Current Assets 409,500 292,500 Non-current Assets 2,275,000 1,768,000 Current Liabilities 221,000 169,000 Non-current Liabilities 764,400 670,800 Total Revenue 728,000 624,000 Total Expenses 500,500 455,000 Required: Answer the following questions in the spaces provided below: a)    Calculate the following ratios for both 2019 and 2020. 2020 2019 Profit Margin (Correct your answer to 0.01%) Current Ratio (Correct your answer to 0.1) Debt to Total Assets...
The following financial information was extracted from MCL’s current draft financial statements and those of the...
The following financial information was extracted from MCL’s current draft financial statements and those of the previous year:​ 2017 ($M) 2016 ($M) 2015 ($M) Revenue 220 260 240 Total assets 260 280 250 Net Profit before tax 19 (3) 17 The car parts and accessories industry has been very competitive and consumer demand appears to be slowing in anticipation of change with electric and driverless cars coming into the market. The company has recently restructured its operations to outsource its...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT