Dantonio Company issued five-year, 8% bonds with a total face value of $500,000 on January 1, 2014. Interest is paid semi-annually on June 30 and December 31. The market rate of interest on this date was 10%. Dantonio uses the effective interest rate method.

REQUIREMENT:

Using Excel (or an equivalent program), prepare a five-year bond amortization schedule for these bonds. Show functions clearly.