Excel Finance Trick #15: PV & NPV don’t work: XNPV function
Written by Dr. Wealth on August 26th, 2010
See how to use the XNPV function for non-periodic Cash Flows. This function will do all the math for Discounting Cash Flow that are not all equal and are separated by differing time periods! Asset Valuation with Discounting Cash Flow Analysis. For complicated cash flow analysis, the XNPV function is amazing! In ThisSeries learn 17 amazing Finance Tricks. Learn about the PMT, PV, FV, NPER, RATE, SLN, DB, EFFECT, NOMINAL, NPV, XNPV, and the CUMIPMT functions that can make your financing tasks much easier in Excel. See how to use the PMT function in the standard way, but also see how to use it while incorporating a Balloon payment or a delayed payment. Lean how to translate a Nominal interest rate into an Effective Interest rate. Learn how to calculate how long it takes to pay off a credit card balance. Lean how to calculate the Effect Rate on a Payday loan. And many more financing Tricks!! The Excel Finance Tricks 1-17 will show an assortment of Excel Financing Tricks! Excel Formula
This entry was posted on Thursday, August 26th, 2010 at 3:14 am and is filed under Finance. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.
Tags: and, cash, college, community, Excel, Finance, flows, function, functions, Gel, Girvin, Highline, Mike, non, NPV, periodic, PV, XNPV
O comments at "Excel Finance Trick #15: PV & NPV don’t work: XNPV function"
Comment Now!