|
Online Calculators > Financial Calculators > Loan Calculator
Loan Calculator
Loan Calculator to calculate loan payment and determine the monthly payments on a loan. Loan payment formula on how to calculate loan payments. Use this loan payment calculator for your home loan, personal loan or any other loan payments today.
You will see the exact principal and interest that you will be paying per month or year. You can also use the mortgage payment calculator if you need to input more
options for your home loan.
| Loan Amount: |
$100,000.00 |
| Monthly Payment: |
$764.99 |
| Total # Of Payments: |
180 |
| Total Payment: |
$137,698.79 |
| Payoff Date: |
Nov, 2039 |
| Payment Date |
Payment # |
Interest Paid |
Principal Paid |
Remaining Balance |
| 2024 |
1 |
$375.00 |
$389.99 |
$99,610.01 |
| 2025 |
12 |
$4,384.34 |
$4,795.58 |
$94,814.43 |
| 2026 |
12 |
$4,164.04 |
$5,015.88 |
$89,798.55 |
| 2027 |
12 |
$3,933.61 |
$5,246.31 |
$84,552.23 |
| 2028 |
12 |
$3,692.59 |
$5,487.33 |
$79,064.91 |
| 2029 |
12 |
$3,440.51 |
$5,739.41 |
$73,325.49 |
| 2030 |
12 |
$3,176.84 |
$6,003.08 |
$67,322.41 |
| 2031 |
12 |
$2,901.06 |
$6,278.86 |
$61,043.55 |
| 2032 |
12 |
$2,612.61 |
$6,567.31 |
$54,476.24 |
| 2033 |
12 |
$2,310.91 |
$6,869.01 |
$47,607.22 |
| 2034 |
12 |
$1,995.34 |
$7,184.57 |
$40,422.65 |
| 2035 |
12 |
$1,665.29 |
$7,514.63 |
$32,908.02 |
| 2036 |
12 |
$1,320.07 |
$7,859.85 |
$25,048.16 |
| 2037 |
12 |
$958.99 |
$8,220.93 |
$16,827.23 |
| 2038 |
12 |
$581.32 |
$8,598.60 |
$8,228.63 |
| 2039 |
11 |
$186.30 |
$8,228.63 |
$0.00 |
Loan Payment Formula
The loan payment formula is shown below on how to calculate loan payments.
P = r(PV)/(1-(1+r)^-n), where
P = Payment
PV = Present value
r = rate per period
n = # of periods
How to Calculate Loan Payments
To use the loan payment formula, you will need a few variables such as the loan amount, annual interest rate and the loan terms.
For example, here's how to calculate monthly payment on a loan with loan amount of $100,000, 5% interest rate and loan terms of 10 years.
Monthly Payment = ((100000 * 5/12/100) / (1 - 1 / (1 + 5/12/100)^10*12)) = $1,060.66
The monthly payment for the loan is $1,060.66.
Loan Calculator Excel
|
|
Electrical Calculators
Real Estate Calculators
Accounting Calculators
Business Calculators
Construction Calculators
Sports Calculators
Physics Calculators
Random Generators
Financial Calculators
Compound Interest Calculator
Mortgage Calculator
How Much House Can I Afford
Loan Calculator
Stock Calculator
Investment Calculator
Retirement Calculator
401k Calculator
eBay Fee Calculator
PayPal Fee Calculator
Etsy Fee Calculator
Markup Calculator
TVM Calculator
LTV Calculator
Annuity Calculator
How Much do I Make a Year
Math Calculators
Mixed Number to Decimal
Ratio Simplifier
Percentage Calculator
Health Calculators
BMI Calculator
Weight Loss Calculator
Conversion
CM to Feet and Inches
MM to Inches
Others
How Old am I
Random Name Picker
Random Number Generator
|