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

Website: http://money-saving-calculators.prudentminds.com

Loan Amortization Schedule and Calculator - vertex42.com

Screenshot

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

Date: 2017-02-16 18:11:01
Website: https://www.vertex42.com

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

Date: 2016-11-21 02:19:12
Website: https://www.vertex42.com

3 Resources

Loan Calculator - Prudent Minds

Loan Amortization Schedule and Calculator - vertex42.com

Amortization Calculation Formula and Payment Calculator

Related topics