including amortization schedule and charts

Original Size

A fixed principal payment loan has a declining payment amount. That is, unlike a normal loan, which has a level periodic payment amount, the principal payment part of the payment is the same payment to payment and the interest portion of the payment is less each period due to the declining principal balance. Thus the payment is from one payment to the next. Ultimately, the borrower will pay less in interest with this loan method.

This calculator will solve for any one of four possible unknowns: "Amount of Loan", "Total Scheduled Periods" (term), "Annual Interest Rate" or the "Periodic Payment".

Enter a '0' (zero) for one unknown value.

The term (duration) of the loan is a function of the "Total Scheduled Payments" and the "Payment Frequency". If the loan is calling for monthly payments and the term is four years, then enter 48 for the "Total Scheduled Periods". If the payments are made quarterly and the term is ten years, then enter 40 for the "Total Scheduled Periods".

Normally you would set the "Payment Method" to "Arrears" for a loan. This means that the monies are lent on one day and the first payment isn't due until one period after the funds are received.

If the first payment is due on the day the funds are available, then set "Payment Method" to "Advance". This is typical for leases.

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

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.

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.

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.

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.

Hello,

You said there is free amortization schedule for download for personal use (http://www.pine-grove.com/amortization/free-amortization-schedule.htm) but when clicking on download page, this is what appears: https://financial-calculators.com/downloads, no free version of amortization schedule.

May you advise the correct link to download free version?

Thanks.

Proyuth

That calculator is no longer available. Please try this free online amortization calculator.

The advantage is it works with all devices and not just Windows computers.

Thank you very much!