Question: i need the excel formula please Union Local School District has a bond outstanding with a coupon rate of 2.9 percent paid semiannually and 16

i need the excel formula please

Union Local School District has a bond outstanding with a coupon rate of 2.9 percent paid semiannually and 16 years to maturity. The yield to maturity on this bond is 2.7 percent, and the bond has a par value of $5,000. What is the dollar price 2 of the bond? 3 4 Input area: 5 6 Settlement date 1/1/2020 7 Maturity date 1/1/2036 8 Coupon rate 2.90% 9 Coupons per year 2 10 Redemption value (% of par) 100 11 Yield to maturity 2.70% 12 Par value $ 5,000 13 14 (Use cells A6 to B12 from the given information to complete this question. You must use the 15 16 17 Output area: 18 19 Price (%) 20 Price 21

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Attached are the two spreadsheets that I have already completed, but I can't for the life of me explain how the formula's work. I have also attached the questions that I have to answer. I have...

Hi please see attachments for better formatting, all questions are on Microsoft word attachment except for Ch. 5: Questions 3 & 4 & Chapter: 8 Question 6. have their own individual attached Microsoft...

Union Local School Districct has a bond outstanding witha coupon rate of 3.1 percent paid semiannually and 22 years to maturity. The yield to maturity on this bond is 3.4 percent, and the bond has a...

years to maturity. The bonds make semiannual payments and currently sell for 106.32 percent of par. What is the current yield on the bonds? The YTM? The effective annual yield? needed expansion...

1. Valuing Bonds What is the price of a 25-year, zero coupon bond paying $1,000 at maturity, assuming semiannual compounding, if the YTM is: a. 6 percent? b. 8 percent? c. 10 percent? 2. Valuing...

Hello, need help answering the problems attached. Please note that an excel worksheet has been provided for Ch. 8 question 6. Please show work. Chapter 8 Problems 4, 6, 7, 32 Input boxes in tan...

Please see attached. Any help would be greatly appreciated. For Chapter 5....I did the last part of question 3 and all of question 4. Can you please check my work? Thank you! Chapter 5 Question 1...

1 Even though most corporate bonds in the United States make coupon payments semiannually, bonds issued elsewhere often have annual coupon payments. Suppose a German company issues a bond with a par...

Even though most corporate bonds in the United States make coupon payments semiannually, bonds issued elsewhere often have annual coupon payments. Suppose a German company issues a bond with a par...

4. Yan Yan Corp. has a $2,000 par value bond outstanding with a coupon rate of 4.9% paid semiannually and 13 years to maturity. The yield to maturity is 3.8%. What is the price of the bond? 5. Union...

McNally Corporation makes a special ski. Next year, McNally hopes to produce 20,000 pairs of skis. Seven pounds of fiberglass are required to make each pair of skis. The company expects to have...

In Figure A a concrete lined channel is given. In Figure B the bottom of the same channel is covered by vegetation. Which channel carries more discharge providing that the channel geometric...

Question 7 The following table summarizes prices of various default - free zero - coupon bonds ( expressed as a percentage of face value ) : \ table [ [ Maturity ( years ) , 1 , 2 , 3 , 4 , 5

Add "Viggo Mortenslet cast = new Map ( ) ;en " to the cast as the key, with value "Aragorn".