Investment decisions and sensitivity analysis: NPV-consistency of rates of return

Marchioni, Andrea and Magni, Carlo Alberto (2018): Investment decisions and sensitivity analysis: NPV-consistency of rates of return. Published in: European Journal of Operational Research No. 268 : pp. 361-372.

Abstract

Investment decisions may be evaluated via several different metrics/criteria, which are functions of a vector of value drivers. The economic significance and the reliability of a metric depend on its compatibility with the Net Present Value (NPV). Traditionally, a metric is said to be NPV-consistent if it is coherent with NPV in signalling value creation. This paper makes use of Sensitivity Analysis (SA) for measuring coherence between rates of return and NPV. In particular, it introduces a new, stronger definition of NPV-consistency that takes into account the influence of value drivers on the metric output. A metric is strongly NPV-consistent if it signals value creation and the ranking of the value drivers in terms of impact on the output is the same as that provided by the NPV. The degree of (in)coherence is calculated with Spearman's (1904) correlation coefficient and Iman and Conover's (1987) top-down coefficient. We focus on the class of AIRRs (Magni 2010, 2013) and show that the average Return On Investment (ROI) enjoys strong NPV-consistency under several (possibly all) methods of Sensitivity Analysis.

• Item Type: MPRA Paper
• Language: English
• Keywords: Finance, sensitivity analysis, investment decisions, NPV, Return On Investment, consistency, average, AIRR
• Subjects: C - Mathematical and Quantitative Methods > C0 - General > C02 - Mathematical Methods; C - Mathematical and Quantitative Methods > C6 - Mathematical Methods ; Programming Models ; Mathematical and Simulation Modeling > C67 - Input-Output Models; G - Financial Economics > G3 - Corporate Finance and Governance > G31 - Capital Budgeting ; Fixed Investment and Inventory Studies ; Capacity

References

Adelson, R.M. (1965) Criteria for capital investment: an approach through decision theory. Operational Research Quarterly 16, 19-50.

Ashford R.W., Berry, R.H., Dyson, R.G. (1988) Operational research and financial management. European Journal of Operational Research, 36, 143-152.

Baroum, S.M., Patterson, J.H. (1996) The development of cash flow weight procedures for maximizing the net present value of a project. Journal of Operations Management, 14(3) (September), 209-227.

Barry, P.J., Robison, L.J. (2014) Technical note: Economic rates of return and investment analysis. The Engineering Economist, 59(3), 231-236.

Ben-Horin, M., Kroll, Y. (2017) A simple intuitive NPV-IRR consistent ranking. The Quarterly Review of Economics and Finance. https://doi.org/10.1016/j.qref.2017.01.004.

Baesens B., Setiono R., Mues C., Vanthienen, J. (2003) Using neural network rule extraction and decision tables for credit-risk evaluation. Management Science 49, 312–329.

Bernhard, R.H. (1980) A simplification and an extension of the Bernhard-De Faro sufficient condition for a unique non-negative internal rate of return. Journal of Financial and Quantitative Analysis. 15(1), 201-209.

Board, J., Sutcliffe, C., Ziemba, W.T. (2003) Applying operations research techniques to financial markets. Interfaces, 33(2) (Mar-Apr), 12-24.

Borgonovo, E. (2010) Sensitivity analysis with finite changes: An application to modified EOQ models. European Journal of Operational Research, 200, 127-138.

Borgonovo, E. (2010b) A Methodology for Determining Interactions in Probabilistic Safety Assessment Models by Varying One Parameter at a Time. Risk Analysis, 30 (3), 385-399.

Borgonovo, E., Apostolakis, G. E. (2001) A new importance measure for risk-informed decision-making. Reliability Engineering and System Safety, 72 (2), 193-212.

Borgonovo, E., Gatti, S., Peccati, L. (2010) What drives value creation in investment projects? An application of sensitivity analysis to project finance transactions. European Journal of Operational Research, 205, 227-236.

Borgonovo, E., Peccati, L. (2004) Sensitivity analysis in investment project evaluation. International Journal of Production Economics, 90, 17-25.

