C13 fx A B C 1 Compute bond proceeds, amortizing premium by interest method, and interest expense 2 4 3 DATA 4 Face amount of bonds 5 Contract rate of interest 6 Term of bonds, years 7 Market rate of interest 8 Interest payment $36,000,000 11% 5 9% Semiannual 9 D E Using formulas and cell references, perform the required analysis, and input your answers into the Amounts column. Transfer the numeric results for the green entry cells (C13 C16) into the appropriate fields in CNOWV2 for 10 grading 11 12 13 Ja PV of cash proceeds 14 b. Premium amortized for the 1st interest payment period 15 c. Premium amortized for the 2nd interest payment period 16 d. Interest expense for the 1st year 17 18 Amounts Formulas 19 20 21 Data + Workbook Statistics Calculation Mode: Automatic