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: 
Feb, 2038 
Payment Date 
Payment # 
Interest Paid 
Principal Paid 
Remaining Balance 
2023 
10 
$3,683.53 
$3,966.41 
$96,033.59 
2024 
12 
$4,220.04 
$4,959.88 
$91,073.72 
2025 
12 
$3,992.19 
$5,187.73 
$85,885.99 
2026 
12 
$3,753.86 
$5,426.05 
$80,459.93 
2027 
12 
$3,504.59 
$5,675.33 
$74,784.60 
2028 
12 
$3,243.87 
$5,936.05 
$68,848.55 
2029 
12 
$2,971.17 
$6,208.75 
$62,639.80 
2030 
12 
$2,685.94 
$6,493.98 
$56,145.82 
2031 
12 
$2,387.61 
$6,792.31 
$49,353.51 
2032 
12 
$2,075.57 
$7,104.35 
$42,249.16 
2033 
12 
$1,749.20 
$7,430.72 
$34,818.44 
2034 
12 
$1,407.83 
$7,772.09 
$27,046.35 
2035 
12 
$1,050.78 
$8,129.14 
$18,917.21 
2036 
12 
$677.33 
$8,502.59 
$10,414.62 
2037 
12 
$286.72 
$8,893.20 
$1,521.42 
2038 
2 
$8.56 
$1,521.42 
$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
