Please provide the Excel formula, need to enter the formula to get the number, not directly fill in the number. Thank you!

The Sanders Company issued 9.5% bonds, dated January 1 , with a face amount of $8,000,000 on January 1 , 2023. The bonds mature on December 31, 2032 (10 years). For bonds of similar risk and maturity, the market yield is 11.0\%. Interest is paid semiannually on June 30 and December 31. Sanders uses the effective interest method. 3. Record the first interest payment on June 30,2023 (at the effective rate). 4. Record the second interest payment on December 31,2023 (at the effective rate). \begin{tabular}{|c|l|l|l|} \hline Date & \multicolumn{1}{c|}{ General Journal } & Debit & \\ \hline December 31, 2023 & Interest expense & & \\ \cline { 3 - 4 } & Cash & & \\ \cline { 2 - 5 } & Discount on bonds payable & & \\ \hline \end{tabular}