Question: Yan Yan Corp. has a $ 2 , 0 0 0 par value bond outstanding with a coupon rate of 4 . 9 percent paid

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 percent. What is the dollar price of the bond?
\table[[Settlement date,11?2000
Can you do it on excel please
Yan Yan Corp. has a $2,000 par value bond outstanding with

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:

A test bond with par value = 100, annual coupon rate = 4.8% (paid semi-annually), maturity = one year, and market price = $100.50 is: (a) Overpriced by $0.93 O (b) Overpriced by $0.07 0 (c)...

Q:

9. Assume that you plan to buy a share of XYZ stock today and to hold it for 2 years. Your expectations are that you will not receive a dividend at the end of Year 1, but you will receive a dividend...

Q:

explanation needed in details(DON'T COPPY FROM OTHER SOURCES) 9. Assume that you plan to buy a share of XYZ stock today and to hold it for 2 years. Your expectations are that you will not receive a...

Q:

How to complete in excel urgent Excel Problem 3 Show All Excel Work (21 Points) You are evaluating two mutually exclusive projects, A and B. The cash flows are below. What is the IRR for each...

Q:

1 Excel Problem 2 Show All Excel Work (29 points) Browne Inc. is considering a capital project with average risk and needs to calculate the weighted 3 average cost of capital. The marginal tax rate...

Q:

1 Excel Problem 2 Show All Excel Work (29 points) Browne Inc. is considering a capital project with average risk and needs to calculate the weighted 3 average cost of capital. The marginal tax rate...

Q:

Chap 7: Bond Valuation 1. You are considering a 15-year, $1,000 par value bond. Its coupon rate is 9%, and interest is paid semi-annually. If you require a rate of 14.2%, how much should you be...

Q:

Please answer with formulas. Thank you! Excel Online Structured Activity: Bond valuation You are considering a 10-year, $1,000 par value bond. Its coupon rate is 11%, and interest is paid...

Q:

If I could get help with these following questions, that would be great! All the information is already provided. Question 1' Excel Online Structured Activity: Interest Rate Sensitivity A bond trader...

Q:

Your father is 50 years old and will retire in 10 years. He expects to live for 25 years after he retires, until he is 85. He wants a fixed retirement income that has the same purchasing power at the...

Q:

If Baker did not make the above june 30 adjusting entry for Supplies: The errors on the income Statement for June would be: item understated: Net Income items overstated: Supplies Expense, Total...

Q:

Tech Savvy, a computer consulting firm, has decided to write off the $8,375 balance of an account owed by a customer, Nick Wadle. Journalize the entry to record the write-off, assuming that (b) The...

Q:

Which of the following is true concerning SEP IRAs? Taxpayers with a SEP IRA must contribute for their employees. SEP IRAs allow only nondeductible contributions.

Q:

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

Q:

12. Select one or two goals and imagine the goal(s) being achieved to your full satisfaction. How does this goal, or how do these goals, relate to your vision? Experience the achievement of your...

Q:

10. Write down a set of values that are important to you. Ask family members and friends to encourage you to live according to your values.

Q:

9. Do I have what it takes in terms of ability, motivation, and personal traits to get there? This question may be answered through inventories or evaluations or through questioning others who are...