Loan Mortgage / Amortization Schedule with Regular and Additional Payments in Excel

Features:

1. User-Friendly Input Tab
   Easily enter your loan details, including loan amount, interest rate, loan term, and other specifics. This tab has all the fields you need to set up your schedule in minutes. No confusing formulas to worry about—simply fill in the blanks and let the scheduler do the rest.
   
2. Automatic Amortization Schedule
   Watch your loan payment schedule build itself based on the details entered in the Input tab. This dynamic sheet shows your monthly principal and interest amounts, outstanding balance, and the overall payment timeline—all automatically calculated for you.
   
3. Interactive Graphs for Quick Insights
   Instantly visualize your loan details with two dynamic graphs:
   
   • Principal & Interest Bar Chart: Clearly see how your payments are allocated between principal and interest month by month.
   • Time Savings Pie Chart: Discover how additional payments can shorten your loan term and save you interest over time.