This video shows how to open and use the Loan Amortization Calculator found in Microsoft Excel 2007/2010. Calculator allows you to enter loan amount, annual interest rate, time frame, number of payments per year, start date and any option extra payments. The calculator will output the cumulative loan, principle per payment, interest per payment and more. This video also demonstrates how to unprotect the sheet.

Handy Excel Resources
https://amzn.to/3gFx7s1 – Excel Formulas & Functions For Dummies 5th Edition
https://amzn.to/3sYnuH6 – Microsoft Excel 2019 VBA and Macros
https://amzn.to/2PqXhU0 – MICROSOFT EXCEL VBA AND MACROS FOR BEGINNERS:
https://amzn.to/3xtsLtM – Microsoft Excel VBA Programming for the Absolute Beginner
https://amzn.to/3xwkEg0 – Excel 2019 Bible
https://amzn.to/3aJEHxW – EXCEL 2020 FOR BEGINNERS

As an Amazon Associate, I earn from qualifying purchases. Product prices and availability are subject to change.

Please take the opportunity to connect and share this video with your friends and family if you find it useful.