-->

Ratio analysis | Ashmita Old is Gold solution of account grade 12

ASHMITA OLD IS GOLD SOLUTION OF ACCOUNT|GRADE - 12| RATIO ANALYSIS

Ratio Part Click here 

 2076 Set B Q. No. 15

(a)             Current ratio = (current assets)/(current liabilities)

                         = 160000/80000

                        = 2:1

Working note

Current assets =Debtors + Cash balance + closing stock

                           = 40000 + 24000 + 96000

                           = 160000

Current liabilities = Creditors

                                 = 80000

(b)            Quick ratio = (Quick assets)/(Current liabilities)

                    = 64000/80000

                    = 0.8:1   

Working note

Quick assets = Current assets – closing stock

                       = 160000 – 96000

                       = 64000

(c)             Debtors turnover ratio = (Net sales) / (Closing debtors)

Or, 10 = Net sales / 40000

Net sales = Rs. 400000

(d)      Gross profit ratio = (Gross profit)/(Net sales)*100

                                = 80000/400000*100

                                =20%

(e)     Net profit ratio = (Net profit)/(Net sales) *100

                             = 50000/400000*100

                             = 12.5%

2076 Set C Q. No. 15

 (a) Gross profit margin = (Gross profit)/(Net sales)*100

                                    20    =  (108000/ Net sales)*100

                                    0.2 = 108000 / Net sales

                                   0.2 Net sales = 108000

                                  Sales Amount = Rs. 540000

(b) Quick ratio = (Quick Assets)/(Current liabilities)

                           = 50000/45000

                           = 11.11:1

Working note

Quick assets = Debtors + Cash balance 

                       = 40000 + 10000

                       = 50000

Current liabilities = Bank overdraft + Expenses due + Creditors

                                 = 10000 + 5000 + 30000

                                 = 45000

(c) Net profit margin = (NPAT)/Neet sales *100

                       5 = Net profit / 540000 *100

                     0.05 = Net profit / 540000

           Net profit = Rs. 27000

  (d) Return on shareholder's equity = ((NPAT) / Shareholder's fund) *100

                       = (27000 / 270000)*100

                         = 10%

Working note

Shareholder's fund = Share capital + General reserve +Retaining earning

                                  = 200000 + 50000 + 20000

                                  = 270000

2075 Set A Q. No. 15

   (a) Current ratio = (Current assets) / Current liabilities

                            = 400000/125000

                           = 3.2:1

Working note

Current assets = Stock + Cash + Debtors

                        = 200000 + 50000 + 150000

                        = 400000

Current liabilities = Creditors 

                           = 125000

(b) Liquid ratio = Liquid ratio / Current liabilities

                           = 200000 / 125000

                           = 1.6:1

Working note

 Liquid assets = Current assets - Stock 

                       = 400000 - 200000

                        = 200000

(C) Debtors turnover ratio = Net sales / Debtors

               = 700000 / 150000

               = 4.67 times

(d) Fixed assets turnover ratio = Sales/Fixed assets

                OR, 2.5 = 700000 / fixed assets

                OR, 2.5 fixed assets = 700000

                Fixed assets = Rs. 2800000

2075 Set B Q. No. 15

  1.       Average stock = (Opening stock + Closing stock) / 2

OR, 125000 = (100000 + Closing stock) / 2

OR, 250000 = 100000 + Closing stock

Closing stock = 250000 – 100000

                         = 150000

Stock at the end = 150000 

      Inventory turnover ratio = Cost of goods sold / Average Inventory

OR, 4 = Cost of goods sold / 125000

OR, Cost of good sold = Rs. 500000

Gross profit = Sales – Cost of goods sold

Amount of Sales = 125000 + 500000

           = Rs. 625000

