Sign up to save your podcasts
Or
Share How to Setup Advanced Loan Amortization Schedule in Google Sheets (or Excel)
Share to email
Share to Facebook
Share to X
Share to email
Share to Facebook
Share to X
Or
How to Setup Advanced Loan Amortization Schedule in Google Sheets (or Excel)
In this episode, Nick Baldo breaks down the concept of amortization schedules. He guides listeners through setting up and formatting a spreadsheet, calculating payments, and creating an amortization schedule. He also discusses handling negative loan balances, calculating payoff periods, and the impact of additional payments. The episode concludes with error handling tips and additional resources.
Enroll to Real Estate Accounting Bootcamp: http://bit.ly/reabcourse (Enter Code YOUTUBE50 for $50 off!)
End to End Podio Training: https://www.incomedigs.com/pcc
Check out our Podio Templates: https://bit.ly/3pE4DBt
Download our guide: https://www.incomedigs.com/qbosetupguide
Advanced Loan Repayment Calculator: https://www.youtube.com/watch?v=1JiY_UUjPKY&t=602s
Per your specific request, here is a super helpful tutorial on how to set up an Advanced Loan Amortization Schedule in Google Sheets (or excel). This lesson demonstrates how to account for additional principal payments throughout the loan. Play with the numbers to figure out your revised payment schedule and how much you can save over the course of the loan!
(0:00) Introduction and Overview of Amortization Schedule
(2:00) Setting Up and Formatting Google Sheet/Excel for Amortization
(4:05) Calculating Minimum Monthly Payment and Setting Up Period in the Schedule
(6:59) Creating an Amortization Schedule: Interest and Principal Payment
(10:59) Handling Negative Loan Balance and Adjusting Principal Amount
(16:07) Calculating Payoff Month/Year and Understanding Formulas in Excel
(18:01) Impact of Additional Payments on Payoff Period & Payment Scenarios
(20:00) Addressing Errors, Importance of Cell Locking, and Application to Mortgages/Student Loans
(21:11) Interest Saving Calculations Over Time
(21:48) Closing Remarks and Additional Resources on incomedigs.com
View all episodes
By Nick BaldoIn this episode, Nick Baldo breaks down the concept of amortization schedules. He guides listeners through setting up and formatting a spreadsheet, calculating payments, and creating an amortization schedule. He also discusses handling negative loan balances, calculating payoff periods, and the impact of additional payments. The episode concludes with error handling tips and additional resources.
Enroll to Real Estate Accounting Bootcamp: http://bit.ly/reabcourse (Enter Code YOUTUBE50 for $50 off!)
End to End Podio Training: https://www.incomedigs.com/pcc
Check out our Podio Templates: https://bit.ly/3pE4DBt
Download our guide: https://www.incomedigs.com/qbosetupguide
Advanced Loan Repayment Calculator: https://www.youtube.com/watch?v=1JiY_UUjPKY&t=602s
Per your specific request, here is a super helpful tutorial on how to set up an Advanced Loan Amortization Schedule in Google Sheets (or excel). This lesson demonstrates how to account for additional principal payments throughout the loan. Play with the numbers to figure out your revised payment schedule and how much you can save over the course of the loan!
(0:00) Introduction and Overview of Amortization Schedule
(2:00) Setting Up and Formatting Google Sheet/Excel for Amortization
(4:05) Calculating Minimum Monthly Payment and Setting Up Period in the Schedule
(6:59) Creating an Amortization Schedule: Interest and Principal Payment
(10:59) Handling Negative Loan Balance and Adjusting Principal Amount
(16:07) Calculating Payoff Month/Year and Understanding Formulas in Excel
(18:01) Impact of Additional Payments on Payoff Period & Payment Scenarios
(20:00) Addressing Errors, Importance of Cell Locking, and Application to Mortgages/Student Loans
(21:11) Interest Saving Calculations Over Time
(21:48) Closing Remarks and Additional Resources on incomedigs.com