Sign up to save your podcasts
Or
Share How to Create a Loan Amortization Schedule in Google Sheets/ MS Excel
Share to email
Share to Facebook
Share to X
Share to email
Share to Facebook
Share to X
Or
How to Create a Loan Amortization Schedule in Google Sheets/ MS Excel
In this episode, Nick Baldo delves into the intricacies of loan calculations for real estate investments. He guides listeners through setting up a loan calculation in Excel or Google Sheets, and explores how interest rates and terms affect monthly payments. Nick also explains how to complete and adjust an amortization schedule.
End-to-End Accounting Course: https://www.incomedigs.com/reab2 (Enter Code YOUTUBE50 for $50 off!)
Link to Advanced Amort Calculator: https://www.youtube.com/watch?v=1JiY_UUjPKY&t=940s
FREE Amort Template: https://www.incomedigs.com/amort-calc...
Free COA Template: https://www.incomedigs.com/chart-of-a...
Visit our Official Website: http://www.incomedigs.com
Ever need to generate an amortization schedule quickly? This video demonstrates how to use simple formulas in Google Sheets and/or Microsoft Excel to quickly whip up an amort schedule. Anything else you would like to see related to Google Sheets or Excel? Leave a comment below!
(0:00) Introduction and overview of the episode
(1:05) Understanding key variables of a loan
(2:04) How to start a loan calculation in Excel or Google Sheets
(4:26) Exploring how monthly payment changes with interest rates and terms
(6:03) Completing the amortization schedule: dates and calculations
(9:23) Amortization schedule: Adjusting variables
(12:01) Conclusion and invitation for audience questions.
View all episodes
By Nick BaldoIn this episode, Nick Baldo delves into the intricacies of loan calculations for real estate investments. He guides listeners through setting up a loan calculation in Excel or Google Sheets, and explores how interest rates and terms affect monthly payments. Nick also explains how to complete and adjust an amortization schedule.
End-to-End Accounting Course: https://www.incomedigs.com/reab2 (Enter Code YOUTUBE50 for $50 off!)
Link to Advanced Amort Calculator: https://www.youtube.com/watch?v=1JiY_UUjPKY&t=940s
FREE Amort Template: https://www.incomedigs.com/amort-calc...
Free COA Template: https://www.incomedigs.com/chart-of-a...
Visit our Official Website: http://www.incomedigs.com
Ever need to generate an amortization schedule quickly? This video demonstrates how to use simple formulas in Google Sheets and/or Microsoft Excel to quickly whip up an amort schedule. Anything else you would like to see related to Google Sheets or Excel? Leave a comment below!
(0:00) Introduction and overview of the episode
(1:05) Understanding key variables of a loan
(2:04) How to start a loan calculation in Excel or Google Sheets
(4:26) Exploring how monthly payment changes with interest rates and terms
(6:03) Completing the amortization schedule: dates and calculations
(9:23) Amortization schedule: Adjusting variables
(12:01) Conclusion and invitation for audience questions.