commercemine

12th | Accounting Ratio | Question No. 111 To 115 | Ts Grewal Solution 2023-2024

Question 111:

Calculate Trade Payables Turnover Ratio and Average Debt payment Period from the following information:
 

 

1st April, 2020
 `

31st March, 2021
 `

Sundry Creditors

1,50,000

4,50,000

Bills Payable

50,000

1,50,000


Total Purchases  ` 21,00,000; Purchases Return  ` 1,00,000; Cash Purchases  ` 4,00,000.

Answer:

Average Trade Payables 

=  Opening Creditors & B/P + Closing Creditors & B/P÷2

 

=  1,50,000 + 50,000 + 4,50,000 + 1,50,000÷2

 

 ` 4,00,000

 

Net Credit Purchases 

=  Total Purchases - Purchases Return - Cash Purchases

 

=  21,00,000 - 1,00,000 - 4,00,000 =  ` 16,00,000

 

Trade Payables Turnover Ratio 

=  Net Credit Purchases /  Average Trade Payables 

=  16,00,000/4,00,000 = 4 times

 

Average Debt Payment Period 

=  12 Trade Payable Turnover Ratio

 

=  12/4 

=  3 months

Question 112:

Calculate Trade payables Turnover Ratio from the following information:
Opening Creditors  ` 1,25,000; Opening Bills Payable  ` 10,000; Closing Creditors  ` 90,000; Closing bills Payable  ` 5,000; Purchases  ` 9,50,000; Cash Purchases  ` 1,00,000; Purchases Return  ` 45,000.

Answer:

Net Credit Purchases = Purchases – Cash Purchases – Purchase Return
                                  =  ` 9,50,000 –  ` 1,00,000 –  ` 45,000 =  ` 8,05,000

Average Trade Payables 

=  Opening Creditors & Bills payables + Closing Creditors & Bills payables / 2

 

=  1,25,000 + 10,000 + 90,000 +5,000/2

 

 ` 1,15,000

 

Trade Payables turnover ratio

=  8,05,000/115000 

 

=  7 Times

 

Question 113:

Calculate Trade Payables Turnover Ratio for the year 2022-23 in each of the alternative cases:
Case 1 : Closing Trade Payables  ` 45,000; Net Purchases  ` 3,60,000; Purchases Return  ` 60,000; Cash Purchases  ` 90,000.
Case 2 : Opening Trade Payables  ` 15,000; Closing Trade Payables  ` 45,000; Net Purchases  ` 3,60,000. 
Case 3 : Closing Trade Payables  ` 45,000; Net Purchases  ` 3,60,000.
Case 4 : Closing Trade Payables (including  ` 25,000 due to a supplier of machinery)  ` 55,000; Net Credit Purchases  ` 3,60,000.

Answer:

Case 1

Net Credit Purchases = Net Purchases − Cash Purchases

= 3,60,000 − 90,000

= 2,70,000

Trade Payables Turnover Ratio = Net Credit Purchases/Closing Trade Payables                                     

= 2,70,000/45,000 

= 6 times

Case 2

Net Purchases = 3,60,000
Average Trade Payables = Opening Trade Payables + Closing Trade Payables/2                                                     

= 15,000 + 45,000/2 = 30,000

Trade Payables Turnover Ratio = Net Credit Purchases/Average Trade Payables  

= 3,60,000/30,000 = 12 times

Case 3

Trade Payable Turnover Ratio = Net Credit Purchases/Closing Trade Payables 

= 3,60,000/45,000 

= 8 times

Case 4

Net Credit Payables for Goods = Trade Payables − Creditors for Machinery

= 55,000 − 25,000

= 30,000

Trade Payables Turnover Ratio = Net Credit Purchases/Average Trade Payables 

= 3,60,000/30,000 

= 12 times

 

Question 114:

Closing Trade Payables `5,40,000, Net purchases `43,20,000, Cash purchases `10,80,000. Calculate Trade Payables Turnover Ratio 

Answers;

Trade payable turnover ratio= credit purchases/ average trade payable

Trade payable turnover ratio =32,40,000 / 5,40,000= 6 Times

Credit purchases= net purchases - cash purchases

32,40,000 = 43,20,000- 10,80,000     

 

Calculation Opening and Closing trade payable

 

Question 115:

From the following information, calculate Opening and Closing trade payable:
Cash purchases 25% of total Purchases, Revenue from operation `3,00,000, Gross profit 25% on revenue from Operations, Opening Inventory ` 75,00,000, Closing Inventory  `150,000, Trade Payables turnover Ratio 3 times, Closing Trade Payables were `75,000 in excess of opening trade payables

Answers;

1

Cost of revenue from operation

= revenue from operation - gross profit

 

 

=3,00,000 -( 25% of revenue from operations)

= 3,00,000 -( 25% of 3,00,000)

= 3,00,000 - 75,000

 

Cost of revenue from operation

=2,25,000

 

 

 

2.

 

Total purchases

 

Total purchases

= cost of revenue + closing inventory - opening inventory

= 25,000 + 15,0000 - 75,000

= 3,00,000

 

 

 

3.

 

Net credit purchases

= total purchases - Cash purchases

= 3,00,000 - 25% of 3,00,000

    3,00,000 - 75,000

 

Net credit purchases

= 2,25,000

 

 

 

4.

Trade payable turnover ratio

3

3x + 3 X + 2,25,000

6x + 2,25,000

6x =

X =

X=

Closing trade payables =

= net credit purchases / average trade payable

= 225,000/ X + X + 7500/2

= 4,50,000

= 4,50,000

4,50,000 -2,25,000

2,25,000/6

37,500 (Opening trade payable)

37,500 + 75,000= 1,12,500

 

Ts Grewal Solution 2023-2024

Click below for more Questions

Class 12 / Volume – I

Chapter 3 – Accounting Ratio

Question No. 1 To 5

Question No. 6 To 10

Question No. 11 To 15

Question No. 16 To 20

Question No. 21 To 25

Question No. 26 To 30

Question No. 31 To 35

Question No. 36 To 40

Question No. 41 To 45

Question No. 46 To 50

Question No. 51 To 55

Question No. 56 To 60

Question No. 61 To 65

Question No. 66 To 70

Question No. 71 To 75

Question No. 76 To 80

Question No. 81 To 85

Question No. 86 To 90

Question No. 91 To 95

Question No. 96 To 100

Question No. 101 To 105

Question No. 106 To 110

Question No. 111 To 115

Question No. 116 To 120

Question No. 121 To 125

Question No. 126 To 130

Question No. 131 To 135

Question No. 136 To 140

Question No. 141 To 145

Question No. 146 To 150

Question No. 151 To 155

Question No. 156 To 160

Question No. 161 To 165

Question No. 166 To 170

Question No. 171 To 175

Question No. 176 To 180

Question No. 181 And 182