Please provide formulas within excel! Thank you:$)$

Question $1$ D $-$ Construct a line chart showing the relationship between yield an price for this bond. Use the table to determin the price at

specfic yields.

As an investor, you are considering an investment in the bonds of Wayne Enterprises. The bonds pay interest semiannually, will

mature in nine years, and have a coupon rate of $7\%$ with a par value of $$1,000.$ Currently the bonds are selling for $$823.$

A $-$ If the required return for bonds this risky is $12\%,$ what is the highest price you would be willing to pay?

B $-$ What is the yield to maturity for these bonds?

Yield to Maturity

C $-$ What is the Macauley Duration for this Bond? What is the Modified Duration?

D $-$ Construct a line chart showing the relationship between yield an price for this bond. Use the table to determin the price at

specfic yields.