This video displays how to create an Amortization Schedule in Google Sheets for a 30 Year Fixed-Rate Loan. The video starts out with calculating what the monthly payment will be for the loan based on the Amount, Rate and Term using the PMT Function. The middle portion of the video focuses on building the schedule. In the final portion of the lesson we discuss how to incorporate extra principal payments into the schedule.
Learn more about Google Sheets Functions with this Book at Amazon.
amzn.to/3HkHcGa
Buy the complete Google Workspace User Guide at Amazon:
amzn.to/3Hr9dLW
DISCLAIMER: As an Amazon Affiliate I get a commission for every purchase via these links
#GoogleSheetsAmortizationSchedule
#GoogleSheetsAmortizationTable
27 июл 2020