Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.

Get a Professional Answer

Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.

100% Satisfaction Guarantee

Rate the answer you receive.

Ask Manal Elkhoshkhany Your Own Question

Manal Elkhoshkhany, Bachelor's Degree

Category: Single Problem

Satisfied Customers: 9819

Experience: Finished my BA degree with a GPA of 4.0.

3708793

Type Your Single Problem Question Here...

Manal Elkhoshkhany is online now

Given the following data on bonds from AT&T, Dell, and IBM.

Customer Question

Given the following data on bonds from AT&T, Dell, and IBM. Each bond has a par value of $1000. AT&T Dell IBM Complete the table above. Calculate the value of the bond if your required return is 5% on AT&T, 6.5% on Dell, and 8% on IBM. Determine the yield to maturity (YTM) on the bonds given the current price. Based on each bond’s ratings and your determination of its yield to maturity, explain how you rank each bond for risk and return. Deliverable:

Submitted: 1 year ago.

Category: Single Problem

Share this conversation

Customer:replied 1 year ago.

I also need formula calculations along with answers please.

The coupon price for AT&T is 5.55% and Maturity is 5/15/2036 The coupon price for IBM is 7.00% and Maturity is 10/30/2025 The coupon price for Dell is 5.40% and the Maturity is 10/30/2025

No you do not have to pay anything additional, I am requesting you to provide the current prevailing market price of these bonds as without it the YTM may not be calculated, thanks.

Please double check the problem in your book/assignment, the problem should state the current price of the bond. I have answered the problem based on the numbers I have from an old assignment, so check cells "B30, C30, & D30" - I have highlighted those in red. If you enter the prices of the bonds provided in your assignment in those cells, excel would automatically calculate the solution for you. If you do not know how to do that, please upload the file with the full question to www.box.com then copy and paste the share link here.

Please click on the following link to download the solution:

If you have any questions, please do not hesitate to ask; if all is clear, please rate the service

P.S. If you like my services, please feel free to direct your future posts to me specifically by typing "For Manal Elkhoshkhany" at the beginning of your post. Should you choose to do this, please try to allow me at least 48 hours before the deadline. If you need to meet me online for a timed assignment, please advise me of the date and time (EST) you want me to meet you here and I will (Also please notify me at least 48 hours in advance) . Please make sure you take the length (and number) of the questions into consideration when making your offer to avoid delays in providing solutions.