aem model
Comments
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Still loading...
ABCDEFGHIJKL
1
AGNICO_EAGLE MINES
2
20082009201020112012201320142015TERMINAL
3
PRODUCTION GROWTH20.00%120.00%140.00%20.00%17.00%12.00%12.00%12.00%3.20%
4
GOLD PRICE$875$950$1,400$2,000$2,750$2,200$1,700$1,500$1,100
5
PRODUCTION 2705941,4261,7112,0022,2422,5112,8122,902
6
COGP$400$380$355$375$390$410$425$440$520
7
GROSS REVENUE$128,250$338,580$1,489,752$2,779,920$4,723,640$4,012,692$3,201,187$2,980,744$1,683,164
8
EBIT$124,403$328,423$1,445,059$2,696,522$4,581,931$3,892,311$3,105,151$2,891,322$1,632,670
9
EBT$107,803$311,823$1,428,459$2,679,922$4,565,331$3,875,711$3,088,551$2,874,722$1,616,070
10
EAT$75,462$218,276$999,922$1,875,946$3,195,732$2,712,998$2,161,986$2,012,305$1,131,249
11
REINVESTMENT-$500,000-$557,000-$218,000-$125,000-$100,000-$80,000-$70,000-$50,000-$75,000
12
FCF-$424,538$775,276$1,217,922$2,000,946$3,295,732$2,792,998$2,231,986$2,062,305$1,206,249
13
DISCOUNT RATE9.00%
14
NPV-$389,485$711,262$1,025,100$1,545,097$2,334,779$1,815,257$1,330,860$1,128,152$11,376,885
15
16
SENSITIVITY ANALYSIS (DISCOUNT RATE & LONG TERM GOLD PRICE)
17
VALUATION$135.87$1,200$1,400$1,600$1,800$2,000$2,250
18
LTD415,0008.00%$178.71$206.25$233.78$261.31$288.85$323.27
19
CASH+M/S2080009.00%$153.87$175.38$196.90$218.41$239.92$266.81
20
SHARES OUTSTANDING155,00010.00%$135.67$152.97$170.27$187.56$204.86$226.48
21
VALUE OF FIRM$21,267,39311.00%$121.66$135.86$150.07$164.27$178.48$196.24
22
VALUE OF EQUITY$21,060,39312.00%$110.46$122.32$134.18$146.04$157.90$172.72
23
VALUE OF EQUITY PER SHARES$135.8714.00%$93.53$102.10$110.67$119.24$127.82$138.53
24
25
26
THIS VALUATION DOES NOT PLACE ANY VALUE ON THE ADDITIONAL RESERVES OR RESOURCES
27
28
29
30
31
32
33
34
35
36
37
38
39
Loading...
 
 
 
Sheet3