Refer to the following tableLong$-$term debt $($So $23,500$ bond contract$)$$$23,500,000$Preferred stock of this firm$2,000,000$Common stock $($$$10$ par$)$ of this firm$10,000,000$Retained earnings of this firm$4,000,000$Total debt and equity$$39,500,000$A $6\%$ coupon rate, payable semiannually, and a par of $$1,000.$ Bonds $($long term debt$)$ mature $10$ years from today. The yield to the price of the bond $*23500$ to get the market value of the ta long tem debt. Bon pete clue oblained eng the $.)$ function in Excel.$)$$$16,634,273$$$15,320,338$$$17,310,634$$$16,479,150$