(d) Andere Limited has issued a $ 30,000 par value bond with a coupon rate of 8%p.a and a maturity period of 15 years. I Required: Create an excel model showing the interest and principal repayments separately and calculate the value of the bond when the required rate of return is 10% assuming (1) Interest is paid annually. (4 Marks) (1) Interest is paid semi-annually. (4 Marks)