Ware Co. produces and sells motorcycle parts. On the first day of its fiscal year, Ware issued $44,000,000 of 5-year, 13% bonds at a market (effective) interest rate of 10%, with interest payable semiannually. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below.

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter11: Bond Pricing And Amortization (bonds)
Section: Chapter Questions
Problem 1R: The University Club recently issued 1,500,000 of 10-year, 9% bonds at an effective interest rate of...
icon
Related questions
Question
Compute bond proceeds, amortizing premium by interest method, and interest expense
Ware Co. produces and sells motorcycle parts. On the first day of its fiscal year, Ware issued $44,000,000 of 5-year, 13% bonds at a market
(effective) interest rate of 10%, with interest payable semiannually. This information has been collected in the Microsoft Excel Online file. Open the
spreadsheet, perform the required analysis, and input your answers in the questions below.
X
Open spreadsheet
Compute the following:
a. The amount of cash proceeds from the sale of the bonds. Round your answer to the nearest dollar.
b. The amount of premium to be amortized for the first semiannual interest payment period, using the interest method. Round your answer to the
nearest dollar.
c. The amount of premium to be amortized for the second semiannual interest payment period, using the interest method. Round your answer to
the nearest dollar.
d. The amount of the bond interest expense for the first year. Round your answer to the nearest dollar.
Transcribed Image Text:Compute bond proceeds, amortizing premium by interest method, and interest expense Ware Co. produces and sells motorcycle parts. On the first day of its fiscal year, Ware issued $44,000,000 of 5-year, 13% bonds at a market (effective) interest rate of 10%, with interest payable semiannually. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. X Open spreadsheet Compute the following: a. The amount of cash proceeds from the sale of the bonds. Round your answer to the nearest dollar. b. The amount of premium to be amortized for the first semiannual interest payment period, using the interest method. Round your answer to the nearest dollar. c. The amount of premium to be amortized for the second semiannual interest payment period, using the interest method. Round your answer to the nearest dollar. d. The amount of the bond interest expense for the first year. Round your answer to the nearest dollar.
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Similar questions
  • SEE MORE 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