Presented below is a partial amortization table: Semi Annual Interest Period Jan 1, 2026 July 1, 2026 Jan 1, 2027 July 1, 2027 Jan 1, 2028 July 1 2028 Interest payment $75,000 [3] 75,000 75,000 75.000 Interest expense [2] 64,704 64,498 64,288 64.070 Amortization $10,095 10,296 10,502 [4] 207 Bond Amortized Cost [1] 3,235,177 3,224,881 3,214,379 [5]

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
On January 1, 2026, Manson Corporation issued $3-million 10-year bonds. The bonds pay
semi-annual interest on July 1 and January 1, and Manson has a December 31, year-end.
Presented below is a partial amortization table:
Semi Annual
Interest
Period
Jan 1, 2026
July 1, 2026
Jan 1, 2027
July 1, 2027
Jan 1, 2028
July 1, 2028
Jan 1, 2029
Interest
payment
1
$75,000
[3]
75,000
75,000
75,000
75,000
Interest
expense
[2]
64,704
64,498
64,288
64,073
63,855
Amortization
$10,095
10,296
10,502
[4]
10,927
11,145
Bond
Amortized
Cost
[1]
3,235,177
3,224,881
3,214,379
[5]
3,192,740
3,181,595
Required:
Set up a table in MS Excel with all relevant information. Use the table to answer the following
questions in MS Excel. Use Excel formulas to support your calculation whenever possible
a. Were the bonds issued at a discount or premium? How do you know?
b. What is the face value of the bonds?
c. What is the contractual rate of interest?
d. Calculate the missing amounts for items [1] through [5] in the amortization table
e. What was the market interest rate when the bonds were issued?
f. Prepare the journal entry to record the issue the bonds on January 1, 2026
g. Prepare the journal entry to record the first interest payment on July 1, 2026
h. Prepare the journal entry to record the accrual of interest on December 31, 2026
i. What amounts would be reported as current and as noncurrent liabilities on Manson's
December 31, 2026, balance sheet?
I
Transcribed Image Text:On January 1, 2026, Manson Corporation issued $3-million 10-year bonds. The bonds pay semi-annual interest on July 1 and January 1, and Manson has a December 31, year-end. Presented below is a partial amortization table: Semi Annual Interest Period Jan 1, 2026 July 1, 2026 Jan 1, 2027 July 1, 2027 Jan 1, 2028 July 1, 2028 Jan 1, 2029 Interest payment 1 $75,000 [3] 75,000 75,000 75,000 75,000 Interest expense [2] 64,704 64,498 64,288 64,073 63,855 Amortization $10,095 10,296 10,502 [4] 10,927 11,145 Bond Amortized Cost [1] 3,235,177 3,224,881 3,214,379 [5] 3,192,740 3,181,595 Required: Set up a table in MS Excel with all relevant information. Use the table to answer the following questions in MS Excel. Use Excel formulas to support your calculation whenever possible a. Were the bonds issued at a discount or premium? How do you know? b. What is the face value of the bonds? c. What is the contractual rate of interest? d. Calculate the missing amounts for items [1] through [5] in the amortization table e. What was the market interest rate when the bonds were issued? f. Prepare the journal entry to record the issue the bonds on January 1, 2026 g. Prepare the journal entry to record the first interest payment on July 1, 2026 h. Prepare the journal entry to record the accrual of interest on December 31, 2026 i. What amounts would be reported as current and as noncurrent liabilities on Manson's December 31, 2026, balance sheet? I
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Accounting for Intangible assets
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education