Originally Posted by

**JakeD** CaptainBlack, I posted this in the other thread before you closed it.

Here are two ways to put this in Excel.

First way: use the IRR function for internal rate of return. Copy 2000 into 24 cells. Enter -205000 into the 25th cell. In the 26th cell use the IRR function with the 25 cells as the input array. Use initial guess .1. The answer is .1024 = 10.24%.

Second way: put .1 in a cell, call it r. Put the formula

205000 - (2000*(1+r)*(power(1+r;24)-1))/r

into another cell where r is a reference to the first cell. Use the Goal Seek tool to find the value of r that sets the formula cell to target value 0. Same result.