Difference between revisions of "Project Evaluation Methods"

From QueensMineDesignWiki
Jump to: navigation, search
(References)
(References)
 
(20 intermediate revisions by 3 users not shown)
Line 1: Line 1:
NOT A FINAL PRODUCT. DON’T JUDGE
 
 
 
= <br>Current Industry Methods =
 
= <br>Current Industry Methods =
   
 
All mining is performed for profit. Since there are many possible ways to mine a deposit and many deposits to chose from, one must be able to select the best deposit and the most efficient mining techniques, for the deposit that are available. For investors, this problem is compounded by the numerous mining companies to choose from. A measure must be used that can be applied to all projects of varying scope and design so that they may be compared. Given the variability in the type, length and cost of mining projects, different measures may favor different projects; therefore the measure to use is not always clear. Table 1 displays the results of a survey in 2002 of the Chief Financial Officers of Fortune 1000 companies, outlining the use of different methods to measure value.
 
All mining is performed for profit. Since there are many possible ways to mine a deposit and many deposits to chose from, one must be able to select the best deposit and the most efficient mining techniques, for the deposit that are available. For investors, this problem is compounded by the numerous mining companies to choose from. A measure must be used that can be applied to all projects of varying scope and design so that they may be compared. Given the variability in the type, length and cost of mining projects, different measures may favor different projects; therefore the measure to use is not always clear. Table 1 displays the results of a survey in 2002 of the Chief Financial Officers of Fortune 1000 companies, outlining the use of different methods to measure value.
   
