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!
Hey Sergio, excellent video. I do have a question though. Your total payment does not include the interest..why is that ? I believe the interest should be included too as that is something you are paying as well from your pocket ?
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. 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, 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 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.
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
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.
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.
This is one of the best videos explaining a Mortage carculator in excel, great stuff!
Very good video. I was able to build my mortgage calculator with your instructions. Thank you.
Wow! You explained this very well. Thank you! I look forward to using this very soon.
Great video and instruction! Really learned a lot! Thanks!
You hero, thank you for this, I was stressing about how to keep track of this on a ss and you saved the day.
Great refresher ! Thank you
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.
Hey Sergio, excellent video. I do have a question though. Your total payment does not include the interest..why is that ? I believe the interest should be included too as that is something you are paying as well from your pocket ?
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.
This is amazing. One question, however what if I make extra payments of varying amounts on different months. How does work into this scenario?
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...
Thank you !!!
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?
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.
I would like to make 1 extra payment, not every month, how can I edit it?
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 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
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..
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.
How can you edit this so you can make a half payment biweekly?
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?
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.
This is great
How to download file?
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.
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.
how to download file
≋p≋r≋o≋m≋o≋s≋m 🌹