Compute bond proceeds, amortizing premium by interest method, and interest expense DATA Face amount of bonds Contract rate of interest Term of bonds, years Market rate of interest Interest payment REQUIRED: a. Compute the amount of cash proceeds from the sale of the bonds. $41,000,000 11% 3 9% Semiannual b. Compute the amount of premium to be amortized for the first semiannual interest payment period, using the interest method. c. Compute the amount of premium to be amortized for the second semiannual interest payment period, using the interest method. d. Compute the amount of the bond interest expense for the first year. Using formulas and cell references from the problem data, perform the required analysis. Formulas entered in the green cells show in the orange cells. Transfer amounts to CNOWv2 for grading. a. PV of cash proceeds b. Premium amortized for the 1st interest payment period c. Premium amortized for the 2nd interest payment period d. Interest expense for the 1st year Amounts Formulas $43,114,728 =-PV(C7/2,C6*2,C4*C5/2,C4)