Problem No. 14. Rearrange the balance Sheet in vertical form and calculate the trend percentage taking 2016 figures as 100 and briefly comment on the same. Balance Sheet as on 31 December (Rs in Lac) Liabilities 2016 2017 2018 2019 Assets 2016 2017 2018 2019 Share 60 60 80 80 Building 50 60 55 80 Capital Reserve 50 45 20 20 Goodwill 50 45 40 40 Surplus 13 32 31 40 Machinery 20 40 43 50 Debentures 10 20 20 30 Stock 05 15 25 05 Secured 12 08 10 20 Debtors 20 14 15 10 Loans Creditors 06 08 10 Bank 01 02 08 28 03 Cash 05 01 02 15 04 Preliminary 03 02 01 Overdraft Expenses Other 01 02 02 03 Liabilities 153 177 181 200 153 177 181 200 Particulars 2016 % 2017 % 2018 % 2019 %6 SOURCES OF FUNDS Share capital 60 100 60 100 BO 133.33 Reserves and Surplus 63 100 77 122.22 51 80.95 Less: Preliminary Exp 3 100 -2 66.67 Owned funds 120 100 135 112.5 130 33.33 108.33 Debentures 10 100 20 200.00 20 200.00 Secured Loans 12 100 Borrowed funds 22 100 20 66.67 127,27 10 83.33 30 136.36 CAPITAL EMPLOYED 142 100 163 114.79 160 112.68 190 2303 28 8 133.33 95.24 0.00 140 116.67 300.00 166.67 227.27 133.80 ASSETS Fixed assets Building 50 100 Goodwill 50 100 45 Machinery 20 100 40 899 60 120.00 90.00 200.00 55 110.00 BO 160.00 40 80.00 40 80.00 43 215.00 sol 250.00 Working capital Current assets Cash 5 100 Stock 5 100 Debtors 20 100 (A) 00 100 Less: Current Rabilities Creditors 6 100 Bank OD 1 100 Other Liabilities 1 100 (B) B 100 Net working capital (A-8) 22 100 8888 88888 1 20.00 2 40.00 15 15 300.00 25 500.00 14 70.00 15 75.00 30 100.00 42 140.00 300.00 5 100.00 30 50.00 30 300.00 8 133.33 10 166.67 5 50.00 2 200.00 800.00 4 400.00 12 18 2 200.00 150.00 81.82 2 200.00 31 300.00 201 250.00 22 100.00 10 $25.00 20 90.91 APPLICATION OF FUNDS 142 100 163 114.79 160 112.68 190 133.80