<center>[[Image:Capital budget tools.jpg|center|774x437px|Table 1: The use of diffrent valuation methods by CFO's of Furtune 1000 companies]]Table 1: The use of diffrent valuation methods by CFO's of Furtune 1000 companies<ref>Ryan, P. A. &amp; Ryan, G. P. (2002). Capital Budgeting Practices of the Fortune 1000: How Have Things Changed? Journal of Business and Management , Volume 8, Number 4, Winter.</ref></center>
+
<center>[[Image:Capital budget tools.jpg|center|774x437px|Table 1: The use of different valuation methods by CFO's of Fortune 1000 companies]]Table 1: The use of different valuation methods by CFO's of Fortune 1000 companies<ref>Ryan, P. A. &amp; Ryan, G. P. (2002). Capital Budgeting Practices of the Fortune 1000: How Have Things Changed? Journal of Business and Management , Volume 8, Number 4, Winter.</ref></center>
 
<br>
 
<br>
   
There is a good consensus formed on methods such as Net Present Value (NPV)link and Internal Rate of Return (IRR)link with other tools being used regularly. On top of the basic methods there are supplemental tools shown in table 2.
+
There is a good consensus formed on methods such as <span class="plainlinks">[http://queensminedesign.miningexcellence.ca/index.php/Project_Evaluation_Methods#Net_Present_Value_.28NPV.29 Net Present Value (NPV)]</span> and <span class="plainlinks">[http://queensminedesign.miningexcellence.ca/index.php/Project_Evaluation_Methods#Internal_Rate_of_Return_.28IRR.29 Internal rate of Return (IRR)]</span> with other tools being used regularly. On top of the basic methods there are supplemental tools shown in table 2.
   
<center>[[Image:Supplemental capital budgeting tools.jpg|center|767x220px|Table 2: The use of diffrent supplemental valuation methods by CFO's of Furtune 1000 companies]]Table 2: The use of diffrent supplemental valuation methods by CFO's of Furtune 1000 companies<ref>Ryan, P. A. &amp; Ryan, G. P. (2002). Capital Budgeting Practices of the Fortune 1000: How Have Things Changed? Journal of Business and Management , Volume 8, Number 4, Winter.</ref></center>
+
<center>[[Image:Supplemental capital budgeting tools.jpg|center|767x220px|Table 2: The use of different supplemental valuation methods by CFO's of Fortune 1000 companies]]Table 2: The use of different supplemental valuation methods by CFO's of Fortune 1000 companies<ref>Ryan, P. A. &amp; Ryan, G. P. (2002). Capital Budgeting Practices of the Fortune 1000: How Have Things Changed? Journal of Business and Management , Volume 8, Number 4, Winter.</ref></center>
 
<br>
 
<br>
   
Line 17: Line 15:
 
= <br>Net Present Value (NPV) =
 
= <br>Net Present Value (NPV) =
   
NPV is the most common method for evaluating a project with 85.1% of respondents’ using it always or often. An overview of the method can be found here. link to project page
+
NPV is the most common method for evaluating a project with 85.1% of respondents’ using it always or often. An overview of the method can be found [http://queensminedesign.miningexcellence.ca/index.php/Project_economics#Present_Value_Calculation here].
   
The main variable in the NPV equation that must be determined by the group doing the analysis is the cost of capital or interest rate, in the provided explanation. The cost of capital can be considered in two ways; the hurdle rate for the company considering the project which must be passed for to consider it, or what the company pays for the capital it invests, calculated using the weighted average cost of capital or WACC. link
+
The main variable in the NPV equation that must be determined by the group doing the analysis is the cost of capital or interest rate, in the provided explanation. The cost of capital can be considered in two ways; the hurdle rate for the company considering the project which must be passed for to consider it, or what the company pays for the capital it invests, calculated using the weighted average cost of capital or WACC.
   
 
== <br>Hurdle Rate ==
 
== <br>Hurdle Rate ==
   
While the hurdle rate may be the calculated WACC for a company, it is essentially a way to describe the value when it deviates from the calculated cost of capital. One example is large companies valuing long mine life projects. Often large mines can have an operating life of 50+ years and due to the effects of discounting at your cost of capital any cash flow beyond year 30 will not have a large effect on the NPV. For example, revenue of $50 million discounted at 12% for year 31 only contributes $1.5 million to the NPV. This causes a bias of long mine life projects being undervalued. Larger companies want large project to both significantly increase their cash flow and provide long term growth. To properly value these projects they may use a hurdle rate of 4%. In the example this would increase the discount value from $1.5 million to $15 million in year 31, an increase of one order of magnitude. This trend of large companies using lower cost of capitals is also displayed in WACC calculations, as the equity in large companies tends to be more “patient” capital however not to this degree.
+
While the hurdle rate may be the calculated WACC for a company, it is essentially a way to describe the value when it deviates from the calculated cost of capital. One example is large companies valuing long mine life projects. Often large mines can have an operating life of 50+ years and due to the effects of discounting at your cost of capital any cash flow beyond year 30 will not have a large effect on the NPV. For example, revenue of $50 million discounted at 12% for year 31 only contributes $1.5 million to the NPV. This causes a bias of long mine life projects being undervalued. Larger companies want large project to both significantly increase their cash flow and provide long term growth. To properly value these projects they may use a hurdle rate of 4%. In the example this would increase the discount value from $1.5 million to $15 million in year 31, an increase of one order of magnitude. This trend of large companies using lower cost of capitals is also displayed in WACC calculations, as the equity in large companies tends to be more “patient” capital however not to this degree.
   
When choosing a cost of capital for a project, approximate it by comparing the size and location of the site to a company that would most likely buy it; therefore properly valuing for your target audience.
+
When choosing a cost of capital for a project, approximate it by comparing the size and location of the site to a company that would most likely buy it; therefore properly valuing for your target audience.
   
 
== <br>Weighted Average Cost of Capital (WACC) ==
 
== <br>Weighted Average Cost of Capital (WACC) ==
   
The weighted average cost of capital simply takes the weighted average cost of both debt and equity capital. The cost of debt is the rate the company pays the bank. The cost of equity capital is found using stock charts with the capital asset pricing modellink or by polling large owners. WACC uses the following equation:
+
The weighted average cost of capital simply takes the weighted average cost of both debt and equity capital. The cost of debt is the rate the company pays the bank. The cost of equity capital is found using stock charts with the <span class="plainlinks">[http://queensminedesign.miningexcellence.ca/index.php/Project_Evaluation_Methods#Capital_Asset_Pricing_Model_.28CAPM.29 capital asset pricing model]</span> or by polling large owners. WACC uses the following equation:
+
<center><span style="font-size: medium">''<span style="font-family: verdana">WACC=(ke×We)+(kd [1-t]×Wd)<ref>Pratt, S. (1998). Cost of Capital: Estimations and Applications. New York, New York: John Wiley &amp; Sons, Inc. </ref></span>''</span></center>
<center><span style="font-size: medium">''<span style="font-family: verdana">WACC=(ke×We)+(kd [1-t]×Wd)<ref>Pratt, S. (1998). Cost of Capital: Estimations and Applications. New York, New York: John Wiley & Sons, Inc. </ref></span>''</span></center>
+
<br>Where: '''''ke''''' is the cost of equity capital, '''''We''''' is the percentage of equity in the capital structure, '''''kd''''' is the cost of debt, '''''t''''' is the marginal tax rate and '''''Wd''''' is the percentage of debt in the capital structure.
<br>Where: '''''ke''''' is the cost of equity capital, '''''We''''' is the percentage of equity in the capital structure, '''''kd''''' is the cost of debt, '''''t''''' is the marginal tax rate and '''''Wd''''' is the percentage of debt in the capital structure.
 
   
 
The marginal tax rate is needed because interest paid on debt for a business is deductable for tax purposes, so the true cost of debt is the fraction paid after using the deduction.
 
The marginal tax rate is needed because interest paid on debt for a business is deductable for tax purposes, so the true cost of debt is the fraction paid after using the deduction.
Line 38: Line 36:
   
 
Calculating the cost of equity capital can be difficult; the most commonly used method is the capital asset pricing model. The model uses the riskless interest rate and the market premium, and alters them using systematic risk as a modifier described by a stocks beta. This creates the following linear equation for cost of equity capital:
 
Calculating the cost of equity capital can be difficult; the most commonly used method is the capital asset pricing model. The model uses the riskless interest rate and the market premium, and alters them using systematic risk as a modifier described by a stocks beta. This creates the following linear equation for cost of equity capital:
 
<center>''<span style="font-family: verdana"><span style="font-size: medium">E(Ri)=Rf+B(RPm)<ref>Pratt, S. (1998). Cost of Capital: Estimations and Applications. New York, New York: John Wiley &amp; Sons, Inc. </ref></span></span>''</center>
 
<br>Where: '''''Rf''''' is the riskless interest rate, '''''B''''' is the beta of the stock and '''''RPm''''' is the risk premium for the market as a whole.
   
<center>''<span style="font-family: verdana"><span style="font-size: medium">E(Ri)=Rf+B(RPm)<ref>Pratt, S. (1998). Cost of Capital: Estimations and Applications. New York, New York: John Wiley & Sons, Inc. </ref></span></span>''</center>
 
 
The riskless interest rate is typically the rate on a 30-day, 5-year or 20-year US Treasury bond.<ref>Pratt, S. (1998). Cost of Capital: Estimations and Applications. New York, New York: John Wiley &amp; Sons, Inc. </ref>The Beta can be found for many stocks in financial papers or by using [http://www.google.ca/finance Google Finance]. The market premium is found using historical data comparing the gain in the stock market over the riskless interest rates for the period in question. Given the forward looking nature of NPV, an assumption is made that the markets will hold the observed trend.<br>The difference in betas between large and small cap companies helps to reconcile how small cap companies are riskier and investors expect higher returns while large cap companies are safer and investors expect lower returns.
<br>Where: '''''Rf''''' is the riskless interest rate, '''''B''''' is the beta of the stock and '''''RPm''''' is the risk premium for the market as a whole.
 
 
The riskless interest rate is typically the rate on a 30-day, 5-year or 20-year US Treasury bond.<ref>Pratt, S. (1998). Cost of Capital: Estimations and Applications. New York, New York: John Wiley & Sons, Inc. </ref> The Beta can be found for many stocks in financial papers or by using Google Finance link. The market premium is found using historical data comparing the gain in the stock market over the riskless interest rates for the period in question. Given the forward looking nature of NPV, an assumption is made that the markets will hold the observed trend.<br>The difference in betas between large and small cap companies helps to reconcile how small cap companies are riskier and investors expect higher returns while large cap companies are safer and investors expect lower returns.
 
   
 
= <br>Internal Rate of Return (IRR) =
 
= <br>Internal Rate of Return (IRR) =
   
Internal rate of return is the second most common tool used and is one of the easiest to calculate. The IRR uses the same equation as NPV, except the cost of capital is solved for the sum of the cash flows equal to zero. So the IRR is the cost of capital that would give you an NPV of zero.
+
Internal rate of return is the second most common tool used and is one of the easiest to calculate. The IRR uses the same equation as NPV, except the cost of capital is solved for the sum of the cash flows equal to zero. So the IRR is the cost of capital that would give you an NPV of zero.
   
Excel has an IRR function that requires all after tax cash flows to be in one row sequentially. Another way in excel to find the IRR is to have all the cost of capitals linked to one cell, and then use goal seek to have the sum of the row of cash flows equal to zero by varying the cost of capital.
+
Excel has an IRR function that requires all after tax cash flows to be in one row sequentially. Another way in excel to find the IRR is to have all the cost of capitals linked to one cell, and then use goal seek to have the sum of the row of cash flows equal to zero by varying the cost of capital. An example Excel sheet can be found here: [[File:IRR Example.xlsx]]
   
 
== <br>IRR Comparison ==
 
== <br>IRR Comparison ==
Line 54: Line 51:
 
Calculating IRR is easy but the effort comes in the evaluation of the IRR versus other IRR’s. If it is larger than a company’s hurdle rate or WACC, it is a good indicator. However, if the project has any unusual risk it may need a higher IRR. A 12% IRR for a project in Timmins Ontario with well defined typical geology and close infrastructure and labour markets is far more attractive than a 12% IRR on a project in a remote part of China in a previously un-explored area. The risks differ greatly and where risk is high it must be justified by a higher IRR. This is also consequential in comparing different options within same project. Using double benching may increase the IRR but it has to be sufficient to offset the incurred risk of slope stability.
 
Calculating IRR is easy but the effort comes in the evaluation of the IRR versus other IRR’s. If it is larger than a company’s hurdle rate or WACC, it is a good indicator. However, if the project has any unusual risk it may need a higher IRR. A 12% IRR for a project in Timmins Ontario with well defined typical geology and close infrastructure and labour markets is far more attractive than a 12% IRR on a project in a remote part of China in a previously un-explored area. The risks differ greatly and where risk is high it must be justified by a higher IRR. This is also consequential in comparing different options within same project. Using double benching may increase the IRR but it has to be sufficient to offset the incurred risk of slope stability.
   
The problem with both these examples is that they are qualitative not quantitative and there is no hard and fast rules for converting qualitative risk into IRR. Often, in order to accurately quantify risk, a monte carlo simulation will be utilized. Common qualitative concerns outside of project technology decisions that should be considered include but are not limited to:
+
The problem with both these examples is that they are qualitative not quantitative and there is no hard and fast rules for converting qualitative risk into IRR. Often, in order to accurately quantify risk, a monte carlo simulation will be utilized. Common qualitative concerns outside of project technology decisions that should be considered include but are not limited to:
   
 
*metal prices/economy - Inconsistency in the sale price of your product and the cost of your consumables
 
*metal prices/economy - Inconsistency in the sale price of your product and the cost of your consumables
Line 64: Line 61:
 
= <br>Real Options =
 
= <br>Real Options =
   
In an attempt to better quantify the impacts of risk, real options have increased in popularity. In the 2002 survey only 1.6% of CFO’s used it always or often but in more recent Harvard Business Review articles they claim an increase in the methods popularity.<ref>Copeland, T. &amp; Tufano, P. (2004). A Real-World Way to Manage Real Options. The Harvard Busniess Review, March 2004 P. 1-12</ref> Real options are usually used in two basic forms.
+
In an attempt to better quantify the impacts of risk, real options have increased in popularity. In the 2002 survey only 1.6% of CFO’s used it always or often but in more recent Harvard Business Review articles they claim an increase in the methods popularity.<ref>Copeland, T. &amp;amp;amp;amp;amp;amp; Tufano, P. (2004). A Real-World Way to Manage Real Options. The Harvard Business Review, March 2004 P. 1-12</ref> Real options are usually used in two basic forms.
   
One way is to put a value on a choice or option; having a flexible plan is more valuable than a rigid plan that can’t change in response to, for example, commodity price fluctuations. For a simple phased project the second phase will be built if it will be profitable or canceled if not. The fundamental idea is that the second phase does not cost you anything if not built and gives the opportunity for upside. So the choice is worth the variability of the upside multiplied by the time till the decision.
+
One way is to put a value on a choice or option; having a flexible plan is more valuable than a rigid plan that can’t change in response to, for example, commodity price fluctuations. For a simple phased project the second phase will be built if it will be profitable or canceled if not. The fundamental idea is that the second phase does not cost you anything if not built and gives the opportunity for upside. So the choice is worth the variability of the upside multiplied by the time till the decision.
   
 
Secondly, real options are used to more accurately predict revenue. Instead of using pre determined prices, the options of the commodity that trades are used in a formula to predict the prices and account for fluctuation.
 
Secondly, real options are used to more accurately predict revenue. Instead of using pre determined prices, the options of the commodity that trades are used in a formula to predict the prices and account for fluctuation.
Line 72: Line 69:
 
= <br>Payback Period =
 
= <br>Payback Period =
   
The third and fourth most used methods are payback and discounted payback periods, reportedly used 52.6% and 37.6%, respectively by CFO’s always or often. As two of the older and simpler techniques, they are still very popular.
+
The third and fourth most used methods are payback and discounted payback periods, reportedly used 52.6% and 37.6%, respectively by CFO’s always or often. As two of the older and simpler techniques, they are still very popular.
  +
  +
Payback period is the amount of time it takes to recuperate the capital expenditures for a project from cash flow. Discounted payback is the same except discounted cash flows are used to calculate the payback period. Often investors or managers prefer a payback of three years or less, however mines typically have longer payback periods. A three year payback is more feasible for proposed mine upgrades. For example, a new piece of equipment should pay for itself in no longer than three years by increasing productivity or saving maintenance costs. If this is not the case the proposal may not look favorable as a rough rule of thumb.<ref>Anthes, G. ROI Guide: Payback Period. Sun Wind Power Systems: Files. www.sunwindpowerinc.com/files/files/ROI_Guide.doc. Accessed: March 5, 2010</ref>
   
Payback period is the amount of time it takes to recuperate the capital expenditures for a project from cash flow. Discounted payback is the same except discounted cash flows are used to calculate the payback period. Often investors or managers prefer a payback of three years or less, however mines typically have longer payback periods. A three year payback is more feasible for proposed mine upgrades. For example, a new piece of equipment should pay for itself in no longer than three years by increasing productivity or saving maintenance costs. If this is not the case the proposal may not look favorable as a rough rule of thumb.<ref>Anthes, G. ROI Guide: Payback Period. Sun Wind Power Systems: Files. www.sunwindpowerinc.com/files/files/ROI_Guide.doc. Accessed: March 5, 2010</ref>
 
 
 
= <br>Notes =
 
= <br>Notes =
   
Line 85: Line 80:
 
*Armitage, S. (2005). The cost of capital&nbsp;: intermediate theory. Cambridge, New York&nbsp;: Cambridge University Press.
 
*Armitage, S. (2005). The cost of capital&nbsp;: intermediate theory. Cambridge, New York&nbsp;: Cambridge University Press.
 
*Chew Jr., D. H. (1999). The new corporate finance&nbsp;: where theory meets practice . Boston, MA&nbsp;: Irwin/McGraw-Hill.
 
*Chew Jr., D. H. (1999). The new corporate finance&nbsp;: where theory meets practice . Boston, MA&nbsp;: Irwin/McGraw-Hill.
*Copeland, T. &amp; Tufano, P. (2004). A Real-World Way to Manage Real Options. The Harvard Busniess Review, March 2004 P. 1-12
+
*Copeland, T. &amp; Tufano, P. (2004). A Real-World Way to Manage Real Options. The Harvard Business Review, March 2004 P. 1-12
 
*Pratt, S. (1998). Cost of Capital: Estimations and Applications. New York, New York: John Wiley &amp; Sons, Inc.
 
*Pratt, S. (1998). Cost of Capital: Estimations and Applications. New York, New York: John Wiley &amp; Sons, Inc.
 
*Ryan, P. A. &amp; Ryan, G. P. (2002). Capital Budgeting Practices of the Fortune 1000: How Have Things Changed? Journal of Business and Management , Volume 8, Number 4, Winter.<br>
 
*Ryan, P. A. &amp; Ryan, G. P. (2002). Capital Budgeting Practices of the Fortune 1000: How Have Things Changed? Journal of Business and Management , Volume 8, Number 4, Winter.<br>
  +
  +
[[Category:2010]]

Latest revision as of 12:10, 5 April 2011


Current Industry Methods

All mining is performed for profit. Since there are many possible ways to mine a deposit and many deposits to chose from, one must be able to select the best deposit and the most efficient mining techniques, for the deposit that are available. For investors, this problem is compounded by the numerous mining companies to choose from. A measure must be used that can be applied to all projects of varying scope and design so that they may be compared. Given the variability in the type, length and cost of mining projects, different measures may favor different projects; therefore the measure to use is not always clear. Table 1 displays the results of a survey in 2002 of the Chief Financial Officers of Fortune 1000 companies, outlining the use of different methods to measure value.

Table 1: The use of different valuation methods by CFO's of Fortune 1000 companies
Table 1: The use of different valuation methods by CFO's of Fortune 1000 companies[1]


There is a good consensus formed on methods such as Net Present Value (NPV) and Internal rate of Return (IRR) with other tools being used regularly. On top of the basic methods there are supplemental tools shown in table 2.

Table 2: The use of different supplemental valuation methods by CFO's of Fortune 1000 companies
Table 2: The use of different supplemental valuation methods by CFO's of Fortune 1000 companies[2]


Due to the numerous methods available with varying degrees of use, the prospect of valuing different options in a project is not always a simple one. Some of the tools in the survey will be discussed along with the significance of their results.


Net Present Value (NPV)

NPV is the most common method for evaluating a project with 85.1% of respondents’ using it always or often. An overview of the method can be found here.

The main variable in the NPV equation that must be determined by the group doing the analysis is the cost of capital or interest rate, in the provided explanation. The cost of capital can be considered in two ways; the hurdle rate for the company considering the project which must be passed for to consider it, or what the company pays for the capital it invests, calculated using the weighted average cost of capital or WACC.


Hurdle Rate

While the hurdle rate may be the calculated WACC for a company, it is essentially a way to describe the value when it deviates from the calculated cost of capital. One example is large companies valuing long mine life projects. Often large mines can have an operating life of 50+ years and due to the effects of discounting at your cost of capital any cash flow beyond year 30 will not have a large effect on the NPV. For example, revenue of $50 million discounted at 12% for year 31 only contributes $1.5 million to the NPV. This causes a bias of long mine life projects being undervalued. Larger companies want large project to both significantly increase their cash flow and provide long term growth. To properly value these projects they may use a hurdle rate of 4%. In the example this would increase the discount value from $1.5 million to $15 million in year 31, an increase of one order of magnitude. This trend of large companies using lower cost of capitals is also displayed in WACC calculations, as the equity in large companies tends to be more “patient” capital however not to this degree.

When choosing a cost of capital for a project, approximate it by comparing the size and location of the site to a company that would most likely buy it; therefore properly valuing for your target audience.


Weighted Average Cost of Capital (WACC)

The weighted average cost of capital simply takes the weighted average cost of both debt and equity capital. The cost of debt is the rate the company pays the bank. The cost of equity capital is found using stock charts with the capital asset pricing model or by polling large owners. WACC uses the following equation:

WACC=(ke×We)+(kd [1-t]×Wd)[3]


Where: ke is the cost of equity capital, We is the percentage of equity in the capital structure, kd is the cost of debt, t is the marginal tax rate and Wd is the percentage of debt in the capital structure.

The marginal tax rate is needed because interest paid on debt for a business is deductable for tax purposes, so the true cost of debt is the fraction paid after using the deduction.


Capital Asset Pricing Model (CAPM)

Calculating the cost of equity capital can be difficult; the most commonly used method is the capital asset pricing model. The model uses the riskless interest rate and the market premium, and alters them using systematic risk as a modifier described by a stocks beta. This creates the following linear equation for cost of equity capital:

E(Ri)=Rf+B(RPm)[4]


Where: Rf is the riskless interest rate, B is the beta of the stock and RPm is the risk premium for the market as a whole.

The riskless interest rate is typically the rate on a 30-day, 5-year or 20-year US Treasury bond.[5]The Beta can be found for many stocks in financial papers or by using Google Finance. The market premium is found using historical data comparing the gain in the stock market over the riskless interest rates for the period in question. Given the forward looking nature of NPV, an assumption is made that the markets will hold the observed trend.
The difference in betas between large and small cap companies helps to reconcile how small cap companies are riskier and investors expect higher returns while large cap companies are safer and investors expect lower returns.


Internal Rate of Return (IRR)

Internal rate of return is the second most common tool used and is one of the easiest to calculate. The IRR uses the same equation as NPV, except the cost of capital is solved for the sum of the cash flows equal to zero. So the IRR is the cost of capital that would give you an NPV of zero.

Excel has an IRR function that requires all after tax cash flows to be in one row sequentially. Another way in excel to find the IRR is to have all the cost of capitals linked to one cell, and then use goal seek to have the sum of the row of cash flows equal to zero by varying the cost of capital. An example Excel sheet can be found here: File:IRR Example.xlsx


IRR Comparison

Calculating IRR is easy but the effort comes in the evaluation of the IRR versus other IRR’s. If it is larger than a company’s hurdle rate or WACC, it is a good indicator. However, if the project has any unusual risk it may need a higher IRR. A 12% IRR for a project in Timmins Ontario with well defined typical geology and close infrastructure and labour markets is far more attractive than a 12% IRR on a project in a remote part of China in a previously un-explored area. The risks differ greatly and where risk is high it must be justified by a higher IRR. This is also consequential in comparing different options within same project. Using double benching may increase the IRR but it has to be sufficient to offset the incurred risk of slope stability.

The problem with both these examples is that they are qualitative not quantitative and there is no hard and fast rules for converting qualitative risk into IRR. Often, in order to accurately quantify risk, a monte carlo simulation will be utilized. Common qualitative concerns outside of project technology decisions that should be considered include but are not limited to:

  • metal prices/economy - Inconsistency in the sale price of your product and the cost of your consumables
  • political/social - Chance of labour disputes, trouble permitting and in extreme cases chance of government extortion or land seizure
  • location – Infrastructure for power and water access, transportation costs and geological certainty for previously unexplored areas with unknown structure

Each of these in the extreme cases can warrant several points of increase in the calculated IRR in order to make the project on par with other similar projects without these risks.


Real Options

In an attempt to better quantify the impacts of risk, real options have increased in popularity. In the 2002 survey only 1.6% of CFO’s used it always or often but in more recent Harvard Business Review articles they claim an increase in the methods popularity.[6] Real options are usually used in two basic forms.

One way is to put a value on a choice or option; having a flexible plan is more valuable than a rigid plan that can’t change in response to, for example, commodity price fluctuations. For a simple phased project the second phase will be built if it will be profitable or canceled if not. The fundamental idea is that the second phase does not cost you anything if not built and gives the opportunity for upside. So the choice is worth the variability of the upside multiplied by the time till the decision.

Secondly, real options are used to more accurately predict revenue. Instead of using pre determined prices, the options of the commodity that trades are used in a formula to predict the prices and account for fluctuation.


Payback Period

The third and fourth most used methods are payback and discounted payback periods, reportedly used 52.6% and 37.6%, respectively by CFO’s always or often. As two of the older and simpler techniques, they are still very popular.

Payback period is the amount of time it takes to recuperate the capital expenditures for a project from cash flow. Discounted payback is the same except discounted cash flows are used to calculate the payback period. Often investors or managers prefer a payback of three years or less, however mines typically have longer payback periods. A three year payback is more feasible for proposed mine upgrades. For example, a new piece of equipment should pay for itself in no longer than three years by increasing productivity or saving maintenance costs. If this is not the case the proposal may not look favorable as a rough rule of thumb.[7]


Notes

  1. Ryan, P. A. & Ryan, G. P. (2002). Capital Budgeting Practices of the Fortune 1000: How Have Things Changed? Journal of Business and Management , Volume 8, Number 4, Winter.
  2. Ryan, P. A. & Ryan, G. P. (2002). Capital Budgeting Practices of the Fortune 1000: How Have Things Changed? Journal of Business and Management , Volume 8, Number 4, Winter.
  3. Pratt, S. (1998). Cost of Capital: Estimations and Applications. New York, New York: John Wiley & Sons, Inc.
  4. Pratt, S. (1998). Cost of Capital: Estimations and Applications. New York, New York: John Wiley & Sons, Inc.
  5. Pratt, S. (1998). Cost of Capital: Estimations and Applications. New York, New York: John Wiley & Sons, Inc.
  6. Copeland, T. &amp;amp;amp;amp;amp; Tufano, P. (2004). A Real-World Way to Manage Real Options. The Harvard Business Review, March 2004 P. 1-12
  7. Anthes, G. ROI Guide: Payback Period. Sun Wind Power Systems: Files. www.sunwindpowerinc.com/files/files/ROI_Guide.doc. Accessed: March 5, 2010


References

  • Anthes, G. ROI Guide: Payback Period. Sun Wind Power Systems: Files. www.sunwindpowerinc.com/files/files/ROI_Guide.doc. Accessed: March 5, 2010
  • Armitage, S. (2005). The cost of capital : intermediate theory. Cambridge, New York : Cambridge University Press.
  • Chew Jr., D. H. (1999). The new corporate finance : where theory meets practice . Boston, MA : Irwin/McGraw-Hill.
  • Copeland, T. & Tufano, P. (2004). A Real-World Way to Manage Real Options. The Harvard Business Review, March 2004 P. 1-12
  • Pratt, S. (1998). Cost of Capital: Estimations and Applications. New York, New York: John Wiley & Sons, Inc.
  • Ryan, P. A. & Ryan, G. P. (2002). Capital Budgeting Practices of the Fortune 1000: How Have Things Changed? Journal of Business and Management , Volume 8, Number 4, Winter.