Extract specific data from the balance sheet and create an excel/google doc or other spread. Im attaching a sample balance sheet if can you please segregate the following and create and easy to read format/template. Find out the following in the balance sheet. 1. Non current assets 2. Financials assets 3. Borrowings (LT & ST) 4. Details of other income.

also please explain do i need to study other details for this data or this is enough information in consolidated statements

Consolidated Balance Sheet (in crores) As at March 31, 2019 As at March 31, 2020 Notes 3 4 5 6 a 66 9 77,882.83 8.599.56 6,275.34 777.06 42.171.91 27,022.73 2,418.89 10 18 12 13 22 ASSETS (1) NON-CURRENT ASSETS a Property, plant and equipment (b Capital work-in-progress C Right of use assets (d Goodwill le Other intangible assets 16 Intangible assets under development 19 Investment in equity accounted investees (h) Financial assets: 0 Other investments ( Finance receivables ( Loans and advances liv Other financial assets Deferred tax assets (net) Non-current tax assets net Ik Other non-current assets 2) CURRENTASSETS (a) Inventories (b Investment in equity accounted investees held for sale) Ic Financial assets: 0 Other investments Trade receivables mi) Cash and cash equivalents iv) Bank balances other than in above V Finance receivables (vi) Loans and advances (vii) Other financial assets Id Current tax assets (net) le Assets classified as held-for-sale If Other current assets 18 1,028.05 16,833.77 782.78 4.749.57 5,457.90 1.152.05 5.381.57 2,02,534.01 37,456.88 20 72,619.86 8,538.17 74787 37.866.74 23.345.67 24.743.38 1,49751 22,073517 407.42 2.809.18 5.151 11 1,024.56 2.938.73 1,83,763.37 39,013.73 591.50 8,938 33 18,996 17 21.559.80 11,08902 11.55152 1.268.70 3.213.56 184 37 162 27 6.862 22 1,23,431.16 3,07,194.53 14 910) 11 15 16 17 18 12 13 10,861 54 11 172.69 18.467 80 15 259.17 14.245.30 935.25 4.586.48 14280 194.43 6.264.91 1,19,587.25 3,22,121.26 47@ 21 IL 23 23 24 79.54 62.358.99 63,078.53 813.56 63,892.09 679.22 59,500.34 60,179.56 523.06 60,702.62 TOTAL ASSETS EQUITY AND LIABILITIES EQUITY a) Equity share capital b) Other equity Equity attributable to owners of Tata Motors Ltd. Non-controlling interests LIABILITIES (1) NON-CURRENT LIABILITIES (a) Financial liabilities: 10 Borrowings Lease liabilities (iii) Other financial liabilities (b) Provisions Ic Deferred tax liabilities (net) dl Other non-current liabilities 26 28 30 22 31 83,315.62 5.162.94 3.858.48 14.736,69 194187 8.759.52 1,17,775.12 70,81750 156.17 2,792.71 11,854.85 1.49104 13.922 21 1,01,034.48 LULU assets 21 B.2019 1,19,587.25 3,22,121.26 0.00222 1,23,431.16 3,07,194.53 IL NN 719.54 62.358.99 63,078.53 813.56 63,892.09 679.22 59,500.34 60,179.56 523.06 60,702.62 26 TOTAL ASSETS EQUITY AND LIABILITIES EQUITY a Equity share capital b) Other equity Equity attributable to owners of Tata Motors Ltd. Non-controlling interests LIABILITIES (1) NON-CURRENT LIABILITIES (a) Financial liabilities: 10 Borrowings (ii) Lease liabilities (iii) Other financial liabilities (bProvisions c) Deferred tax liabilities (net) Id Other non-current liabilities (2) CURRENT LIABILITIES la Financial liabilities: 0 Borrowings di) Lease liabilities (1) Trade payables a) Total outstanding dues of micro and small enterprises (D) Total outstanding dues of creditors other than micro and small enterprises iv) Acceptances 28 30 22 31 83.315.62 5.162.94 3,858.48 14,736.69 194187 8.759.52 1,17,775.12 70,817.50 156.17 2,792.71 11,854.85 1,491.04 13,922 21 1,01,034.48 27 16 36253 814.18 20.150.26 1730 dere planeresial liabilities 29 30 (b) Provisions c Current tax liabilities (net) d Other current liabilities 109.75 63,517.13 2.771 33 36,544.00 10.329.04 1,040.14 8.965.95 1,40,454.05 3,22.121.26 130.69 68.382.84 3.177.14 32,838.35 10.196.75 1,017.64 9,546.46 1,45,457.43 3,07,194.53 32 TOTAL EQUITY AND LIABILITIES See accompanying notes to consolidated financial statements Notes Year ended March 31, 2020 Year ended March 31, 2019 33 2.58.594.36 2.473.61 2,61,067.97 2.973.15 2.64.041.12 2.99.190.59 2.747.81 3,01,938.40 2.965.31 3,04.903.71 34 1. 1111 IV. 35 36 1,52,968.74 1297.27 12,228.35 2.231.19 30.438.60 7.243.33 1,738.74 21.425.43 4.188.49 57,087.46 (17.503.40) 2.71.749.66 (7.708.54) 1.82.254.45 (1,245.37) 13,258.83 2,053.28 33.243.87 5.758.60 905.91 23.590.63 4.224.57 62,238.12 19.659.59 3,06.623.30 (1,719.59) 37 VA VI. 147.93 1,371.45 180.97 Revenue from operations (a) Revenue (D) Other Operating Revenues Total revenue from operations Other income (includes Government grants) Total Income (1) Expenses (a) Cost of materials consumed 102 Cost of materials consumed () Basis adjustment on hedge accounted derivatives (b Purchase of products for sale c Changes in inventories of finished goods, work-in-progress and products for sale d) Employee benefits expense le Finance costs Foreign exchange loss (net) Depreciation and amortisation expense th Product development/Engineering expenses 10 Other expenses Amount transferred to capital and other account otal Expenses (IV) Profit/Loss before exceptional items and tax (I-IV Exceptional Items (a) Defined benefit pension plan amendment past service cost (6) Employee separation cost c) Provision/write off/(reversal)(net) of impairment of capital work-in-progress and intangibles under development (net) (d) Provision for impairment of Passenger Vehicle Business le Provision for Onerous Contracts Provision/(reversal) for cost of closure of operation of a subsidary a) Provision for impairment in Jaguar Land Rover (h) Provision for impairment in subsidiaries 0 Profit on sale of investment in a subsidiary Company Provision for loan given to a Joint venture (6) Others Profit/Loss) before tax V-VI) Tax expense/ credit net: la) Current tax (including Minimum Alternate Tax) (b) Deferred tax Total tax expense/(credit (net) Profit/(loss for the year from continuing operations (VII-VIII) Share of profit/(Loss) of joint ventures and associates (net) Profit/loss) for the year (IX-X) Attributable to: (a) Shareholders of the Company (b) Non-controlling interests Other comprehensive income/loss): (A) 0 Items that will not be reclassified to profit or loss: (a) Remeasurement gains and losses) on defined benefit obligations (net) (b) Equity instruments at fair value through other comprehensive income (net) (c) Share of other comprehensive income in equity accounted investees (net) (d) Gains and losses) in cash flow hedges of forecast inventory purchases Income tax (expense)/credit relating to items that will not be reclassified to profit or loss (B) Items that will be reclassified to profit or loss: (a) Exchange differences in translating the financial statements of foreign operations 47 (c) 8 (a) 8. (b) 436.14 (73.04) 1.418.64 777.00 (65.62 17 476) 353.20 VI 22 25.12 (10,579.98) 1,893.05 (1.497.80) 395.25 (10,975 23) 1.000.00 (11.975.23) 381.01 27.837.91 (376.98) 109.27 (31,371.15) 2.225.23 14,662.68) 2.437.45) (28,933.70) 209.50 (28,724.20) (28,826.23 102.03 IX X XL 9 (12.070.85) 95.62 XII. 8.803.29 (132.99 (2.48) 695.39 (1.505.43) 2,233.22 (2.561 26) A 35.60 11.15 (1.746.24G 697.41 (2.010.22) for