eBookXOpen spreadsheetShow Me HowPresent value of bonds payable; discountPinder Co. produces and sells high-quality video equipment. To finance its operations, Pinder issued $20,000,000 of four-year, 8% bonds, with interest payablesemiannually, at a market (effective) interest rate of 11%. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform therequired analysis, and input your answers in the question below.$Office 365Determine the present value of the bonds payable. Round your answer to the nearest dollar. Excel template - Saved5vFileB1323456789Homev16171819202122✓Insert10111213 PV of bonds1415ArialX ✓ fxAB1 Present value of bonds payable; discountDATAFace amount of bondsContract rate of interestTerm of bonds, yearsMarket rate of interestInterest paymentDrawPage Layout10 v$20,000,0008%411%SemiannualAmountFormulaskCSearch (Option + Q)B H✓ ✓ Av .....DataUsing formulas and cell references, perform the required analysis, and inputyour answer into the Amount column. Transfer the numeric result for the greenentry cell (B13) into the appropriate field in CNOWv2 for grading.FormulaCHERYReviewViewEvabDHelpEditingCurrencyE$ ✓-0.00

Bond :— Bond is a Liability which is Owned By the Owner for a specific period of time on which…

5v B13 1 2 3 4 5 8 9 Arial X ✓ fx 6 Term of bonds, years 7 Market rate of interest Interest payment A B Present value of bonds payable; discount Face amount of bonds Contract rate of interest 10 11 12 13 PV of bonds 14 15 16 17 18 19 20 21 22 DATA ✓10 V B EA... $20,000,000 8% 4 11% Semiannual Using formulas and cell references, perform the required analysis, and input your answer into the Amount column. Transfer the numeric result for the green. entry cell (B13) into the appropriate field in CNOWV2 for grading. C Amount Formula vab D Currency E $ ~ 0 .00

5v B13 1 2 3 4 5 8 9 Arial X ✓ fx 6 Term of bonds, years 7 Market rate of interest Interest payment A B Present value of bonds payable; discount Face amount of bonds Contract rate of interest 10 11 12 13 PV of bonds 14 15 16 17 18 19 20 21 22 DATA ✓10 V B EA... $20,000,000 8% 4 11% Semiannual Using formulas and cell references, perform the required analysis, and input your answer into the Amount column. Transfer the numeric result for the green. entry cell (B13) into the appropriate field in CNOWV2 for grading. C Amount Formula vab D Currency E $ ~ 0 .00

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

Present value of bonds payable; discount Pinder Co. produces and sells high-quality video equipment. To finance its operations, Pinder issued $24,000,000 of three-year, 7% 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.
Present value of bonds payable; discount Pinder Co. produces and sells high-quality video equipment. To finance its operations, Pinder issued $25,000,000 of three-year, 7% bonds, with interest payable semiannually, at a market (effective) interest rate of 9%. 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. Open spreadsheet Determine the present value of the bonds payable. Round your answer to the nearest dollar. $
Present value of bonds payable; discount 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. Open spreadsheet Determine the present value of the bonds payable. Round your answer to the nearest dollar. 22,729,071x Feedback Y Check My Work Remember, the selling price of a bond is the sum of the present values of: the face amount of the bonds due at the maturity date and the periodic interest to be paid on the bonds. The market rate of interest is used to compute the present value of both the face amount and the periodic interest.
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 $26,000,000 of 4-year, 11% bonds at a market (effective) interest rate of 9%, 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: 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…
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 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. $ 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…
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…
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 $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…
2.cengagenow.com/ilm/takeAssignment/takeAssignmentMain.do?invoker3D&takeAssignmentSessionLocator=&inprogress3false eBook Show Me How Calculator Print Item Entries for Issuing Bonds and Amortizing Discount by Straight-Line Method On the first day of its fiscal year, Chin Company issued $18,200,000 of five-year, 9% 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 11%, resulting in Chin receiving cash of $16,828,145. a. Journalize the entries to record the following: 1. Issuance of the bonds. 2. First semiannual interest payment. The bond discount is combined with the semiannual interest payment. (Round your answer to the nearest dollar.) 3. Second semiannual interest payment. The bond discount is combined with the semiannual interest payment. (Round your answer to the nearest dollar.) If an amount box does not require an entry, leave it blank. 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 $29,000,000 of three-year, 10% bonds at a market (effective) interest rate of 9%, 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.…