Updates for 2022: Historical Investment Calculator update to 15 indices through Dec. 2021
Compare different assets, for example, the S&P 500 with gold and housing, and optionally adjust for inflation.
Inflation Calculator U.S. and German historical inflation calculations plus future inflation. Investment Calculator inflation model updated.

# Fixed Principal Payment Loan CalculatorIncludes a printable amortization schedule and charts.

×

#### Info...

Original Size

Copy and paste this URL to save your inputs to share them with others.

Click "Calc", "Clear", "Preview." or "Schedule" to update the URL. Paste it into any browser to reload.

## 18 Comments on “Fixed Principal Payment Calculator”

Join the conversation. Tell me what you think.
• ##### Tamarasays:

Where can I get an amortization schedule for an interest free personal loan with a fixed monthly payment?

• ##### Karlsays:

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 Brownsays:

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.

• ##### Karlsays:

For different compounding options and the ability to set dates, try this calculator.

NOTE: Set the "Amortization Method" to "Fixed Principal".

• ##### Benardsays:

How do we set the repayment date to for example 26th of every month?

• ##### Karlsays:

Use this loan calculator, and under "Amortization Method" select "Fixed Principal." This calculator allows users to set the dates.

• ##### Ali Bensacisays:

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 ?

• ##### Karlsays:

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.

• ##### Ali Bensacisays:

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

• ##### Karlsays:

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

• ##### Annasays:

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

• ##### Karlsays:

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.

• ##### Edsays:

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.

• ##### Karlsays:

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.

• ##### Omarsays:

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?

• ##### Karlsays:

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.