Question: please use excel formula to answer Yan Yan Cerp. has a $2,000 par value bond outstanding with a coupon rate of 4,7 percent paid semiannually

please use excel formula to answer

$please use excel formula to answer Yan Yan Cerp. has a \$2,000$

Yan Yan Cerp. has a \$2,000 par value bond outstanding with a coupon rate of 4,7 percent paid semiannually and 13 years to maturity The yield to maturity of the bond is 5.05 percent What is the dolar price of the bond? input area; function to answer this question. Leave the "dasis" input blank in the function. You may enter a constant as a hard coded value.)

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!

1.KatyDid Clothes has a $120 million (face value) 30-year bond issue selling for 101 percent of par that carries a coupon rate of 9 percent, paid semiannually. What would be KatyDid's before-tax...

Excel Online Structured Activity: Bond valuation You are considering a 10-year $1,000 par value bond. Its coupon rates and interest is paid semiannually. The data has been collected in the Microsoft...

Questions: Using the case study data: Create a table showing NWC each year 2. Calculate the FCF for each year Now calculate the free cash flow for every year; use the appropriate discount rate you...

Calculate the free cash flow for every year; use the appropriate discount rate. Accept it or reject it, why? Please answer whatever u can and show calculation, thank you Speakco is in the music...

please add excel formula 3 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 the bond is 3.8...

in excel formula please Yan Yan Corp. has a $2,000 par value bond outstanding with a coupon rate of 4.1 2 percent paid semiannually and 13 years to maturity. The yield to maturity of the bond is 5.05...

Excel Online Structured Activity: Bond valuation An investor has two bonds in her portfolio, Bond C and Bond Z. Each bond matures in 4 years, has a face value of $1,000, and has a yield to maturity...

QUESTION 1 A bond is maturing in 5 years, with R1000 par value and a coupon interest rate of 12% paid semi-annually, if the YTM (required rate of return) on similar risk bonds is 16%, calculate the...

Given the following information on a bond, Par value: $1000 Interest rate: 6% Coupon rate: 8% paid semiannually Years to maturity: 15 years, what is the expected price at the end of year 5? Select...

1 Bond valuation AN 15 $1,000.00 9.00% 2 7.51% 8 3 Years to maturity Par value of bond Coupon rate 6 Frequency interest paid per year 7 Effective annual rate 8 9 Calculation of periodic rate: 10...

A long cylinder of radius R1 is displaced along its axis with a constant velocity vo inside a stationary co-axial cylinder of radius R2. The space between the cylinders is filled with viscous liquid....

All questions in Part A must be answered. You do not have to use IRAC to answer questions in Part A. Each question in this part is worth 5 marks. Your answers should make reference to cases and...

Lequel de ces lments a ncessairement un effet dilutif? a) Les options d'achat d'actions lorsque le cours moyen de march pendant la priode est suprieur au prix d'exercice des options b) Les options...

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...