Mortgage Calculator With Extra Payment 

Very thorough. Paced so that I, as a first timer, could follow. Clear explanations. Patient tone of voice. I now have an amortization schedule with extra payments. A+++

This, hands down, is the BEST TUTORIAL I have ever watched.

Thank you for this tutorial! There were a couple of places I had to go back and watch parts of it over because the steps weren't clearly expressed, but by watching it, I was able to figure out what I needed to do to fix it. I love that you had the insight to make this video to help those of us that aren't up to par on Excel!

Great video! You should definitely consider making more financial advice content for your channel. You make things simple, clear, and most important - authentic. RU-vid is filled with content creators that provide advice that is more complicated than it really is; which you've demonstrated in this video how simple it is. Keep up the good work!

While Googling and watching many other videos I've been trying to figure this out for months. I used it with my Numbers spreadsheet and with a little tweaking, your video worked perfectly! THANK YOU!!!

EXCELLENT TUTORIAL!!!! I stopped and started this video a gazillion times while I simultaneously made my Numbers spreadsheet mortgage calculator. Thank you so much for being extremely clear and making a valuable tool for homebuyers!

EXCELLENT video!!! I paused and started it a number of times, and managed to build the exact form. I was able to apply this formula to all of my current loans to the penny (or close enough). Not just to my mortgage but all of them (truck, camper, and boat). Every time when I pay off a loan, I roll the paid loan payment onto my next loan inline, so it compounds and my total debt is paid off faster. With this calculator I can see exactly when a loan is going to paid off, and how much (and when), I will be rolling the old payment to the next. This ables me to get an estimated picture of when ALL my loans are going to be paid off. Worth the effort and time. THANKS!

I appreciate your excellent instruction. You made it super easy to follow along and I matched my amortization schedule to the penny. Now it is much easier for me to plan scenarios for early mortgage payoff. Thank you very much for your time and this excellent video.

There have been many videos, especially those concerning mortgages, but this video or lesson offers a detailed explanation in a very professional manner. Thank you for this video.

Thank you for taking the time to make this video. This will be an instrumental tool in determining my strategy for paying off my mortgage while my interest rates swing wildly

This is super useful and interesting! Just what I have been searching for. and the tutorial is easy to follow! You are awesome, please do more of these interesting videos. Thanks much!

this is so simple to follow, a great reminder from my classes.

You are awesome!!! This was very easy to follow and there are so many people I know who will take advantage of this video. Thank you for sharing your knowledge. I look forward to other financial advise you can share with us.

Awesome! You really hit the nail, the best tutorial, keep it up man you really are helping people like me (first-time buyer), Thank you much

Thanks for this tutorial. This will help me with our goal of paying off my mortgage early.

Success!!!! Great tutorial.

Well done, I was able to use this with another video to create a calculator from Canada! Thank you so much!

I watched a different video and found this one was a bit clearer. It was able to help me add in extra payments. Nicely done.

Your tutorial is so straightforward and easy to follow! Thank you so much! Will you be making a video on how to make a budget on excel?

Very well done! I copied everything over on to my own. Thank you!

Absolutely Excellent!!! Very easy to follow and understand on a subject that every home owner should understand and use.

Excellent and Outstanding video!

Thank you for this. Today is Jan 1, 2024 - and I created a 15 year house payment plan ! thanks !

Great Great Tutorial , Thank You Sir !

Wow!! Very nice!! Thank you for sharing!!

Thank you so much! Super helpful!

What I used the rounding that you recommended, this caused me to be off by two dollars after pulling all the rows down. What might my error be?

Great job ! Great job !

Great content! Thank you!

Two things 1. I like the beginning and ending music. 2. My spreadsheet did not match my statement exactly. When you round monthly payment (B6) do you drag it down the column as well? Or do you leave (C10) with the MIN function in.? Thanks

This is VERY good, very helpful to me, it is what I've been looking for. Thank you!

Thank you for the easy to follow instruction

