Account Internal Rate of Return - Version 04.2003b

This model calculates the internal rate of return on an investment account that has a series of deposits and/or withdrawals. The worksheet currently accommodates up to forty deposit or withdrawal events. The data entry cells are identified with a blue background. All other cells are locked. All deposits should be entered as positive numbers and withdrawals should be entered as negative numbers.

Data Entry

Period End Date: Enter the last day of the period over which you want to calculate the internal rate of return.

Balance on End Date: Enter the account balance on the Period End Date.

Date of Investment Or Withdrawal: Enter in this column the dates of each respective deposit or withdrawal event that the account has experienced in the period being examined.

Amount Invested or Withdrawn: Enter in this column the amount of each deposit or withdrawal corresponding to the date entered in the left column. All Deposits should be entered as positive numbers and withdrawals should be entered as negative numbers.

The calculator model then outlines for you the total contributions, the total withdrawals and the overall net investment. Finally, the model indicates the annualized internal rate of return in the account.