12. Copy the formula in cell E9 down through cell E26. You want to see the dates for June 30 and December 31 through the years. However, there is a problem in the leap years (2028 and 2032). Look down the numbers in column E to find the first incident that reads 6/29/2028. Change that formula to add 366 days instead of 365 . Do the same thing for the next cell down the column to change the 12/30/2028 to 12/31/2028. Also correct the dates in the year 2032. 13. Input a formula or cell reference in cell F7 to show the interest payment amount. Make sure the formula can be copied down the column through cell F26. Remember that the amount of the interest payment stays the same each time a payment is made. 14. Input a formula in cell G7 to calculate the interest expense to be recognized. Make sure the formula can be copied down the column through cell G26. When the formula is first copied, it will show 0's down the column. This will be corrected when you complete the formulas in columns H and I. 15. Input a formula in cell H7 to determine the amount of the discount or premium amortized. It will make the next formula easier if the amount of discount amortized is a positive number and the amount of premium amortized is a negative number. Copy the formula down through cell H26. \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline 2 & A & B & C & E & F & G & H & 1 \\ \hline 1 & \multicolumn{2}{|c|}{ ACC 2102 Intermediate Accounting II } & & & & & & \\ \hline 2 & Ch 14 Excel Problem & & & & & & & \\ \hline 3 & & & & & & & & \\ \hline 4 & Face value of bonds & $8,000,000.00 & & Payment & Interest & Interest & Discount & Carrying \\ \hline 5 & Stated interest rate & 5% & & Date & Payment & Expense & Amortized & Amount \\ \hline 6 & Market interest rate & 8% & 0 & 6/30/2024 & 0 & 0 & 0 & $6,369,160.84 \\ \hline 7 & Term in years & 10 & 1 & 12/31/2024 & 200,000.00 & & & \\ \hline 8 & Issue date & 1/1/2024 & 2 & & 200,000.00 & & & \\ \hline 9 & First interest payment date & 6/30/2024 & 3 & & 200,000.00 & & & \\ \hline 10 & Second interest payment date & 12/31/2024 & 4 & & 200,000.00 & & & \\ \hline 11 & & & 5 & & 200,000.00 & & & \\ \hline 12 & Semi-annual Interest Payment & $200,000.00 & 6 & & 200,000.00 & & & \\ \hline 13 & & & 7 & & 200,000.00 & & & \\ \hline 14 & PV of the bond principal & $3,651,095.57 & 8 & & 200,000.00 & & & \\ \hline 15 & PV of interest payments & $2,718,065.27 & 9 & & 200,000.00 & & & \\ \hline 16 & Cash Proceeds from Bond issuance & $6,369,160.84 & 10 & & 200,000.00 & & & \\ \hline 17 & & & 11 & & 200,000.00 & & & \\ \hline 18 & Did bonds sell at a discount or premium? & Discount & 12 & & 200,000.00 & & & \\ \hline 19 & & & 13 & & 200,000.00 & & & \\ \hline 20 & & & 14 & & 200,000.00 & & & \\ \hline 21 & & & 15 & & 200,000.00 & & & \\ \hline 22 & & & 16 & & 200,000.00 & & & \\ \hline 23 & & & 17 & & 200,000.00 & & & \\ \hline 24 & & & 18 & & 200,000.00 & & & \\ \hline 25 & & & 19 & & 200,000.00 & & & \\ \hline 26 & & & 20 & & 200,000.00 & & & \\ \hline 77 & & & & & & & & \\ \hline \end{tabular}