top of page

Financial Analysis | Multidisciplinary Engineering Analysis  | 2022

NPV Vs. IRR Definitions (per the Corporate Finance Institute)

I programmed the excel application above to determine which investment option would be the best choice by determining:

  • Net Present Value

  • Internal Rate of Return

  • Payback Period


The option with two of the following was determined to be the optimal solution: Highest NPV, Highest IRR, or Lowest Payback Period

Feel free to create your own example in the excel sheet above. Replace the blue text in the "Input Values" section to your liking, and scroll down to see "Determined Values".


 

  • LinkedIn
  • Facebook
  • Contact
bottom of page