Amortization Schedule using BA II Plus

This video explains how to construct an amortization schedule using the TI BA II Plus calculator.
The method discussed is also used to calculate mortgage payments.
Calculating Bond Price: • Calculating Bond Value...

[@PerryCuda]

CFA WARNING!: when you have finished this calculation in the Level 1 CFA Quant section make sure to reset your I/Y default to P/Y = 1, C/Y = 1. Otherwise, you'll miscalculate ALL of your fixed income calculations, your dilutive securities, any cost of capital problems, and any TVM problem. It's almost not even worth the risk of doing it this way.

[@WorldWideSk8boarding]

instead of setting C/Y you can also just find EAR not sure whats better... i think im going to avoid risking forgetting to set C/Y back to 1 lol

[@elivelie9249]

do not disrespect my King Joshua Emmanuel

[@ZekeRodriguezshow]

This explanation is better than the $200.00 software I purchased for my Finance class ha ha/ Thanks for the upload!

[@davidcooper7339]

Finally I've figured out that there's nothing wrong with my calculator and this example proved a success. Excellent demonstration.

[@MrMatt0329]

watched this before my exam the other day, perfect video, thank you so much.

[@bookedtea]

I cannot thank you enough for your tutorials. you've definitely saved me more than once and I've only had class for a week!

[@belkacemguehaiz3988]

Thank you for the video! Much appreciated. Learned more in your 4 min video than a whole class at University

[@becca7984]

Thanks so much for your video! I'm in an introductory accounting class and I was doing this by hand! This makes it so much easier with this calculator, and your explanation! 🙂

[@celiaschirado9384]

thank you!! I like the way you explained it.

[@ShahidulIslam-wr5lw]

Thanks a lot. I don't know how to calculate amortisation in calculator. This video helped me to get it.

[@tejiriaren3982]

Thanks a million Joshua Emmanuel, you are a life saver!

[@GMornat]

Thanks for your content Joshua, always super clear !

[@Pysankarka]

Thank you! Great video, so easy to follow and understand. Thanks again.

[@romanotafaj9818]

Thanks man, nice and clear to understand!

[@justineowona4291]

THANK YOU SO MUCH!!! you taught me so much in this short video!!

[@stephaniealdana5088]

This was extremely helpful! Thank you.

[@alexandrabunker1012]

Thank you so much Joshua, this was very helpful!

[@danf73]

Wow, what an awesome explanation! Thank you!

[@ebtisamalhunaidi1462]

you save my life for the next exam ,,,, appreciate it

[@carolinalynch2087]

Greatttttt video, so simple to understand. I so needed this for financial management course.

[@perspective1409]

My teacher went way too fast so I ended up writing the steps down wrong. Thanks for the clear explanation!

[@bernardchung1443]

The video is super good! Thank you so much!

[@ericzhou9053]

Thanks for helping! what a good job!

[@chrisstubstad148]

Your videos are great. Thank you

[@lenanguyennn]

thank you so much. this has helped immensely!

[@miss_gono]

The best explanation i'v ever seen! myb exam is tomorrow!

[@mindykanaskie3938]

Brilliant, thank you! BTW, you can change the number of decimal places by using 2nd, Format, then type the number of decimal places you'd like,then press enter.

[@MikeSmith-xg5nw]

Amazing video, thanks a lot man!

[@matthewagnello1208]

Great explanation, thanks!

[@RaulPelcastreRealEstate]

Very clear instructions and video quality.

[@laurenbellamy]

This is great, thank you so much!

[@solnest555]

You are great teacher, you saved my bmat! Thank u!!!@!😘

[@yannischristodoulides9673]

Great video. Thank you.

[@dorischong2518]

thx for the explanation, Joshua!

[@joshemman]

Doris Chong You're welcome Doris.

[@becca7984]

Just as a side note, after you calculate PMT, and then hit 2ND AMORT, you can just click CPT after P1 and it will automatically go to 2nd Payment :) If that's easier for you, rather than clicking 2 and then P1 and P2 :)

[@mihikajoshi3928]

Hey, thanks for the tip! Do you know what the difference between P1 and P2 is?

[@conniemasiya7425]

Thank you, saves time

[@mmx0732]

Super, thanks!

[@GhoulPB]

I've been struggling so much in my financial math course, you sir are a hero.

[@maujranii]

You are great. Thanks!

[@nataliechua9934]

I love this! This was like magic :) thanks for the video

[@joshemman]

You're welcome, Natalie.

[@irina-alexandra.constantinescu]

Excellent! Thank you!

[@AloneMaru]

Thank you very much!

[@henryy6918]

Thank you Josh!

[@andrewgarrettdrums]

You're a legend

[@oatsnahhh4774]

Thank you so much.

[@AlwaysHappyReading]

Thanks, so perfect~~!!!

[@diane4993]

thanks a million!

[@CC-es1jm]

nicely done!

[@Clifffffffffford]

Thanks Joshua!

[@oluwadamiloladaniel5140]

Thank you!

[@greensea66]

Thank you!!

[@brettswannell9828]

Is there a way to find out the total principle remaining or paid off up to a certain point without having to add them up and create a table by hand? I understand its not necessary for a 4-year amortization schedule but would be EXTREMELY helpful when I am working on a 30-year mortgage with monthly payments

[@rheinxromer]

oh man thanks so much

[@sajadahmad333]

Great Video Joshua, One Questions, my calculator shows cumulative interest instead of current period interest. Any reason?

[@qatar0064]

thank you

[@a.g.6119]

Thank you

[@dhruvtrivedi7689]

thanks josh

