Calculates the net present value of an investment based on a series of periodic cash flows and a discount rate.
NPV()
Description
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 yet. Stay tuned!