A B 1 EOY Cash flow -$15,000 $2,000 $2,500 $3,000 $3,500 2 3 1 4 2 5 3 6. 4 7 $4,000 $4,000 9 7 $4,000 10 8 $4,000 11 12 A 13 F

A $15,000 investment is to be made with anticipated annual returns as shown in the spreadsheet in Figure P4-130. If the investor’s time value of money is 10% per year, what should be entered in cells B11, B12, and B13 to obtain present, annual, and future equivalent values for the investment?

Extracted text: A B 1 EOY Cash flow -$15,000 $2,000 $2,500 $3,000 $3,500 2 3 1 4 2 5 3 6. 4 7 $4,000 $4,000 9 7 $4,000 10 8 $4,000 11 12 A 13 F