Net Present Value vs. Internal Rate of Return - the Basics
How confident are you that you understand the metrics, Net Present Value (NPV) and Internal Rate of Return (IRR), and know how and when to use them?
This article provides a brief introduction to NPV and IRR and mentions some advantages and disadvantages of each. This is a prelude to the Masterclass, How to Do Financial Evaluation using NPV and IRR to be hosted by the Moolman Institute on 25 May 2021.
Why Does Money have a Time Value?
Money has a time value. The same amount of money is worth more in the present than in the future. To understand why this is so, imagine that you will receive $1 million at a specific date. There is a huge difference between that date being now or 40 years into the future. Until you receive the money, you cannot do anything with it.
This is why money has a time value – because of the opportunity cost. Money in the present is worth more than the same amount of money in the future, because of its potential earning capacity. When you have the money, you can do things with it (such as investing it and earning a return).
What are Present Value and Future Value?
If money has a time value, then one should be able to calculate its value at any one point in time based on knowledge of its value at another point in time, as well as the relevant rate of change of value versus time.
The value of money at the present time is referred to as Present Value and at a future time Future Value.
Below are two equations for converting values from the present to a future date and the inverse.
where P = Present Value
F = Future Value
r = discount rate per period n (typically per year)
n= number of periods (typically years)
The process of moving money backwards in time from a future time to the present time is called discounting and moving forwards in time from the present to the future is called compounding.
What is Net Present Value (NPV)?
When you want to assess the financial implications of a project, company, investment, technology or expense, you need to look at all the cash flows (in and out) and their timing (remember that money has a time value). How does the total incoming cash flow compare with the total outgoing cash flow?
Stated in another way, if we look at the present values of all the cash inflows and outflows (to compare apples with apples), is it net positive or net negative? What is its magnitude compared with other options?
To answer this question, we use the Net Present Value.
Spreadsheets such as Excel have a built-in NPV function.
What is Internal Rate of Return (IRR) ?
The Internal Rate of Return or IRR is a measure of the size of the returns vs. the size of the investment for a series of cash flows in the form of a percentage return. The series of cash flows is usually that which is generated by a project, company, investment or technology.
Although not exactly the same, at the simplest level you can think of the IRR as interest to be earned on an investment or deposit. (A big difference is that IRR is usually not guaranteed, but rather an estimate of potential future returns.)
The IRR is not that easy to calculate, but luckily most spreadsheet software have built-in IRR functions.
So… Which is Better – NPV or IRR? Which Should I use to Evaluate My Company or Technology?
Both NPV and IRR have advantages and disadvantages:
Whilst NPV takes into account cost of capital, it is difficult to determine what rate you should use. Whilst IRR (as a percentage return) is more intuitive to understand, it cannot be used in all situations and can overstate returns.
The short answer regarding which is better: you should strive to always use BOTH! They each provide a different view on the financial viability or attractiveness of the investment opportunity.
Don’t miss out on this online masterclass, it’s free. Limited seats are available.
Note: these masterclasses are excerpts from the Moolman Institute’s Financial Modeling for Entrepreneurs Course Series.