Question: 11 Please show your work so I can learn it You find a zero coupon bond with a par value of $10,000 and 17 years

11 Please show your work so I can learn it

You find a zero coupon bond with a par value of $10,000 and 17 years to maturity. If the yield to maturity on this bond is 4.9 percent, what is the price of the bond? Assume semiannual compounding periods. Settlement date Maturity date Coupon rate Coupons per year Redemption value (% of par) Yield to maturity Par value 1/1/2000 1/1/2017 0.00% - 2 100 4.90% 10,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

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!

12 Please show your work so I can learn it Yan Yan Corp. has a $2,000 par value bond outstanding with a coupon rate of 4.9 percent paid semiannually and 13 years to maturity. The yield to maturity of...

Complete the problems in an Excel spreadsheet. Be sure to show your work to receive credit; no hard keys. Q/ A zero coupon bond matures in 10 years with 1,000 SAR par value. The market's required...

Question 1 During the last holiday, you worked in a commercial bank as an Intern. In the first week, you were assigned to work with the bond desk. The first task given to you is to price two (2)...

Pls show calculations. 1) Consider an 8% coupon bond selling for $953.10 with three years until maturity making annual coupon payments. The interest rates in the next three years will be, with...

10 Please show your work so I can learn it A Japanese company has a bond outstanding that sells for 91.53 percent of its \100,000 par value. The bond has a coupon rate of 3.4 percent paid annually...

Please show your work. Thanks! Regal Health Plans issued a 12 percent annual coupon bond a few years ago. The bond now sells for $1,100. The bond has a call provision that allows Regal to call the...

eBookCheck my workCheck My Work button is now enabledItem 3 You find a zero coupon bond with a par value of $10,000 and 20 years to maturity. The yield to maturity on this bond is 4.2 percent. Assume...

Please show all work and no excel!! 8. Joann buys a ten-year 10,000 floating rate par value bond with annual coupons. She knows the coupons will be level at 6.5% for the first five years, and then...

Please show your work in excel and by calculator You find the following Treasury bond quotes. To calculate the number of years until maturity, assume that it is currently May 2022 . All of the bonds...

Hello my friend please assist me with my discussion Interest Rates Negotiation is a soft skill that might just be one of the most important skills you will ever learn. For this Discussion you will...

In a three-person team, role-play the following individuals who are visiting a local car dealership: (1) A 19-year-old college student, (2) One-half of a young married couple with two children, (3) A...

The stockholders equity accounts of Neer Corporation on January 1, 2010, were as follows. Preferred Stock (8%, $50 par, cumulative, 10,000 shares authorized) $ 400,000 Common Stock ($1 stated value,...

Current Attempt in Progress Mary just bought a 2 0 - year bond with an 8 % coupon rate ( paid semi - annually ) and $ 1 0 0 0 par value for $ 1 0 5 0 . She is expecting an effective annual yield (...

P-1) (100 Pts.) A chemical manufacturing company (CMC) has a contract for the procurement of the neccssaly chemicals from four suppliers. The chemicals purchased from Supplier A are priced at $20...

1. LaunchPad for Real Communication offers key term videos and encourages selfassessment through adaptive quizzing. Go to bedfordstmartins.com/realcomm to get access to: LearningCurve Adaptive...

3. For an interesting look at conflict and debate, you need not search further than the U.S. Congress. Debates on the floor of the Senate and House of Representatives are broadcast on C-SPAN and...

2. Identify conflict triggers in yourself and others