Excel Forum

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.