Borgonovo, E., Peccati, L. (2006) The importance of assumptions in investment evaluation. International Journal of Production Economics, 101(2) (June), 298-311.

Borgonovo, E., Peccati, L. (2006) Uncertainty and global sensitivity analysis in the evaluation of investment projects. International Journal of Production Economics, 104, 62-73.

Borgonovo, E., Plischke, E. (2016) Sensitivity analysis: A review of recent advances. European Journal of Operational Research, 248(3), 869-887.

Borgonovo, E., Tarantola, S., Plischke, E., Morris, M.D. (2014) Transformations and invariance in the sensitivity analysis of computer experiments. Journal of the Royal Statistical Society, B, 76, Part 5, 925-947.

Bosch-Badia, M.T., Montllor-Serrats, J., Tarrazon-Rodon, M.A. (2014) Capital budgeting and shareholders’ value: Investment projects versus courses of action. The Engineering Economist, 59, 207-230.

Brealey, R.A., Myers, S.C. (2000) Principles of Corporate Finance. McGraw-Hill, New York.

Brimberg, J., Hansen, P., Laporte, G., Mladenovic, N., Urosevic, D. (2008) The maximum return-on-investment plant location problem with market share. Journal of the Operational Research Society, 59(3), 399-406.

Brimberg, J., ReVelle, C. (2000) The maximum return-on-investment plant location problem. Journal of the Operational Research Society, 51(6) (June), 729-735.

Bring, J. (1994) How to standardize regression coefficients. The American Statistician, 48(3)(August), 209-213.

Cigola, M., Peccati, L. (2005) On the comparison between the APV and the NPV computed via the WACC. European Journal of Operational Research, 161(2) (March), 377-385.

Danaher, P.J., Rust, R.T. (1996) Determining the optimal return on investment for an advertising campaign. European Journal of Operational Research, 95(3) (December), 511-521.

Dhavale, D.G., Sarkis, J. (2018) Stochastic internal rate of return on investments in sustainable assets generating carbon credits. Computers & Operations Research, 89 (January), 324-336.

De Faro, C. (1978) A sufficient condition for a unique non-negative internal rate of return: Further comment. Journal of Financial Quantitative Analysis, 13, 577-584.

Ekern, S. (1981) Time Dominance Efficiency Analysis. Journal of Finance, 36(5) (December), 1023-1034.

Fabozzi, F.J., Huang, D., Zhou, G. (2010) Robust portfolios: contributions from operations research and finance. Annals of Operations Research, 176(1) (April), 191-220.

Foster, J.E., Mitra, T. (2003) Ranking investment projects. Economic Theory, 22, 469-494.

Gondzio, J., Kouwenberg, R. (2001) High-performance computing for asset-liability management. Operations Research, 49(6) (November-December), 879-891.

Grubbstrom, R.W., Ashcroft, S.H. (1991) Application of the calculus of variations to financing alternatives. Omega, 19(4), 305-316.

Hartman, J.C. and Schafrick, I.C. (2004) The relevant internal rate of return. The Engineering Economist, 49(2).

Hartman, J. (2007) Engineering economy and the decision-making process. Pearson Prentice Hall, Upper Saddle River, NJ.

Hazen, G.B. (2003) A new perspective on multiple internal rates of return. The Engineering Economist, 48(1), 31-51.

Hazen, G.B. (2009) An extension of the internal rate of return to stochastic cash flows. Management Science, 55, 1030-1034.

Helton, J.C. (1993) Uncertainty and sensitivity analysis techniques for use in performance assessment for radioactive waste disposal. Reliability Engineering and System Safety, 42, 327-367.

Herroelen, W.S., Van Dommelen, P., Demeulemeester, E.L. (1997) Project network models with discounted cash flows a guided tour through recent developments. European Journal of Operational Research, 100(1) (July), 97-121.

Hespos, R.F., Strassman, P.A. (1965) Stochastic decision trees for the analysis of investment decisions. Management Science, 11(19) (August), 224-259.

