Excel Forum
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




Excel Finance Class 81: XNPV Function XIRR Function - See Algorithm That XNPV uses


Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htm
Learn how to use the XNPV and XIRR function to Discount Future Cash flows to estimate an assets value (asset valuation using Discounted Cash Flow Analysis). See how the XNPV calculates -- see the XNPV algorithm. See how XNPV function calculates differently that the PV function. See that XNPV algorithm uses fraction of years based on a 365 day year for the discounting number of periods, whereas the PV just uses integers for the number of periods.





Got a Question? Ask it Here in the Forum.