Includes a printable amortization schedule and charts.A fixed principal payment loan has a declining payment amount. That is, unlike a typical loan, which has a level periodic payment amount, the principal portion 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 amount declines from one period to the next. Ultimately, the borrower will pay less in interest charges with this loan method.
This calculator will solve for any one of four possible unknowns: "Amount of Loan," "Number of Payments" (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 "Number of Payments" and the "Payment Frequency." If the loan is calling for monthly payments and the term is four years, then enter 48 for the "Number of Payments." If the payments are made quarterly, and the term is ten years, then enter 40 for the "Number of Payments."
Normally you would set the "Payment Method" to "Arrears" for a loan. Arrears 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.
Hello,
I’m looking to see the effects of extra principle payments on a fixed principle loan. Basically would like to see the effects of paying extra principle every week. I’m having trouble finding the correct calculator for this. Could you please guide me to the correct calculator?
Thanks,
Rich
This calculator will do what you need.
It’s a bit involved, due to all the options/features, but scroll down the page for some tutorials.
Feel free to ask questions as well.
Hello ,
Can we specify the first payment date in this calculator .. so that the payment schedule can be generated and kept for reference will be replica of what is in real.
Thanks & Regards,
Chandra
No you can’t. Not with this calculator.
However, you can with this amortization schedule calculator.
Just set the "Amortization Method" option to "Fixed Principal."
Hi,
I’m curious how I would figure out annual ROI for a deal like this:
$1,000 my investment.
$1,200 my total return during 42 days on a payment plan. (6 weeks)
Paid to me weekly in equal installments of $200 each.
No interest charged.
This would be easy to figure out if all the money was due back in one lump sum at the end of the 6 weeks but since I collect some of the money every 2 weeks I’m returning it at a faster overall rate and I don’t know what I need to use to calculate that. Any help is appreciated.
It’s still easy with the right calculator. 🙂
See the Internal Rate of Return Calculator. This calculates an annualized ROI from a regular or irregular cash flow.
Once you check it out, if you have any questions just ask. Let me know how you make out using it.
Okay Thanks. I’m checking it out now. I don’t see where to enter the expected amount of $1,200 or the number of payments or end date.
As I understood you, the $1,200 is not a single amount but a series of repayments of $200 each, right?
If that’s the case, enter your initial investment which is $1,000 as a negative value and follow that by 6 $200 positive amounts (you’re being repaid) on the dates they are paid or expected. The last date is the date of the last cash flow. Zeros have no impact on the result.
If you have other questions pertaining to a particular calculator, please keep them on the page for the calculator so that others can follow along. Thanks!
Thanks Karl. That makes sense. I got that working now but I actually need the ROI and not the IRR I think. Is there a way to convert or do I need a different calc?
An IRR is an annualized ROI. In your original question, you had mentioned "annual ROI".
If you don’t want an annualized ROI, then the calculator calculates the gross return as well (the ROI). Personally, the annualized number makes more sense to me because when the ROR (rate-of-return) is annualized, it allows an investor to compare the results of different investments that have different time frames.