if this can get an excel explanation as well i would super appreciate that.

Suppose you structured a bond deal for Kanye West that paid him a large lump sum amount upfront, with future royalties and streaming revenues from his albums going towards payments to bondholders. Each bond has a face value of $1,000 and a coupon rate of 6.0% with semi-annual coupons. If the bonds have 13 years remaining until maturity and the current yield to maturity is 8.0%, how much is each bond worth? Round to the nearest cent. Type your numeric answer and submit 2268.53 You are incorrect Hint Non-annual coupon bond, so we use Eq. 3.10 to price it. Since semi-annual, m=2. Make sure you divide the annual coupon amount by m when using Eq. 3.10