Please provide the current price of bonds
Please provide current market price of bond to calculate YTM, thanks.
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.
It should be available in the market where they are traded like New York Stock Exchange, etc.
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.
You must be using a mac :), please copy the link to your browser and it will open (I am always facing this problem too :)
Were you able to access the file?