On January 2, Year 1, the Lyndhurst Company Inc a privately-held issued $1,000,000, five-year, 10% bonds, dated January 2, Year 1. The bonds provided for semiannual interest payments to be made on June 30 and December 31 of each year. Terms of the bond indenture allowed the company to call the bonds at 102 after one year. The bonds were issued when the market interest rate was 8%. Lyndhurst uses the effective interest method for amortizing bond discounts and premiums The bonds are term bonds that mature on December 31, Year 5. Lyndhurst's fiscal year for financial reporting purposes is December 31. The company called the bonds at 102 on June 30, Year 2 Use the following spreadsheet to calculate the present values of the principal and interest cash flows related to the bonds, and the resulting bond issue price. For each shaded cell in columns B, C, and D, enter the appropriate figures in the shaded cells. For cells C2 and C3, enter the amortization interest rate (as a decimal). For column E find the appropriate time value factors in the references located in the "Resources" lab and enter those into the shaded cells. The spreadsheet will automatically calculate the bond issue price based on your entries (cell F4)