the answer is on here I just need to know how to soecifically calculate the part Im pointing at. like how did they get that number and specifically in excel? and then after that how do u get to the final answer

On January 1, 20X1, Hilton-top Hotels issued the following bond payable, interest payment is due annuallv on Decemhor 21 vvnat is the carrying value of the bond at December 31,201 (round to the nearest whole number)? Fill in the blank Explanation Step 1: Compute I/Y, market rate of interest. Explanation Step 1: Compute I/Y, market rate of interest. PMT for bonds is always par value times coupon rate =(37,450)=700,000x 5.35% N=10=Term PV=675,000=Issueprice FV=(700,000)= face value to be paid back at the end of the term CPT I/Y=5.83 In your calculator look at the amortization schedule. Set your P1 and P2 both equal to "1" (the first year). Find the balance or carrying value of the