17
18 Price Bond A $2,000 $1,719 $1,487 $1,294 $1,134 $1,000 $887 $791
19 Price Bond B $1,000 $820 $676 $558 $463 $386 $322 $270
20 Price Bond C $3,000 $2,308 $1,815 $1,459 $1,196 $1,000 $851 $735
21
22 The formula in cell B18 is: =-PV(B16,$B$3,$B$4,$B$5,1). Then copy formula in cell B18 to cells C18, D18, E18, F18, G18,
23 H18, and I18.