Loan Calculator - Prudent Minds

How the calculator works

This calculator uses a standard compound interest amortization formula to help you calculate the interest payable on a loan over any period. It will calculate loan payments, tell you the total sum to be repaid and the total interest you will pay. You will need to provide the duration of the loan (in months), the amount you intend to borrow and the APR (annual percentage rate) for the calculator to work. Please note that quoted APR's are intended to include the full cost of credit including any admin fees or additional charges....

Read more


Related topics : interest car loan calculator / used car loan calculator / loan payment calculator car / car bank loan calculator / car loan calculator uk

Loan Amortization Schedule and Calculator -


Bonus #1: Home Mortgage Calculator (Commercial Version)

This is a commercial use license of our Home Mortgage Calculator spreadsheet. It allows you to run an analysis on either a fixed rate or variable rate mortgage.


Screenshots: Simple Interest Amortization & Payment Schedule

Bonus #2: Simple Interest Loan Amortization & Payment Schedule (Commercial Version)

This is a commercial...

Read more

Date: 2017-02-16 18:11:01

Related topics : amortization loan calculator weekly payments / loan calculator payment schedule / amortization loan calculator extra payment / commercial loan mortgage payment calculator / loan calculator payment every 2 weeks

Amortization Calculation Formula and Payment Calculator


Calculating the Monthly Payment in Excel

Microsoft Excel has a number of built-in functions for amortization formulas . The function corresponding to the formula above is the PMT function. In Excel, you could calculate the monthly payment using the following formula:

=PMT(r,n,P) or =PMT(0.075/12,5*12,20000)

Calculating the Rate Per Period

When the number of compounding periods...

Read more

Date: 2016-11-21 02:19:12

Related topics : calculating loan payments formula / loan calculator payment amount / calculating loan payments in excel / loan payment calculator excel / loan calculator payment schedule