Union Local School District has bonds outstanding with a coupon rate of 3.7% paid semiannually and 16 years to maturity. The yield to maturitiy on these bonds is 3.9% and the bonds have a par value of $5000. What is the dollar price of the bond? Please explain in terms of excel.

XD ? 5 X Calculating a bond price - Excel FORMULAS DATA REVIEW FILE HOME INSERT PAGE LAYOUT VIEW Sign In Calibri - 11 % Paste BIU Cells Editing Alignment Number Conditional Format as Cell Formatting Table Styles Styles Clipboard Font