Net Present Value (NPV)
Based on the concept of Time Value of Money. Highly related to the concept of Present Value of Money.
Net Present Value () represents the total present value of a series of future cash flows, adjusted for the Time Value of Money. It’s a key metric for evaluating investment profitability.
Mathematically, it is calculated as:
Where:
- : cash flow at time
- : discount rate or required rate of return
- : number of periods
Or using the excel function Excel Function - NPV