CEAT Tyres Analysis.xlsx - Taking CEAT Tyres as our company...

Mar-21 Mar-20 Mar-19 Mar-18 Mar-17
12 mths 12 mths 12 mths 12 mths 12 mths
EQUITIES AND LIABILITIES
SHAREHOLDER'S FUNDS
Equity Share Capital 40.45 40.45 40.45 40.45 40.45
Total Share Capital 40.45 40.45 40.45 40.45 40.45
Reserves and Surplus 3,124.29 2,886.95 2,710.59 2,506.37 2,265.70
Total Reserves and Surplus 3,124.29 2,886.95 2,710.59 2,506.37 2,265.70
Total Shareholders Funds 3,164.74 2,927.40 2,751.04 2,546.82 2,306.15
NON-CURRENT LIABILITIES
Long Term Borrowings 1,341.04 1,401.99 1,002.72 272.3 703.51
Deferred Tax Liabilities [Net] 265.6 261.11 207.71 178.15 134.59
Other Long Term Liabilities 79.57 164.47 4.61 12.91 27.16
Long Term Provisions 44.94 38.19 36.83 33.8 34.18
Total Non-Current Liabilities 1,731.15 1,865.76 1,251.87 497.16 899.44
CURRENT LIABILITIES
Short Term Borrowings 0.53 165.59 214.31 143.64 57.99
Trade Payables 1,943.60 1,171.37 1,033.93 848.54 749.58
Other Current Liabilities 957.42 693.25 710.86 694.19 475.44
Short Term Provisions 107.58 121.65 99.85 50.14 54.6
Total Current Liabilities 3,009.13 2,151.86 2,058.95 1,736.51 1,337.61
Total Capital And Liabilities 7,905.02 6,945.02 6,061.86 4,780.49 4,543.20
ASSETS
NON-CURRENT ASSETS
Tangible Assets 5,491.06 3,736.88 2,785.74 2,409.81 2,340.62
Intangible Assets 0 83.59 60.57 65.44 68.25
Capital Work-In-Progress 0 916.86 718.89 161.86 48.77
Intangible Assets Under Developmen 0 16.92 30.55 0 0
Fixed Assets 5,491.06 4,754.25 3,595.75 2,637.11 2,457.64
Non-Current Investments 118.11 320.22 313.01 279.99 194.39
Long Term Loans And Advances 7.57 4.73 4.08 3.04 1.95
Other Non-Current Assets 104.2 70.4 184.34 112.27 65.65
Total Non-Current Assets 5,720.94 5,149.60 4,097.18 3,032.41 2,719.63
CURRENT ASSETS
Current Investments 0 0 0 40.06 64.27
Inventories 1,112.50 879.5 965.15 754.96 923.44
Trade Receivables 922.26 704.66 726.46 712.15 592.05
Cash And Cash Equivalents 25.51 26.59 59.74 73.01 17.47
Short Term Loans And Advances 0 50.32 58 49.02 50.02
Other Current Assets 123.81 134.35 155.33 118.88 176.32
Total Current Assets 2,184.08 1,795.42 1,964.68 1,748.08 1,823.57
Taking CEAT Tyres as our company for anal
Standalone Balance Sheet - CEAT TYRES (In Crores)

Total Assets 7,905.02 6,945.02 6,061.86 4,780.49 4,543.20

