Download Excel File: https://excelisfun.net/files/EMT1761.xlsx
Learn how to use the XNPV function to discount non-periodic future cash flows to value investments.
This video answers the question: why does the NPV and XNPV function yield different answers. Look at the algorithm for the XNPV function.
Learn the algorithm for the XNPV function, which is different than the more common NPV function. The advantage to the XNPV function is that you can have non-periodic time periods and the cash flow at time zero, the cots, is included in cash flow range.
(00:00) Introduction
(00:31) How to use XNPV function
(01:06) What is algorithm for the XNPV function
(02:51) Bonus formula that shows a single cell array formula for the XNPV algorithm.
(03:33) Conclusion