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