Hi Sergio. I loved being able to build my own calculator. I learned so much in this small video alone. Would you be able to direct me on how to make the payments come out accelerated biweekly? Also, I make an extra payment monthly but also make additional payments through the year. Any ideas how I could set that up? I love to watch the principal go down and it gives me incentive to make more payments against the principal. Thank you again!
Nice job, thank you. So sad that the price inputs and mortgage rates are now so incredibly high. Would make me laugh at your comments if I weren't crying.
Hi. Good review. I have a mortgage calculation that I need to solve. I would like a formula to calculate the net Present Value of the interest payment stream (so a payment that declines each montg for the term of the loan). I need it to calculate bank prepayment penalties. Any ideas?
Hi Sergio! How would you adjust the spreadsheet to calculate a one time additional payment or a additional payments at different times? Someone may want to add additional payments but not every month. Can this be modified?
yeah, people keep asking this question..I'll have to find some time to come up with a mechanism to make that happen. It's difficult to throw in a one-time deal..maybe just go to that time period and type it in.?....for now at least...
Hi Sergio, great video and I have replicated with a few additional features (interest saved and months saved) that work when the loan is set to max term but then fail when it's reduced. I've tried all I can to fix but it's beyond me. Are you able to offer any assistance ?
not off the top of my head, I'd have to see how you built it. You can always go the long route and construct some in between variables..like count one and then count the other and then subtract them. It's a bit of an elementary solution, but as my python coding buddy says, "Let the computer do the heavy lifting, noone ever sees the code." lol.
Can be possible client wise auto update loan amotozation table? Also if possible interest rate change so auto update automatic in excel Extra Payments means (Start at Payment No,Extra Payment,Payment Interval,Extra Annual Payment,Payment,Total Extra Payments) Additional Payment already showing in your video ,Variable or Fixed Rate ,Impact of interest rate HIKE on your loan EMI & repayment schedule & Impact of interest rate CUT on your loan EMI & repayment schedule ? how to create in excel & Suppose provide only interest
Is there a video that shows the interest rate changes during the duration of the loan. Cuŕrently our interest rates go up and down during the course of the bond
I do not, but maybe I can do a part 2 for this video later and include that. I have done it for clients int he past, just do additional columns and keep them the same. Maybe use an input at the top and fill it in from there.
That is a great question. yes. In this case, the interest gets assessed monthly, so anything over that interest payment goes to the principal. You'd have to modify this spreadsheet if you wanted extra payments to go to future payments.
![ROSÉ(로제) - APT. (Band VER.) (With. 이영지) [더 시즌즈-이영지의 레인보우] | KBS 241129 방송](http://i.ytimg.com/vi/IW8qaemx74g/mqdefault.jpg)
This is one of the best videos explaining a Mortage carculator in excel, great stuff!
Great refresher ! Thank you
You hero, thank you for this, I was stressing about how to keep track of this on a ss and you saved the day.
Wow! You explained this very well. Thank you! I look forward to using this very soon.
Very good video. I was able to build my mortgage calculator with your instructions. Thank you.
Great video and instruction! Really learned a lot! Thanks!
Hi Sergio. I loved being able to build my own calculator. I learned so much in this small video alone. Would you be able to direct me on how to make the payments come out accelerated biweekly? Also, I make an extra payment monthly but also make additional payments through the year. Any ideas how I could set that up? I love to watch the principal go down and it gives me incentive to make more payments against the principal. Thank you again!
This is a great idea...I'll put this video on my list and let you know. Thank you.
Hi Sergio,
Thanks for your video. How can I put for the extra payment like 1 time in a year, not every month like your demonstration.
Nice job, thank you. So sad that the price inputs and mortgage rates are now so incredibly high. Would make me laugh at your comments if I weren't crying.
This is amazing. One question, however what if I make extra payments of varying amounts on different months. How does work into this scenario?
Thank you !!!
It would be so kind if you saved your Excel file from the video and included it in a link here in the comments for others to play with!
Hi. Good review. I have a mortgage calculation that I need to solve. I would like a formula to calculate the net Present Value of the interest payment stream (so a payment that declines each montg for the term of the loan). I need it to calculate bank prepayment penalties. Any ideas?
Hi Sergio! How would you adjust the spreadsheet to calculate a one time additional payment or a additional payments at different times? Someone may want to add additional payments but not every month. Can this be modified?
yeah, people keep asking this question..I'll have to find some time to come up with a mechanism to make that happen. It's difficult to throw in a one-time deal..maybe just go to that time period and type it in.?....for now at least...
How can you edit this so you can make a half payment biweekly?
how do we see yearly amortization instead of monthly. can you please explain. Any way to see Annual please.
Instead of dividing the rate by 12 and multiplying the years by 12, you leave those out, so payment cell should look like PMT(A5,A6,A8,0)
@@rudydeleon8288dead on right. Well said.
Hi Sergio, great video and I have replicated with a few additional features (interest saved and months saved) that work when the loan is set to max term but then fail when it's reduced. I've tried all I can to fix but it's beyond me. Are you able to offer any assistance ?
not off the top of my head, I'd have to see how you built it. You can always go the long route and construct some in between variables..like count one and then count the other and then subtract them. It's a bit of an elementary solution, but as my python coding buddy says, "Let the computer do the heavy lifting, noone ever sees the code." lol.
I would love to see this also as I want to include the interest and months saved.@@sergiogarciaphd7142
This is great
Can be possible client wise auto update loan amotozation table?
Also if possible interest rate change so auto update automatic in excel
Extra Payments means (Start at Payment No,Extra Payment,Payment Interval,Extra Annual Payment,Payment,Total Extra Payments) Additional Payment already showing in your video ,Variable or Fixed Rate ,Impact of interest rate HIKE on your loan EMI & repayment schedule & Impact of interest rate CUT on your loan EMI & repayment schedule ? how to create in excel & Suppose provide only interest
Is there a video that shows the interest rate changes during the duration of the loan. Cuŕrently our interest rates go up and down during the course of the bond
@@lindamacgillicuddy8891how to mataine client wise?
Do you have something that includes escrow payments calculations?
I do not, but maybe I can do a part 2 for this video later and include that. I have done it for clients int he past, just do additional columns and keep them the same. Maybe use an input at the top and fill it in from there.
If you added an extra column to show principal amount would that mess up your spreadsheet?
not at all..run it as you wish...just add the additional column and plug in your principal calculation..and then leave it alone..
What if you don't make extra payments every month. How will you set up a formula for that?
Simply cut it out or make it zero. No big deal.
How to download file?
how to download file
Is the extra payment going to the principal only?
That is a great question. yes. In this case, the interest gets assessed monthly, so anything over that interest payment goes to the principal. You'd have to modify this spreadsheet if you wanted extra payments to go to future payments.
≋p≋r≋o≋m≋o≋s≋m 🌹