1 ) Solve the following quesitons in an Excels spreadsheet, and create a cash-flow table for each Bond A and Bond B over 6 years. a) Calculate the yield rates for two bonds described below. b)...

1 ) Solve the following quesitons in an Excels spreadsheet, and create a cash-flow table for each Bond A and Bond B over 6 years.

a) Calculate the yield rates for two bonds described below.

b) Correctly use Rate of Return (ROR) analysis to determine which, if either, bond an investor with a MARR of 10%, should purchase.

c) Confirm your answer to part (b) using
Present Worth Analysis. Type out formulas used and calculations performed.

d) Confirm your answer to part (b) using
Annual Worth Analysis. Type out formulas used and calculations performed.

Extracted text: Bond A $8,000 $9,000 8% Annually Purchase Price Coupon Rate 6% Annually Face Value $10,000 $10,000 Matures in 6 years б уears