XNPV:This function calculates the net present value for a series of cash flows that are not equally spaced in time. Syntax:XNPV(rate,values,dates) XIRR:This function calculates the internal rate of return for a series of cash flows that are not equally spaced in time. Syntax:XIRR(values,da...
Using the Functions in Excel: XIRR The extended internal rate of return (XIRR) function in Excel assumes irregular payment dates rather than estimates for annual periods. XIRR might be used in projects or investments like mutual funds, which are redeemed and reinvested in at various interva...
Calculating your Lending XIRR ROI in 3 Easy Steps 1. Create Spreadsheet: Open up a new spreadsheet in Microsoft Excel (or any Office program). Label one column Date and another Amount. It should look something like the image on the right. We will fill this spreadsheet with our bank account...