Main Profile

At A Glance

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.
Length: 12:40

Contact

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

Want more info about Excel Finance Class 81: XNPV Function XIRR Function - See Algorithm That XNPV uses? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question