In this video, I show you how to build a fully automated mortgage tracker in Google Sheets from scratch, complete with an amortization schedule that handles extra prepayments. You’ll learn how to calculate your monthly payment, interest paid, principal paid, and remaining balance for every payment period using built-in Google Sheets formulas. I also walk through how to factor in excess prepayments so you can see exactly how extra principal payments reduce your total interest and shorten your loan. A free mortgage calculator is also available on RyanOConnellFinance.com if you want to run your numbers instantly.
*Free Mortgage Calculator Tool:* https://ryanoconnellfinance.com/mortgage-calculator/
*Download the Google Sheets file created in this video for FREE:* https://ryanoconnellfinance.com/product/google-sheets-mortgage-tracker/
Chapters
0:00 – Intro to Mortgage Tracker in Google Sheets
0:36 – Enter the Inputs
1:21 – Mortgage Calculator Monthly Payment
3:04 – Find the Payment Date
3:40 – Enter the Total Payment
4:06 – Calculate the Extra Principal Paid on Each Payment
4:46 – Calculate the Interest Paid on Each Payment
5:26 – Calculate the Principal Paid on Each Payment
5:42 – Calculate the Remaining Balance
6:17 – Make the Amortization Table Fully Automated
8:46 – Verify the Calculations Are Correct
10:02 – Factoring in Excess Prepayments
11:50 – Mortgage Calculator on RyanOConnellFinance.com
*Disclosure: This is not financial advice and should not be taken as such. The information contained in this video is an opinion. Some of the information could be wrong. This channel is owned and operated by Portfolio Constructs LLC. Some of the links above are affiliate links, meaning, at no additional cost to you, I will earn a commission if you click through and make a purchase.
