Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Excel XNPV Function: Discounting non-Periodic Cash Flows. Algorithm for How it Works! EMT 1761

Posted on by Annie D

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

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.

ExcelIsFunMon, October 18, 2021 7:45pm