You could ask the question, "If the interest rate is (say) 3%, what investment on (say) 1/1/2003 makes the present value of the cash flow zero?" You could answer that question with Solver:
----A----- ----B----- -------------C-------------
1 01/01/2003 (4,749.82)
2 03/01/2003 600.00
3 05/25/2003 600.00
4 12/01/2003 1,000.00
5 05/05/2004 1,500.00
6 06/07/2004 600.00
7 10/05/2004 600.00
8
9 0.00 B9: =XNPV(3%, B1:B7, A1:A7)
Set B9 to zero by changing B1.
There may a way to do that with another financial function in lieu of Solver, but I don't know it.
Bookmarks