valuation of jag2
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
weather.comJaguar Mining
2
20082009201020112012201320142015TERMINAL
3
PRODUCTION GROWTH20.00%45.00%45.00%18.00%66.00%33.00%30.00%20.00%1.00%
4
GOLD PRICE (E)$875$1,099$1,200$1,800$1,800$1,800$1,800$1,800$1,800
5
PRODUCTION 46140140165192255320304307
6
COGP$420$560$560$800$750$750$750$750$750
7
GROSS REVENUE$20,930$75,460$89,600$165,200$201,600$268,128$336,000$319,200$322,392
8
EBIT$20,302$73,196$86,912$160,244$195,552$260,084$325,920$309,624$312,720
9
EBT$14,662$67,556$81,272$154,604$189,912$254,444$320,280$303,984$307,080
10
EAT(30% Effective Rate)$10,263$47,289$56,890$108,223$132,938$178,111$224,196$212,789$214,956
11
REINVESTMENT-$500,000-$75,000-$110,000-$95,000-$160,000-$85,000-$55,000-$50,000-$40,000
12
FCF-$489,737$122,289$166,890$203,223$292,938$263,111$279,196$262,789$254,956
13
DISCOUNT RATE20.00%
14
NPV-$408,114$101,908$115,896$117,606$141,270$105,738$93,502$73,340$449,391
15
16
SENSITIVITY ANALYSIS (DISCOUNT RATE & LONG TERM GOLD PRICE)
17
VALUATION$10.47$1,200$1,400$1,600$1,800$2,000$2,250
18
LTD141,0008.00%$96.38$109.81$123.23$136.66$150.09$166.87
19
CASH+M/S400009.00%$84.02$94.81$105.60$116.39$127.18$140.66
20
SHARES OUTSTANDING84,00010.00%$74.57$83.43$92.28$101.14$110.00$121.07
21
VALUE OF FIRM$980,84711.00%$67.08$74.47$81.86$89.25$96.64$105.87
22
VALUE OF EQUITY$879,84712.00%$60.97$67.21$73.46$79.70$85.95$93.76
23
VALUE OF EQUITY PER SHARES$10.4714.00%$51.55$56.14$60.74$65.34$69.94$75.69
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
Sheet4