Question

In: Accounting

The trial balance of Miyanda Traders, after the calculation of the gross profit, was as follows:...

The trial balance of Miyanda Traders, after the calculation of the gross profit, was as
follows:

Dr (K) Cr (K)
Gross profit 120 000
Sundry expenses 57 000
Non-current assets (cost) 400 000
Non-current assets (provision for depreciation) 82 000
Trade receivables 55 000
Trade payables 85 000
Inventory at 31 December 2019 125 000
Cash 5 000
Bank loan (repayable 31 January 2020) 35 000
Capital 320 000
642 000 642 000


7
Additional information for the year ended 31 December 2019:
1. Mark-up on cost of sales, 25%.
2. Depreciation for the year on non-current assets, K15 000.
Required
(a) Calculate the following for the year ended 31 December 2019:

(i)
(ii)
(iii)
(iv)
Revenue (sales)
Net profit ratio
Return on Capital Employed ratio
Quick ratio (acid test)
[2 Marks]
[2 Marks]
[2 Marks]
[2 Marks]
(b) Explain to Miyanda why the quick ratio (acid test) is a better measure of liquidity
than the working capital ratio (current ratio).
Marks]
[4
(c) Comment upon the adequacy of Miyanda’s cash for the next three months. Give one
reason for your comment. [4 Marks]

(d) Suggest four ways in which Miyanda might increase the cash in the business.
[4 Marks]

Solutions

Expert Solution

A)

i)Sales =Gross Profit/sales to gp ratio

Cost to GP ratio=25%

Lets say cost=100 then Gross Profit shall be 25 and sales shall be 125

Therefore taking above we can say that Gross Profit to sales ratio is 25/125=20%

Gross Profit =120000k

Sales=120000/20%=6,00,000k

ii) Net Profit Ratio=Net Profit/Sales

Net profit= Gross Profit-sundry expenses - Depreciation

=120000-57000-15000

=48000k

Net Profit Ratio=48,000k/6,00,000k

                               =8%               

iii) Return on Capital employed ratio=net profit /Capital employed*100

                                                                  = 48,000k/642000k*100=7.477%

iv) Quick Ratio= Cash + Marketable Securities + Accounts receivable/ Current Liabilities

                    =(5000+55000)/ (85000+35000**)=0.5

** because bank loan is payable within 1 month thats why it is included in current liability

B) Quick Ratio (Acid Test Ratio) = (Current Assets - Inventory)/Current Liabilities

                                                       or

= Cash+ Marketable Securities + Accounts receivable/ Current Liabilities                                                       

             Working Capital (Current) Ratio= Current Assets/Current Liabilities

     

Miyanda Traders need to understand that quick ratio (acid test) is a better measure of liquidity than the working capital ratio (current ratio) because acid test ratio takes effect of inventory and other such assets which are not liquid as other current assets as inventory takes time to sell. The acid test, or quick ratio, compares a company's most short-term assets to its most short-term liabilities to see if a company has enough cash to pay its immediate liabilities, such as short-term debt. However acid-test ratio may not give a reliable picture of a firm's financial condition if the company has accounts receivable that take longer than usual to collect or current liabilities that are due but have no immediate payment needed.

     

C) Miyanda Traders has cash of 5,000k however after 1 moth they are having payment of 35,000k for bank loan, also their trade payables are more than trade receivable by 30000k which can also leads to shortage of cash.

D) Four ways in which Miyanda Traders might increase the cash in the business are

i) They can increase cash sales as it would leads to increase in cash

ii) They can reduce unnecessary expenses ,if possible

iii) They should increase GP ratio which will leads to more profit and therefore more cash

iv) They can delay payments to creditors and receive early payment from debtors by giving cash discounts.


Related Solutions

