At Westonci.ca, we provide clear, reliable answers to all your questions. Join our vibrant community and get the solutions you need. Get immediate and reliable solutions to your questions from a knowledgeable community of professionals on our platform. Join our platform to connect with experts ready to provide precise answers to your questions in different areas.
Sagot :
Answer:
YTM is 7.54%.
Explanation:
The yield to maturity can be calculated using the following RATE function in Excel:
YTM = RATE(nper,pmt,-pv,fv) .............(1)
Where;
YTM = yield to maturity = ?
nper = number of periods = number of years to maturity = original maturity number of years - number of years between January 1, 2016 and January 1, 2018 = 20 - 2 = 18
pmt = annual coupon payment = face value * annual coupon rate = 1000 * 9% = 90 (Note: This is an inflow to the bondholder and it is therefore a positive figure).
pv = present value = current bond price = -1141.20 (Note: This is an outflow to the buyer of the bond and it is therefore a negative figure).
fv = face value of the bond = 1000 (Note: This is an inflow to the bondholder and it is therefore a positive figure).
Substituting the values into equation (1), we have:
YTM = RATE(18,90,-1141.20,1000) ............ (2)
Inputting =RATE(18,90,-1141.20,1000) into excel (Note: as done in the attached excel file), the YTM is obtained as 7.54%.
Therefore, YTM is 7.54%.
We hope this was helpful. Please come back whenever you need more information or answers to your queries. Thanks for using our platform. We aim to provide accurate and up-to-date answers to all your queries. Come back soon. Keep exploring Westonci.ca for more insightful answers to your questions. We're here to help.