Compute bond proceeds, amortizing premium by interest method, and interest expense

Principles of Accounting Volume 1
19th Edition
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax
Chapter13: Long-term Liabilities
Section: Chapter Questions
Problem 5PB: Dixon Inc. issued bonds with a $500,000 face value, 10% interest rate, and a 4-year term on July 1,...
icon
Related questions
icon
Concept explainers
Topic Video
Question
Compute bond proceeds, amortizing premium by interest method, and interest expense
4. BE.11.05 ALGO
Ware Co. produces and sells motorcydle parts. On the first day of its fiscal year, Ware issued $28,000,000 of four-year, 11% bonds at a market
5. BE.11.06 BLANKSHEET
(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.
6. EX.11.01
7. EX.11.02 ALGO
Open spreadsheet
8. EX.11.03 ALGO
9. EX.11.05 ALGO
Compute the following
a. The amount of cash proceeds from the sale of the bonds. Round your answer to the nearest dollar.
10. EX 11.07
11. EX 11.15
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,
12. PR 11.01A BLANKSHEET
13. PR 11.02A BLANKSHEET
C. The amount of premium to be amortized for the second semiannual interest payment period, using the interest method. Round your answer to the
14. EX 11.10.EXCELALGO
nearest dollar,
15. EX 11.12 EXCELALGO
d. The amount of the bond interest expense for the first year. Round your answer to the nearest dollar.
16. EX 11.16.EXCELALGO
17. EX 11.17. EXCELALGO
Check My Work
Previous
Next
Progress: 16/17 items
Transcribed Image Text:Compute bond proceeds, amortizing premium by interest method, and interest expense 4. BE.11.05 ALGO Ware Co. produces and sells motorcydle parts. On the first day of its fiscal year, Ware issued $28,000,000 of four-year, 11% bonds at a market 5. BE.11.06 BLANKSHEET (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. 6. EX.11.01 7. EX.11.02 ALGO Open spreadsheet 8. EX.11.03 ALGO 9. EX.11.05 ALGO Compute the following a. The amount of cash proceeds from the sale of the bonds. Round your answer to the nearest dollar. 10. EX 11.07 11. EX 11.15 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, 12. PR 11.01A BLANKSHEET 13. PR 11.02A BLANKSHEET C. The amount of premium to be amortized for the second semiannual interest payment period, using the interest method. Round your answer to the 14. EX 11.10.EXCELALGO nearest dollar, 15. EX 11.12 EXCELALGO d. The amount of the bond interest expense for the first year. Round your answer to the nearest dollar. 16. EX 11.16.EXCELALGO 17. EX 11.17. EXCELALGO Check My Work Previous Next Progress: 16/17 items
X Excel
template - Saved
File
Home
Insert
Formulas
Data
Review
View
Help
Tell me what you want to do
OComments
X Cut
国
E Autosum- 7 O
Arial
10 . A A"
Currency
Copy
Insert Delete Format OClear
Paste
$- % > * 4
Cell
Formatting - as Table- Styles
Sort & Find d
Fiter Select
Conditional Format
BIUR
Format Painter
Undo
Cipboard
Font
Algnment
Number
Tabies
Cels
tating
C13
Compute bond proceeds, amortizing premium by interest method, and interest expense
DATA
4 Face amount of bonds
$28.000,000
11%
Contract rate of interest
Term of bonds. years
Market rate of interest
8 Interest payment
9%
Semiannual
Using formulas and cell references, perform the required analysis, and input your answers into the Amounts
column. Transfer the numeric results for the green entry cells (C13.C16) into the appropriate fields in CNOWV2 for
10 grading
12
13 a PV of cash proceeds
14 b. Premium amortized for the 1st interest payment period
15 c. Premium amortized for the 2nd interest payment period
16 d. Interest expense for the 1st year
Amounts
Formulas
A Data +
Transcribed Image Text:X Excel template - Saved File Home Insert Formulas Data Review View Help Tell me what you want to do OComments X Cut 国 E Autosum- 7 O Arial 10 . A A" Currency Copy Insert Delete Format OClear Paste $- % > * 4 Cell Formatting - as Table- Styles Sort & Find d Fiter Select Conditional Format BIUR Format Painter Undo Cipboard Font Algnment Number Tabies Cels tating C13 Compute bond proceeds, amortizing premium by interest method, and interest expense DATA 4 Face amount of bonds $28.000,000 11% Contract rate of interest Term of bonds. years Market rate of interest 8 Interest payment 9% Semiannual Using formulas and cell references, perform the required analysis, and input your answers into the Amounts column. Transfer the numeric results for the green entry cells (C13.C16) into the appropriate fields in CNOWV2 for 10 grading 12 13 a PV of cash proceeds 14 b. Premium amortized for the 1st interest payment period 15 c. Premium amortized for the 2nd interest payment period 16 d. Interest expense for the 1st year Amounts Formulas A Data +
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Financial Statements
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning