IDEAS home Printed from https://ideas.repec.org/p/pra/mprapa/95266.html
   My bibliography  Save this paper

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

Author

Listed:
  • Marchioni, Andrea
  • Magni, Carlo Alberto

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.

Suggested Citation

  • Marchioni, Andrea & Magni, Carlo Alberto, 2018. "Investment decisions and sensitivity analysis: NPV-consistency of rates of return," MPRA Paper 95266, University Library of Munich, Germany.
    • Handle: RePEc:pra:mprapa:95266
    as

    Download full text from publisher

    File URL: https://mpra.ub.uni-muenchen.de/95266/1/MPRA_paper_95266.pdf
    File Function: original version
    Download Restriction: no
    ---><---

    Other versions of this item:

    References listed on IDEAS

    as
    1. 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, Elsevier, vol. 205(1), pages 227-236, August.
    2. Leyman, Pieter & Vanhoucke, Mario, 2017. "Capital- and resource-constrained project scheduling with net present value optimization," European Journal of Operational Research, Elsevier, vol. 256(3), pages 757-776.
    3. J Brimberg & P Hansen & G Laporte & N Mladenović & D Urošević, 2008. "The maximum return-on-investment plant location problem with market share," Journal of the Operational Research Society, Palgrave Macmillan;The OR Society, vol. 59(3), pages 399-406, March.
    4. Ekern, Steinar, 1981. "Time Dominance Efficiency Analysis," Journal of Finance, American Finance Association, vol. 36(5), pages 1023-1034, December.
    5. Magni, Carlo Alberto, 2015. "Investment, financing and the role of ROA and WACC in value creation," European Journal of Operational Research, Elsevier, vol. 244(3), pages 855-866.
    6. de Faro, Clovis, 1978. "A Sufficient Condition for a unique Nonnegative Internal Rate of Return: Further Comments," Journal of Financial and Quantitative Analysis, Cambridge University Press, vol. 13(3), pages 577-584, September.
    7. Helga Meier & Nicos Christofides & Gerry Salkin, 2001. "Capital Budgeting Under Uncertainty---An Integrated Approach Using Contingent Claims Analysis and Integer Programming," Operations Research, INFORMS, vol. 49(2), pages 196-206, April.
    8. Emanuele Borgonovo, 2010. "A Methodology for Determining Interactions in Probabilistic Safety Assessment Models by Varying One Parameter at a Time," Risk Analysis, John Wiley & Sons, vol. 30(3), pages 385-399, March.
    9. Murthi, B. P. S. & Choi, Yoon K. & Desai, Preyas, 1997. "Efficiency of mutual funds and portfolio performance measurement: A non-parametric approach," European Journal of Operational Research, Elsevier, vol. 98(2), pages 408-418, April.
    10. Carlo Alberto Magni, 2015. "Investment, financing and the role of ROA and WACC in value creation," Department of Economics 0050, University of Modena and Reggio E., Faculty of Economics "Marco Biagi".
    11. Jacek Gondzio & Roy Kouwenberg, 2001. "High-Performance Computing for Asset-Liability Management," Operations Research, INFORMS, vol. 49(6), pages 879-891, December.
    12. Carlo Alberto Magni, 2014. "Mathematical Analysis of Average Rates of Return and Investment Decisions: The Missing Link," The Engineering Economist, Taylor & Francis Journals, vol. 59(3), pages 175-206, July.
    13. James E. Foster & Tapan Mitra, 2003. "Ranking investment projects," Economic Theory, Springer;Society for the Advancement of Economic Theory (SAET), vol. 22(3), pages 469-494, October.
    14. Magni, Carlo Alberto, 2016. "Capital depreciation and the underdetermination of rate of return: A unifying perspective," Journal of Mathematical Economics, Elsevier, vol. 67(C), pages 54-79.
    15. Seifert, Daniel & Seifert, Ralf W. & Protopappa-Sieke, Margarita, 2013. "A review of trade credit literature: Opportunities for research in operations," European Journal of Operational Research, Elsevier, vol. 231(2), pages 245-256.
    16. Carlo Alberto Magni, 2010. "Average internal rate of return and investment decisions: A new perspective," PROYECCIONES FINANCIERAS Y VALORACION 006653, MASTER CONSULTORES.
    17. Joy, O Maurice & Bradley, Jerry O, 1973. "A Note on Sensitivity Analysis of Rates of Return," Journal of Finance, American Finance Association, vol. 28(5), pages 1255-1261, December.
    18. E. Borgonovo & S. Tarantola & E. Plischke & M. D. Morris, 2014. "Transformations and invariance in the sensitivity analysis of computer experiments," Journal of the Royal Statistical Society Series B, Royal Statistical Society, vol. 76(5), pages 925-947, November.
    19. Daniel Teichroew & Alexander A. Robichek & Michael Montalbano, 1965. "An Analysis of Criteria for Investment and Financing Decisions Under Certainty," Management Science, INFORMS, vol. 12(3), pages 151-179, November.
    20. John Board & Charles Sutcliffe & William T. Ziemba, 2003. "Applying Operations Research Techniques to Financial Markets," Interfaces, INFORMS, vol. 33(2), pages 12-24, April.
    21. Bart Baesens & Rudy Setiono & Christophe Mues & Jan Vanthienen, 2003. "Using Neural Network Rule Extraction and Decision Tables for Credit-Risk Evaluation," Management Science, INFORMS, vol. 49(3), pages 312-329, March.
    22. Menezes, Mozart B.C. & Kim, Seokjin & Huang, Rongbing, 2015. "Return-on-investment (ROI) criteria for network design," European Journal of Operational Research, Elsevier, vol. 245(1), pages 100-108.
    23. Danaher, Peter J. & Rust, Roland T., 1996. "Determining the optimal return on investment for an advertising campaign," European Journal of Operational Research, Elsevier, vol. 95(3), pages 511-521, December.
    24. Myung, Young-Soo & Kim, Hu-gon & Tcha, Dong-wan, 1997. "A bi-objective uncapacitated facility location problem," European Journal of Operational Research, Elsevier, vol. 100(3), pages 608-616, August.
    25. Richard F. Hespos & Paul A. Strassmann, 1965. "Stochastic Decision Trees for the Analysis of Investment Decisions," Management Science, INFORMS, vol. 11(10), pages 244-259, August.
    26. Carlo Magni, 2013. "The Internal Rate of Return Approach and the AIRR Paradigm: A Refutation and a Corroboration," The Engineering Economist, Taylor & Francis Journals, vol. 58(2), pages 73-111.
    27. Talavera, D.L. & Nofuentes, G. & Aguilera, J., 2010. "The internal rate of return of photovoltaic grid-connected systems: A comprehensive sensitivity analysis," Renewable Energy, Elsevier, vol. 35(1), pages 101-111.
    28. Gordon Hazen, 2009. "An Extension of the Internal Rate of Return to Stochastic Cash Flows," Management Science, INFORMS, vol. 55(6), pages 1030-1034, June.
    29. Rivett, Patrick, 1974. "Perspective for operational research," Omega, Elsevier, vol. 2(2), pages 225-233, April.
    30. Borgonovo, E. & Peccati, L., 2006. "Uncertainty and global sensitivity analysis in the evaluation of investment projects," International Journal of Production Economics, Elsevier, vol. 104(1), pages 62-73, November.
    31. Peter J. Barry & Lindon J. Robison, 2014. "Technical Note: Economic Rates of Return and Investment Analysis," The Engineering Economist, Taylor & Francis Journals, vol. 59(3), pages 231-236, July.
    32. Daniel Teichroew & Alexander A. Robichek & Michael Montalbano, 1965. "Mathematical Analysis of Rates of Return Under Certainty," Management Science, INFORMS, vol. 11(3), pages 395-403, January.
    33. Bernhard, Richard H., 1980. "A Simplification and an Extension of the Bernhard-deFaro Sufficient Condition for a Unique Non-Negative Internal Rate of Return," Journal of Financial and Quantitative Analysis, Cambridge University Press, vol. 15(1), pages 201-209, March.
    34. Wiesemann, Wolfram & Kuhn, Daniel & Rustem, Berç, 2010. "Maximizing the net present value of a project under uncertainty," European Journal of Operational Research, Elsevier, vol. 202(2), pages 356-367, April.
    35. Borgonovo, E. & Peccati, L., 2006. "The importance of assumptions in investment evaluation," International Journal of Production Economics, Elsevier, vol. 101(2), pages 298-311, June.
    36. Rapp, Birger, 1980. "The internal rate of return method -- A critical study," Engineering Costs and Production Economics, Elsevier, vol. 5(1), pages 43-52, June.
    37. Mørch, Ove & Fagerholt, Kjetil & Pantuso, Giovanni & Rakke, Jørgen, 2017. "Maximizing the rate of return on the capital employed in shipping capacity renewal," Omega, Elsevier, vol. 67(C), pages 42-53.
    38. Herroelen, Willy S. & Van Dommelen, Patrick & Demeulemeester, Erik L., 1997. "Project network models with discounted cash flows a guided tour through recent developments," European Journal of Operational Research, Elsevier, vol. 100(1), pages 97-121, July.
    39. Yang, Kum Khiong & Talbot, F. Brian & Patterson, James H., 1993. "Scheduling a project to maximize its net present value: An integer programming approach," European Journal of Operational Research, Elsevier, vol. 64(2), pages 188-198, January.
    40. Meir J. Rosenblatt & Zilla Sinuany-Stern, 1989. "Generating the Discrete Efficient Frontier to the Capital Budgeting Problem," Operations Research, INFORMS, vol. 37(3), pages 384-394, June.
    41. Cigola, Margherita & Peccati, Lorenzo, 2005. "On the comparison between the APV and the NPV computed via the WACC," European Journal of Operational Research, Elsevier, vol. 161(2), pages 377-385, March.
    42. Ashford, Robert W. & Berry, Robert H. & Dyson, Robert G., 1988. "Operational research and financial management," European Journal of Operational Research, Elsevier, vol. 36(2), pages 143-152, August.
    43. Carlo Alberto Magni, 2010. "Average internal rate of return and investment decisions: A new perspective," Proyecciones Financieras y Valoración 6653, Master Consultores.
    44. Borgonovo, E., 2010. "Sensitivity analysis with finite changes: An application to modified EOQ models," European Journal of Operational Research, Elsevier, vol. 200(1), pages 127-138, January.
    45. Steuer, Ralph E. & Na, Paul, 2003. "Multiple criteria decision making combined with finance: A categorized bibliographic study," European Journal of Operational Research, Elsevier, vol. 150(3), pages 496-515, November.
    46. Grubbström, RW & Ashcroft, SH, 1991. "Application of the calculus of variations to financing alternatives," Omega, Elsevier, vol. 19(4), pages 305-316.
    47. Jessica Lima e Silva & Vinicius Amorim Sobreiro & Herbert Kimura, 2018. "Prepurchase financing pool: Revealing the IRR problem," The Engineering Economist, Taylor & Francis Journals, vol. 63(2), pages 158-170, April.
    48. Ben-Horin, Moshe & Kroll, Yoram, 2017. "A simple intuitive NPV-IRR consistent ranking," The Quarterly Review of Economics and Finance, Elsevier, vol. 66(C), pages 108-114.
    49. Frank Fabozzi & Dashan Huang & Guofu Zhou, 2010. "Robust portfolios: contributions from operations research and finance," Annals of Operations Research, Springer, vol. 176(1), pages 191-220, April.
    50. L C Thomas, 2010. "Consumer finance: challenges for operational research," Journal of the Operational Research Society, Palgrave Macmillan;The OR Society, vol. 61(1), pages 41-52, January.
    51. Kumbhakar, Subal C., 2011. "Estimation of production technology when the objective is to maximize return to the outlay," European Journal of Operational Research, Elsevier, vol. 208(2), pages 170-176, January.
    52. Borgonovo, E. & Peccati, L., 2004. "Sensitivity analysis in investment project evaluation," International Journal of Production Economics, Elsevier, vol. 90(1), pages 17-25, July.
    53. Borgonovo, Emanuele & Plischke, Elmar, 2016. "Sensitivity analysis: A review of recent advances," European Journal of Operational Research, Elsevier, vol. 248(3), pages 869-887.
    54. Pasqual, Joan & Padilla, Emilio & Jadotte, Evans, 2013. "Technical note: Equivalence of different profitability criteria with the net present value," International Journal of Production Economics, Elsevier, vol. 142(1), pages 205-210.
    55. Li, Jie & Jo Min, K. & Otake, Toshitsugu & Van Voorhis, Timothy, 2008. "Inventory and investment in setup and quality operations under Return On Investment maximization," European Journal of Operational Research, Elsevier, vol. 185(2), pages 593-605, March.
    56. Spronk, Jaap & Hallerbach, Winfried, 1997. "Financial modelling: Where to go? With an illustration for portfolio management," European Journal of Operational Research, Elsevier, vol. 99(1), pages 113-125, May.
    57. J Brimberg & C ReVelle, 2000. "The maximum return-on-investment plant location problem," Journal of the Operational Research Society, Palgrave Macmillan;The OR Society, vol. 51(6), pages 729-735, June.
    58. Maria Teresa Bosch-Badia & Joan Montllor-Serrats & Maria Antonia Tarrazon-Rodon, 2014. "Capital Budgeting and Shareholders’ Value: Investment Projects Versus Courses of Action," The Engineering Economist, Taylor & Francis Journals, vol. 59(3), pages 207-230, July.
    Full references (including those not matched with items on IDEAS)

    Citations

    Citations are extracted by the CitEc Project, subscribe to its RSS feed for this item.
    as


    Cited by:

    1. Quan Dai & Hongfei Jia & Yao Liu, 2020. "Private vehicle-based crowdshipping for intercity express transportation: Feasibility assessment," International Journal of Distributed Sensor Networks, , vol. 16(2), pages 15501477209, February.
    2. Andrea Marchioni & Carlo Alberto Magni & Davide Baschieri, 2020. "Investment and Financing Perspectives for a Solar Photovoltaic Project," MIC 2020: The 20th Management International Conference,, University of Primorska Press.
    3. Khulan Myagmar & Bayanjargal Darkhijav & Tsolmon Renchin & Dugarjav Chultem, 2023. "Cost–benefit analysis for riverbank erosion control approaches in the steppe area," Environment, Development and Sustainability: A Multidisciplinary Approach to the Theory and Practice of Sustainable Development, Springer, vol. 25(9), pages 9251-9266, September.
    4. Carlo Alberto Magni & Stefano Malagoli & Andrea Marchioni & Giovanni Mastroleo, 2020. "Rating firms and sensitivity analysis," Journal of the Operational Research Society, Taylor & Francis Journals, vol. 71(12), pages 1940-1958, December.
    5. Schosser, Josef, 2019. "Consistency between principal and agent with differing time horizons: Computing incentives under risk," European Journal of Operational Research, Elsevier, vol. 277(3), pages 1113-1123.
    6. Magni, Carlo Alberto & Marchioni, Andrea, 2018. "Project appraisal and the Intrinsic Rate of Return," MPRA Paper 95262, University Library of Munich, Germany.
    7. Magni, Carlo Alberto & Marchioni, Andrea, 2019. "Performance measurement and decomposition of value added," MPRA Paper 95258, University Library of Munich, Germany.
    8. Marek Walacik & Małgorzata Renigier‐Biłozor & Aneta Chmielewska & Artur Janowski, 2020. "Property sustainable value versus highest and best use analyzes," Sustainable Development, John Wiley & Sons, Ltd., vol. 28(6), pages 1755-1772, November.
    9. Sławomir Kurpaska & Mirosław Janowski & Maciej Gliniak & Anna Krakowiak-Bal & Urszula Ziemiańczyk, 2021. "The Use of Geothermal Energy to Heating Crops under Cover: A Case Study of Poland," Energies, MDPI, vol. 14(9), pages 1-25, May.
    10. Magni, Carlo Alberto & Marchioni, Andrea, 2020. "Average rates of return, working capital, and NPV-consistency in project appraisal: A sensitivity analysis approach," International Journal of Production Economics, Elsevier, vol. 229(C).
    11. Magni, Carlo Alberto & Marchioni, Andrea & Baschieri, Davide, 2023. "The Attribution Matrix and the joint use of Finite Change Sensitivity Index and Residual Income for value-based performance measurement," European Journal of Operational Research, Elsevier, vol. 306(2), pages 872-892.
    12. Carlo Alberto Magni & Andrea Marchioni, 2022. "Performance attribution, time-weighted rate of return, and clean finite change sensitivity index," Journal of Asset Management, Palgrave Macmillan, vol. 23(1), pages 62-72, February.

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Magni, Carlo Alberto & Marchioni, Andrea & Baschieri, Davide, 2023. "The Attribution Matrix and the joint use of Finite Change Sensitivity Index and Residual Income for value-based performance measurement," European Journal of Operational Research, Elsevier, vol. 306(2), pages 872-892.
    2. Magni, Carlo Alberto, 2016. "Capital depreciation and the underdetermination of rate of return: A unifying perspective," Journal of Mathematical Economics, Elsevier, vol. 67(C), pages 54-79.
    3. Magni, Carlo Alberto, 2015. "Investment, financing and the role of ROA and WACC in value creation," European Journal of Operational Research, Elsevier, vol. 244(3), pages 855-866.
    4. Magni, Carlo Alberto & Marchioni, Andrea, 2020. "Average rates of return, working capital, and NPV-consistency in project appraisal: A sensitivity analysis approach," International Journal of Production Economics, Elsevier, vol. 229(C).
    5. Andrea Marchiioni & Carlo Alberto Magni, 2016. "Sensitivity analysis and investment decisions: NPV-consistency of rates of return," Department of Economics 0089, University of Modena and Reggio E., Faculty of Economics "Marco Biagi".
    6. Carlo Alberto Magni, 2015. "Investment, financing and the role of ROA and WACC in value creation," Department of Economics 0050, University of Modena and Reggio E., Faculty of Economics "Marco Biagi".
    7. Magni, Carlo Alberto & Veronese, Piero & Graziani, Rebecca, 2017. "Chisini means and rational decision making: Equivalence of investment criteria," MPRA Paper 81532, University Library of Munich, Germany.
    8. Carlo Alberto Magni & Stefano Malagoli & Andrea Marchioni & Giovanni Mastroleo, 2020. "Rating firms and sensitivity analysis," Journal of the Operational Research Society, Taylor & Francis Journals, vol. 71(12), pages 1940-1958, December.
    9. Magni, Carlo Alberto & Marchioni, Andrea, 2019. "Performance measurement and decomposition of value added," MPRA Paper 95258, University Library of Munich, Germany.
    10. Magni, Carlo Alberto, 2015. "Aggregate Return On Investment for investments under uncertainty," International Journal of Production Economics, Elsevier, vol. 165(C), pages 29-37.
    11. Carlo Alberto Magni, 2015. "ROI and profitability index: A note on managerial performance," Department of Economics 0048, University of Modena and Reggio E., Faculty of Economics "Marco Biagi".
    12. Gino Favero & Gherardo Piacitelli, 2024. "Irr and equivalence of cash-flow streams, loans, and portfolios of bonds," Decisions in Economics and Finance, Springer;Associazione per la Matematica, vol. 47(2), pages 379-399, December.
    13. Carlo Alberto Magni, 2010. "Average Internal Rate of Return and investment decisions: A new perspective," Centro Studi di Banca e Finanza (CEFIN) (Center for Studies in Banking and Finance) 0021, Universita di Modena e Reggio Emilia, Dipartimento di Economia "Marco Biagi".
    14. Weber, Thomas A., 2014. "On the (non-)equivalence of IRR and NPV," Journal of Mathematical Economics, Elsevier, vol. 52(C), pages 25-39.
    15. Alexandr V. Zhevnyak, . "Reference," NEW CONCEPT OF RETURN ON BORROWED AND INVESTMENT PROJECTS,, Socionet.
    16. Mørch, Ove & Fagerholt, Kjetil & Pantuso, Giovanni & Rakke, Jørgen, 2017. "Maximizing the rate of return on the capital employed in shipping capacity renewal," Omega, Elsevier, vol. 67(C), pages 42-53.
    17. Magni, Carlo Alberto & Marchioni, Andrea, 2018. "Project appraisal and the Intrinsic Rate of Return," MPRA Paper 95262, University Library of Munich, Germany.
    18. Cuthbert, James R. & Magni, Carlo Alberto, 2016. "Measuring the inadequacy of IRR in PFI schemes using profitability index and AIRR," International Journal of Production Economics, Elsevier, vol. 179(C), pages 130-140.
    19. Magni, Carlo Alberto, 2009. "Splitting up value: A critical review of residual income theories," European Journal of Operational Research, Elsevier, vol. 198(1), pages 1-22, October.
    20. Carlo Alberto Magni & Ken V. Peasnell, 2015. "The Term Structure of Capital Values:An accounting-based framework for measuring economic profitability," Department of Economics 0060, University of Modena and Reggio E., Faculty of Economics "Marco Biagi".

    More about this item

    Keywords

    Finance; sensitivity analysis; investment decisions; NPV; Return On Investment; consistency; average; AIRR;
    All these keywords.

    JEL classification:

    • C02 - Mathematical and Quantitative Methods - - General - - - Mathematical Economics
    • C67 - Mathematical and Quantitative Methods - - Mathematical Methods; Programming Models; Mathematical and Simulation Modeling - - - Input-Output Models
    • G31 - Financial Economics - - Corporate Finance and Governance - - - Capital Budgeting; Fixed Investment and Inventory Studies

    NEP fields

    This paper has been announced in the following NEP Reports:

    Statistics

    Access and download statistics

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:pra:mprapa:95266. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Joachim Winter (email available below). General contact details of provider: https://edirc.repec.org/data/vfmunde.html .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.