Loan Payment
Loan Payment. Calculate with Principal, Annual interest rate (%), Total months; review the formula, units and worked example.
Values and units
Runs in this browserResult
Set the inputs and run the tool to view the result.
How to use Loan Payment
- Review the populated example and the input units, then replace it with your data.
- Calculate with Principal, Annual interest rate (%), Total months; review the formula, units and worked example.
- Run the tool, inspect the result, then copy or download what you need.
Method and scope
pmt(principal,annual/1200,months)
Formula
pmt(principal,annual/1200,months)- principal
- Principal
- annual
- Annual interest rate (%)
- months
- Total months
Numbers retain the tool's existing precision. Keep monetary inputs in the same currency and enter percentages as percentage values.
Estimates depend on the inputs and the stated formula. Confirm contractual costs, carrier rules and applicable taxes separately.
Input example
Principal: 100000 Annual interest rate (%): 5 Total months: 120
Expected result: 1,060.655152 currency/
Questions and result checks
How does Loan Payment determine the result?
pmt(principal,annual/1200,months)
Formula
pmt(principal,annual/1200,months)- principal
- Principal
- annual
- Annual interest rate (%)
- months
- Total months
Numbers retain the tool's existing precision. Keep monetary inputs in the same currency and enter percentages as percentage values.
What should I check before processing?
Estimates depend on the inputs and the stated formula. Confirm contractual costs, carrier rules and applicable taxes separately.
How can I verify the output?
Use the supplied example as a check, then compare important results with the original source or business document.
Principal: 100000 Annual interest rate (%): 5 Total months: 120
Expected result: 1,060.655152 currency/
Related tools
Simple Interest
Calculate with Principal, Annual interest rate (%), Interest days; review the formula, units and worked example.
Exchange & PaymentsCompound Interest
Calculate with Principal, Annual interest rate (%), Number of years; review the formula, units and worked example.
Exchange & PaymentsAnnualized Return
Calculate with Initial investment, Ending value, Holding period in days; review the formula, units and worked example.
Exchange & PaymentsDiscounted Value
Calculate with Future amount, Discount rate (%), Number of years; review the formula, units and worked example.
Exchange & PaymentsCredit Term Cost
Calculate with Credit sales amount, Annual financing cost rate (%), Credit period in days; review the formula, units and worked example.
Exchange & PaymentsEffective APR
Calculate with Periodic interest rate (%), Periods per year; review the formula, units and worked example.