Emory Health has a bond issue outstanding with a coupon rate of 8 percent and five years remaining until maturity. The par value of the bond is $1,000, and the bond pays interest annually.

1. Determine the current value of the bond if present market conditions justify a 12 percent required rate of return.
2. Now, suppose Emorys five-year bond had semi-annual coupon payments. What would be its current value? Assume an 8 percent return.
3. Assume that Emorys bond had a semi-annual coupon, but 10 years remaining to maturity. What is the current value under these conditions? Assume an 8 percent return.

Please show in Excel