PLEASE POST EXCEL FORMULAS

D 5 As an investor, you are considering an investment in new bonds being issued by Stark Industries. The bonds pay interest semiannually, mature in thirty years, and have a coupon rate of 8.5% with a par value of $1,000 Currently the bonds are selling for $1,237. 7 8 Wayne Enterprices Bonds Price $ 1,237.00 Par Value $ 1,000.00 Coupon Rate 8.5% Payment Frequency 2 Settlement Date 2/28/2020 Maturity Date 2/28/2050 A - If the required return for bonds this risky is 4.6%, what is the highest price in dollars) you would be willing to pay? 4.6% 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 Required Return Valuation B - What is the actual annual yield to maturity, based on the current price, for these bonds? Yield to Maturity C- What is the Macauley Duration for this Bond? What is the Modified Duration? Macauley Duaration Modified Duration E G C D H D-Construct a line chart showing the relationship between yield an price for this bond, using the following Price Place Chart Here 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 Yield 0% 19 26 3% 495 5% 6% 7% 8% 996 10% 1196 12% 13% 14% 15% 16% 17% 18% 19% 20% 21% 22% 23% 24% 2596