Full article: https://spreadsheetpoint.com/excel/am...
Here are two loan amortization spreadsheet templates I made for Excel. I'll explain how to use both. More importantly, you can get them yourself with the full article linked above.
Your mortgage payments apply to principal and interest (unless you have some sort of interest-only loan like we used to commonly see before 2008). This template works with conventional and FHA mortgage loans.
00:00 Simple Amortization Schedule Spreadsheet
00:33 More Complex Amortization Spreadsheet
Subscribe to this YouTube channel to get updates on Google Sheets Tips and Google Sheets Tutorials videos - / spreadsheetpoint
This channel is meant for people who want to learn about Google Sheets and be more productive in their day to day life. It covers a range of Google Sheets topics such as useful Google Sheets features, Google Sheets functions, Google Sheets formulas, Pivot table, Google Apps Script,.Shortcuts, Google Sheets Charting, Data Analysis, etc. Please subscribe to this channel and never miss a new video on Google Spreadsheets
You can also find a lot of useful resources on Google Sheets here: https://spreadsheetpoint.com/
#GoogleSheets #GoogleSheetsTips #Spreadsheet