FINE 332 Corporate bonds Module 3 Assignment.xlsx | Latest 2026 Update with complete solutions.

Question 1 - Use the coupon, par and purchase price given to show the yield to maturity (YTM)
Cash Flows
Purch. 0.5 1.0 1.5 2.0 2.5 3.0 3.5 4.0
Coupon 6.10% (788) 31 31 31 31 31 31 31 31
Par 1,000.00
YTM 10.2146%

Question 2 - Use the coupon, interest rate and par given to calculate the bond's price

0.5 1.0 1.5 2.0 2.5 3.0 3.5 4.0 4.5
Coupon 6.40% 32 32 32 32 32 32 32 32 32
Par 1,000.00
Rate 5.60%
Bond price 1,071.2306

Question 3 - Use the coupon, par and purchase price given to show the yield to maturity (YTM)
Cash Flows
Purch. 1.0 2.0 3.0 4.0 5.0 6.0 7.0 8.0
Coupon 5.55% (909) 56 56 56 56 56 56 56 56
Par 1,000.00
YTM 6.5190%

Question 4 - Use the coupon, interest rate and par given to calculate the bond's price

1.0 2.0 3.0 4.0 5.0 6.0 7.0 8.0 9.0
Coupon 6.60% 66 66 66 66 66 66 66 66 66
Par 1,000.00
Rate 6.50%
Bond price 1,012.1979

,h Flows
4.5 5.0 5.5 6.0 6.5 7.0 7.5
31 31 31 31 31 31 1,031




Cash Flows
5.0 5.5 6.0 6.5 7.0 7.5 8.0 8.5 9.0 9.5 10.0 10.5 11.0
32 32 32 32 32 32 32 32 32 32 32 32 32




h Flows
9.0 10.0 11.0 12.0 13.0 14.0 15.0
56 56 56 56 56 56 1,056




Cash Flows
10.0 11.0 12.0 13.0 14.0 15.0 16.0 17.0 18.0 19.0 20.0 21.0 22.0
66 66 66 66 66 66 66 66 66 66 66 66 66