Sandford Co. sells bonds on March 1, 2017. The bonds pay interest on September 1 and March 1. The due date of the bonds is September 1, 2020. Pertinent information follows: Par value of the bonds Stated interest rate Bond yield rate $ 500,000 10% 12% A) Calculate the bond price and bond discount using EXCEL function. B) Prepare amortization schedule Nin 678092 2 3 10 11 12 13 14 15 16 17 18 19 20 21 22 A B D E F Sanford Co. G H J K Date L M A. Calculation of issue price and discount using Excel's PV function: B. Schedule of Bond Discount Amortization Effective Interest Method 10% Bonds Sold to Yield 12% Bond Amortized Cash Interest Discount Paid Expense Amort. cost of Bonds N C