• Originally published: 22/03/2018 13:58
Publication number: ELQ-58839-1
View all versions & Certificate NPV Calculator (Excel Template)

Calculate Net Present Value with ease by using this Excel spreadsheet.

Description
Net Present Value (NPV) is used to calculate the difference between cash inflows from the investments and the cost of investments.

The formula is the following:

When cash arrivals are EVEN:
NPVt=1 to T = ∑ Xt/(1 + R)t – Xo

Where:
> Xt = total cash inflow for period t
> Xo = net initial investment expenditures
> R = discount rate, finally
> t = total time period count

When cash arrivals are UNEVEN:
NPV = [Ci1/ (1+r)1 + Ci2/(1+r)2 + Ci3/(1+r)3 + …] – Xo

Where:
> R is the specified return rate per period;
> Ci1 is the consolidated cash arrival during the first period;
> Ci2 is the consolidated cash arrival during the second period;
> Ci3 is the consolidated cash arrival during the third period, etc…

By using the NPV formula, investors can see the difference between cash inflows from the investments and cost of investments.

If the difference is positive, the project is great. If it is negative, it is not worth investors' time.

You can calculate NPV with ease by downloading this NPV calculator. Simply follow the instructions in the how-to attached.

This Best Practice includes
1 Excel File

Dheeraj Vaidya CFA FRM offers you this Best Practice for free!

Discuss

Reviews

• (last updated: 12/10/2019 10:21)
• (last updated: 20/08/2019 07:39)
• (last updated: 26/06/2019 08:45)
• (last updated: 25/10/2018 19:22)
• (last updated: 03/08/2018 08:20)
• (last updated: 29/07/2018 14:47)
• (last updated: 22/07/2018 06:29)
• (last updated: 11/06/2018 15:23)

Any questions on NPV Calculator (Excel Template)?

The user community and author are here to help. Go ahead! 