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




  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.


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

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

Comments, suggestions & questions welcomed...

* Required