How to Use Excel To Calculate Investment Portfolio Returns | eHow
Excel contains an internal rate of return formula that calculates your annual portfolio return rate. ... Step 5 Enter the internal rate of return formula in cell C1 using the formula "=XIRR([the cells containing the values],[the cells containing the dates...