3. 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? 1/1/2000 1/1/2016 3.70% 2 100 3.90% $ 5,000 4 5 56 7 Settlement date Maturity date 8 Coupon rate э Coupons per year 0 Redemption value (% of par) 1 Yield to maturity 2 Par value 3 4 5 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. 6 7 Dollar price 8

Principles of Accounting Volume 1
19th Edition
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax
Chapter13: Long-term Liabilities
Section: Chapter Questions
Problem 4EA: On January 1, 2018, Wawatosa Inc. issued 5-year bonds with a face value of $200,000 and a stated...
icon
Related questions
Question

snl 

3.
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?
1/1/2000
1/1/2016
3.70%
2
100
3.90%
$
5,000
4
5
56
7
Settlement date
Maturity date
8
Coupon rate
э
Coupons per year
0
Redemption value (% of par)
1
Yield to maturity
2
Par value
3
4
5
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.
6
7
Dollar price
8
Transcribed Image Text:3. 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? 1/1/2000 1/1/2016 3.70% 2 100 3.90% $ 5,000 4 5 56 7 Settlement date Maturity date 8 Coupon rate э Coupons per year 0 Redemption value (% of par) 1 Yield to maturity 2 Par value 3 4 5 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. 6 7 Dollar price 8
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
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