In: Accounting
Compute bond proceeds, amortizing discount by interest method, and interest expense | |||
DATA | |||
Face amount of bonds | $84,000,000 | ||
Contract rate of interest | 7% | ||
Term of bonds, years | 5 | ||
Market rate of interest | 11% | ||
Interest payment | 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 | ||
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 |