This finance video tutorial explains how to create an amortization table in excel. This schedule shows the beginning balance, monthly payment, monthly interest, and ending balance of a mortgage with a specified principal, loan term, and annual interest rate. Excel Tutorial For Beginners: https://www.youtube.com/watch?v=nK-uNYuvcag Top 30 Excel Tips & Shortcuts: https://www.youtube.com/watch?v=UMad9_-4rOU Final Exam and Test Prep Videos: https://bit.ly/41WNmI9 _________________________________________ How To Calculate The Total Hours Worked: https://www.youtube.com/watch?v=VC2d3QtPBSE How To Make a Time-Sheet In Excel: https://www.youtube.com/watch?v=eSYKj5gWrGE How To Calculate Loan Payments In Excel: https://www.youtube.com/watch?v=ifbNN2SoKlk How To Create an Amortization Table: https://www.youtube.com/watch?v=QZfMW203v4U Excel - Business Account Ledger: https://www.youtube.com/watch?v=9oifIFRywGo ______________________________________ Relative & Absolute Cell References: https://www.youtube.com/watch?v=Yx52CYvR5ao Lock Cells and Protect Sheets In Excel: https://www.youtube.com/watch?v=wrOE8fheMR0 Excel Interactive Checklist: https://www.youtube.com/watch?v=2W06Rmp-UbY Excel Pivot Tables: https://www.youtube.com/watch?v=WoR2RhT7AF0 ______________________________________ YouTube Channel Growth Accelerator: https://www.patreon.com/YouTubeChannelGrowthAccelerator Algebra For Beginners: https://www.video-tutor.net/algebra-for-beginners-basic-introduction.html Final Exams and Video Playlists: https://www.video-tutor.net/ Full-Length Math & Science Videos: https://www.patreon.com/mathsciencetutor/collections