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

[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?

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

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

[2009worstyearever]

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

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

[Deerok4Dragon7]

yea what a pain my textbook blows at explaining how to get...

[rkuanysh]

thank you so much, you make more sense than my textbook. lol

[Pinkish92]

thank you! now if only my prof taught this to the class before she assigned the assignment

[scarletxandra]

Thanks for all your help!!

[elbastaki]

Thank you David. This is very informative.

[delenalena]

why the formula is error in NPER, PMT ?????

is there something wrong with "number currency, or something like that??? could anyone give explain??

[bortho101]

Thanks heaps david, very informative

[souljahqt]

Thank You so much David, I wish my textbook or professor did it this way! You saved my grade!!!!!

[oatmeal10011]

Thank you for doing this video. This saved me loads of time figuring this out. Would you do this similarly to calculate YTC, but use the number of periods to call rather than number of periods to maturity?

[nighthawk3210]

That was a huge help, thank you so much!!

[KOREAPUMP]

That's nice and easy-understood video~

[lordbinder]

its an interesting solution, but aplying it in some cases wont work. For instance a bond that pays monthly an interest of 0.431% and pays montlhy equal amortizations with a technical price of 90.32 and a market price of 68.6: maturity at jan 2016 will give 3,94 with your solution and the real IRR as today was 17.21%. Am i missing something?