Question
1. Using the PV function in Excel, calculate the issue price of the bonds. 2. Prepare an effective-interest amortization table for the bonds through the
1. | Using the PV function in Excel, calculate the issue price of the bonds. |
2. | Prepare an effective-interest amortization table for the bonds through the first three interest payments. Round amounts to the nearest dollar. |
3. | Record Halbach Corporation's issuance of the bonds on January 1,2022, and payment of the first semiannual interest amount and amortization of the bond premium on June 30,2022. Explanations are not required. |
Halbach
Corporation issued
$700,000
of
16%,
10-year
bonds payable on January 1,
2022.
The market interest rate at the date of issuance was
14%,
and the bonds pay interest semiannually (on June 30 and December 31).
Halbach
Corporation's year-end is June 30.Read the requirements
LOADING...
.
1. Using the PV function in Excel, calculate the issue price of the bonds. (Round your answer to the nearest whole dollar.)
The issue price of the bonds is |
2. Prepare an effective-interest amortization table for the bond through the first three interest payments. Round amounts to the nearest dollar.
|
|
|
| Premium | Bond |
Semiannual | Interest | Interest | Premium | Account | Carrying |
Interest Date | Payment | Expense | Amortization | Balance | Amount |
Jan 1, 2022 |
|
Jun 30, 2022 |
|
|
|
|
Dec 31, 2022 |
|
|
|
|
|
Jun 30, 2023 |
|
|
|
|
|
3. Record
Halbach
Corporation's issuance of the bonds on January 1,
2022,
and payment of the first semiannual interest amount and amortization of the bond premium on June 30,
2022.
Explanations are not required. (Record debits first, then credits. Exclude explanations from any journal entries.)Start by recording the issuance of bonds on January 1,
2022.
Journal Entry | ||||||
Date | Accounts | Debit | Credit | |||
Jan | 1 | Cash |
|
| ||
|
| Premium on Bonds Payable |
|
| ||
|
|
| ||||
|
|
|
Record the payment of the first semiannual interest amount and amortization of the bond premium on June 30,
2022.
Journal Entry | ||||||
Date | Accounts | Debit | Credit | |||
Jun | 30 | Interest Expense |
|
| ||
|
| Premium on Bonds Payable |
|
| ||
Cash |
|
| ||||
|
|
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started