A $15,000 investment is to be made with anticipated annual returns as shown in the spreadsheet in

Question:

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?

Figure P4-130:

B EOY Cash flow -$15,000 $2,000 3 1 $2,500 3 $3,000 4 $3,500 $4,000 $4,000 8 6 $4,000 10 $4,000 11 12 13