[@footballfc2924]

hi joshua, thanks for your video! i was trying out examples of amortisation schedules using the baii calculator and got a doubt. If my principal is 20000 and the rate is 2% pa to be paid in 5 years (60 payments), I get 60 payments of 333.50 which added together yield 20009.76, but I expected it to have yielded more than that, like more towards 20000+(2%*20000=400). Can anyone tell me what I'm thinking or doing wrong? regards, jose'

[@hlengiwemkhabela2665]

Wow thank you very much for FV 0. My interest was so wrong bcos I ddnt press FV 0 thanks

[@JJayesh_Rathod]

Thanks bro

[@michaelguadagno4453]

Is there a quick and easy way to calculate total interest paid over the loan term on the BAII or in excel instead of constructing an amort schedule?

[@niccolatartaglia3016]

Great video, but is is still incumbent on you to explain when you clear TVM and when you don't. At 2:10 you are re-inputting the payment of 6071.14 although it is still saved in the key PMT from before. The reason why I think this is important is because I do not understand which parts of the previous computation are necessary to create the amortization table. Still very helpful video!!!

[@joshemman]

+Niccola Tartaglia At 2:10, you really don't have to re-input PMT. But in real-life situations, you don't make payments of 607.13894... You pay 607.14.

[@niccolatartaglia3016]

+Joshua Emmanuel Oh ok, I see, now I get it. I was a little bit confused because I thought that you deleted everything in the TVM memory before (with 2nd CLR TVM) and then ONLY typed in the payment of 607.14. But that of course does not work. Thanks for your reply and thanks for the video, very good explanation!!!!

[@JennyFarley]

thanks bro

[@joshemman]

You5re welcome, Jenny.

[@andrewrossman8022]

Hi Josh- i really like your video. Is there somewhere to download the calculator for my computer?

[@joshemman]

I'm not aware of any download source for the BAII Plus for desktop/laptop. However, you can download the app from the App store.

[@andrewrossman8022]

+Joshua Emmanuel Thanks for the quick response! I have the app downloaded for my iPhone but don't see a way for me to download the calculator to my laptop. How were you able to make this video if you didn't have the calculator downloaded to your computer?

[@joshemman]

Professors teaching with the BA II Plus get a USB emulator from the manufacturer. It's a plug & play device. No installer.

[@kuldeepchawla8106]

Hi, I was wondering how to calculate the rate, if we have FV, PV and N. My BI ii gives me error message if i follow the instructions. Could you please help me out.

[@jidefolami1933]

Please ensure that the PV and FV are in alternating signs. For example, PV could be set as a negative number to indicate initial cash outflow, then, FV would set as a positive number to indicate cash inflow at the end of the investment period of N.

[@mdell-t4655]

I have been trying to figure out uneven payments

[@hanalalhan]

Hi I followed you step by step, but I didn't get the same numbers you got for balance, PRN, INT, what would be the mistake?

[@joshemman]

Maybe you re-input the PMT incorrectly. Try doing it again without re-inputting PMT (You don't actually have to). Let me know if that works please.

[@birdy2008100]

At 3:03, the interest inputted for the second year is 1280.09, and it is wrong. The calculator shows the right number 1284.087236. Others are perfect.

[@darrennathaniel552]

Hi Joshua, can I ask is it possible to solve this question with the default C/Y = 1 and P/Y = 1? Therefore my N= 16, I/Y = 2, FV = 0, PV = -20,000 and solve for PMT. however the answer i get is 5892.01. is there something i missed?

[@joshemman]

It won't work this way. First, N is the number of payments; there are only 4 payments, not 16. Second, since payment interval and compounding frequency are different, you will first need to convert the interest rate to annual rate which is not 2%.

[@darrennathaniel552]

@@joshemman thank you sir i appreciate the reply!

[@fernandocruz-zf3gc]

May I ask why the first year interest is not 20000*8%?

[@timy8749]

Because he set C/Y=4, which means the loan is compounding quarterly. That's why the interests from the first year is greater than $1600

[@shijothomas7855]

if you put pv in negative pmt should be in positive then only getting bal 15577.5

[@joshemman]

+shijo thomas If you input -ve PV, PMT will be +ve, & your BAL should be negative (-15577.50) in the first period.

[@singpankipietro763]

How if the payment made every three month? What is the p/y ?

[@becca7984]

You might have to take 3 months ÷ by 12 to get # of years. That's just my guess....

[@Zi_gemi8222]

My Bal shows 27,719.78 and I don't know why

[@ann-stephaniedumont2684]

When you are ready to Amort, why do you put P1 ENTER and P2 ENTER ?

[@joshemman]

P1 = Payment interval 1, P2 = Payment interval 2, and so on.

[@ann-stephaniedumont2684]

Thank you for the quick reply !

[@randiaz95]

In the video you said p1 was beginning period and p2 is the ending period so if you put p1=1 and p2=4 it will get all of the interest payments principal payments and balance throughout 1 to 2?

[@joshemman]

You mean 1 to 4?

[@randiaz95]

Yeah

[@ppppp1378]

Now i can pass the exam

[@some_dude_nate]

ok how do you solve for a 30 year without doing this long process

[@joshemman]

It depends on what you're looking for. See if this helps: kzbin.info/www/bejne/a2bbmHhqZaqlqLc or this kzbin.info/www/bejne/qYXLl6yigpWmirc

[@juliusseizure5705]

You actually put $1280.09 in P2 interest when it should've been $1,284.09

[@contacttimbre]

Doesn't work by these directions. I have watched and done this several times

[@sophiastaub3877]

Thank you