I'm British (UK resident) I *do* have a mortgage calculator of my own which I wrote quite differently because I can't get my head around the pmt function (so I calculated the *daily* compounding that we have here manually) It's not as accurate as yours and drifts by a few pounds over the course of each year (through rounding errors) but I just "correct it" to match the bank's statement annually. What having one has taught me is just _overpay, overpay, overpay!_ In short, through having it (the calculator), I look set to have save more than 70% of the time I would have had the mortgage and around 85% of the interest I would otherwise have been charged! Each £10 paid on the mortgage was saving £17 in interest at the beginning (not so much now at all) but is entirely tax-free! What an incentive - Ask myself _What if I throw another £46.87 at the mortgage today or go out to watch a film with friends....._ I will try to work through your pmts function and change it to annual for if I ever get another mortgage (or writing a spreadsheet for someone else when they see what I've done {as in paying mine off so early}). Thank you for sharing

Thank you so much for this excellent tutorial.

Great video!!! Helped me understand alot. However I ran into a problem at the end when using the =MAX function. When I added like you stated it only showed me the value in the first cell of the interest column. Im pretty sure Im adding correctly but need some assistance. Thanks

Thank you very much for this video! This has to be the BEST video ever, i have been searching for so many videos to help me gauge mortgage calculation and I am so grateful because of your video :) God Bless You!

Thank you so much for this calculator. Wonderful presentation. Since then I switched to using a Heloc in the first lien position. I was wondering if you would consider making a calculator for this application since interest is compounded daily. Thanks again.

Great job. Thank you!

Super helpful, thank you!

Totally Great Video !! Thanks !!

Is there a way to add or take into account property taxes and home owners insurance? Maybe having them show in my monthly payment?

Thanks for this. I was able to match to the penny without any tweaking. I was able to add a "Months Early" field to the top with the following calculation: =B5-(MATCH(0,G8:G368,0))+1

You rock. Thank you so much!

When trying to enter rounding for the monthly payment I could not get the formula to work. The video portion showing this was hard to see it as it moved quickly. Can someone give me the =round formula for the monthly payment please. BTW this class was the best I have ever seen. Clean and simple to follow. Thank you! Please do more!

Great Video, Thank you so much for making it. I have one question: The Original Int. You copy it from Total Int. 184,,,, but when you change the Rate it does not copy as the Total Inter?

Thank you so much. I loved this excel calculator

Beautifully done! Thank you for making this. It was super helpful! Edit: I have a question. In the above example, if extra payments are made, what would be the formula to calculate the actual number of months in which the loan is paid off?

Hi, I've been looking for and using other spreadsheets and this is by far the easiest. Can you make one for those who have insurance & escrow included in their mortgage payments?

Very detailed info.

Great Video!

Will this work with any excel file, or is there something that needs to be added to your excel file?

Thank you so much. I managed to do my own and have a plan for my path to financial freedom.

Thanks..this what I was looking for with Extra Payments functionality

Thank you sir!

GREAT VIDEO! when it comes to rounding the monthly payment and the interest expense, try using the ROUNDDOWN function, instead of just ROUND. I found that when I did that, I did not have any cents left over at the end of the spreadsheet. keep up the good work!

Great job thank you

Great stuff

Thanks for a great video. I'm a little confused because the payment calculated by the spreadsheet is about $20.00 less that the payment on my lender's provided table. it's amazing how much small extra payments affect the interest savings.

Thank you very much.

Thank you for the video, is very useful

What should I do if I have variable rate of interest..what formula should I change

Is it possible to show one with Escrow

Hi, do you have a tutorial for Bio weekly payment or can you tell me what needs to be adjusted in this spread sheet?

Can the extra payment amount varies from months to months or it needs to be fixed amount? Thanks

great video

Figured out how to drag on my own. I give you a A+ on the video and a E- on answering peoples questions.

Thank you for your video. I followed everything up to 9:30. The original calculation changes each time we change the terms of the loan. How was the original interest figure maintained?

how do banks account for future property taxes or how that changes the loan amount if the loan was 220,000, which is part of the escrow accont?

Nice Tutorial. It helped me a lot. Thanks for the same.

Hello and thank you for your detailed video, I currently have an Amortization table that is in use and I seem to be off on my calculation by approximately, $1300 dollars I hope this will get me straightened out. Also why don't Amortization table have Escrow associated into the equations? It is part of monthly payments. One more question, by adding the $2.71 on to the last payment isn't that only relevant if you didn't make any extra payments? if you made extra payments to the schedule wouldn't your interest change making the $2.71 a non-important entity? Thank You in advance.

