81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199

NPV()

Description

Calculates the net present value of an investment based on a series of periodic cash flows and a discount rate.

How To Use in Sheets

NPV(discount, cashflow1, [cashflow2, ...])

External Links

Computing Net Present Value (NPV) and Internal Rate of Return (IRR) on a series of cash flows

This tutorial video shows how to use Microsoft excel or Google sheets to compute the Net Present Value (NPV) and Internal Rate of Return (IRR) on an investment based on the expected cash flows.

0Better Sheets Tutorials

No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.