How to get yield to maturity (YTM) with Excel & TI BA II+

Yield to maturity (YTM, yield) is the bond's internal rate of return (IRR). It is the rate that discounts future cash flows to the current market price.

Category:

Education

Tags:

• Finance
• Excel
• Quant

[yoelfn]

so easy to understand! thanks man, saved teh day for me haha

[JoeyGenau78]

@tackleashley I got that a lot too. The cause of error 5 is having both PV & FV negative or positive. One has to be outflow and one has to be input, meaning one negative; one positive.

[Yash4NZ]

Great video, your exaplanation was very clear :)



[edibledaze]

@alexzivo when you enter 950 for PV, be sure to press the +/- button, and then enter it as the PV. If you miss this then you will get the error message.

[tackleashley]

I tried to put all the figures into my calculator but it just says error 5 ? what am I doing wrong?

[2009worstyearever]

@Mj4665 did you put in a guess for the program? I got 7.138% following his steps.

[tanyamuriyan]

Try Asian women # lushfmlk.info #

[mualex3]

You helped me to understand the subject in 10 min way better than my prof at college

[Mj4665]

Thank you very much for the video, it was very helpful in solving my first calculation, but my second one doesnt seem to work! im told a bond has 10 years until maturity, a coupon rate of 8% and sells for $1100. I calculated my current yield on the bond as (80/1100 ) * 100 = 7.27% and i next needed to calculate the yeild to maturity. But when i followed your steps in excel my rate answer was #NUM! ... any ideas why ? thank you.

[xxxTUBATUBExxx]

excellent job... I really wish 2 b ur student coz my finance prof thinks we r already expert in these subjects. And he just explain things as if we already have met them b4...