On January $1,2025,$ Excel Corporation issued $\backslash$$$1,500,000$ in long$-$term bonds. The bonds will mature in $30$ years and have a stated interest rate of $\backslash (8\backslash \%\backslash )$ and a market interest rate of $\backslash (9\backslash \%\backslash ).$ The bonds pay interest semiannually on January $1$ and July $1$ of each year. The bonds are accounted for using the effective$-$interest method.

Required: Use Microsoft Excel

$($a$)$ Compute the price of the bonds, using a financial calculator. List and label the inputs you used.

$($b$)$ Write the journal entry to record the issuance of the bonds.

$($c$)$ Construct in good form $($including a heading$)$ a bond amortization table for this problem to indicate the date, the amount of cash paid, interest expense, amortization of discount or premium, and carrying value at the date of issuance and for each interest payment date through July $1,2026.$ Make sure all columns and rows are properly labeled. $($Round amounts to the nearest dollar.$)$

$($d$)$ Write the journal entries related to the bonds for the following two dates: July $1,2025$ and December $31,2025.$