The Internal Rate of Return worksheet calculates an internal rate of return (IRR) based on the Hypothetical Terms of Sale and the Projected Post Sale Cash Flow. It assumes a sale of the business at the end of the projection period. You can edit the two blue text cells to adjust the IRR calculation .