what formula do yoi use one excel to get the dollar price of a bond with this information?

how to calculate bond price on excel with pa Saved Help Paste Save & Exit BIU Alignment Number Conditional Format as Cell Formatting Table Cells Editing Clipboard Styles Font Styles A1 A D E G 1 2 Union Local School District has bonds outstanding with a coupon rate of 3.7 percent paid semiannually and 16 years to maturity. The yield to maturity on these bonds is 3.9 percent and the bonds have a par value of $5,000. What is the dollar price of the bond? 3 4 5 1/1/2000 Settlement date Maturity date Coupon rate Coupons per year Redemption value (% of par) Yield to maturity Par value 6 1/1/2016 7 3.70% 2 100 10 3.90% 11 5,000 12 13 Complete the following analysis. Do not hard code values in your calculations. Leave the "Basis" input blank in the function. You must use the built-in Excel function to answer this question 14 15 16 Dollar price 17 18