skip to Main Content

Loan Amortization Calculator Excel Template

4.86 (7 reviews)

Credit amortization plan template. Calculate loan payments and create schedule in one click. With flexible term options. All in Excel.

Learn more about License Types

Someka refunds icon


Someka one time payment icon


Someka direct download icon



We need Financial Markets (mostly commercial banks) to get financial liquidity to reach our targets. This Loan Amortization Calculator Excel Template is a tool to identify the repayment schedule plan of the money you borrow for a mortgage.


Main Features of the Template

Basically, this Excel loan amortization template is a tool where you can input the amount of money, interest rate, payment frequency, balloon payment, and loan term according to your situation. After you type in the inputs, you may see the Loan Amortization schedule immediately.

Furthermore, you can select your payment frequency from the drop-down, which contains Monthly, Quarterly, Semi-Annually, Annually options in this excel loan amortization calculator.


To emphasize, the input parts have been clarified with white cells. So the gray areas indicate the results. Thus, just put your financial data and let the loan amortization calculator template help you to find the best option for you.

Once the schedule is created it is easy to observe your payments (principal and interest) and your Outstanding Loan Balance. Besides that, if the loan amortization schedule does not match your needs you may check other scenarios. In that way, you will be able to see if they are attractive or not. That’s how our loan amortization calculator in excel works.

Loan Amortization Calculator Excel Template Features Summary:

  • Monthly, Quarterly, Semi-Annually, Annually payment options
  • Loan Amortization Schedule with a balloon payment
  • Easy to fill
  • Also full print ready
  • Informational notes included
  • No installation needed, ready-to-use
  • Works both on Mac and Windows
  • Compatible with Excel 2010 and later versions
  • Does not include any VBA code or macros

Loan Amortization Calculator is a ready-to-use Excel Template and provided as-is. If you need customization on your reports or need more complex templates, please refer to our custom services.


Watch the video below to see the template in action! Presentation also includes usage notes, explanations and tips & tricks about the template.



7 reviews for Loan Amortization Calculator Excel Template

  1. Murali

    The template has useful functions and it helped me with my finances. Recommendable

  2. Ginette

    great amortization calculator i used it several times and it worked awesome at work

  3. Nicole

    nice and useful app team thx. Please remove your logo and add ours.

    • Someka

      Hello Nicole,

      You can remove the logo or replace it with your own logo for each sheet. For Free Versions, you are not allowed to remove the logo or alter any copyrighted material in the template.
      You can do it in the full version. Please check how to do that in this link.


      Hope this helps!

  4. Jeana R

    thank you great product. but tiny question how can I change payment frequency. I want to see annually.

    • Someka

      Hello Jeana,

      You can select the payment frequency from the dropdown list.
      Please see the image below.


  5. Dory

    really useful!!

  6. U Tin Tun Win

    I had see you are great
    Thank you so much



Leave a customer review

Only verified users who have downloaded and used the template may leave a review.