






Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
Financial modeling using Microsoft excel to analyse financial models
Typology: Assignments
1 / 11
This page cannot be seen from the preview
Don't miss anything!
Mar-20 Mar- EQUITIES AND LIABILITIES SHAREHOLDER'S FUNDS Equity Share Capital 719.54 679. TOTAL SHARE CAPITAL 719.54 679. Reserves and Surplus 16,800.61 21,483. TOTAL RESERVES AND SURPLUS 16,800.61 21,483. TOTAL SHAREHOLDERS FUNDS 18,387.65 22,162. NON-CURRENT LIABILITIES Long Term Borrowings 14,776.51 13,914. Deferred Tax Liabilities [Net] 198.59 205. Other Long Term Liabilities 1,646.56 404. Long Term Provisions 1,769.74 1,281. TOTAL NON-CURRENT LIABILITIES 18,391.40 15,806. CURRENT LIABILITIES Short Term Borrowings 6,121.36 3,617. Trade Payables 8,102.25 10,408. Other Current Liabilities 10,180.46 7,765. Short Term Provisions 1,406.75 1,148. TOTAL CURRENT LIABILITIES 25,810.82 22,940. TOTAL CAPITAL AND LIABILITIES 62,589.87 60,909. ASSETS NON-CURRENT ASSETS Tangible Assets 19,540.25 18,316. Intangible Assets 5,667.73 3,970. Capital Work-In-Progress 1,755.51 2,146. Other Assets 0 0 FIXED ASSETS 29,702.78 28,573. Non-Current Investments 15,730.86 15,434. Deferred Tax Assets [Net] 0 0 Long Term Loans And Advances 138.46 143. Other Non-Current Assets 3,449.01 3,529. TOTAL NON-CURRENT ASSETS 49,021.11 47,680. CURRENT ASSETS Current Investments 885.31 1,433. Inventories 3,831.92 4,662. Trade Receivables 1,978.06 3,250. BALANCE SHEET OF TATA MOTORS (in Rs. Cr.)
Mar-20 Mar-19 Mar- 12 mths 12 mths 12 mths INCOME 43,485.76 68,764.88 58,234. 0 0 793. 43,485.76 68,764.88 57,441. 43,928.17 69,202.76 58,831. Other Income 1,383.05 2,554.66 1,557. TOTAL REVENUE 45,311.22 71,757.42 60,389. EXPENSES Cost Of Materials Consumed 26,171.85 43,748.77 37,080. Operating And Direct Expenses 830.24 571.76 474. 722.68 144.69 842. Employee Benefit Expenses 4,384.31 4,273.10 3,966. Finance Costs 1,973.00 1,793.57 1,744. 3,375.29 3,098.64 3,101. Other Expenses 7,959.75 9,895.68 9,251. TOTAL EXPENSES 49,927.64 69,155.42 60,369. -4,616.42 2,602.00 19. Exceptional Items -2,510.92 -203.07 -966. PROFIT/LOSS BEFORE TAX -7,127.34 2,398.93 -946. Current Tax 33.05 294.66 92. Less: MAT Credit Entitlement 0 0 0 Deferred Tax 129.24 83.67 -4. Tax For Earlier Years 0 0 0 TOTAL TAX EXPENSES 162.29 378.33 87. -7,289.63 2,020.60 -1,034.
TATA MOTORS (in Rs. Cr.) REVENUE FROM OPERATIONS [GROSS] Less: Excise/Sevice Tax/Other Levies REVENUE FROM OPERATIONS [NET] TOTAL OPERATING REVENUES Changes In Inventories Of FG,WIP And Stock-In Trade Depreciation And Amortisation Expenses PROFIT/LOSS BEFORE EXCEPTIONAL, EXTRAORDINARY ITEMS AND TAX TAX EXPENSES-CONTINUED OPERATIONS PROFIT/LOSS AFTER TAX AND BEFORE EXTRAORDINARY ITEMS
Very Low Very Low Very Low Very Low 0.377238692920256 0.373452375918723 0.384060002601269 0. Low Liquidity Low Liquidity Low Liquidity Low Liquidity 2.40390805785405 1.74831697839415 1.93551924596623 1. Greater Risks Within Safety Margin Within Safety Margin Within Safety Margin 0.293839881757224 0.259504121105316 0.250325861349753 0. Good Good Good Good 0.136849197352118 0.056955704702668 0.032842877168498 0. Low Liquidity Low Liquidity Low Liquidity Low Liquidity -12,242.06 -9,711.51 -9,247.29 -8,781. Low Working Capital Low Working Capital Low Working Capital Low Working Capital 0.4999490198904 0.583703154325049 0.576423234700307 0. Low ROI Low ROI Low ROI Low ROI 0.293779967908545 0.363859048232603 0.340655235483168 0. High use of Debts High use of Debts High use of Debts High use of Debts 0.694773131818296 1.12896564960253 0.970086451632516 0. Low Returns Low Returns Low Returns Low Returns 0.887082320249378 1.44220646123884 1.29837746470214 0. Low Returns High Returns to Asset High Returns to Asset Low Returns -16.7632576733165 2.93841856482553 -1.80158614788553 -5.
Very Low
Low Liquidity
Within Safety Margin
Good
Low Liquidity -6,840. Low Working Capital
Low ROI
High use of Debts
Low Returns
Low Returns -0.