1

Compute bond proceeds, amortizing discount by interest method, and interest expense DATA 2 3 4 5 6 7 8 9 miN 00 O Face amount of bonds Contract rate of interest Term of bonds, years Market rate of interest Interest payment $79,000,000 7% 4 10% Semiannual Using formulas and cell references, perform the required analysis, and input your answers into the Amount column. Transfer the numeric results for the green entry cells (C13:C16) into the appropriate fields in CNOWV2 for grading. Amount Formulas 10 11 12 13 14 15 16 17 a. PV of cash proceeds b. Discount amortized for the 1st interest payment period c. Discount amortized for the 2nd interest payment period d. Interest expense for the 1st year