Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2023/11/NPV.xlsx

In this Microsoft Excel video I demonstrate how to calculate Net Present Value (NPV). If your cash flows are at regular intervals you can use the NPV function to perform tis calculation. If your cash flows are on specific irregularly spaced dates you can use the XNPV function.

️Timestamps
00:00 Introduction
00:29 NPV function - for regularly spaced cash flows
02:10 XNPV - for irregularly spaced cash flows



#exceltutorial #exceltips