Union Local School District has bonds outstanding with a coupon rate of 3.7 percent paid semiannually and 16 years to maturity. The yield to maturity on these bonds is 3.9 percent and the bonds have a par value of $5,000. What is the dollar price of the bond? Settlement date Maturity date Coupon rate Coupons per year Redemption value (% of par) Yield to maturity Par value $ 1/1/2000 1/1/2016 3.70% 2 100 3.90% 5,000 Complete the following analysis. Do not hard code values in your calculations. Leave the "Basis" input blank in the function. You must use the built-in Excel function to answer this question. Dollar price
Union Local School District has bonds outstanding with a coupon rate of 3.7 percent paid semiannually and 16 years to maturity. The yield to maturity on these bonds is 3.9 percent and the bonds have a par value of $5,000. What is the dollar price of the bond? Settlement date Maturity date Coupon rate Coupons per year Redemption value (% of par) Yield to maturity Par value $ 1/1/2000 1/1/2016 3.70% 2 100 3.90% 5,000 Complete the following analysis. Do not hard code values in your calculations. Leave the "Basis" input blank in the function. You must use the built-in Excel function to answer this question. Dollar price
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
Please do not give handwritten answers thanku
![Paste
Clipboard T
Al
1
2
3
4
S
6
7
8
9
10
11
12
FILE
13
14
15
16
17
18
19
20
%
READY
Attempt(s)
HOME
Calibri
BIU-
B
INSERT
V
1
Font
X
.
Sheet1
PAGE LAYOUT
✓
C
→
A A
fr
G
Calculating a bond price - Excel
FORMULAS
DATA
%
Alignment Number
Settlement date
Maturity date
Coupon rate
Coupons per year
Redemption value (% of par)
Yield to maturity
Par value
D
$
Conditional Format as Cell
Formatting Table Styles-
Styles
1/1/2000
1/1/2016
3.70%
REVIEW
E
2
100
3.90%
5,000
VIEW
F
G
Cells
Union Local School District has bonds outstanding with a coupon rate of 3.7 percent paid
semiannually and 16 years to maturity. The yield to maturity on these bonds is 3.9 percent
and the bonds have a par value of $5,000. What is the dollar price of the bond?
H
[[[1]]
E
3
? B
M
Editing
T
Sign In
Complete the following analysis. Do not hard code values in your calculations. Leave
the "Basis" input blank in the function. You must use the built-in
answer this question.
Excel function to
Dollar price
J
x
<
3
4
100%](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F306544d4-bfab-472e-b269-53a01660a688%2F8b84cea8-6846-420f-98ad-ecbb1046b937%2F8jxgxot_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Paste
Clipboard T
Al
1
2
3
4
S
6
7
8
9
10
11
12
FILE
13
14
15
16
17
18
19
20
%
READY
Attempt(s)
HOME
Calibri
BIU-
B
INSERT
V
1
Font
X
.
Sheet1
PAGE LAYOUT
✓
C
→
A A
fr
G
Calculating a bond price - Excel
FORMULAS
DATA
%
Alignment Number
Settlement date
Maturity date
Coupon rate
Coupons per year
Redemption value (% of par)
Yield to maturity
Par value
D
$
Conditional Format as Cell
Formatting Table Styles-
Styles
1/1/2000
1/1/2016
3.70%
REVIEW
E
2
100
3.90%
5,000
VIEW
F
G
Cells
Union Local School District has bonds outstanding with a coupon rate of 3.7 percent paid
semiannually and 16 years to maturity. The yield to maturity on these bonds is 3.9 percent
and the bonds have a par value of $5,000. What is the dollar price of the bond?
H
[[[1]]
E
3
? B
M
Editing
T
Sign In
Complete the following analysis. Do not hard code values in your calculations. Leave
the "Basis" input blank in the function. You must use the built-in
answer this question.
Excel function to
Dollar price
J
x
<
3
4
100%
Expert Solution
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 2 steps with 2 images
Recommended textbooks for you
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education