Ignizio, J.P. (1976) An approach to the capital budgeting problem with multiple objectives. The Engineering Economist, 21(4), 259-272.

Iman, R.L., Conover, W.J. (1987) A measure of top-down correlation. Technometrics, 29 (3), 351-357.

Joy, O.M., Bradley, J.O. (1973) A note on sensitivity analysis of rates of return. Journal of Finance (December 1973), 1255-1261.

Koc, A., Morton, D.P., Popova, E. Hess, S.M., Kee, E., Richards, D. (2009) Prioritizing project selection. The Engineering Economist, 54(4), 267-297.

Kumbhakar, S.C. (2011) Estimation of production technology when the objective is to maximize return to the outlay. European Journal of Operational Research, 208(2) (January), 170-176.

Leyman, P., Vanhoucke, M. (2017) Capital- and resource-constrained project scheduling with net present value optimization. European Journal of Operational Research, 256(3) (February), 757-776.

Li, J., Min, K.J., Otake, T., Van Voorhis, T. (2008) Inventory and investment in setup and quality operations under Return On Investment maximization. European Journal of Operational Research, 185(2) (March), 593-605.

Lima e Silva, J., Sobreiro, V.A., Kimura, H. (2017) Pre-Purchasing financing pool: Revealing the IRR problem. The Engineering Economist, DOI: 10.1080/0013791X.2017.1333662.

Magni, C.A. (2010) Average Internal Rate of Return and investment decisions: A new perspective. The Engineering Economist, 55(2), 150-180.

Magni, C.A. (2013) The Internal Rate of Return approach and the AIRR Paradigm: A refutation and a corroboration. The Engineering Economist: A Journal Devoted to the Problems of Capital Investment, 58(2), 73-111.

Magni, C.A. (2014) Mathematical analysis of average rates of return and investment decisions: The missing link. The Engineering Economist, 59(3), 175-206.

Magni, C.A. (2015) Investment, financing and the role of ROA and WACC in value creation. European Journal of Operational Research, 244, 855-866.

Magni, C.A. (2016) Capital depreciation and the underdetermination of rate of return: A unifying perspective. Journal of Mathematical Economics, 67 (December), 54-79.

Menezes, M.B.C., Kim, S., Huang, R. (2015) Return-on-investment (ROI) criteria for network design. European Journal of Operational Research, 245(1) (August), 100-108.

Meier, H., Christofides, N., Salkin, G. (2001) Capital Budgeting Under Uncertainty—An Integrated Approach Using Contingent Claims Analysis and Integer Programming. Operations Research, 49(2) (March-April), 196-206.

Morch, O., Fagerholta, K., Pantuso, G., Rakkec, J. (2017) Maximizing the rate of return on the capital employed in shipping capacity renewal. Omega, 67 (March), 42-53.

Murthi, B.P.S., Choi, Y.K., Desai, P. (1997) Efficiency of mutual funds and portfolio performance measurement: A non-parametric approach. European Journal of Operational Research, 98(2) (April), 408-418.

Myung, Y.-S., Kim, H., Tcha, D. (1997) A bi-objective uncapacitated facility location problem. European Journal of Operational Research, 100(3), 608-616.

Nauss, R.M. (1988) On the use of internal rate of return in linear and integer programming. Operations Research Letters, 7(6) (December), 285-289.

Pasqual, J., Padilla, E., Jadotte, E. (2013) Technical note: Equivalence of different profitability criteria with the net present value. International Journal of Production Economics, 142(1) (March), 205-210.

Percoco, M., Borgonovo, E. (2012) A note on the sensitivity analysis of the internal rate of return. International Journal of Production Economics, 135, 526-529.

Pianosi, F., Beven, K., Freer, J., Hall, J.W., Rougier, J., Stephenson, D.B., Wagener, T. (2016) Sensitivity analysis of environmental models: A systematic review with practical workflow. Environmental Modelling & Software, 79, 214-232.

Rapp, B. (1980) The Internal Rate of Return method - A critical study. Engineering Costs and Production Economics, 5(1) (June), 43-52.

