Fixed Principal Payment Loan Calculator

Includes a printable amortization schedule and charts.

A fixed principal loan is a type of loan where the borrower repays a fixed amount of the principal loan amount each period, until the loan is fully paid off. The interest on the loan is calculated based on the outstanding principal balance, which decreases over time as the borrower makes principal payments.

In contrast, a traditional loan with fixed payments typically has a fixed payment amount that includes both principal and interest, so the amount of principal paid each period may vary depending on the interest rate and the remaining term of the loan.

Fixed principal loans are often used for business loans or other types of loans where the borrower expects to have a steady stream of income over time and wants to ensure that they can pay off the loan on a fixed schedule. They can also be useful for borrowers who want to reduce their total interest payments by paying off the loan faster.


© 2022, Pine Grove Software, LLC
$ : mm/dd/yyyy

Information

Original Size

Additional instructions for the fixed principal calculator

Enter the four primary inputs:

  • Loan Amount: Enter the total amount of the loan you wish to take out. This should be entered as a positive number.
  • Number of Payments: Enter the total number of payments you will make to pay off the loan. This should be entered as a positive whole number.
  • Annual Interest Rate: Enter the annual interest rate for the loan, expressed as a percentage. For example, if the annual interest rate is 5%, you would enter "5" for this field.
  • Payment Amount: Enter the amount of each payment you will make to pay off the loan. This should be entered as a positive number.

Note: You may enter 3 of the 4 values (Loan Amount, Number of Payments, Annual Interest Rate, Payment Amount) and leave one value as 0, and the calculator will calculate the unknown value based on the entered values.

These secondary inputs must all be set. If you are not sure about any of them, we suggest that you leave them set to their default setting.

  • Payment Frequency: Select the frequency of payments you will make to pay off the loan. This can be monthly, bi-weekly, weekly, or other intervals.
  • Compounding: Select the compounding frequency of the loan. This is the frequency at which the interest is calculated and added to the loan balance. If the loan documents do not specify a compounding frequency or you don't know it, then set it to be the same as the payment frequency.
  • Payment Method: Select the payment method you will use to pay off the loan. If the first payment is due when the loan originates set this option to "Advance." Otherwise, we'll assume the first payment is due one period after the origination date (when the funds are available) and in that case, this must be set to "Arrears."

23 Comments on “Fixed Principal Payment Calculator”

Join the conversation. Tell me what you think.
  • Where can I get an amortization schedule for an interest free personal loan with a fixed monthly payment?

    • You can use this amortization calculator.

      Normally, setting one of the 4 main inputs (loan amount, number of payments, interest rate or payment amount) to zero causes the calculator to solve for that input.

      In your case, since there’s no interest, the interest rate is 0.0%, and you’ll not want the calculator to solve for a rate.

      Therefore, look at the "amortization method" and select "No Interest".(Then you can enter zero for the interest rate.)

      Hope this helps.

  • Greg Brown says:

    A start date would be useful. Also, for daily compounding, monthly interest would not be annual interest / 12, but either 30 or 31 days of daily interest, depending on the month (28 for Feb, of course). Thanks.

  • If I borrow $16,200 by signing a 3-year, 6% note payable and the note payable is repayable in three annual fixed principal payments is my compound monthly or yearly ?

    • It could be either or neither. The compounding depends on the term of the loan. When in doubt, though, set the compounding equal to the scheduled payment frequency.

  • Also, how can I calculate that with blended principal payments ?

    • Sorry, I don’t understand this question. How do you calculate what?

      • I curious how to calculate the fixed principle payment, how can i make the formular myself when using excel

        • I don’t discuss formulas or equations. If I get into that, there would be no time left to work on this site (I only do this part-time). But, the fixed principal portion is the total principal divided by the number of payments. Then you add the accrued interest. It is probably the simplest of all payment calculations.

  • In determining the annual interest payments for a 4-year Note with annual fixed principal payments and 2% annual compounding, it appears the interest payment each year is just 2% * outstanding principal. Is this correct? I was thinking it should be 2% * (outstanding principal + previous year’s interest). Thank you.

    • Assuming that the annual payment including the interest due was paid on time, it is correct that the interest is on the outstanding balance only.

  • Hi..
    First of all, thank you for the effort you put into making those calculators.
    I used the “Fixed Principal Payment Calculator” and I got results different from that when I used “Loan Calculator with options”. My goal was to use the “Loan Calculator with options” in order to use the “Extra payments” feature, but before doing so I wanted to make sure that this calculator would give the same results as the “Fixed Principal Payment Calculator”, which was not the case.
    – Loan amount = RMB 1,080,000
    – Number of payments = 216
    – Annual Interest Rate = 5.25%
    – Payment Frequency & Compounding = Monthly
    – Payment Method = Arrears (Loan)

    When using “Fixed Principal Payment Calculator”, I get 1st payment=RMB 9725, and the Total Interest= RMB ¥512,663.04 which are the correct numbers, but when using the “Loan Calculator with options” results are different.
    Am I missing something?
    Thanks for your help in advance.

    • Hello, I get exactly the same result with both calculators, and my result matches your results. That’s assuming by loan calculator with options, you mean this calculator.

      Did you change any of the dates with the loan calculator? If so, that will change the results. How do you have your interest options set? What are the dates you used, assuming the loan date and first payment date are not exactly one month apart. If the dates are not a month apart, set them so they are, then you’ll see the results match. The loan calculator is accurate enough that if you change the dates, the results change.

      • Hello Karl, thank you for your kind reply.
        your reference to the loan calculator with options is correct.

        I just tried it again and it’s ok now. I think I know what my mistake was. I should have set “payment amount” to zero BEFORE pressing “calc”.

        Thank you once again..

  • The changes to this website have really dragged down the functionality. I can no longer run an amortization schedule and bump in extra payments to that schedule. I don’t see where I can do this among the breakout of calculators. I am unable to input any mortgage terms for some of the calculators to even run them so I no longer find this website useful. It’s a shame that when something works as the original website had, someone feels duty bound to tweak into dysfunctional oblivion.

    • I’m sorry you are having problems with the updated site. However, there should be no issues. You should be able to do what you did on the prior site.

      However, you didn’t give me any specifics, so it’s hard for me to say why you are experiencing problems.

      I will point out that it is possible that setting from prior visits are being carried over in your case from the old site. This should not happen. If you experience a problem with a calculator page, please do a hard refresh (see additional note at the end of this comment).

      Please let me know specifics if you have an issue after a HARD refresh of the page.

      (Sites have to change, otherwise, browser technology changes and sites will eventually stop working. With the last update, I tried to get ahead of the curve.)

      Hard reset:

      If you do not see the change right away, you may have to perform a hard refresh of the page:

      Depending on your operating system all you need to do is the following key combination:

      • Windows: ctrl + F5
      • Mac/Apple: Apple + R or command + R
      • Linux: F5

      Above, from Refresh Your Cache.

    • As far as creating an amortization schedule with extra payments, is this the calculator you are looking for:

      Extra Payment Calculator

      The calculators themselves did not change between the old site and the new site. You can get to any of the calculators you were using on the old site on this new site by changing financial-calculators.com to accuratecalculators.com followed by the same calculator.

  • how can i copy the schedule to an excel sheet?

    • The ability to select and copy a schedule is only available to subscribers.

      Also, so you know, copying and pasting to a spreadsheet can be a hit or miss feature, depending on the operating system, browser and spreadsheet, results vary.

Comments, suggestions & questions welcomed...

Leave a Reply to Ali Bensaci Cancel reply

Your email address is not published. I use it only to notify you of a reply.

Let me know if you have a website. I might like to visit it.

* Required