Ware Co. produces and sells motorcycle parts. On the first day of its fiscal year, Ware...

Ware Co. produces and sells motorcycle parts. On the first day of its fiscal year, Ware issued $32,000,000 of five-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.

Open spreadsheet

Compute the following:

The amount of cash proceeds from the sale of the bonds. Round your answer to the nearest dollar.

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

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

$
The amount of the bond interest expense for the first year. Round your answer to the nearest dollar.

Solutions

Expert Solution

Correct Answer:

Cash proceeds from bond = $ 35,706,433

Semi-Annually		Formula Applied
Face Value of Bond	$ 32,000,000
Interest Semi-Annually @ 13%/2	$ 2,080,000	*(Face Value of Bonds Coupon rate )**
Semi-Annual Effective interest Rate r = ( 10%/2)	0.0500	10%
Time Period (n) 5 years * 2	10.00	5
Present Value of Face Value of Bond	$ 1,9,645,224	Face Value/(1+r%)^2n
Present Value of Interest payment	$ 1,6,061,209	*Interest ((1-(1+r)^-n)/r)**
Cash proceeds from the bond issue	$ 3,5,706,433	PV of Face value of bond + PV of Interest Paid Annually
Premium or (Discount)	$ 3,706,433	Issue Price - Face Value of Bonds

Requirement b:

The amount of premium to be amortized for the first semi-annual interest payment period: $ 2,94,678

Requirement c:

The amount of premium to be amortized for the Second semi-annual interest payment period: $ 3,09,412

Requirement d:

The amount of bond interest expense for the first year: $ 35,55,909

Working: for a, b, c:

Effective Interest Amortization Table
Formula Used	*(32,000,00013%) / 2**	*Last year’s Carrying value of bond Market Rate of Interest (10%)**	Interest Expense - Cash Paid	Last year's Carrying value of Bond - current year's Premium amortized
	Changes during the bond
Date	cash paid	Interest Expense	(Premium)/Discount Amortized	Carrying value of Bond
Year beginning		-	-	$ 3,57,06,433
1st interest payment	$ 20,80,000	$ 17,85,322	$ (2,94,678)	$ 3,54,11,754
2nd Interest payment	$ 20,80,000	$ 17,70,588	$ (3,09,412)	$ 3,51,02,342

End of Answer.

Thanks

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

Ware Co. produces and sells motorcycle parts. On the first day of its fiscal year, Ware...

Ware Co. produces and sells motorcycle parts. On the first day of its fiscal year, Ware Co. issued $70,000,000 of three-year, 14% bonds at a market (effective) interest rate of 12%, with interest payable semiannually. Compute the following: a. The amount of cash proceeds from the sale of the bonds. Use the tables of present values in Exhibit 8 and Exhibit 10. Round to the nearest dollar. $ b. The amount of premium to be amortized for the first semiannual...

Boyd Co. produces and sells aviation equipment. On the first day of its fiscal year, Boyd...

Boyd Co. produces and sells aviation equipment. On the first day of its fiscal year, Boyd Co. issued $70,000,000 of three-year, 11% bonds at a market (effective) interest rate of 13%, with interest payable semiannually. Compute the following: a. The amount of cash proceeds from the sale of the bonds. Use the tables of present values in Exhibit 5 and Exhibit 7. Round to the nearest dollar. $ b. The amount of discount to be amortized for the first semiannual...

Compute bond proceeds, amortizing premium by interest method, and interest expense Ware Co. produces and sells...

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 $30,000,000 of five-year, 12% 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: The amount of cash...

Compute bond proceeds, amortizing premium by interest method, and interest expense Ware Co. produces and sells...

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 $28,000,000 of three-year, 11% bonds at a market (effective) interest rate of 8%, 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. Compute the following: The amount of cash proceeds from...

Compute Bond Proceeds, Amortizing Premium by Interest Method, and Interest Expense Ware Co. produces and sells...

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 Co. issued $90,000,000 of five-year, 12% bonds at a market (effective) interest rate of 10%, with interest payable semiannually. Compute the following: a. The amount of cash proceeds from the sale of the bonds. Use the tables of present values in Exhibit 8 and Exhibit 10. Round to the nearest dollar. b. The...

On July 1, 2019, the first day of its 2020 fiscal year, the Town of Bear...

On July 1, 2019, the first day of its 2020 fiscal year, the Town of Bear Creek issued at par $4,200,000 of 8 percent term bonds to renovate a historic wing of its main administrative building. The bonds mature in five years on July 1, 2024. Interest is payable semiannually on January 1 and July 1. As illustrated in the table below, a sinking fund is to be established with equal semiannual additions made on June 30 and December 31....

On the first day of its fiscal year, Lessor, Inc., leased certain property at an annual...

On the first day of its fiscal year, Lessor, Inc., leased certain property at an annual rental of $100,000 receivable at the beginning of each year for 10 years. The first payment was received immediately. The leased property is new, had cost $650,000, and has an estimated useful life of 13 years with no salvage value. The rate implicit in the lease is 8%. The present value of an annuity of $1 payable at the beginning of the period at...

On July 1, 2016, the first day of its 2017 fiscal year, the City of Nevin...

On July 1, 2016, the first day of its 2017 fiscal year, the City of Nevin issued at par $4,200,000 of 8 percent term bonds to construct a new city office building. The bonds mature in five years on July 1, 2021. Interest is payable semiannually on January 1 and July 1. A sinking fund is to be established with equal semiannual additions made on June 30 and December 31, with the first addition to be made on December 31,...

On July 1, 2016, the first day of its 2017 fiscal year, the City of Nevin...

On July 1, 2016, the first day of its 2017 fiscal year, the City of Nevin issued at par $2,000,000 of 6 percent term bonds to construct a new city office building. The bonds mature in five years on July 1, 2021. Interest is payable semiannually on January 1 and July 1. A sinking fund is to be established with equal semiannual additions made on June 30 and December 31, with the first addition to be made on December 31,...

On the first day of its fiscal year, Chin Company issued $16,800,000 of five-year, 4% bonds...

On the first day of its fiscal year, Chin Company issued $16,800,000 of five-year, 4% bonds to finance its operations of producing and selling home improvement products. Interest is payable semiannually. The bonds were issued at a market (effective) interest rate of 6%, resulting in Chin Company receiving cash of $15,366,859. a. Journalize the entries to record the following: Issuance of the bonds. First semiannual interest payment. The bond discount amortization, using the straight-line method, is combined with the semiannual...

Subjects