Need help with the following question: 1.). Write a paragraph to summarize the results of the bond amortization schedule and indicate whether Caleb can purchase this bond with the $580,000 presently available

B c D E F G H 2 3 4 5 Bond Details Date 1/1/26 Face Value $ 580,000.00 Contract Rate 9% Effective Rate 12% Life (years) 4 Payments per Year 2 6 7 8 9 10 11 12 13 14 Bond Calculations Present Value $ 525,974.79 Future Value $ 580,000.00 Payment $ 26,100.00 15 16 17 18 19 20 Amortization of Bond Discount Date Interest Payment Interest Expense Bond Discount Balance Carrying Value 1/1/26 $ 54,025.21 $ 525,974.79 6/30/26 $ 26,100.00 $ 31,558.49 $ 5,458.49 $ 48,566.72 $ (520,516.31) 12/31/26 $ 26,100.00 $ (31,230.98) $ (57,330.98) $ 105,897.70$ 463,185.33 6/30/27 $ 26,100.00 $ 27,791.12 $ 1,691.12 $ 104,206.58 $ (461,494.21) 12/31/27 $ 26,100.00 $ (27,689.65) $ (53,789.65) $ 157,996.23 $ 407,704.56 6/30/28 $ 26,100.00 $ 24,462.27 $ (1,637.73) $ 159,633.96 $ (409,342.28) 12/31/28 $ 26,100.00 $ (24,560.54) $ (50,660.54) $ 210,294.49 $ 358,681.75 6/30/29 $ 26,100.00 $ 21,520.90 $ (4,579.10) $ 214,873.59 $ (363,260.84) 12/31/29 $ 26,100.00 $ (21,795.65) $ (47,895.65) $ 262,769.24 $ 315,365.19 Totals $ 208,800.00 $ 55.97 $ (208,744.03) $ 1,264,238.50 $ (209,676.82) 21 22 23 24 25 26 27 28 29 30 31