F Future payment cash flow i Discount rate or interest rate n the number of periods in the future the cash flow is. B14 in our example. Mathematically NPV Formula is represented as NPV Cash Flows 1- it Initial Investment.
In order to calculate NPV subtract investment value cash outflow from Sum of Present Value PV of all future cash flows.
This relationship is critical to understanding the IRR. Net Present Value 51818 - 50000 1818. The NPV is the PV present value of all cash inflows minus the PV of all cash outflows. You will be left with either a positive or a negative value.