pease answer all subparts beause i cant post last subparts separately because they are interlinked with each other i hope u will answer all thanku in advance Compute bond proceeds, amortizing premium by interest method, and interest expenseWare Co. produces and sells motorcycle parts. On the first day of its fiscal year, Ware issued $29,000,000 of five-year, 13% bonds at a market (effective) interest rate of10%, with interest payable semiannually. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, andinput your answers in the questions below.Open spreadsheetCompute the following:a. The amount of cash proceeds from the sale of the bonds. Round your answer to the nearest dollar.mb. 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.Sd. The amount of the bond interest expense for the first year. Round your answer to the nearest dollar.$

Bond Valuation Here discuss about the details of Bond Present Valuation and and amortization of bond…

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 $29,000,000 of five-year, 13% bonds at a market (effective) interest rate om 10%, with interest payable semiannually. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, anc 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. $

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 $29,000,000 of five-year, 13% bonds at a market (effective) interest rate om 10%, with interest payable semiannually. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, anc 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. $

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...

See similar textbooks

Similar questions

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 $37,000,000 of three-year, 11% 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. 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. Do not…
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…
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 $42,000,000 of four-year, 12% bonds at a market (effective) interest rate of 11%, 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. Open spreadsheet Compute the following: The amount of cash proceeds from the sale of the bonds. Round your answer to the nearest dollar. $ fill in the blank 2 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. $ fill in the blank 3 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. $ fill in the…
Boyd Co. produces and sells aviation equipment. On the first day of its fiscal year, Boyd issued $83,000,000 of five-year, 8% bonds at a market (effective) interest rate of 10%, with interest payable semiannually. This information has been collected in the Microsoft Ex Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet Compute the following: A. The amount of cash proceeds from the sale of the bonds. Round your answer to the nearest dollar. $4 B. The amount of discount 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 discount 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.
Compute bond proceeds, amortizing discount by interest method, and interest expense Boyd Co. produces and sells aviation equipment. On the first day of its fiscal year, Boyd issued $80,000,000 of five-year, 9% bonds at a market (effective) interest rate of 11%, 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 discount to be amortized for the first semiannual interest payment period, using the interest method. Round your answer to the nearest dollar. $ 73,969,806 X $ c. The amount of discount to be amortized for the second semiannual interest payment period, using the interest method. Round your answer to the nearest dollar. 468,339 X $ 442,581 X d. The amount of the bond…
Ware Co. produces and sells motorcycle parts. On the first day of its fiscal year, Ware issued $37,000,000 of three-year, 11% 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. The amount of cash proceeds from the sale of the bonds. Round your answer to the nearest dollar. $
Compute bond proceeds, amortizing discount by interest method, and interest expense Boyd Co. produces and sells aviation equipment. On the first day of its fiscal year, Boyd issued $88,000,000 of three-year, 9% bonds at a market (effective) interest rate of 11%, 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. Open spreadsheet Compute the following: The amount of cash proceeds from the sale of the bonds. Round your answer to the nearest dollar. $ fill in the blank 2 The amount of discount to be amortized for the first semiannual interest payment period, using the interest method. Round your answer to the nearest dollar. $ fill in the blank 3 The amount of discount to be amortized for the second semiannual interest payment period, using the interest method. Round your answer to the nearest dollar. $ fill in…
Compute bond proceeds, amortizing discount by interest method, and interest expense Boyd Co. produces and sells aviation equipment. On the first day of its fiscal year, Boyd issued $80,000,000 of five-year, 9% bonds at a market (effective) interest rate of 11%, 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 discount 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 discount 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…
Some of the questions are in the screenshots to make it easier! The following section is taken from Ohlman Corp.’s balance sheet at December 31, 2018. Current liabilities Interest payable $ 112,000 Long-term liabilities Bonds payable, 7%, due January 1, 2021 1,600,000 Bond interest is payable annually on January 1. The bonds are callable on any interest date.(a)Journalize the payment of the bond interest on January 1, 2019. (Credit account titles are automatically indented when amount is entered. Do not indent manually.
Pinder Co. produces and sells high-quality video equipment. To finance its operations, Pinder issued $20,000,000 of 4-year, 9% bonds, with interest payable semiannually, at a market (effective) interest rate of 11%. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below. Determine the present value of the bonds payable. Round your answer to the nearest dollar.
Pinder Co. produces and sells high-quality video equipment. To finance its operations, Pinder issued $30,000,000 of four-year, 9% bonds, with interest payable semiannually, at a market (effective) interest rate of 10%. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below. Determine the present value of the bonds payable. Round your answer to the nearest dollar.
Boyd Co. produces and sells aviation equipment. On the first day of its fiscal year, Boyd issued $83,000,000 of five-year, 8% bonds at a market (effective) interest rate of 10%, with interest payable semiannually. This information has been collected in the Microsoft Excel Online file. The amount of cash proceeds from the sale of the bonds. Round your answer to the nearest dollar.