Tuell plans to issue $ 2 million of 10 percent, 20- year bonds. The market rate of interest at the time of issue is 9 percent. The bonds are issued on June 30, 2010, and pay interest semiannually on June 30 and December 31. Tuell has a December 31 year-end.

Required:

Use a computer spreadsheet.

Determine the amount of cash Tuell will receive when the company issues the bonds. Prepare a bond amortization schedule that indicates the amounts of cash, interest expense, amortization, and bond carrying value on each interest payment date.