Loan Calculator

The Loan Calculator for Excel is an ideal solution to evaluate how a loan's terms will affect the borrower's payment obligations. The model is fully-customizable and accommodates loans with up to 500 payment periods.

The principal amount, interest rate, payment frequency and the length of the loan can be entered into the Loan Calculator for Excel and a payment table is automatically generated.

Upcoming payments and each payment's breakdown between principal and interest is displayed. An additional feature is the ability to make extra payments each period.

Inputs to the Loan Calculator for Excel include:

Name of Loan and/or Lender.
Face Value of Loan (Original Amount).
Annual Interest Rate.
Loan Period in Years.
Number of Payments per Year.
Loan Commencement Date.
Amount of Extra Payment per Period (if any).

The Loan Summary results display:

Scheduled Payment (per period).
Scheduled Number of Payments.
Actual Number of Payments.
Total Amount of Early Payments.
Total Interest Paid.

The Loan payment table displays columns for:

Payment Number.
Payment Date.
Beginning Balance.
Scheduled Payment.
Extra Payment.
Total Payment.
Principal.
Interest.
Ending Balance.

Buy Now
Price: USD 24.95

Related Excel Solutions:

Mortgage Calculation (Real Estate and Loan) | Loan Analysis (Real Estate and Loan) | Lease and Loan Calculation (Real Estate and Loan) | Loan Comparison (Real Estate and Loan) | Loan Amortization Templates (Real Estate and Loan) | Loan Amortization Calculator and Schedule (Real Estate and Loan)

Share your thoughts with other users: Create your own review

Download Loan Calculator Reference

For iTunes & iOS Device

Popular Searches
1.	Automate cost allocation
2.	Financial analysis templates
3.	Allocate
4.	Excel
5.	Capture ratio

Add Economic Data to Excel Reports and Dashboards

See How Here