Rivett, P. (1974) Perspective for Operational Research. Omega, 2(2), 225-233.

Rosenblatt, M.J., Sinuany-Stern, Z. (1989) Generating the discrete efficient frontier to the capital budgeting problem. Operations Research, 37(3), 384-394.

Ross, S.A., Westerfield, R.W., Jordan, B.D. (2011) Essentials of corporate finance, 7th ed. McGraw-Hill/Irwin, New York.

Saltelli, A., Marivoet, J. (1990) Non-parametric statistics in sensitivity analysis for model output: A comparison of selected techniques. Reliability Engineering and System Safety, 28, 229-253.

Saltelli, A., Ratto, M., Andres, T., Campolongo, F., Cariboni, J., Gatelli, D., Saisana, M., Tarantola, S. (2008) Global Sensitivity Analysis. The Primer. John Wiley & Sons, Chichester.

Saltelli, A., Tarantola, S., Campolongo, F., Ratto, M. (2004) Sensitivity analysis in practice. A guide to assessing scientific models. John Wiley & Sons, Chichester.

Savage, I.R. (1956) Contributions to the theory of rank order statistics - The two-sample case. The Annals of Mathematical Statistics, 27(3), 590-615.

Seifert, D., Seifert, R.W., Protopappa-Siekec, M. (2013) A review of trade credit literature: Opportunities for research in operations. European Journal of Operational Research, 231(2) (December), 245-256.

Small, P.H. (1956) Operations Research from a financial viewpoint. Operations Research, 4, 581-587.

Sobol', I.M. (1993) Sensitivity estimates for nonlinear mathematical models. Mathematical Modeling and Computational Experiments, 1(4), 407-414.

Sobol', I.M. (2001) Global sensitivity indices for nonlinear mathematical models and their Monte Carlo estimates. Mathematics and Computers in Simulation, 55, 271-280.

Soper, C.S. (1959) The marginal efficiency of capital: A further note. The Economic Journal, 69 (March), 174-177.

Spearman, C. (1904) The proof and measurement of association between two things. The American Journal of Psychology, 15(1), 72-101.

Spronk, J, Hallerbach, W. (1997) Financial modelling: Where to go? With an illustration for portfolio management. European Journal of Operational Research, 99(1) (May), 113-125.

Steuer, R.E., Na, P. (2003) Multiple criteria decision making combined with finance: A categorized bibliographic study. European Journal of Operational Research, 150(3) (November), 496-515.

Talavera, D.L., Nofuentes, G., Aguilera, J. (2010) The internal rate of return of photovoltaic grid-connected systems: A comprehensive sensitivity analysis. Renewable Energy, 35(1) (January), 101-111.

Teichroew, D., Robichek, A., Montalbano, M. (1965) Mathematical analysis of rates of return under certainty. Management Science, 11, 395-403.

Teichroew, D., Robichek, A., Montalbano, M. (1965) An analysis of criteria for investment and financing decisions under certainty. Management Science, 12, 151-179.

Thomas L.C. (2010) Consumer finance: challenges for operational research. Journal of the Operational Research Society, 61(1) (January), 41-52.

Weingartner, H.M. (1963) Mathematical Programming and the Analysis of Capital Budgeting Problems, Prentice-Hall, Englewood Cliffs, NJ.

White, G.I., Sondhi, A.C., Fried, D. (1997) The Analysis and Use of Financial Statements. Second edition. Wiley, New York, USA.

Wiesemann, W., Kuhn, D., Rustem, B. (2010) Maximizing the net present value of a project under uncertainty. European Journal of Operational Research, 202(2) (April), 356-367.

Xu, X., Birge, J.R (2008) Operational decisions, capital structure, and managerial compensation: A news vendor perspective. The Enginering Economist, 53(3), 173-196.

Yang, K.K., Talbot, F.B., Patterson, J.H. (1993) Scheduling a project to maximize its net present value: An integer programming approach. European Journal of Operational Research, 64(2) (January), 188-198.