Concept explainers
Videos
The University Club recently issued $1,500,000 of 10-year, 9% bonds at an effective interest rate of 10%. Bond interest is payable annually.
You have been asked to calculate the issuance price of the bonds and prepare amortization schedules for any discount or premium. The worksheet BONDS has been provided to assist you. Note that the worksheet contains a scratch pad at the bottom that has been preprogrammed to automatically compute and display the relevant
Calculate the issue price of bonds and prepare amortization schedules for any discount or premium.
Explanation of Solution
Calculate the issue price of bonds and prepare amortization schedules for any discount and premium.
Table (1)
The formulae for the above calculation are as follows:
Figure (2)
Want to see more full solutions like this?
Chapter 11 Solutions
Excel Applications for Accounting Principles
- Please correct answer with accounting questionarrow_forwardA company has decided to purchase equipment, needing to borrow $100,000 from its local bank to make the purchase. The bank gives the company two options: (a) 60-month installment note with 4% interest or (b) 120-month installment note with 8% interest. Lenders often charge a higher interest rate for longer-term loans to compensate for additional risk of lending for a longer time period. Record $100,000 cash received from the issuance of the 120-month installment note with 8% interest.Record $100,000 cash received from the issuance of the 120-month installment note with 8% interest. Select the options to display a 120-month installment note with 12% interest. How much of the principal amount is due after the 60th payment?arrow_forward!??arrow_forward
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning