Question

In: Accounting

Boom Ltd has the following comparative data.    BOOM LTD Statement of financial position as at...

Boom Ltd has the following comparative data.   
BOOM LTD
Statement of financial position as at 30 June
2020 2019
$ $
Cash 20,050            29,380
Receivables (net) 63,560            57,190
Inventories 59,200            51,300
Property, plant and equipment (net) 207,980          179,170
350,790          317,040
Accounts payable 47,670            57,610
Loan payable (15%) 99,000            99,000
Share capital, $10 each 138,000          118,000
Retained earnings 66,120            42,430
350,790          317,040

Additional information for 2020:
1 Profit was $19,120
2 Sales on account were $376,000.  Sales returns and allowances amounted to $29,700
3 Cost of sales was $199,400.   
4 Net cash provided by operating activities was $52,400   
5 The loan payable is a non-current liability in both years.   
6 Depreciation for the year was $22,500 and there were no disposals in the year.   

Required
Calculate the following at 30 June 2020 (round your final answers to 2 decimal places):
a) Current ratio.
b) Quick ratio.
c) Average collection period.
d) Average days in inventory.
e) Cash return on sales ratio.
f) Cash debt coverage.
g) Current cash debt coverage.
h) Capital expenditure ratio
i) Free cash flow

Solutions

Expert Solution

a. Current Ratio for 2020 : Formula= Current Assets/ Current Liabilities

Current Assets: Cash + Receivables + Inventories

$ 20050+$ 63560+$ 59200

$ 142810

Current Liabilites: Accounts Payable which is 47670

Therefore Current Ratio= 142810/47670

= 3 times (approx)

b. Quick Ratio for 2020 = Quick assets/ Current Liabilites

Quick Assets:    Cash + Receivables

$20050+ $ 63560

$83610

Quick Ratio= 83610/47670

1.75 times (approx)

c. Average Collection period: The average collection period is calculated by dividing the average balance of accounts receivable by total net credit sales for the period and multiplying the quotient by the number of days in the period.

Formula- (Average Debtors/Net Credit Sales) Multiply 365 days

Average Debtors: (Receivables of 2020+ Receivables of 2019) /2

(63560+57190)/2= $ 60375/-

Net Credit Sales= Credit Sales less Returns

376000-29700

= $ 346300

Average Collection period= (60375/346300) Multiply 365 days

64 days approx

4. Average days in inventory; Formula- (Average Inventory/ Cost of Goods Sales) Multiply 365 days

  Average Inventory: Ending inventory (Inventory of 2020)+ Beginging inventory (Inventory of 2019) /2

(59200+51300)/2= $ 55250/-

Cost of Sales: $ 199400

Average days in inventory- (55250/199400) Multiply 365 days

101 days approx

ekkarill92 answered 1 year ago
Next > < Previous

Related Solutions

