Question: 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

in excel formula please in excel formula please Yan Yan Corp. has a $2,000 par value

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 percent. What is the dollar price of the bond? 3 4 Input area: 13 14 function to answer this question. Leave the "Basis" input blank in the function. You may 15 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!

IN EXCEL FORMULA PLEASE! 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...

Please show excel formulas used. A Cameron Corp. bond has a $1,000 par value, a 5 percent coupon rate paid semiannually, and nine years until maturity. If similar investments yield 6%, what is the...

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...

need excel formula help asap! Yan Yan Corp. 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...

i need the excel equations please Yan Yan Corp. 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...

Need to complete 10 homework but now i need 5 homework then after some time 5 homework more. Here it is attachment. Chapter 5 HW Questions [ALL OF THESE MUST BE DONE IN EXCEL] 1. Future value: Chuck...

Jays Grappling Gym has an outstanding bond that has a $1,000 par value and a 6.5% coupon rate. Interest is paid semi-annually. The bond has 13 years remaining until it matures. Today the going...

I need help using a formula and showing me how to do it for myself, Thank you!! # 2 Jays Grappling Gym has an outstanding bond that has a $1,000 par value and a 6.5% coupon rate. Interest is paid...

please show work # 2 - Jay's Grappling Gym has an outstanding bond that has a $1,000 par value and a 6.5% coupon rate. Interest is paid semi-annually. The bond has 13 years remaining until it...

17. Solve for price and price% in Excel and show formulas please. Yan Yan Corp. has a $2,000 par value bond outstanding with a coupon rate of 4.7 percent paid semiannually and 13 years to maturity....

Air pollution in large U.S. cities is monitored to see whether it conforms to requirements set by the Environmental Protection Agency. The following data, expressed as an air pollution index, give...

Must an equation of state satisfy the two conditions in Eqs. 13.50 and 13.51?

Computer Science fast fast pls pls CIST 2 4 5 2 v 7 Capstone Network information VLANs on MLS . Network will use 1 0 . 5 5 . 2 4 0 . 0 2 0 for 5 subnets. End devices will be assigned addresses via...

10) For a bond that pays cash interest (i.e., not a zero coupon bond), YTM is (a) always equal to the coupon rate (b) always equal to the current yield (c) is always less than the coupon rate (d) can...

9. Explain the relationship between identity and communication.

a. How do you think these stereotypes developed?

a. How many different groups were represented?