Skip to content

Excel Amortization Schedule Template

4.54 (13 reviews)

Loan amortization calculator in Excel. Define your credit payments and create printable amortization table in one click. With flexible term options.

Download Free Version
One-Time Purchase
Business Subscription

Additional Services



Someka refunds icon

30-Days
Return

Someka one time payment icon

One-Time
Payment

Someka direct download icon

Instant
Download

One-Time Purchase
Business Subscription
SOMEKA BUSINESS 99 $ /m

Redeem 3 Templates

Download 3 premium templates of your choice for free each month.

Continuous Technical Support

We’ll be your one-stop assistant for all your Excel & Google Sheets questions and needs.

Multi-User Environment

You’ll be entitled to multi-user licensing for your templates.

Cancel Anytime | Growing Catalogue | Continuous Updates

someka-bundle-icon

TEMPLATE DESCRIPTION

If you need an Excel Amortization Schedule Template, this product will provide you with a one-sheet solution. This simple amortization calculator Excel tool will help you to create your repayment schedule plan for the money you borrow for a mortgage, student loan, farm loan or any other credit type.

Loan-Amortization-Calculator-S00-2

Main Features of the Template

Basically, this Excel amortization schedule 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 create an amortization schedule with fixed monthly payment and balloon in Excel.

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

Loan-Amortization-Calculator-S01-2_2

To emphasize, the input parts have been clarified with white cells. So the gray areas show the results. Thus, just put your financial data in 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.

Excel Amortization Schedule 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

Amortization Schedule 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.

PRODUCT VIDEO

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

FREQUENTLY ASKED QUESTIONS

USER REVIEWS & COMMENTS

13 reviews for Excel Amortization Schedule Template

  1. Liz YO

    I want to have a visualize summary like a graph of my template, how is that possible?

    • Someka

      Greetings! To acquire this new sheet, please make a request for our customizable service. If you have any inquiries regarding this, kindly reach out to contact@someka.net.

  2. Olivia Kalberg

    SO simple, just add your input and some easy numbers and the template will do all the work for you. Well done.

  3. Tamara Clifford

    I couldnt undrestand the idea of ballon payment, can you explain more about it?

    • Someka

      Sure, with a mortgage containing a balloon payment, the amount due at the conclusion of the loan term may be significantly larger than usual. Prior to that point, payments may be comparatively low, however the amount owed at the end is substantial.

  4. Alex Sid

    If you have a hard time keeping track of your loans and debts and never know when it’s time to make payments, then this template is perfect for you. It showed me exactly how bad I was managing my loans and now I’m in much better shape because of it.

  5. Vahid Imani

    I want to pay my loan each 3 month. how should I add it in this template, so I know did I paid it or not.

    • Someka

      Greetings, thank you for reaching out to us.
      If you would like to adjust the frequency of your payments, simply navigate to the Assumption section on the Dashboard page and select your desired option from the dropdown menu.
      We are here to help with any other inquiries you may have – simply email contact@someka.net and we will get back to you.

  6. Rebbeca Porter

    What should I add in the assumption of this template?

    • Someka

      Greetings! In the assumption section, kindly enter the details regarding the loan you have obtained.

  7. Murali

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

  8. Ginette

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

  9. 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.

      how-to-remove-someka-logo

      Hope this helps!

  10. 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.

      loan-amortization_dropdown

  11. Dory

    really useful!!

  12. U Tin Tun Win

    I had see you are great Someka.net.
    Thank you so much

  13. MANUEL GONZALEZ

    MUY BUENA PLANTILLA

Leave a customer review

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

RELATED TEMPLATES

Search