In this episode, Nick Baldo delves into creating a loan amortization schedule using Excel for real estate deal analysis. He covers everything from understanding the present value and monthly payment, to adjusting principal payments based on loan balance. The episode also explores visual representation of loan data and concludes with resources available at Income Digs.

Real Estate Accounting: https://www.youtube.com/playlist?list=PL89qBCL2vU2sab5dEzpwJTZi0zTLjCDXJ Real Estate loans always come with an amortization calculator. This video dissects the calculator as I show you step-by-step how to create and customize a loan amortization schedule in Google Sheets or Excel. Download the free template here: http://bit.ly/amortizationcalc

Enroll to Real Estate Accounting Bootcamp: http://bit.ly/reabcourse (Enter Code YOUTUBE50 for $50 off!) Join the Waitlist for Builder Books Academy: https://www.incomedigs.com/bba-wait-list Enroll to Super VA: https://www.incomedigs.com/sva

(0:00) Introduction to creating a loan amortization schedule (1:23) Using Excel for Real Estate Deal Analysis (2:25) Personalizing and Building the Loan Amortization Schedule (5:35) Understanding the Present Value and Minimum Monthly Payment (10:59) Locking Cells and Dealing with Additional Payments in Google Sheets (14:29) Impact of Additional Principal on Loan Payoff Period (18:32) Adjusting Principal Payment Based on Loan Balance (21:57) Cleaning Up and Finalizing the Amortization Schedule (24:43) Finding the Payoff Month, Year, and Date (29:02) Visual Representation of Loan Data with a Chart (31:38) Closing Remarks and Availability of Resources at Income Digs