Please help me with how to solve this in excel.

In order to accurately assess the capital structure of a firm, it is necessary to convert its balance sheet figures from historical book values to market values. KJM Corporation's balance sheet (book values) as of today is as follows: The bonds have an 8.4% coupon rate, payable semiannually, and a par value of $1,000. They mature exactly 10 years from today. The yield to maturity is 11%, so the bonds now sell below par. What is the current market value of the firm's debt