Mortgage Calculator WITH Extra Payments | Google Sheets

Подписаться 22 тыс.

Просмотров 21 тыс.

50% 1

To download a full template of this spreadsheet follow this link:
docs.google.co...
(Need to make a copy to edit)
This mortgage amortization table is the perfect tool to monitor your current or future property. Use the google sheets features in this video to analyze how interest rates and extra payments can impact what is owed over the life of your loan.

Опубликовано:

1 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 60

@navk963 7 месяцев назад

Someone suggest how to calculate additional columns like escrow, taxes, insurance etc

@Freebleesite 5 месяцев назад

This vid was fantastic. I've been looking for something like this for a while to help me figure out whether it's better to over pay on mortgage vs leave money in savings vs pay off finance. One small error I spotted though which was driving me crazy for a while, you'll only notice it when you start playing with the excess payments. The total principal should include the excess payment. i.e. Total Principal = Previous period principal + Current Period Principal + Current Period Excess Payment i.e. =J9+E10+G10 Thanks again!

@trevorperraton1938 2 месяца назад

I believe the Payment formula is also wrong. It uses the interest calculation in the previous month's field instead of the same month's Interest field. This only affects the last line in the table. =MIN(C10+F10,$D$9)

@amcaruso1 6 месяцев назад

Great video! I was hoping for a spreadsheet to also include Escrow payments.

@christinet2089 6 месяцев назад

I copied yours into my Numbers in Mac and idk why I’m showing a negative balance by pay period 231 when my term should be 360 without extra payments….

@christinet2089 6 месяцев назад

Also, shouldn’t the excess payment go into the total principal?

@philosopher703 Месяц назад

With every video paste a sample sheet

@marcelak6800 3 дня назад

Thank you for creating the spreadsheet for us! It's perfect!!

@jessmorris7202 3 месяца назад

Hello, this is great! Can we change this to account for fortnightly mortgage repayments? I tried, but my sheet is now looking weird! Thanks :)

@weilin1826 Месяц назад

Hi Brain Will you be able to adding the HELOC Calculation method for comparison ?

@AZFOSTERMOM-gb6mq Месяц назад

Mine was perfect until I started to scroll down and something is off with the principal and interest that’s making it. Go out of whack and turn it into a triple amount.

@carolinengarachu1055 9 месяцев назад

Just discovered your videos🎉 they are amazing and you simplify Excel perfectly👌🏾 thank you

@dtb7822 10 дней назад

Could you explain how to add escrow into this amortization schedule?

@eluoj22 5 месяцев назад

Awesome, was trying to find out how mortgage interest vs principal payments are calculated. Building a spreadsheet along with your video really helps. Very well explained and presented.

@vincelabranche 7 месяцев назад

Thank you so much for this. Exactly what i was looking for. Thanks a bunch

@ronnak8427 7 месяцев назад

Watched a lot of these to build my own and found your explanation to be perfect. My only issue is working on the dates for bi-weekly instead of monthly. I think I got it right, substituted the 12 for 26, but Im still slightly off as my amortization is 23.8yrs?? go figure.

@mandypdx 8 месяцев назад

Thank you for this!! You thought of everything most tend to leave out when creating an amortization sheet🎉🎉

@raylenealexander9519 29 дней назад

If you have already paid for a few years on a 15 month loan, do you put in what you owe now or what the loan started at?

@zoeeforder3844 3 месяца назад

Do you have a version of this that allows for variable interest rates, but the minimum monthly payment remains the from that change. ie original payment is $170 per week at 10.%pa, then 6 months later the rate changes to 11.25% and the new minimum payment is $173 without the minimum payment changing as the principal goes down. Thanks

@nehalgohel842 2 месяца назад

you just have to manually type in the new rate(which is 11.25%/12) in the formula of the cell of the 7th month payment and make sure you lock the cell so that formula copies for the future cells. i hope you understood because english is not my native language.

@matthewthomas2548 7 месяцев назад

omg, i copied the entire of this a didn't realize i could download it LOOOOOOOOOL

@rer1967 3 месяца назад

😅 I did the same, I guess it's good excel practice.

@mattanfang 15 дней назад

Instead of the total amount of interest saved, could you do a calculation where it shows how much each extra monthly payment saved? If so, how?

@mattanfang 15 дней назад

If I manually copy the value of "Int Saved" and then subtract that from the previous month's "Int Saved" I can see how much the "Excess Payment" had in regards to an amortized savings affect however for the life of me I can't get it to do these calculations automatically without having to do these extra steps. Any help is greatly appreciated if anybody can please figure it out. Thanks

@jeastinareynolds3735 Месяц назад

Hi. Does this work for any tracker? I downloaded your form, entered the #s for my car and the payment on the tracker and what my real payment is show to be off by a few dollars 😢

@jeastinareynolds3735 Месяц назад

⁠@brianturgeon ? Can you help with this?

@BBPaws 7 месяцев назад

This was amazing, thank you! It's so interesting to play around with these numbers.

@TraceyBlanks 5 месяцев назад

How could this be modified for bi-weekly payments?

@FloydRinehart 3 месяца назад

Not sure if anyone has already answered your question. In case they haven’t, the easiest thing to do would be to add up all the payments made over the course of the month and make sure that “Payment” + “Excess Payment” equals that total. For instance, using this example, if you wanted to make bi-weekly payments of $2,000 , you would leave the monthly payment as $3,160.34 and mark the excess payment as $839.66 since you would be paying a total of $4000 per month. Interest is only accrued at the start/end of each month, not between bi-weekly payments. Hope that helps!

@pamelamcdaniel916 Месяц назад

Wowza Brian!! So informative and helpful. And thanks a bunch for the spreadsheet link. You're awesome!!

@yangeislandslegal Месяц назад

Thank you so very much

@cr8dinimagodei 6 месяцев назад

I was totally following along as best I could in IOS but when it got to the drag down of the principal, interest, and ending balance after entering in all the formulas, my the numbers were totally off. Can't figure out what keeps going wrong as I re started twice, in case I missed a step or entered something wrong the first couple times. I would love to see an IOS Numbers version!

@rer1967 3 месяца назад

Thank you so much for this video. I've been trying to calculate paying off my mortgage in the next two years based on additional principal. This worked perfectly!

@EltonMcMillan 4 месяца назад

This was very helpful I made it along with your video and all works great! Thanks

@1paradox 6 месяцев назад

this doesn't take biweekly payment into consideration, right?

@trangel101 5 месяцев назад

Thank you!! Great job! I appreciate that you added the link to google.

@varghesekurien86 2 месяца назад

Thanks

@Zulonix 11 месяцев назад

Nice job! I once wrote a windows program that would display a chart of a given loan. I could alter loan parameters based on mouse movement. I noticed that a loan has a shape and from the shape, I could tell if it was a good loan or terrible loan.