Coeur d'lene Mines
Comments
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
|
 
Still loading...
ABCDEFGHIJKLM
1
Coeur d'lene mines
2
20082009201020112012201320142015TERMINAL
3
PRODUCTION GROWTH20.00%75.00%18.00%25.00%5.00%3.00%2.00%0.00%1.00%
4
SILVER PRICE (E)$16$15$21$44$44$44$44$44$20
5
PRODUCTION 17,12629,97135,36544,20646,41747,80948,76648,76649,253
6
COGP$7$7$7$6$6$6$6$6$8
7
GROSS REVENUE$154,134$247,257$512,795$1,679,847$1,763,839$1,816,754$1,853,089$1,853,089$591,038
8
EBIT$138,721$222,531$461,516$1,511,862$1,587,455$1,635,079$1,667,780$1,667,780$531,934
9
EBT$125,401$209,211$448,196$1,498,542$1,574,135$1,621,759$1,654,460$1,654,460$518,614
10
EAT$87,780$146,448$313,737$1,048,979$1,101,894$1,135,231$1,158,122$1,158,122$363,030
11
REINVESTMENT-$65,000-$75,000-$110,000-$20,000-$20,000-$25,000-$25,000-$30,000-$35,000
12
FCF$22,780$221,448$423,737$1,068,979$1,121,894$1,160,231$1,183,122$1,188,122$398,030
13
DISCOUNT RATE15.00%
14
NPV$19,809$192,563$320,406$702,871$641,447$576,840$511,496$446,659$1,068,816
15
16
SENSITIVITY ANALYSIS (DISCOUNT RATE & LONG TERM GOLD PRICE)
17
VALUATION$55.57$16$18$20$22$25$28
18
LTD333,0008.00%$67.55$73.77$80.00$86.23$95.57$104.91
19
CASH+M/S4500010.00%$55.44$59.70$63.96$68.22$74.61$81.00
20
SHARES OUTSTANDING75,10012.00%$47.16$50.23$53.31$56.38$60.99$65.59
21
VALUE OF FIRM$4,461,09814.00%$41.02$43.32$45.61$47.91$51.35$54.80
22
VALUE OF EQUITY$4,173,09816.00%$36.22$37.98$39.74$41.50$44.15$46.79
23
VALUE OF EQUITY PER SHARES$55.5718.00%$32.32$33.70$35.08$36.46$38.53$40.60
24
25
26
Production includes conversion from Gold to Silver at a 60:1 ratio. For example in 2010 they will produce 155k/oz of gold so the numbers aren't as high as they appear.
27
28
29
30
31
32
33
34
35
36
37
38
39
Loading...
 
 
 
Sheet3
Sheet4