Welcome to the San Gold HUB on AGORACOM

San Gold Corporation - one of Canada's most exciting new exploration companies and gold producers.

Free
Message: Re: NPV Calculation
7
Jul 04, 2008 06:04PM

Re: NPV Calculation

posted on Jul 05, 2008 05:30AM

Someone on the other board asked how I do these calculations. I'm repeating my answer here, in the interests of transparency:

(cash flow in a given year) = (value of production) - (production costs) - (refining costs)

To bring the cash flow from year 'n' (that is a year 'n' years in the future) to the present time, discount it at the rate you choose:

(cash flow)/(1+rate)^n

Lay it all out on a spreadsheet. Add up the value of the years and you have a NPV estimate of the market cap. Divide by the number of shares, fully diluted of course, and you have your NPV estimate of the share price.

You can get more sophisticated, varying cash flows, rates, inflation, estimated borrowing costs, etc., but I think this fairly simple method can go a long way to telling you what a company is worth, complete with the level of risk you want to assign to the investment. I certainly like it better than $/oz in the ground, or multiples of present cash flow.

The beauty of spreadsheets, Slug, is that they make it easy to answer your question. Just pop in the numbers, and:

0.5 oz/t, $662 Gold:

$4.02/share 10% DR

$5.82/share 7% DR

$7.73/share 5% DR

0.5 oz/t, $934Gold:

$6.55/share 10% DR

$9.40/share 7% DR

$12.42/share 5% DR

0.6 oz/t, $662 Gold:

$5.25/share 10% DR

$7.56/share 7% DR

$10.01/share 5% DR

0.6 oz/t, $934 Gold:

$8.28/share 10% DR

$11.85/share 7% DR

$15.64/share 5% DR

Clearly, grades have as significant a role in the profitability as the POG. We can have some more fun with the sheet, too. Let's say that in 2017, they upgrade the milling capacity to 2,400 t/d at a cost of $10M. What then? Well, production would increase to ~333,000 oz/y at a cost of around $236/oz. This then results in estimated NPV's of:

0.4 oz/t, $662 Gold:

$3.31/share 10% DR

$4.95/share 7% DR

$6.71/share 5% DR

0.4 oz/t, $934 Gold:

$5.67/share 10% DR

$8.38/share 7% DR

$11.29/share 5% DR

Up the grades, and you then get:

0.6 oz/t, $662 Gold:

$6.18/share 10% DR

$9.11/share 7% DR

$12.27/share 5% DR

0.6 oz/t, $934 Gold:

$9.72/share 10% DR

$14.26/share 7% DR

$19.14/share 5% DR


Lots of blue sky here, and you don't have to stray that far from the highly probable to see it.

D.

8
Jul 05, 2008 09:46AM

Jul 05, 2008 10:56AM
2
Jul 05, 2008 01:17PM

Jul 05, 2008 04:34PM
5
Jul 05, 2008 04:58PM

Jul 05, 2008 05:25PM

Jul 05, 2008 06:38PM
1
Jul 07, 2008 06:12AM
3
Jul 07, 2008 08:26AM
Share
New Message
Please login to post a reply