Question: I need excel formula Yan Yan Corp. has a $2,000 par value bond outstanding with a coupon rate of 4.7 percent paid semiannually and 13

I need excel formula

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 5.05 percent. What is the dollar price of the bond?
Input area:
Settlement date 1/1/2020
Maturity date 1/1/2033
Coupon rate 4.70%
Coupons per year 2
Redemption value (% of par) 100
Yield to maturity 5.05%
Par value $2,000
(Use cells A6 to B12 from the given information to complete this question. You must use the built-in Excel function to answer this question. Leave the Basis input blank in the function. You may enter a constant as a hard coded value.)
Output area:
Price (% of par)
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!

Q:

Yan Yan Corp. has a $ 2 , 0 0 0 par value bond outstanding with a coupon rate percent paid semiannually and 1 3 years to maturity. The yield to maturity bond is 5 . 0 5 percent. What is the dollar...

Q:

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

Q:

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

Q:

Please show excel formula! 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...

Q:

Make sure to include the excel formula: 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...

Q:

1) The market for short-term debt is known as A) the money market. C) the notes market. B) the bond market. D) the capital market. 1) 2) A commercial bank will loan you $7,500 for two years to buy a...

Q:

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

Q:

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

Q:

*Please do not use Excel. Show detailed explanation. 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...

Q:

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

Q:

Brief Explanation Malcolm Gladwell's article on The Art of Failure is written for a different type of audience than Jensen and DiTiberios article on "Personality and Individual Writing Processes....

Q:

How can managers' decisions affect an entity's cash flow and cash from operations? How are these decisions different from managers' ability to influence accrual financial statements?

Q:

Investors using the strategy of _ _ _ _ _ try to find stocks that are undervalued in the market.market timing investing for growth buying and holding value investing

Q:

CT Corp Comprehensive Question Canadian Tire Corporation, Limited (Canadian Tire) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

Q:

12. Explain how training relates to attracting new employees, employee retention, and motivation.

Q:

11. How has new technology improved training and development? What are some of the limitations of using iPods or PDAs for training?

Q:

10. What are the implications of the aging work force? What strategies should companies consider from a training and development perspective to best utilize older employees and prepare for their...