please show excel formulas

Number Styles 85 A Calculate the numbers using excel formula in the green boxes Add account labels in beige boxes 3 Put your final solution in the yellow boxes 4 AC220-Unit 6 Problems Show your work in Excel. Students must also use excel formulas 6 (Select Formulas - Financial tab in Excel for a listing of formulas) Q1. Amalgamated Realty Inc. offers a 8.5 percent coupon bond with annual payments. The yield to maturity is 10.2 percent and the maturity date is 9 years from today. What is the market price of this bond if the face value is $1,000 (Hint: Use Present Value formula) 1000 Calculate the annual coupon 0.085 7 9 Bond 1a Rate 1 Term 12 YTM 9 10,20% Price of the bond: Q2. Consider a bond with a coupon rate of 7.5% and annual coupons. The par value is $1,000, and the bond has 6 years ta maturity. The yield te maturity is 9 percent. What is the value of the band