BALANCE SHEET OF ABC LTD ABC Ltd. Rs. Crore(1) Dec-06 Dec-07 12mths 12mths Dec-08 12mths Dec-09 12mths Dec-10 12mths Dec-11 12mths Gross fixed assets Land & building Plant & machinery Other fixed assets Capital WIP Less: cumulative depreciation Net fixed assets Revalued assets Investments In group/associate cos. In mutual funds Other investments Marketable investment Market value of quoted investment Deferred tax assets Inventories Raw materials and stores Raw materials Stores and spares Finished and semi-finished goods Finished goods Semi-finished goods Other stock Receivables Sundry debtors Debtors exceeding six months Accrued income Advances/loans to corporate bodies Group/associate cos. Other cos. Deposits with govt./agencies Advance payment of tax Other receivables Cash & bank balance Cash in hand Bank balance Intangible assets (not written off) Intangible assets (goodwill, etc.) Total Assets 1047.9 223.7 628 102.4 93.8 326.4 721.5 0.6 328.6 191.8 2.7 134.1 76.3 215.3 0 903.4 389.8 366.3 23.5 514.1 470 44.1 1122.8 278.3 636.5 120.9 87.1 328.8 794 0.6 544.5 253.6 77.7 213.2 183.5 573.7 0 1044.6 484.2 455.6 28.6 560.4 521.2 39.2 0 582.11 145.4 22.8 8.3 56.1 56.1 o 33.5 0.01 338.8 574.5 1364.4 347.91 762.28 163.84 90.37 400.1 964.3 0.6 729.51 296.46 77.67 355.38 370.5 645.14 0 1145.68 560.06 534.78 25.28 585.62 548.63 36.99 0 803.16 192.94 14.63 13.68 144.07 144.07 0 35.62 0 416.85 659.88 1.59 658.29 89.47 89.47 4392 1454.1 385.6 779.6 185 103.9 447.1 1007.1 0.6 1068 299.1 80.8 688.1 523.8 863.2 0 1309.8 593.4 565.1 28.3 716.4 673.8 42.6 0 860.4 233.7 10.7 27.4 51.7 51.7 0 42.2 0 505.4 810.3 5.47 804.9 80 80 5135.6 1669.6 425.3 877.6 237.1 129.6 511.5 1158.2 0.6 1832.1 440.3 104.8 1287 935.6 969.9 0 1181.8 539.2 514.6 24.6 638.9 589.7 49.2 3.78 1054.8 264.5 7.6 46.4 291.6 76.8 0 37.7 0 414.6 522 1.47 520.6 47.3 47.3 5796.2 1889.45 504.97 1013.71 260.24 110.53 586.9 1302.55 0.6 1668.93 352.6 504.42 811.91 586.83 593.85 349.61 1240.05 597.12 568.31 28.81 635.71 587.99 47.72 7.22 1268.7 424.79 7.82 45.75 214.85 74.85 0 45.73 0 537.58 913.15 1.41 911.74 22.38 22.38 6765.37 720.8 143.5 30.3 9.3 30.6 30.6 0 16.8 0 520.6 203.3 1.3 202.8 2.5 572 0 0 3539.71 2878.1 Dec-08 12mths 1713.03 225 219.57 219.57 0 1493.46 1459.4 178 Dec-09 Dec-10 Dec 11 12mths 12mths 12mths 2102.5 2488 3043.69 225 225 225 219.5 220 220.12 219.5 220 220.12 0 0 0 1883 2268 2823.57 1861.7 2249.4 2802.64 194.9 1949 263.26 1666.3 2054.5 2539.38 20.7 18 20.26 0.6 0.6 0.67 0 0 177.2 111.5 83.73 110.9 55.5 24.7 110.9 55.5 24.7 0 0 0.2 0.6 0 0 0 0 0 0 0 0 0 ABC Ltd. Rs. Crore Networth Authorized capital Issued capital Paid-up equity capital 1) Preference capital Reserves & surplus Free Reserves Share premium reserves Other free reserves Specific reserves Revaluation reserves Accumulated losses Borrowings Bank borrowing Short-term bank borrowings Long-term bank borrowings Financial institutional borrowings Govt./sales tax deferral borrowings Debentures/bonds Fixed deposits Borrowings from corporate bodies Commercial paper Other borrowings Secured borrowings Unsecured borrowings Current portion of long term debe Total foreign currency borrowings Deferred tax liabilities Current liabilities & provisions Current liabilities Sundry creditors Interest accrued/due Creditors for capital goods Other current liabilities Share application money Advance against WIP Provisions Tax provision Dividend provision Dividend tax provision Other provisions Total liabilities Contingent liabilities Bills discounted Disputed taxes Letters of credit Total guarantees Future lease rent payable Liabilities on capital account Dec-06 Dec-07 12mths 12mths 938.1 1261.2 225 225 145.8 199.1 145.8 199.1 0 0 792.37 1062.1 761.8 1030.5 46 121.2 715.8 909.3 29.9 31 0.6 0 260 186.4 35.1 3.2 31.2 3.2 3.9 12.2 8 0 18.6 18.5 91.3 87.3 1.5 15 0 86.3 69.4 96.4 65.7 163.6 120.7 22.6 4.1 0 0 0 0 1680 2092.11 1438 1673.61 1142.3 1596.01 15.4 17.8 0 0 280.3 59.8 0 0 0 242 418.5 26.4 71.8 129.4 199.2 0 862 157.5 2878.1 3539.71 0 0 56 69.2 1281.4 33.39 0.6 0 264.31 90.57 90.57 0 4.11 0 17.78 86.72 0 0 65.13 146.75 117.56 2.79 0 0 2414.66 1858.02 1787.36 16.5 0 54.16 0 0 556.64 40.2 272 27 0 244.17 4392 11 0 5.2 0 0 60.9 1413 359 2.3 0 0 2855.9 21434 2001.4 7.5 0 54.5 0 0 3196.7 2233.9 2163.3 5.3 0 653 59.03 43.04 40.69 3.33 0 103.13 3534.82 2410.42 2347.19 2.63 0 60.6 0 7.09 1124.4 51.89 550.31 0 5222 6765.37 230.9 712.5 49 3746 3 962.8 172.2 440.1 0 350.5 5796.2 0 288 5135.6 30.4 0.00 0.00 59.3 0.00 39.2 41.4 0.00 0.00 55.3 0.00 49.0 30.83 0.00 0.00 57.37 0.00 39.09 31.9 0.00 0.00 12.00 0.00 0.00 99.5 0.00 0.00 49.6 0.00 0.00 74.65 0.00 0.00 0.00 0.00 0.00 INCOME STATEMENT OF ABC LTD Dec ABC Ltd. Rs. Crore Dec Dec-98 Dec-99 Dec-00 Dec-01 96 97 12mths 12mths 12mths 12mths 12mths 12mths 7137.8 8363.3 10261.57 10978.3 11458.3 11861.77 106.7 165.2 183.93 269.3 305.9 283.14 15.2 46.4 -7.9 128.52 -83.85 -4.63 137.8 50.4 47.15 14.4 47.8 310.93 4533.4 5201.9 6158.31 6548.4 6388.8 6381.54 385 448.7 527.23 584.1 614.3 591.7 105.8 110.8 118.43 123.1 139.9 152.77 577.1 626.5 835.44 861.8 870.1 920.66 283 490.6 676.86 746.5 709.2 835.75 279.2 289.1 345.77 366.2 446 465.86 386.6 474.9 544.02 596.9 712.4 761.8 139.9 54 49.43 20.4 20.7 146.01 Income Other income Change in stocks Non-recurring income Expenditure Raw materials, stores, etc. Wages & salaries Energy (power & fuel) Indirect taxes (excise, etc. Advertising & marketing expenses Distribution expenses Others Non-recurring expenses Profits/losses paDIT Financial charges (incl. Lease rent) PBDT Depreciation PBT Tax provision PAT Appropriation of profits Dividends Equity dividend Dividend tax Retained earnings 707.5 928.8 57 33.8 650.5 895 55.2 57.9 595.3 837.1 192.55 270 402.8 567.1 1229.4 1543.1 1826.8 2195.13 29.28 22.3 13.1 7.74 1200.2 1520.8 1813.7 2187.39 101.05 128.7 130.9 144.66 1099.2 1392.1 1682.8 2042.73 293 318 355 402.42 806.2 1074.1 1327..8 1640.31 261.9 372.44 531.35 711.09942.3 1158.31 249 338.5 463.46 638.1 770.2 1100.62 12.9 33.9 67.9 72.9 172.1 57.69 140.9 194.7 274.9 363.1 385.5 482 You are required to calculate for the three first years (2007-2008-2009) the; 1. Liquidity Ratios. 2. Activity Ratios. 3. Profitability Ratios. 4. Return on Assets (ROA) 5. Financial Ratios