Loan Calculator

Excel loan calculator for real estate and loan

Submit Excel Solution
Submit Solution [Guide]

Recently Added:
Data Tools
Directory Contents Lister
Business Intelligence Dashboards
Automation Add-ins
Financial Analysis Functions
More Resources:
Excel Help Forum




Follow Business Spreadsheets On:
 
Find Excel Solutions:
Suggested text load results and icon loads solution.
Browse Main Categories: Business Finance | Financial Markets | Operations Management | Excel Productivity

Loan Calculator

Rate this solution:
(3/5 from 1 vote)
Buy Now
Loan Calculator screenshot
Pin It
 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
 


Popular Searches




Add Economic Data to Excel Reports and Dashboards
See How Here

   
  © 2014 Business Spreadsheets. All Rights Reserved. Legal | About Us