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

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
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.
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education