Calculate the value of a bond that will mature in 14 years and has a $1,000 face value. The coupon is 5% per annum, payable annually. the investor’s required rate of return is 7% per annum, compounded annually. With no other changes, calculate the value of the bond if the coupon is payable semi-annually and the investor’s required rate of return is compounded semi-annually. Show step by step how to solve on excel or manually.