Excel has three functions to calculate the IRR ... (negative cash flows) at a rate different from the rate of reinvesting part of the positive cash flow. In cell B10, type "=MIRR(B2:B7, 0.065 ...