I really like how you do the comparisons at the end--that's helpful! But I do have a question: I had made another schedule previously that used IPMT in the interest calculation, which involves NPER. Somehow that one comes up about a thousand dollars different in only a year's time on a $230.000 loan and I don't understand what's going on. The way you do it is much simpler, but the payoff looks a lot better the other way, so I'm confused.

Hi. Can you tell me if this will work for a loan already several years in with extra payments already made?

Can I create this spreadsheet eventhough my mortgage started 2 years ago? Adjustments? Include escrow and insurance?

Could easily convert this to a retirement calculator including social security, stocks, pensions, and savings

How do you build a model with a fluctuating interest rate?

Awesome

what if you want to see yearly payments and balances instead of monthly - accurate payments

Hi! I’m trying this in google sheets, everything works EXCEPT dragging the rows down… it autofills some of it but it doesn’t leave “B3” on interest but instead goes to B4, B5 etc… how do I solve this?

how did you drag the worksheet ? Thank you.... Anyone please......

It looks like you are using Excel spread sheet, and not sure if open office uses the same formulas. Also, I notice the annual re-cap of princ/int is missing. I think most loans are based from date of payment to date of payment so the computation is not always 30 days. And if you make an extra payment at a different time than the regular payment, then some of the extra payment will be interest and some principal. Then you would have to insert a row and hopefully everything will self-recalculate. Amortization schedules are approximate figures and work well enough for us to use them.

hi tnx budy., i used it to my system.,

I need the formula for recurring extrapayments, that shows how much I would save in one cell.

My worksheet was to the penny until I started making extra payments. I don't necessarily make them on the due date of the normal payment. How do I record extra payments at a different frequency and on different dates than the "normal payment"?

Great video, thanks for the info, QQ: What happens if instead of doing 1 single extra payment, you make 2?. Thanks again

Awesome video BUT, if your interest rate is 2% with 30 years mortgage and you put a monthly extra payment of let say $200, Would it be better to invest that monthly $200 into stock market if the stock market makes you an average 5% return??? Thank you!

How can you do this with a construction loan where the first year of the loan is interest only?

QUESTION! (first of all brilliant video super helpful) My question is: say I have a 10 year fix but the loan is still to be paid off in 30 years as per your example, how will this affect this calculator. As I can find out the amount paid in interest and priciple paid on the banks website, is there a way to see how overpaying would change the amount only within the 10 year fix period? I hope this makes sense. Will.

How would I edit this for bi-monthly (twice per month) payments? Would I change the Term (months) to 30*24? And for the Payment would I divide the rate by 24? Thanks!!

This is exactly what I was looking for! Thank you! But, I've seen other people say to calculate the monthly rate using this formula ((FixedRate+1)^(1/12))-1 while you just do (FixedRate/12) Can you explain why they run it differently? I was confused why they had it that way.

good day Moneyness, when I round off my interest payment, and I drag down to month 360, my spreadsheets become #VALUE! in all my spreadsheet meaning the formuale for interest payment is copied, but the values are invalid. I lost you there. Please can you help me here. This is the only part that is giving me a problem.

So I'm using google sheet everything work except the total Principal increase every time I ass a extra payment, does any one know how to fix this (I'm using =MAX just like it said in the video)

Very good video.. but I have a question .. there is a big change in total interest payment between adding more down payment vs paying same in the extra monthly $..! Am I missing something? For ex: If I choose to put extra 25k in first month extra payment rather than towards down payment it changes big .. how is that? Can you plz explain

Thank you for sharing. Everything was working fine until I copied and pasted the total interest into the original interest. The values remain the same regardless of changing the interest rate or term. Any ideas as to why?

Suppose , customer don't know how much money he paid. He knows only the loan amount he took first and the current balance of the loan and also the interest rate and the duration of the loan. is it possible to find out the amount he paid ? Example- He took 100 dollar. and current balance is 40 dollar. Interest rate 9%. Time 12 months. How can i estimate the amount he paid ? Is it possible ?

At 3:17 you mentioned how US mortgages differ from outside the US where the compounding works differently? Well, my Irish mortgage as an EU state does not match up using this formula. I'm off by only 1.70 per month. Can you point me in the direction as to how I can fix this European compounding problem. Thanks.

Really would like the same tutorial fr bi-weekly payments....PLEASE!!!!

Holy Guacamole BATMAN 😎 I have found my EXCEL AMORTIZATION KING!

What is the actual formula for K2

🔥🔥🔥

Matched