Colwood Candies issued $370,000 of 12%, five-year bonds on January 1, 2020, when the market interest rate was 16%. The company pays interest annually at year-end. The issue price of the bonds was $321,540. Requirement Create a spreadsheet model to prepare a schedule to amortize the bonds. Use the effective-interest method of amortization. Round to the nearest dollar Requirement. Create a spreadsheet model to prepare a schedule to amortize the bonds. Use the effective-interest method of amortization (Round your final answer to the nearest dollar. For amounts w zero balance, enter a 0 where appropriate.) A B C Interest Payment Interest Expense (16% of (12% of Maturity Value) Preceding Bond Carrying Amount) Date 1-1-2020 12-31-2020 S 12-31-2021 12-31-2022 12-31-2023 12-31-2024 44,400 44,400 44,400 44,400 44,400 51446 52574 53882 55399 56838 D Discount Amortization Discount Balance (C-B) (Preceding E-D) 48460 41414 33240 22758 11759 E 7046 8174 9482 10999 12438 F Bond Carrying Amount ($370,000-E) 321540 328586 336760 346242 355243 367682

Cornerstones of Financial Accounting
4th Edition
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Jay Rich, Jeff Jones
Chapter9: Long-term Liabilities
Section: Chapter Questions
Problem 15MCQ
icon
Related questions
Question
Colwood Candies issued $370,000 of 12% , five-year bonds on January 1, 2020, when the market interest rate was 16%. The company pays interest annually at year-end. The issue price of the bonds was
$321,540.
Requirement
Create a spreadsheet model to prepare a schedule to amortize the bonds. Use the effective-interest method of amortization. Round to the nearest dollar.
Requirement. Create a spreadsheet model to prepare a schedule to amortize the bonds. Use the effective-interest method of amortization (Round your final answer to the nearest dollar. For amounts with
zero balance, enter a 0 where appropriate.)
A
Date
1-1-2020
12-31-2020
12-31-2021
12-31-2022
12-31-2023
12-31-2024
C
Interest Payment Interest Expense (16% of
(12% of Maturity Preceding Bond Carrying
Amount)
Value)
B
S
44,400
44.400
44,400
44,400
44,400
51446
52574
53882
55399
56838
D
Discount
Amortization
(C-B)
7046
8174
9482
10999
12438
E
Discount Balance
(Preceding E-D)
48460
41414
33240
22758
11759
F
Bond Carrying
Amount
($370,000-E)
D
321540
328586
-336760
346242
355243
367682
Clear all
Check ansa
Transcribed Image Text:Colwood Candies issued $370,000 of 12% , five-year bonds on January 1, 2020, when the market interest rate was 16%. The company pays interest annually at year-end. The issue price of the bonds was $321,540. Requirement Create a spreadsheet model to prepare a schedule to amortize the bonds. Use the effective-interest method of amortization. Round to the nearest dollar. Requirement. Create a spreadsheet model to prepare a schedule to amortize the bonds. Use the effective-interest method of amortization (Round your final answer to the nearest dollar. For amounts with zero balance, enter a 0 where appropriate.) A Date 1-1-2020 12-31-2020 12-31-2021 12-31-2022 12-31-2023 12-31-2024 C Interest Payment Interest Expense (16% of (12% of Maturity Preceding Bond Carrying Amount) Value) B S 44,400 44.400 44,400 44,400 44,400 51446 52574 53882 55399 56838 D Discount Amortization (C-B) 7046 8174 9482 10999 12438 E Discount Balance (Preceding E-D) 48460 41414 33240 22758 11759 F Bond Carrying Amount ($370,000-E) D 321540 328586 -336760 346242 355243 367682 Clear all Check ansa
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Bond Amortization
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT