The XIRR function can be found using the command fx and under the category ‘Financial’. XIRR, short for Extended Internal Rate of Return, can help calculate the return when the time interval ...

Find out more about the forward price to earnings ratio and how to calculate the forward price to earnings ratios of companies in Microsoft Excel.

Excel 2013 provides the DATE and XIRR functions, which derive the final annual interest rate from a series of payments on known dates.

Excel's built-in XIRR function allows investors to input cash flows and their respective dates to get an accurate rate of return.