Please tell a friend about us. Thank you.
Enter a "0" (zero) for one unknown value above.

©2016, all rights reserved
$ : mm/dd/yyyy
  Original Size  

17 thoughts on “fixed-principal-payment-calculator

  1. I cannot get a 3/1/2016 loan date for the Fixed Principal Payment Loan Calculator. How is this done?

  2. Correct, with this calculator, the user cannot set the dates. However, please use this amortization schedule.

    Under the “Amortization Method” option, you’ll see fixed principal.

    And with this calculator you can set the loan and first payment date to be whatever you want them to be.

  3. I want to make the same payment monthly for principal and interest and let the additional interest help pay down principal. IE $1000 toward principal $500 toward interest. Interest recalculates automatically though as the principal reduces. Can I change that?

    • Not a problem. However, you will not want to use this calculator. Rather use the amortization calculator. And, instead of having the calculator calculate a payment amount, enter the payment amount that you want to make. Click the schedule button. The payment will pay the interest and the rest will pay down principal. If the payment you enter, is not enough to pay the interest, then you’ll see negative amortization.

  4. Pls give me a even principal pay ment schedule having term loan 1500000 rate of interest 13.10 tenure 60 months starting from july1 2016, even
    principal 25000fixed,l oan date22/06/2016 pay ment starts from 01/07/2016

    • Please use this Time Value of Money Calculator to do what you want.

      Scroll down the page and look for this tutorial:

      21. Calculate PV of Fixed Principal + Interest Loan
      Calculate PV of the declining payment amount
      Demonstrates the cash flow analytics of this calculator

      for instructions.

      If you have additional questions, I’m happy to answer them but please do not reply to the email you’ll receive. Rather post your questions on the calculator’s page.

  5. Can you tell me, How to download Fixed Principal Payment Loan Calculator for Excel.

    • I don’t create Excel calculators. What you can do is use this calculator and from the payment schedule view, you can select the entire schedule and copy and paste it into Excel. If you do that, you may have to use Excel’s “Paste Special” feature and select the paste unformatted option.

  6. Hello,

    You said there is free amortization schedule for download for personal use ( but when clicking on download page, this is what appears:, no free version of amortization schedule.

    May you advise the correct link to download free version?



  7. How to calculate when the grace period is 2 years and during that grace period, i only pay the principal.

    loan 2,500,000.00
    interest 4%
    payment monthly
    20 years

    • This calculator won’t handle that calculation. However, the Ultimate Financial Calculator will.

      You’ll initially set the interest rate to 0%. Enter the payment amount you want and it will be applied to principal Than a 3rd entry for the number of unknown payments. If the loan accrues interest from day 1 (which to me wouldn’t really make sense), then you can add the interest due at the end of the principal only payment series as a new loan. You can calculate the amount of interest that has accrued using the Interest Calculator.

      If you try the above, and have questions, please post them on that page.

  8. I would just like to say thank you for taking the time to do this for the public. I am a small business owner and this was a great help to me.

    • Great to hear. I’m glad that you both found the calculator and found it useful.

      Please tell your friends and associates about this site.

  9. Can you please draw the repayment schedule for flat interest rate???
    loan amount=1000000
    Flat interest rate=5%

    it’s necessary for me..
    please draw it ASAP..

    • I do not create schedules. I provide people with the tools and the support so they can create schedules any time they need one.

      If you have a question about a calculator, please ask.

Comments, suggestions & questions welcomed...

* Required