Mar-21 Mar-20 Mar-19
12 mths 12 mths 12 mths
INCOME
Revenue From Operations [Gross] 7,572.79 6,518.57 6,800.06
Less: Excise/Sevice Tax/Other Levies 0 0 0
Revenue From Operations [Net] 7,572.79 6,518.57 6,800.06
Other Operating Revenues 0 62.54 31.24
Total Operating Revenues 7,572.79 6,581.11 6,831.30
Other Income 31.8 41.34 55.3
Total Revenue 7,604.59 6,622.45 6,886.60
EXPENSES
Cost Of Materials Consumed 4,173.76 3,815.97 4,273.64
Purchase Of Stock-In Trade 10.09 21.2 60.92
Changes In Inventories Of FG,WIP And Stock-In Trade 67.43 14.58 -194.25
Employee Benefit Expenses 667.13 500.54 491.95
Finance Costs 173.05 122.96 64.52
Depreciation And Amortisation Expenses 339.58 255.4 174.3
Other Expenses 1,680.59 1,523.52 1,561.51
Total Expenses 7,111.63 6,254.17 6,432.59
Profit/Loss Before Exceptional, ExtraOrdinary Items And Tax 492.96 368.28 454.01
Exceptional Items -34.06 -29.75 -44.24
Profit/Loss Before Tax 458.9 338.53 409.77
Tax Expenses-Continued Operations
Current Tax 45.26 74.01 90.09
Deferred Tax 0 -6.24 30.77
Total Tax Expenses 45.26 67.77 120.86
Profit/loss after tax and before extra ordinary items 413.64 270.76 288.91
Profit/Loss from continuing operations 413.64 270.76 288.91
Profit/Loss for the Period 413.64 270.76 288.91
lysis, following are the Balance Sheet and Income Statement for the past 5 years.
Standalone Income Statement - CEAT TYRES (In Crores)

Mar-18 Mar-17
12 mths 12 mths
6,244.28 6,333.04
168.91 674.79
6,075.37 5,658.25
85.97 43.48
6,161.34 5,701.73
56.81 41.46
6,218.15 5,743.19
3,650.33 3,308.88
59.88 142.55
93.32 -76.15
413.11 383.85
86.45 79.47
161.68 142.01
1,317.32 1,282.60
5,782.09 5,263.21
436.06 479.98
-26.4 -13.33
409.66 466.65
104.08 114.45
26.86 -10.53
130.94 103.92
278.72 362.73
278.72 362.73
278.72 362.73

*Standalone Balance Sheet for CEAT TYRE
Mar-21 Mar-20 CHANGE %
12 mths 12 mths
EQUITIES AND LIABILITIES
SHAREHOLDER'S FUNDS
Equity Share Capital 40.45 40.45 0
Total Share Capital 40.45 40.45 0 to the curr
Reserves and Surplus 3,124.29 2,886.95 8.2211330297
Total Reserves and Surplus 3,124.29 2,886.95 8.2211330297
Total Shareholders Funds 3,164.74 2,927.40 8.1075356972
NON-CURRENT LIABILITIES
Long Term Borrowings 1,341.04 1,401.99 -4.3473919215
Deferred Tax Liabilities [Net] 265.6 261.11 1.7195817855
Other Long Term Liabilities 79.57 164.47 -51.620356296
Long Term Provisions 44.94 38.19 17.674783975
Total Non-Current Liabilities 1,731.15 1,865.76 -7.2147543092
CURRENT LIABILITIES repay these
Short Term Borrowings 0.53 165.59 -99.679932363
Trade Payables 1,943.60 1,171.37 65.925369439
Other Current Liabilities 957.42 693.25 38.106022358
Short Term Provisions 107.58 121.65 -11.565967941
Total Current Liabilities 3,009.13 2,151.86 39.838558271
Total Capital And Liabilities 7,905.02 6,945.02 13.822854362
ASSETS
NON-CURRENT ASSETS
Tangible Assets 5,491.06 3,736.88 46.942369035
Intangible Assets 0 83.59 -100
Capital Work-In-Progress 0 916.86 -100
Intangible Assets Under Developmen 0 16.92 -100
Fixed Assets 5,491.06 4,754.25 15.497922911
Non-Current Investments 118.11 320.22 -63.115982762
Long Term Loans And Advances 7.57 4.73 60.042283298
Other Non-Current Assets 104.2 70.4 48.011363636
Total Non-Current Assets 5,720.94 5,149.60 11.094842318
CURRENT ASSETS
Current Investments 0 0 0
Inventories 1,112.50 879.5 26.492325185
Trade Receivables 922.26 704.66 30.880140777
Cash And Cash Equivalents 25.51 26.59 -4.0616773223
Short Term Loans And Advances 0 50.32 -100
Other Current Assets 123.81 134.35 -7.8451804987
Total Current Assets 2,184.08 1,795.42 21.647302581
Total Assets 7,905.02 6,945.02 13.822854362
HORIZONTAL/COMP
Horizontal
there was a
While non
The capital
There has b
Inventories
Equity shar
There has b
Long term