Question $2$: A $$1,000$ Nova Corp. bond has a $7\%$ coupon rate that is paid semiannually. The bond matures in three years. If the current price of the bond is $$1,175,$ what is the vield to maturity?

Similar to problem type B$.$V$,$ but Do not forget to multiply the Rate$()$ outputby use the Rate$()$ function

$$ Status: Enter function

Question $3$: You are considering buying a bond that is currently priced at $$714,$ has a face value of $$1,000,$ and matures in seven years. If interest is paid semiannually and the bond has a yield to maturity of $6\mathrm{.}3\%,$ what is the bond's annual coupon rate?

Find the seminnual payments, then, multiply

by $2$ and finally divide by the facevalue

Similar to problem type B$.$V$.,$ but

$(1000)$

use the PMI$0$ function

$$

Status: Enter function

$********$

PLEASE HELP WITH QUESTION #$2$ and #$3$ USING EXCEL FORMULA