(c  Fixed assets turnover ratio = Sales / Net fixed assets

            = 625000 / 156250

            = 4 times

(dDebt equity ratio = (Long term debt / Shareholders equity)*100

Or, 40% = (Long term debt / 500000)*100

Or, 0.4 = Long term debt / 500000

Long term debt = Rs. 200000

2074 Supp. Q. No. 15

(a)             Gross profit margin = (Gross profit / Net sales) * 100

OR, 20% = (300000 / Sales) *100

OR, 0.2 = 300000 / Sales

Or, 0.2 Sales = 300000

 Or, Sales Amount = Rs. 1500000

(b)      Fixed assets turnover ratio = Sales / Fixed assets

                                                  = 1500000 / 750000

                                                  = 2 times

Working note


Fixed assets = Land and building + Machinery

                       = 600000 + 150000

                       = Rs. 750000

(c)             Net profit ratio = (Net profit / Net sales) *100

                            = (150000 / 1500000)*100

                            = 10%

(d)            Quick ratio = Quick assets / Current liabilities

                     = 780000 / 390000

                     = 2.1:1

Working note

Quick assets = Total current assets – Inventories - Prepaid

                       = 1000000 – 200000 – 20000

                       = 780000

Current liabilities = Current liabilities

                                 = 390000

2074 Set A Q. No. 15

(a)             Current ratio = (Current assets / Current liabilities)

                            = 100000 / 50000

                           = 2:1

Working note

Current assets = Debtors + Cash + Prepaid insurance

                         = 60000 + 35000 + 5000

                        = 100000

Current liabilities = Creditors + Interest due

                                 = 400000 + 10000

                                 = Rs. 50000

(b)            Quick ratio = Quick assets / Current liabilities

                     = 95000 / 50000

                     = 1.9:1

Working note

Quick assets = Current assets – Prepaid insurance

                       = 100000 – 5000

                      = 95000

(c)             Debt-equity ratio = (Long term debts / Shareholder’s fund)

                                = (100000 / 240000) * 100

                                = 41.67 %

 Working note

Long term debts = 10 % debenture

                               = 100000 

Shareholder’s fund = Share capital + Reserve & Surplus – Preliminary expenses

= 200000 + 50000 – 10000

= 240000

(d)      Earnings per share = (NPAT – Pref. dividend) / No. of common shares outstanding

= (20000-0) / 2000

= Rs. 10

 Working note

 Net profit = 50000

(-) 10% debenture interest 10000

 Net profit after interest 40000

(-) Tax 20000

 Net profit after tax 20000


 No. of common share = 200000/100

                                        = 2000

2074 Set B Q. No. 15

(a)             Current ratio = Current assets / Current liabilities

Or, 2 = 300000 / Current liabilities

Or, 2 Current liabilities = 300000

Current liabilities = Rs. 600000

Working note

Current assets = Debtors + Cash in hand + Closing stock

                          = 250000 + 50000 + 100000

                          = 400000

(b)            Inventory turnover ratio = Sales / Closing stock

                                             = 500000 / 100000

                                             = 5 times

(c)             Debt-equity ratio = (Long term debts / Shareholder’s fund) *100

                                   = (200000 / 550000)*100

                                   = 36.36%

Working note

Long term debts = Debenture

                               = 200000

Shareholder’s fund = Profit & loss a/c + Share capital 

                                    = 50000 + 500000

                                    = 550000

(d)            Net profit ratio = (Net profit / Net sales) *100

                             = (50000 / 500000) *100

                             = 10% 

2073 Supp. Q. No. 15

(a)             Earnings per share = (NPAT – Pref. dividend) / No. of common

                                      = (240000 – 10000) / 2000

                                      = Rs. 115

Working note

 Net profit before tax 400000

(-) Tax 160000

 Net profit after tax 240000

(b)      Debt-equity ratio = (Long term debts / Shareholder’s fund) *100

                                      = (100000 /300000) *100

                                      = 33.33 %

Working note

Shareholder’s fund = Equity share + Preference share

                                    = 200000 + 100000

                                   = 300000

(c)       Return on common share = (NPAT – Pref. Dividend) / Equity share *100

= (240000 – 10000 / 200000) *100

= 115 %

 2073 Set C. Q. No. 15

(a)             Current ratio = (current assets)/(current liabilities)

                               = 600000 / 200000

                                 = 3:1

Working note

Current assets = Debtors + Cash + Inventory

                           = 250000 + 150000 + 200000

                           = 600000

Current liabilities = Creditors + Outstanding expenses

                                = 100000 + 10000

                                = 200000

(b)            Quick ratio = (Quick assets)/(Current liabilities)

                        = 400000 / 200000

                         = 2:1

Working note

Quick assets = Current assets – Inventory

                        = 600000 – 200000

                        = 300000

(c)             Inventory turnover ratio = Sales / Inventory

                                                   = 2500000 / 200000

                                                       = 12.5 times

(d)            Debt-equity ratio = (Long term debts / Shareholder’s fund) *100

                                                      = (500000 / 1250000) *100

                                                       = 40 %

Working note

Shareholder’s equity = Share capital + Undistributed profit – Discount on share issued

                                      = 1000000 + 300000 – 50000

                                      = 1250000

2073 Set D. Q. No. 15 

(a)             Current ratio = (current assets)/(current liabilities)

                            = 340000 / 100000

                            = 3.4:1

Working note

Current assets = Inventories + Debtors + Cash

                           = 150000 + 175000 + 15000

                           = 340000

Current liabilities = Creditors

                                 = 100000

(b)            Liquid ratio = (liquid assets)/(Current liabilities)

                         = 190000 / 100000

                          = 1.9:1

Working note

Liquid assets = Current assets – Inventories

                         = 340000 – 150000

                        = 190000

(c)             Debtors turnover ratio sales/Debtors

                                               = 875000 / 175000

                                               = 5 times

(d)            Fixed assets turnover ratio = Sales / Fixed assets

         Or, 3.5 = 875000 / Fixed assets

         Or, 3.5 fixed assets = 875000

 

         Fixed assets = Rs. 250000                                             

 2072 Supp. Q. No. 15

(a)             Current ratio = (current assets)/(current liabilities)

                         = 200000 / 100000

                         = 2:1

 

Working note

Current assets = Cash balance + Closing stock + Debtors

= 30000 + 120000 + 50000

=200000

Current liabilities = Bills payable + Creditors

                                 = 20000 + 80000

                                 = 100000

(b)            Quick ratio = (Quick assets)/(Current liabilities)

                         = 80000/100000

                         = 0.8:1

Working note

Quick assets = Current assets – closing stock

                       = 200000 – 120000

                       = 80000

(c)       Debtors turnover ratio = Sales / Debtors

Or, 10 = Sales amount / 50000

 Sales amount = Rs. 500000

 

(d)            Gross profit margin = (Gross profit / Sales)*100

   Or, 20% = (Gross profit / 500000)*100

   Or, 0.2 = Gross profit / 500000

 Gross profit = Rs. 100000

 

2072 Set C. Q. No. 15 

(a)             Current ratio = Current assets / Current liabilities

         Or, 2          = 480000 / Current liabilities

          Or, 2 Current liabilities = 480000

          Current liabilities = Rs. 240000

 Working note

Current assets = Closing stock + Cash in hand + Debtors

                       = 210000 + 120000 + 150000

                     = 480000

(b)            Quick ratio = Quick assets/Current liabilities

                        = 270000 / 240000

                        = 1.125:1

 Working note

Quick assets = Current assets – Closing stock

                        = 480000 – 210000

                        = 270000

(c)             Debt-equity ratio = (Long term debts / Shareholder’s fund) *100

                                    = (200000 / 500000)*100

                                    = 40%

 Working note

Shareholder’s equity = Share capital

                                      = 500000

Long term debts = 10% debenture

                              = 200000

(d)            Debt to total capital ratio = (Long term debts / Capital employed)*100

= (200000 / 700000)*100

= 28.57%

 Working note

Capital employed = LTD + SE

                                  = 200000 + 500000

                                  = 700000

2072 Set D. Q. No. 15

(a)             Current ratio = (current assets)/(current liabilities)

Or, 2 = 200000 / Current liabilities

Current liabilities = 100000

Working note

Current assets = Current assets + Inventories

                           = 200000 + 70000

                           = 270000

(b)            Inventory turnover ratio = Sales / Inventories

Or, 5 = Sales / 70000

Sales amount = Rs. 350000

(c)      Debt-equity ratio = (Long term debts / Shareholder’s fund) *100

                              = (200000 / 500000)*100

                              = 40%                                         

Working note

Long term debt = 10% debenture

                             = 200000

Shareholder’s equity = Share capital

                                      = 500000

(e)             Debt to total capital ratio = (Long term debts / Capital employed)*100

 = (200000/700000)*100

 =28.57%

                 Working note

Capital employed = LTD + SE

                                 = 200000 + 500000

                                 = 700000

 2072 Set E. Q. No. 15

(a)             Current ratio = (current assets)/(current liabilities)

                            = 200000 / 100000

                             =2.1 : 1

 Working note

Current assets = Debtors + Cash + Prepaid insurance + stock

                          = 80000 + 70000 + 10000 + 40000

                          = 200000

Current liabilities = Creditors + Expenses due

                                = 60000 + 40000

                               = 100000

(b)            Quick ratio = (Quick assets)/(Current liabilities)

                         = 150000 / 100000

                         = 1.5 : 1

 Working note

Quick assets = Current assets – prepaid insurance-stock

                        = 200000 - 10000 – 40000

                        = 150000

(c)             Debt-equity ratio = (Long term debts / Shareholder’s fund) *100

                                    = (100000 / 230000)*100

                                    = 43.48 %

 Working note

Long term debts = 10% debenture

                               = 100000

Shareholder’s fund = Share capital + Reserve fund – Preliminary expenses

= 200000 + 50000 – 20000

=230000

(d)      Return on shareholder’s equity = (NPAT – Pref. dividend)/Equity shareholder’s fund

= (23000 – 0) / 2000

= 11.5 %

Working note

Net profit before interest and tax 56000

(-) Interest 10000

Net profit after interest 46000

(-) Tax 23000

Net profit after tax = 23000

 

=