In excel, complete an amortization table using the effective interest method for the given details (all 20 periods) with formulas. Also, complete journal entries for 4 periods assuming the bonds were issued on 1/1/16 and pay interest every 7/1 and 1/1 (the first interest payment will be on 7/1/16 and the next interest payment will be on 1/1/17).

On a separate sheet in your excel workbook, complete an amortization table using the straight-line interest method for the same data. Again, complete journal entries for 4 periods using the same dates as above.

DATA FOR TABLE: Whiteside Corporation issues $500,000 of 9% bonds, due in 10 years, with interest payable semiannually. At the time of issue, the market rate for such bonds is 10%. Compute the issue price of the bonds. (which I know is $468,845) (I know my table headings are to be, Date, Cash Int. Pymt., Int. Exp., Disc. Amort., and Carrying Value, I am having trouble with formulas) Thank you.