Net Present Value (NPV), Internal Rate of Return (IRR), and Payback Period are essential capital budgeting and investment appraisal tools used to evaluate the profitability, risk, and liquidity of projects or investments. This page explains NPV as the difference between the present value of cash inflows and outflows, helping investors determine whether an investment is profitable in dollar terms, while IRR represents the discount rate that makes NPV zero, providing a percentage return to compare against the cost of capital. It also details the Payback Period and Discounted Payback Period, which measure the time required to recover the initial investment, highlighting the difference between simple payback (ignoring time value of money) and discounted payback (accounting for time value of money). Through practical examples, formulas, and step-by-step calculations, this guide demonstrates how investors, financial analysts, and corporate managers can use NPV, IRR, and payback metrics to make informed investment decisions, assess project viability, manage cash flow risk, and optimize capital allocation.

What is Net Present Value (NPV)?

Net Present Value (NPV) is a financial metric used to evaluate the profitability of an investment or project. It represents the difference between the present value of cash inflows and the present value of cash outflows over a period of time. A positive NPV indicates that the projected earnings (in present value terms) exceed the anticipated costs, making the investment potentially profitable.

NPV Formula

Example:
Suppose you are considering an investment that requires an initial outlay of 10,000andisexpectedtogeneratecashinflowsof10,000andisexpectedtogeneratecashinflowsof3,000, 4,000,4,000,5,000, and $6,000 over the next four years. The discount rate is 10%.

NPV=3,000/(1+0.10)1+4,000/(1+0.10)2+5,000/(1+0.10)3+6,000/(1+0.10)4−10,000

Calculating each term:

NPV=3,000/1.10+4,000/1.21+5,000/1.331+6,000/1.4641−10,000​

NPV=2,727.27+3,305.79+3,756.57+4,098.08−10,000

NPV=13,887.71−10,000=3,887.71

The NPV is $3,887.71, indicating the investment is profitable.

NPV Calculator

What is Internal Rate of Return (IRR)?

The Internal Rate of Return (IRR) is the discount rate that makes the Net Present Value (NPV) of all cash flows from a particular project or investment equal to zero. In other words, it is the rate of return at which the present value of cash inflows equals the present value of cash outflows. IRR is used to evaluate the attractiveness of an investment.

IRR Formula

Example:
Using the same example as above, the IRR is the rate rr that satisfies the equation:

0=3,000/(1+IRR)1+4,000/(1+IRR)2+5,000/(1+IRR)3+6,000/(1+IRR)4−10,0000

Solving for IRR requires trial and error or a financial calculator. Let’s assume the IRR is 20% (for illustration purposes).

0=3,000/1.20+4,000/1.44+5,000/1.728+6,000/2.0736−10,0000

0=2,500+2,777.78+2,893.52+2,893.52−10,0000

0=11,064.82−10,0000

≈1,064.820

Since the result is not zero, we adjust the IRR until the equation balances. Suppose the actual IRR is 25%:

0=3,000/1.25+4,000/1.5625+5,000/1.9531+6,000/2.4414−10,0000

0=2,400+2,560+2,560+2,457.83−10,0000

0=9,977.83−10,0000

≈−22.170

The IRR is approximately 25%, meaning the investment yields a 25% return.

IRR Calculator

Key Differences:

  • NPV provides a dollar value of profitability, while IRR provides a percentage return.
  • NPV is better for comparing projects of different sizes, while IRR is useful for understanding the return relative to the cost of capital.

What is Payback Period?

How can we calculate Payback Period?

Payback Period and Discounted Payback Period are financial metrics used to evaluate the time it takes for an investment to recover its initial cost. They help assess the risk and liquidity of an investment.

The Payback Period is the time it takes for an investment to generate cash flows that equal the initial investment cost. It does not consider the time value of money.

Formula:

Payback Period=Initial Investment/Annual Cashflow ⃒ If Cashflow is even​.

Example:

  • Initial Investment: $10,000
  • Annual Cash Inflows: $2,500 per year

Payback Period=10,000/2,500=4 years

The investment will recover its cost in 4 years.

If cash inflows are uneven or the cumulative sum of cash inflow do not exactly match with initial investment, then the payback period is calculated by adding up the cash inflows until the initial investment is recovered by using the following formula.

Payback Period= Year (where CCF-Cumulative Cash Flow just become 0 or negative but after that become positive) + (Initial Investment- CCF)/ CF of after that year where cumulative sum exceeded the initial investment.

YearCash FlowCumulative Discounted Cash Flow
1$3,000$3,000
2$3,000$6,000
3$3,000$9,000
4$3,000$12,000
5$3,000$15,000

Payback Period= 3 + (10,000-9000)/3000 Years = 3.33 Years

Payback Period Calculator

What is Discounted Payback Period?

The Discounted Payback Period is similar to the payback period but accounts for the time value of money by discounting the cash flows. It measures how long it takes for the discounted cash flows to equal the initial investment.

Formula:

Discounted Payback Period=Time when cumulative discounted cash flows≥Initial Investment

Steps:

  1. Calculate the discounted cash flows for each period using the formula:

Discounted Cash Flow=Cash Flow/(1+r)t ​

Where:

  1. r = discount rate
  2. t = time period
  3. Add up the discounted cash flows until the cumulative value equals or exceeds the initial investment.

Example:

  • Initial Investment: $10,000
  • Annual Cash Inflows: $3,000 per year for 5 years
  • Discount Rate: 10%
YearCash FlowDiscount Factor (1/(1+0.10)t )Discounted Cash FlowCumulative Discounted Cash Flow
1$3,0000.9091$2,727.27$2,727.27
2$3,0000.8264$2,479.20$5,206.47
3$3,0000.7513$2,253.90$7,460.37
4$3,0000.6830$2,049.00$9,509.37
5$3,0000.6209$1,862.70$11,372.07

The cumulative discounted cash flow exceeds the initial investment of $10,000 between Year 4 and Year 5. To find the exact discounted payback period:

Discounted Payback Period= Year (where CDCF-Cumulative Discounted Cash Flow just become 0 or negative but after that become positive) + (Initial Investment- CDCF)/ DCF of after that year where cumulative sum exceeded the initial investment.

Discounted Payback Period= 4 + (10,000−9,509.37)/1,862.70 = 4.26 years

The discounted payback period is 4.26 years.

Discounted Payback Period Calculator

Key Differences between Payback Period and Discounted Payback Period

  • Payback Period: Ignores the time value of money and is simpler to calculate.
  • Discounted Payback Period: Accounts for the time value of money, making it more accurate but more complex.

Both metrics are useful for assessing the risk of an investment, but the discounted payback period is generally preferred for longer-term projects where the time value of money is significant.

Written By-Md Kollol Hossain, CEO, CapitalinsightBD

To know more about financial terms, visit here.

DSE Weekly Market Summary

S&P 500 Weekly Market Summary

Identify Consistently Performing DSE Stocks– A Comprehensive Guide

This article is for educational purposes only and does not constitute financial or investment advice.