1. Ezekiel Limited issued a bond with a par value of $ 20,000, coupon rate of 8% p.a. and a maturity period of 12 years. Create a model showing the interest and principal repayment separately and calculate the value of the bond when the required rate of return is 10% if:

1. Interest is paid annually.
2. Interest is paid semi-annually.
3. What would be the value of the bond when the required rate of return is 7.5% payable semi-annually and with a maturity of 8 years?