Boom Ltd has the following comparative data. BOOM LTD Statement of financial position as at 30...
Boom Ltd has the following comparative data. BOOM LTD Statement of financial position as at 30 June 2020 2019 $ $ Cash            20,280            30,990 Receivables (net)            62,860            58,170 Inventories            57,620            49,680 Property, plant and equipment (net)          205,470          175,370          346,230          314,210 Accounts payable            52,350            60,350 Loan payable (15%)            96,000            96,000 Share capital, $10 each          135,000          121,000 Retained earnings            62,880            36,860          346,230          314,210 Additional information for 2020: 1 Profit was  $20,870        2 Sales on account were  $371,600. Sales returns and allowances amounted to $31,500...
Boom Ltd has the following comparative data. BOOM LTD Statement of financial position as at 30...
Boom Ltd has the following comparative data. BOOM LTD Statement of financial position as at 30 June 2020 2019 $ $ Cash            19,980            29,550 Receivables (net)            64,720            59,020 Inventories            61,910            52,060 Property, plant and equipment (net)          200,600          174,340          347,210          314,970 Accounts payable            49,160            58,060 Loan payable (15%)          102,000          102,000 Share capital, $10 each          136,000          119,000 Retained earnings            60,050            35,910          347,210          314,970 Additional information for 2020:         1. Profit was  $19,160        2. Sales on account were $375,100.  Sales returns and allowances amounted to $29,200...
Boom Ltd has the following comparative data. BOOM LTD Statement of financial position as at 30...
Boom Ltd has the following comparative data. BOOM LTD Statement of financial position as at 30 June 2020 2019 $ $ Cash 20,050            29,380 Receivables (net) 63,560            57,190 Inventories 59,200            51,300 Property, plant and equipment (net) 207,980          179,170 350,790          317,040 Accounts payable 47,670            57,610 Loan payable (15%) 99,000            99,000 Share capital, $10 each 138,000          118,000 Retained earnings 66,120            42,430 350,790          317,040 Additional information for 2020: 1 Profit was $19,120        2 Sales on account were $376,000.  Sales returns and allowances amounted to...
QUESTION 1 Boom Ltd has the following comparative data.    BOOM LTD Statement of financial position...
QUESTION 1 Boom Ltd has the following comparative data.    BOOM LTD Statement of financial position as at 30 June 2020 2019 $ $ Cash 20,050 29,380 Receivables (net) 63,560 57,190 Inventories 59,200 51,300 Property, plant and equipment (net) 207,980 179,170 350,790 317,040 Accounts payable 47,670 57,610 Loan payable (15%) 99,000 99,000 Share capital, $10 each 138,000 118,000 Retained earnings 66,120 42,430 350,790 317,040 Additional information for 2020: 1 Profit was $19,120 2 Sales on account were $376,000. Sales returns...
Titiki Ltd. had the following comparative statement of financial position: Titiki Ltd. Comparative Statement of Financial...
Titiki Ltd. had the following comparative statement of financial position: Titiki Ltd. Comparative Statement of Financial Position As at December 31 2020                     2019 Cash                                                                                     $20,500               $12,500 Accounts receivable 34,000                  25,500 Inventories 20,000                  30,000 Prepaid insurance 2,500                    2,000 Equipment 102,000                  90,000 Accumulated depreciation—equipment   (22,500)              (12,500) Total assets   $156,500            $147,500 Accounts payable $23,000               $20,000 Wages payable 4,000                    2,000 Interest payable 2,000                    3,000 Income taxes payable 4,000                    5,000 Long-term note payable 30,000                  34,500 Common shares 65,000                  65,000 Retained earnings     28,500                  18,000...
Titiki Ltd. had the following comparative statement of financial position: Titiki Ltd. Comparative Statement of Financial...
Titiki Ltd. had the following comparative statement of financial position: Titiki Ltd. Comparative Statement of Financial Position As at December 31 2020                     2019 Cash                                                                                     $20,500               $12,500 Accounts receivable 34,000                  25,500 Inventories 20,000                  30,000 Prepaid insurance 2,500                    2,000 Equipment 102,000                  90,000 Accumulated depreciation—equipment   (22,500)              (12,500) Total assets   $156,500            $147,500 Accounts payable $23,000               $20,000 Wages payable 4,000                    2,000 Interest payable 2,000                    3,000 Income taxes payable 4,000                    5,000 Long-term note payable 30,000                  34,500 Common shares 65,000                  65,000 Retained earnings     28,500                  18,000 Total liabilities and shareholders’...
The comparative unclassified statement of financial position for Carla Vista Ltd. follows: CARLA VISTA LTD. Statement...
The comparative unclassified statement of financial position for Carla Vista Ltd. follows: CARLA VISTA LTD. Statement of Financial Position December 31 Assets 2018 2017 Cash $55,000 $28,000 Accounts receivable 81,000 63,000 Inventory 183,000 203,500 Long-term investments 80,000 120,000 Equipment 285,000 156,000 Accumulated depreciation (61,000 ) (37,000 ) Total assets $623,000 $533,500 Liabilities and Shareholders’ Equity Accounts payable $32,000 $ 45,000 Bank loan payable 153,000 172,500 Common shares 219,000 176,000 Retained earnings 219,000 140,000 Total liabilities and shareholders’ equity $623,000 $533,500...
The financial statements of Morgan Ltd appear below: Morgan LTD Comparative Statement of Financial Position 31...
The financial statements of Morgan Ltd appear below: Morgan LTD Comparative Statement of Financial Position 31 December 2018 ________________________________________________________________________________________ Assets                                                                                                         2018                    2017    Cash ..................................................................................................     $ 25,000              $ 40,000 Marketable securities ...........................................................................         15,000                 60,000 Accounts receivable (net) .....................................................................         50,000                 30,000 Inventory ............................................................................................       150,000                170,000 Property, plant and equipment (net) ......................................................       160,000                200,000       Total assets ..................................................................................     $400,000              $500,000 Liabilities and equity Accounts payable ................................................................................     $ 20,000              $ 30,000 Short-term notes payable .....................................................................         40,000                 90,000 Bonds payable...
A summarised comparative statement of financial position of Gilbert Ltd is presented below, together with the...
A summarised comparative statement of financial position of Gilbert Ltd is presented below, together with the statement of profit or loss for the year ended 30 June 2019. Gilbert Ltd Statements of Financial Position (extract) as at 30 June 2019 2019 2018 $ $ Cash 73 000 60 000 Trade receivables 90 000 80 000 Allowance for doubtful debts (6 000) (3 000) Inventory 50 000 45 000 Available for sale investments 24 000 17 000 Plant 110 000 106...
The following are income statement and comparative statement of financial position for Rabies Corporation for the...
The following are income statement and comparative statement of financial position for Rabies Corporation for the year ended 31/12/2019. Sales 1,915,000 C.G.S (965,000) gross income 950,000 Operating expenses (721,000) income from operating 229,000 Other gain or losses ( 2,000) Interest expenses (12,000) Tax (65,000) net income 150,000 Comparative statement of financial positions for the year ended 31/12/2019 ASSETS 2019 2018 L. S. Equity 2019 2018 Cash 104,000 57,000 Accounts payable 69,000 75,000 Accounts receivable 82,000 36,000 Accrued expenses 15,700 16000...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT