How To Calculate Your Monthly Mortgage Payment

This video tutorial explains how to calculate the monthly payment on a mortgage (using Google Sheets) when given the loan amount, interest rate, and loan period. This video also explains how to calculate the total interest paid over the lifetime of a mortgage at different interest rates.

Stay Informed 💡

Get Started Investing 📈

Playlists 🎥

Socials 📸

*Malone Financial is affiliated with the aforementioned companies. Malone Financial receives a commission for any customer conversions realized via the affiliate links. This video includes my own opinions (which do not reflect the opinions of said companies). Investing involves a risk of loss. Nothing mentioned in this video should be construed as financial advice.

[malone_financial]

Found this video helpful? Don't forget to subscribe! Let me know if you have any questions about the calculator.

[emanuelalonso]

this video inspired me in so many ways, not only i got more informed about my future situation if i get a mortgage but also i could play around with the numbers and see what are my options. would be nice to see a followup vide related to overpaying mortage, i added extra column to deduct in principal the overpayment amount but would be nice to see (1) lower repayment vs (2) shorter term.
Also huge thanks for showcasing trade republic in other videos! i had my money sitting on AIB savings accounts (4 to get max interest possible) and basically 1 month in Trade republic is more profitable than 6 month in AIB

[SyedDanialAlhabshi]

Is there a formula to add in later part of the mortgage when say the variable interest rate changes? (i.e. without affecting the original interest rate at the beginning of the mortgage)

[std]

Your presentation is very clear, thank you. Can you show us if we have make some lumsum payment how is that going to change in the sheet.

[killingjoke]

What are all the possible considerations for having either a 15 or 30 year morgage?

[luclud]

Such a nice video, do you do financial consulting?

[allenantony]

can you do a similar video for part buy part rent scheme ?

[gojooyoung]

when i drag thebeginning balance it doens't auto populate the row. it does only one row