Hambelton Ltd. issued $3,750,000 of 5% bonds payable on 1 September 20X9 to yield 4%. Interest on the bonds is paid semi-annually and is payable each 28 February and 31 August. The bonds were dated 1 March 20X8, and had an original term of five years. The accounting period ends on 31 December. The effective-interest method is used. (PV of $1, PVA of $1, and PVAD of $1.) (Use appropriate factor(s) from the tables provided.) Required: 1. Determine the price at which the bonds were issued. (Round time value factor to 5 decimal places. Do not round intermediate calculations. Round your final answer to the nearest whole dollar amount.) Price of Bond $ 2. Prepare a bond amortization table for the life of the bond. (Round time value factor to 5 decimal places. Do not round Intermediate calculations. Round your final answers to the nearest whole dollar amount. Leave no cells blank - be certain to enter "O" wherever required.) Date Opening 1 2 3 4 5 6 7 3,918,281 Interest Payment Interest Expense $ 93,750 $ 93,750 93,750 93,750 93,750 93,750 93,750 Premium Amortization 78,366 $ 78,058 77,744 77,424 77,097 76,764 76,425 15,384 15.692 16,006 16,326 16,653 16,986 17,325 Unamortized Premium $ 168,281 $ 152,897 137,205 121,199 104,873 88,220 71,234 53,909 Net Bond Liability 3,918,281 3,902,897 3,887,205 3,871,199 3,854,873 3,838,220 3,821,234 3,803,909

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
ChapterMB: Model-building Problems
Section: Chapter Questions
Problem 13M
icon
Related questions
Question
Hambelton Ltd. issued $3,750,000 of 5% bonds payable on 1 September 20X9 to yield 4%. Interest on the bonds is paid semi-annually
and is payable each 28 February and 31 August. The bonds were dated 1 March 20X8, and had an original term of five years. The
accounting period ends on 31 December. The effective-interest method is used. (PV of $1, PVA of $1, and PVAD of $1.) (Use
appropriate factor(s) from the tables provided.)
Required:
1. Determine the price at which the bonds were issued. (Round time value factor to 5 decimal places. Do not round intermediate
calculations. Round your final answer to the nearest whole dollar amount.)
Price of Bond $
2. Prepare a bond amortization table for the life of the bond. (Round time value factor to 5 decimal places. Do not round
Intermediate calculations. Round your final answers to the nearest whole dollar amount. Leave no cells blank - be certain to enter
"O" wherever required.)
Date
Opening
1
2
3
4
5
6
7
3,918,281
Interest
Payment
Interest
Expense
$ 93,750 $
93,750
93,750
93,750
93,750
93,750
93,750
Premium
Amortization
78,366 $
78,058
77,744
77,424
77,097
76,764
76,425
15,384
15.692
16,006
16,326
16,653
16,986
17,325
Unamortized
Premium
$ 168,281 $
152,897
137,205
121,199
104,873
88,220
71,234
53,909
Net Bond
Liability
3,918,281
3,902,897
3,887,205
3,871,199
3,854,873
3,838,220
3,821,234
3,803,909
Transcribed Image Text:Hambelton Ltd. issued $3,750,000 of 5% bonds payable on 1 September 20X9 to yield 4%. Interest on the bonds is paid semi-annually and is payable each 28 February and 31 August. The bonds were dated 1 March 20X8, and had an original term of five years. The accounting period ends on 31 December. The effective-interest method is used. (PV of $1, PVA of $1, and PVAD of $1.) (Use appropriate factor(s) from the tables provided.) Required: 1. Determine the price at which the bonds were issued. (Round time value factor to 5 decimal places. Do not round intermediate calculations. Round your final answer to the nearest whole dollar amount.) Price of Bond $ 2. Prepare a bond amortization table for the life of the bond. (Round time value factor to 5 decimal places. Do not round Intermediate calculations. Round your final answers to the nearest whole dollar amount. Leave no cells blank - be certain to enter "O" wherever required.) Date Opening 1 2 3 4 5 6 7 3,918,281 Interest Payment Interest Expense $ 93,750 $ 93,750 93,750 93,750 93,750 93,750 93,750 Premium Amortization 78,366 $ 78,058 77,744 77,424 77,097 76,764 76,425 15,384 15.692 16,006 16,326 16,653 16,986 17,325 Unamortized Premium $ 168,281 $ 152,897 137,205 121,199 104,873 88,220 71,234 53,909 Net Bond Liability 3,918,281 3,902,897 3,887,205 3,871,199 3,854,873 3,838,220 3,821,234 3,803,909
AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
steps

Unlock instant AI solutions

Tap the button
to generate a solution

Similar questions
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
College Accounting, Chapters 1-27
College Accounting, Chapters 1-27
Accounting
ISBN:
9781337794756
Author:
HEINTZ, James A.
Publisher:
Cengage Learning,