A corporate bond has a maturity date of 15 years and a face value of $1000. The coupon interest rate is 4%, paid semi-annually. To receive a semi-annual interest of i = 3%, how much should be paid for the bond'? What is the effective annual interest rate (in %) that you will receive on your investment? Please use the appropriate spreadsheets function and highlight the two final answers in yellow.