Example Three: Use a Trial Balance to: Calculate Gross Profit (Gross Margin), Current Assets, Long-Term Assets...
Example Three: Use a Trial Balance to: Calculate Gross Profit (Gross Margin), Current Assets, Long-Term Assets (PPE), Current Liabilities, and Long-Term Liabilities Prepare Closing Entries, and Calculate ending balance in Retained Earnings. Account Name Debit Credit Cash 143,500 Accounts Receivable 23,250 Allowance for Uncollectible Accounts 465 Inventory 20,750 Prepaid Rent 3,000 Equipment 30,000 Accumulated Depreciation – Equipment 2,300 Accounts Payable 5,000 Salaries Payable 900 Unearned Revenue 3,500 Notes Payable 45,000 Common Stock 150,000 Retained Earnings 10,250 Dividends 1,500 Sales Revenue...
Following is the Trial Balance of Shaheen Traders for the period of 2nd Quarter of 2019:...
Following is the Trial Balance of Shaheen Traders for the period of 2nd Quarter of 2019: Title of Accounts Debit (Rs.) Credit (Rs.) Cash 22,000 Bank 62,000 Marketable Securities 55,000 Salaries Expense 60,000 Prepaid Insurance 27,000 Accounts Payable 36,000 Capital 120,000 Service Income 180,000 Furniture 70,000 Rent Revenue 64,000 Prepaid Advertisement 15,000 Insurance Expense 9,000 Equipment 80,000 Total 400,000 400,000 Data for Adjustment: i. Salaries accrued Rs. 12,000 ii. Insurance expired for 2nd Quarter Rs. 9,000 iii. Service Income Accrued...
Gross profit $ and gross profit % for Walgreens Gross profit for 2018 = Revenue –...
Gross profit $ and gross profit % for Walgreens Gross profit for 2018 = Revenue – Cost of Goods Sold = 131,537 – 100,745 = $30,792 Gross profit % for 2018 = Gross profit / total sales * 100 = $30,792 / $131,537 *100 = 23.41% Gross profit for 2017 = 118,214 – 89,052 = $29,162 Gross profit % for 2017 = $29,162 / $118,214 *100 = 24,67% Gross profit for 2016 = 117,351 – 87,477 = $29,874 Gross profit...
There is a third trial balance that is done as well after the adjusted trial balance....
There is a third trial balance that is done as well after the adjusted trial balance. Do you know what that is and why it is necessary?
POST ADJUSTMENTS TRIAL BALANCE OF TUTU TRADERS FOR THE YEAR ENDED 28 FEBRUARY 2017 BALANCE SHEET...
POST ADJUSTMENTS TRIAL BALANCE OF TUTU TRADERS FOR THE YEAR ENDED 28 FEBRUARY 2017 BALANCE SHEET SECTION DEBIT CREDIT CAPITAL 5 000 000 DRAWINGS        484 000 VEHICLES AT COST        777 000 PLANT AND MACHINERY AT COST        436 550 OFFICE FURNITURE AT COST        271 456 ACCUMULATED DEPRECIATION ON VEHICLES     112 000 ACCUMULATED DEPRECIATION ON PLANT      436 550 ACCUMULATED DEPRECIATION ON FURNITURE     261 456 FIXED DEPOSIT        260 000 15% LONG TERM LOAN     200...
What does gross profit represent? [NOT the calculation, but rather what does it “mean”…] Given this,...
What does gross profit represent? [NOT the calculation, but rather what does it “mean”…] Given this, how would gross profit (also known as gross margin) be computed for a service organization? What might it mean to have a decline in unearned revenues in the current year if the company is a magazine publisher? Explain why the amount of retained earnings reported on the balance sheet is often not the net amount of all accumulated earnings (and losses) less all accumulated...
The trial balance for Game Time on July 31 is as follows: Game Time Trial Balance...
The trial balance for Game Time on July 31 is as follows: Game Time Trial Balance July 31, 20-- Account Name Debit Credit Cash 14,721 Supplies 257 Prepaid Insurance 1,295 Equipment 17,642 Accumulated Depreciation, Equipment 2,287 Repair Equipment 1,265 Accumulated Depreciation, Repair Equipment 880 Accounts Payable 942 B. Ryan, Capital 23,871 B. Ryan, Drawing 2,000 Game Fees 7,954 Concession Fees 3,752 Wages Expense 1,068 Rent Expense 980 Utilities Expense 246 Repair Expense 180 Miscellaneous Expense 32 39,686 39,686 Data for...
The following trial balance was extracted from the books of Al Mawaleh Traders, sole trader as...
The following trial balance was extracted from the books of Al Mawaleh Traders, sole trader as at 31 May 2018. Trial balance as at 31 May 2018 Particulars Debit Credit $ $ Capital 51,960 Drawings 4,080 Buildings at cost 53,000 Receivables and Payables 8,600 6,000 Opening Inventory 11,300 Salaries 5,080 Freight In 2,390 Freight Out 2,140 Insurance 2,790 Purchases and sales 97,600 140,385 Returns 980 1,640 Selling Expenses 1,440 Bad debts 541 Discount Received 960 Equipment at cost 8,000 Furniture...
The trial balance and additional information were extracted from the accounting records of Princess Traders on...
The trial balance and additional information were extracted from the accounting records of Princess Traders on 28 February 2019, the end of the financial year PRE-ADJUSTMENT TRIAL BALANCE ON 28 FEBRUARY 2019 Statement of Financial Position accounts section Debit($) Credit($) Capital 375 000 Drawings 30 000 Land and building 285 000 Vehicle at cost 210 000 Equipment at cost 150 000 Accumulated Depreciation on Vehicle 120 000 Accumulated Depreciation on Equipment 84 000 Fixed deposit: Ben Bank (9% p.a) 45...
The adjusted trial balance of Monona Inc. as of December 31, 2020, follows. Adjusted Trial Balance...
The adjusted trial balance of Monona Inc. as of December 31, 2020, follows. Adjusted Trial Balance December 31, 2020 Acct. No. Account Debit Credit 100 Cash $18,000 $ 104 Accounts receivable 35,000 105 Allowance for doubtful accounts 1,775 106 Inventory 40,000 108 Prepaid insurance 2,400 150 Land 5,725 155 Building 100,000 156 Equipment 30,000 162 Accumulated depreciation 6,250 202 Accounts payable 37,500 204 Salaries payable 2,250 208 Deferred service revenue 1,000 210 Interest payable 250 240 Note payable 75,000 302...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT