Imagine that your supervisor in the fictitious WYZ Widget Company needs you to calculate how much of the assigned budget was actually used you can find the file here. You can then use the fill handle to drag the formula down to the rest of the scores. XIRR can be easily calculated through an excel sheet.
Open up the Format Cells dialog box by either.
For example the calculation 247 tells Excel to multiply 2 by 4 and then add 7 to the product. And compare it to the Actual Expenses sheet the next one in the file. Then type the following formula. It uses an adjustment technique known as the Newton Raphson method to calculate aggregated CAGR read XIRR for each individual investment.