Need help with the following question: 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

Populate Schedule 2 3 4 5 6 7 8 9 10 11 12 13 14 Bond Details Date $ Face Value $ Contract Rate $ Effective Rate $ Life (years) $ Payments per Year $ 46,023.00 580,000.00 0.09 0.12 4.00 2.00 Bond Calculations Present Value $ 525,974.79 Future Value S 580,000.00 Payment s 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 s 26,100.00 S 31,558.49 $ 5,458.49 $ 48,566.72 $ 531,433.28 12/31/26 S 26,100.00 S 31,886.00 $ 5,786.00 $ 42,780.72 $ 537,219.28 6/30/27 S 26,100.00 S 32,233.16 $ 6,133.16 $ 36,647.56 $ 543,352.44 12/31/27 S 26,100.00 S 32,601.15 $ 6,501.15$ 30,146.42 $ 549,853.58 6/30/28 S 26,100.00 S 32,991.21 $ 6,891.21 $ 23,255.20 $ 556,744.80 12/31/28 S 26,100.00 S 33,404.69 $ 7,304.69 $ 15,950.52 $ 564,049.48 6/30/29 s 26,100.00 S 33,842.97 $ 7,742.97 $ 8,207.55 $ 571,792.45 12/31/29 S 26,100.00 S 34,307.55 $ 8,207.55$ (0.00) $ 580,000.00 Total $ 208,800.00 $ 262,825.21 $ 54,025.21 21 22 23 24 25 26 27