Consulting | Excel Examples
Keywords: IRR, XIRR, NPV, XNPV, Worksheet Function, Auditing Features, Precedents
Description: Demonstration of financial functions used to calculate internal rate of return and net present value.
Tip: You can use IRR and NPV to calculate internal rate of return and net present value for even cash flows. For uneven cash flows, use the XIRR and XNPV functions found in the Analysis Pak Add-In.
Guide to the Example: Formulas on the worksheet "Financial Functions" demonstrate Net Present Value and Internal Rate of Return for both regular and irregular cash flows. The arrows provided by the Audit feature show where each formula obtains its input values.
Download File: Click Here
Tip: Click on the link above and choose "Save" to download the xls workbook to your hard drive or "Open" to open the workbook inside of your browser.