Amortization Schedule using BA II Plus
Вставка
- Опубліковано 30 вер 2024
- 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...
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.
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
do not disrespect my King Joshua Emmanuel
This explanation is better than the $200.00 software I purchased for my Finance class ha ha/ Thanks for the upload!
watched this before my exam the other day, perfect video, thank you so much.
Thanks a lot. I don't know how to calculate amortisation in calculator. This video helped me to get it.
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 :)
Hey, thanks for the tip! Do you know what the difference between P1 and P2 is?
Thank you, saves time
Super, thanks!
thank you!! I like the way you explained it.
appreciate your services
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?
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%.
@@joshemman thank you sir i appreciate the reply!
Thanks man, nice and clear to understand!
Thank you so much.
You actually put $1280.09 in P2 interest when it should've been $1,284.09
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
My teacher went way too fast so I ended up writing the steps down wrong. Thanks for the clear explanation!
Doesn't work by these directions. I have watched and done this several times
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!!!
+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.
+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!!!!
My Bal shows 27,719.78 and I don't know why
thank you so much. this has helped immensely!
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!
The video is super good! Thank you so much!
thanks bro
You5re welcome, Jenny.
thx for the explanation, Joshua!
Doris Chong
You're welcome Doris.
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'
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.
Finally I've figured out that there's nothing wrong with my calculator and this example proved a success. Excellent demonstration.
Wow thank you very much for FV 0. My interest was so wrong bcos I ddnt press FV 0 thanks
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?
Great Video Joshua, One Questions, my calculator shows cumulative interest instead of current period interest. Any reason?
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.
ok how do you solve for a 30 year without doing this long process
It depends on what you're looking for. See if this helps: ua-cam.com/video/55xgE40ErrU/v-deo.html or this ua-cam.com/video/sThfylM0sTU/v-deo.html
Thank you for the video! Much appreciated. Learned more in your 4 min video than a whole class at University
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! 🙂
You are great teacher, you saved my bmat! Thank u!!!@!😘
May I ask why the first year interest is not 20000*8%?
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
Thanks for your content Joshua, always super clear !
The best explanation i'v ever seen! myb exam is tomorrow!
THANK YOU SO MUCH!!! you taught me so much in this short video!!
Thank you! Great video, so easy to follow and understand. Thanks again.
Greatttttt video, so simple to understand. I so needed this for financial management course.
Very clear instructions and video quality.
Thank you!
How if the payment made every three month? What is the p/y ?
You might have to take 3 months ÷ by 12 to get # of years. That's just my guess....
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.
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.
I have been trying to figure out uneven payments
Thanks a million Joshua Emmanuel, you are a life saver!
Thank you so much Joshua, this was very helpful!
Your videos are great. Thank you
Thank you
you save my life for the next exam ,,,, appreciate it
This is great, thank you so much!
Wow, what an awesome explanation! Thank you!
This was extremely helpful! Thank you.
if you put pv in negative pmt should be in positive then only getting bal 15577.5
+shijo thomas
If you input -ve PV, PMT will be +ve, & your BAL should be negative (-15577.50) in the first period.
Thanks for helping! what a good job!
I love this! This was like magic :) thanks for the video
You're welcome, Natalie.
Great video. Thank you.
Excellent! Thank you!
You are great. Thanks!
Amazing video, thanks a lot man!
Great explanation, thanks!
Thank you very much!
Thanks, so perfect~~!!!
Now i can pass the exam
oh man thanks so much
Hi Josh- i really like your video. Is there somewhere to download the calculator for my computer?
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.
+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?
Professors teaching with the BA II Plus get a USB emulator from the manufacturer. It's a plug & play device. No installer.
thanks a million!
Thank you Josh!
Thanks Joshua!
You're a legend
nicely done!
Thank you!!
thanks josh
Thanks bro
Thank you
thank you
When you are ready to Amort, why do you put P1 ENTER and P2 ENTER ?
P1 = Payment interval 1, P2 = Payment interval 2, and so on.
Thank you for the quick reply !
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?
You mean 1 to 4?
Yeah
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?
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.
I've been struggling so much in my financial math course, you sir are a hero.