$7$ roblem set as

Problem #$4$: Long$-$Term Llabilities $(36$ points$)$

Page $15$ of $17$

On January $1,2025,$ Craig Industries issued the following bond.

a$)$ Indicate whether the bond will sell at par, a premium or at a discount as of January $1,2025.(2$ pointa$)$

$\backslash$table$[[$Face $($Par$)$ Value Issued,Market Yield Bate,Stited Coupen Rate,Term,Interest Puld $($Cempsunde$6),$Sell at Par, Premilum, or Discount$],[$$$125,000,000,7\mathrm{.}4\%,7\mathrm{.}2\%,20$ yrs$.,$Semi$-$annually,Discount$]]$

b$)$ Use Excel to determine the bond proceeds and quoted bond price.

Enter the relevant time$-$value of money factors in the table provided. $(6$ peinta$)$

Enter your results in the second table. Provide the Excel formula the you used to compute the bod proceeds and the supporting calculation for the quoted bond price. $(4$ pesinta$)$

$\backslash$table$[[$Rate Nper,PMT$,$FV$,$Type,$],[3\mathrm{.}7\%,40,-4,500,000,125,000,000,0]]$c$)$ Prepare the entry to record the issuance of the bonds on january $1,2025.(4$ pointa$)$

$\backslash$table$[[$DATE$,$ACCOUNT NAMES,DEBIT,CREDIT$],[,,,],[,,,],[,,,],[,,,]]$

d$)$

Prepare the partial amortization schedule for the first two interest periods in $2025.($$ points$)$

$\backslash$table$[[$Time Period,Interest Expense,Stated Coupon Interest Paid,Discounts $($Premium$)$ Amortization,Carrying Value of Bonds$],[1/12025,,,,],[6/30/2025$ Calculations,,,,$],[$Amounts$,,,,],[12/31/2025$ Calculations,,,,$],[$Amounts$,,,,]]$

e$)$ Prepare the entry to record the interest payment on the bonds on June $30,2025.(3$ pointa$)$

$\backslash$table$[[$DATE$,$ACCOUNT NAMES,DEBIT,CREDIT$],[,,,],[,,,],[,,,]]$Page $17$ of $17$

$\backslash$table$[[\backslash$table$[[$DATE$],[$Pape $17$ of $17]]],[,,$DEBIT,CREDIT$],[,,,],[,,,],[,,,]]$

$$

Post the effects of the bond entries in the T$-$accounts above to compute their balances on January $1.$ June $30,$ and December $31,2025.(3$ polists$)$

Use the balances in the Taccounts above to compute the carrying value of the bonds at January $1,$ June $30,$ and December $31,2025.(3$ peinta$)$

$\backslash$table$[[,\frac{1}{1}\frac{?}{2025},\frac{6}{30}\frac{?}{2025},\frac{12}{31}\frac{?}{2025}$

PARTS A AND B ARE COMPLETE PLEASE COMPLETE C$,$ D$,$ E$,$ F$,$ and G