Coal India Limited
Coal India Limited
Coal India Limited
Disclaimer: This model and the information contained within, is for educational purposes only and as
such should not be used to make any INVESTMENT decisions. EduPristine shall not be held liable for
any investment decision that the user may or may not take either basing on or taking hints from the
information provided here with. EduPristine also not guarantee accuracy of the model.
Contact Us:
[email protected]
www.edupristine.com/ca
EduPristine has created an integrated valuation model based on publically available information. It is available as an
open-source model for any user. Kindly note that this model is meant for information purpose only.
The complete structure of the model and formulas, linkages etc. have been kept open to allow for any modification
on the part of the user.
EduPristine conducts extensive trainings for financial modeling in MS Excel©. These trainings are targeted towards
investors/ professionals who are looking for a career in finance (Investment Banking, PE, Broking, Equity Research,
etc.). At the completion of the trainings, the participants should be able to create models like these.
EduPristine is India's largest authorized training provider for CFA®, FRM®, PRM and Financial Modeling. It has
conducted more than 300,000+ man-hours of finance trainings for individuals and corporates in all the major Indian
cities and outside India.
ommunity (both retail and
hem in a thorough
ng exercise.
ation. It is available as an
se only.
Management - EduPristine
21 21 21 21
10% 19% 15% 21% 21% 21% 21%
0% 0% 0% 0%
-34% -9% -44% 0% 0% 0% 0%
21
21%
4400%
17%
4400%
0%
4400%
12%
4400%
17%
4400%
4%
4400%
5%
4400%
2%
4400%
8%
4400%
5%
4400%
6%
4400%
-6%
0%
0%
4400%
46%
4400%
5%
4400%
0%
4400%
6%
15000%
150
300%
3%
4400%
109%
4400%
3%
Profit & Loss Statement
(Unless otherwise specified, all financials are in INR Million) FY06A FY07A
Income
Sales 287,018 296,022
Coal used for other purposes 20,540 19,405
Accretion(+)/Decretion(-) of stock 4,838 2,476
Other Income 27,691 32,152
Total 340,088 350,054
Expenditure
Internal consumption of coal 20,137 18,480
Consumption of Stores & Spares 38,888 41,256
Employees remuneration & Benefits 97,880 100,975
Power & Fuel 15,513 16,003
Social Overhead 13,677 14,780
Repairs 6,502 6,649
Contractual Expenses 19,745 20,934
Other Expenditure 13,281 12,640
Interest 909 849
Overburden removal adjustment 12,099 16,866
Finance Charges/Commitment Charges 283 232
Depreciation 13,154 13,116
Impairment 319 462
Provisions/Write off 445 1,169
Total Operating Costs 252,831 264,412
Appropriation
Transfer to Reserve for Foreign Exchange Transaction 31 138
Transfer to General reserve(Incl. Bond Redemption Reserve) 7,876 8,906
Transfer to CSR Reserve
Interim dividend 12,633 15,000
Tax on Dividend 4,756 5,344
Total Appropriations 25,297 29,388
67 70 73 73 73 73 73
8,897 9,339 12,671 17,430 22,274 27,720 35,591
1,592 - - - -
17,054 17,054 22,100 30,970 39,075 46,559 59,128
8,853 5,494 7,771 11,928 15,117 18,297 21,744
34,872 31,957 44,207 60,399 76,537 92,648 116,535
1,157,205
20,690
6,672
116,316
1,300,883
20,203
143,050
364,731
50,487
55,305
23,613
95,065
52,830
1,356
68,125
195
18,691
156
1,939
895,746
405,137
-
405,137
168,412
-
-
-
711
236,014
236,014
236,014
274,024
510,039
73
46,479
-
73,730
27,787
148,068
361,970
Balance Sheet
(Unless otherwise specified, all financials are in INR Million) FY06A FY07A
Fixed Assets
Gross Block 296,734 307,017
Less: Accumulated depreciation 177,916 199,310
Less: Provision for Impairment 15,520 3,777
Less: Other provisions - 5
Net Block 103,298 103,925
Add: Capital Work in Progress 10,988 12,377
Add: Surveyed off Assets 228 241
Total Fixed Assets 114,515 116,543
497,128
306,902
4,228
4
185,994
53,635
891
240,520
12,821
-
9,658
76,282
28,350
784,323
100,581
989,536
1,252,535
4,669
16,199
541,563
236
14,431
-
577,099
675,437
63,164
612,273
-
675,437
1.00
Valuation
Net Income
Add: Depreciation
Add: Interest*(1-Tax Rate)
Less: Fixed Capital Investment
Less: Working Capital Investment
Inventories
Sundry Debtors
Loans & Advances
Current liabilities & Provisions
Minority Interest
Shifting & Rehabilitation Fund
Free Cash Flow to firm
Less: Interest*(1-Tax Rate)
Add: Net Borrowing
Free Cash Flow to Equity
Terminal
FY11E FY12E FY13E FY14E FY15E
Beta---------->
299 0.8 0.82 0.84 0.86 0.88
2.0% 293 290 286 283 279
2.1% 296 292 288 285 282
2.2% 298 294 291 287 284
2.3% 301 297 293 289 286
2.4% 303 299 295 292 288
2.5% 306 302 298 294 290
2.6% 308 304 300 297 293
2.7% 311 307 303 299 295
2.8% 314 310 305 302 298
Terminal 2.9% 316 312 308 304 300
Growth 3.0% 319 315 311 307 303
Rate 3.1% 322 318 314 309 305
3.2% 325 321 316 312 308
3.3% 328 324 319 315 311
3.4% 331 327 322 318 313
3.5% 335 330 325 321 316
3.6% 338 333 328 324 319
3.7% 341 336 331 327 322
3.8% 345 340 335 330 325
3.9% 348 343 338 333 328
4.0% 352 346 341 336 332
a---------->
0.9 0.92 0.94 0.96 0.98 1
276 273 270 267 264 261
278 275 272 269 266 262
280 277 274 271 267 264
282 279 276 273 269 266
285 281 278 275 271 268
287 283 280 277 273 270
289 286 282 279 275 272
292 288 284 281 278 274
294 290 287 283 280 276
(Unless otherwise specified, all financials are in INR Million) FY06A FY07A
Cash Balance
Opening Cash Balance 134,272
Net Cashflow 25,020
Closing Cash Balance 159,293
1
FY08A FY09A FY10A FY11E FY12E FY13E FY14E FY15E
1 1 1 1 1 1 1 1
Reserves
(Unless otherwise specified, all financials are in INR Million) FY06A FY07A
(Unless otherwise specified, all financials are in INR Million) FY06A FY07A
Unsecured Loans
Opening Balance 20,713
Add: New Issued -
Less: Repayments (2,601)
Closing Balance 20,713 18,112
Secured Loans
Opening Balance 2,477
Add: New Issued 850
Less: Repayments -
Closing Balance 2,477 3,327
16,199
-
-
16,199
4,669
-
-
4,669
10,434
13%
1,356.45
Asset Schedule
(Unless otherwise specified, all financials are in INR Million) FY06A FY07A
The analysts who compiled this open source financial model hereby state that the contents in the document reflect
his/her/their views and opinions on the subject matter. Pristine, and its employees/ analysts do conduct trainings
and from time to time to seek establish business or financial relationships with companies covered in the open
research models. As a result, investors should be aware that Pristine and/or such individuals may have conflicts of
interests that could affect the objectivity of this report.
Pristine is India's largest authorized training provider for CFA®, FRM®, PRM and Financial Modeling. It has
conducted more than 300,000+ man-hours of finance trainings for individuals and corporates in all the major
Indian cities and outside India.
ken by Pristine and its
t of their knowledge
ing of the company
pleteness of such
missions there from.
Management - Pristine
Modeling. It has
es in all the major