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...
Related questions
Question
![eBook
X
Open spreadsheet
Show Me How
Present value of bonds payable; discount
Pinder Co. produces and sells high-quality video equipment. To finance its operations, Pinder issued $20,000,000 of four-year, 8% 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.
$
Office 365
Determine the present value of the bonds payable. Round your answer to the nearest dollar.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F45a539d8-0175-49be-87b9-0888edd41698%2Fb19551f8-451e-4f9b-86d4-dc920ce75dfb%2Fbafbibc_processed.jpeg&w=3840&q=75)
Transcribed Image Text:eBook
X
Open spreadsheet
Show Me How
Present value of bonds payable; discount
Pinder Co. produces and sells high-quality video equipment. To finance its operations, Pinder issued $20,000,000 of four-year, 8% 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.
$
Office 365
Determine the present value of the bonds payable. Round your answer to the nearest dollar.
![Excel template - Saved
5v
File
B13
234
5
6
7
8
9
Home
v
16
17
18
19
20
21
22
✓
Insert
10
11
12
13 PV of bonds
14
15
Arial
X ✓ fx
A
B
1 Present value of bonds payable; discount
DATA
Face amount of bonds
Contract rate of interest
Term of bonds, years
Market rate of interest
Interest payment
Draw
Page Layout
10 v
$20,000,000
8%
4
11%
Semiannual
Amount
Formulas
k
C
Search (Option + Q)
B H✓ ✓ Av ..
...
Data
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.
Formula
CHERY
Review
View
Evab
D
Help
Editing
Currency
E
$ ✓
-0
.00](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F45a539d8-0175-49be-87b9-0888edd41698%2Fb19551f8-451e-4f9b-86d4-dc920ce75dfb%2Fbdidzyn_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Excel template - Saved
5v
File
B13
234
5
6
7
8
9
Home
v
16
17
18
19
20
21
22
✓
Insert
10
11
12
13 PV of bonds
14
15
Arial
X ✓ fx
A
B
1 Present value of bonds payable; discount
DATA
Face amount of bonds
Contract rate of interest
Term of bonds, years
Market rate of interest
Interest payment
Draw
Page Layout
10 v
$20,000,000
8%
4
11%
Semiannual
Amount
Formulas
k
C
Search (Option + Q)
B H✓ ✓ Av ..
...
Data
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.
Formula
CHERY
Review
View
Evab
D
Help
Editing
Currency
E
$ ✓
-0
.00
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
![Excel Applications for Accounting Principles](https://www.bartleby.com/isbn_cover_images/9781111581565/9781111581565_smallCoverImage.gif)
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
![Excel Applications for Accounting Principles](https://www.bartleby.com/isbn_cover_images/9781111581565/9781111581565_smallCoverImage.gif)
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning