Task 1 Determine the price of a bond with principal 1000 that pays a coupon rate of 10 %. The yield is 9.3 %. Today is April 12th, 2018; maturity is April 12th, 2020. Use two different ways: (1.1) Tabulate the cash flows and the discount factors in the worksheet and sum the PVs of the cash flows. (1.2) Use the Excel function PRICE()

Task 2 Determine the yield of a bond. The principal is 1000, coupon rate is 5 %. Today's price is 989.5. Today is April 12th 2018; maturity is April 12th , 2021. Use two different ways:

(2.1) Tabulate the cash flows and the discount factors and use Excel's GoalSeek.

(2.2) Use the Excel function YIELD()