(Learning Objective 2: Issue bonds payable (premium); record interest paymentand the related bond amortization using the effective-interest method) On June 30, 2018,the market interest rate is 9%. Randall Corporation issues $600,000 of 10%, 15-year bondspayable. The bonds pay interest on June 30 and December 31. The company amortizes bondpremium using the effective-interest method.Requirements1. Use the PV function in Excel to calculate the issue price of the bonds.2. Prepare a bond amortization table for the term of the bonds using Excel.3. Record the issuance of bonds payable on June 30, 2018; the payment of interest onDecember 31, 2018; and the payment of interest on June 30, 2019.
(Learning Objective 2: Issue bonds payable (premium); record interest payment
and the related bond amortization using the effective-interest method) On June 30, 2018,
the market interest rate is 9%. Randall Corporation issues $600,000 of 10%, 15-year bonds
payable. The bonds pay interest on June 30 and December 31. The company amortizes bond
premium using the effective-interest method.
Requirements
1. Use the PV function in Excel to calculate the issue price of the bonds.
2. Prepare a bond amortization table for the term of the bonds using Excel.
3. Record the issuance of bonds payable on June 30, 2018; the payment of interest on
December 31, 2018; and the payment of interest on June 30, 2019.
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 12 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)