Amortization Schedule Calculator
Amortization Schedule is evaluated from Loan Amount, Annual Interest Rate and Loan Term. The calculation reports Monthly Payment, Total Repayment and Total Interest Paid.
Results
About the Amortization Schedule Calculator
The calculator uses a financial amortization configuration. Each reported value is read as a direct evaluation of the stored rules with the declared field formats and units.
Formula basis:
Monthly Payment = P x r x (1 + r)ⁿ / [(1 + r)ⁿ - 1] (constant)
Interest Portion(m) = Remaining Balance(m-1) x r
Principal Portion(m) = Monthly Payment - Interest Portion(m)
Remaining Balance(m) = Remaining Balance(m-1) - Principal Portion(m)
Where r = monthly rate = APR / 1200, n = total months
Interpret the outputs in the order shown by the result fields. Optional inputs affect only the outputs that depend on those variables.
Formula & How It Works
The calculation applies the following relations exactly as recorded in the metadata: Monthly Payment = P x r x (1 + r)ⁿ / [(1 + r)ⁿ - 1] (constant) Interest Portion(m) = Remaining Balance(m-1) x r Principal Portion(m) = Monthly Payment - Interest Portion(m) Remaining Balance(m) = Remaining Balance(m-1) - Principal Portion(m) Where r = monthly rate = APR / 1200, n = total months Each output field is produced by substituting the supplied inputs into the relevant relation and then applying the declared rounding or text format.
Worked Examples
Example 1: 30-Year Mortgage — First and Last Year
Inputs
With Loan Amount = 300,000, Annual Interest Rate = 7 and Loan Term = 360 as the stated inputs, the result is Monthly Payment = $1,995.91, Total Repayment = $718,527.6 and Total Interest Paid = $418,524.05. Each value corresponds to the declared output fields.
Example 2: 5-Year Auto Loan — Halfway Check
Inputs
With Loan Amount = 35,000, Annual Interest Rate = 6.5 and Loan Term = 60 as the stated inputs, the result is Monthly Payment = $684.82, Total Repayment = $41,089.2 and Total Interest Paid = $6,088.83. Each value corresponds to the declared output fields.
Example 3: 10-Year Home Equity Loan — Impact of Extra Payment
Inputs
With Loan Amount = 50,000, Annual Interest Rate = 8.5 and Loan Term = 120 as the stated inputs, the result is Monthly Payment = $619.93, Total Repayment = $74,391.6 and Total Interest Paid = $24,391.29. Each value corresponds to the declared output fields.
Example 4: Personal Loan — Full 3-Year Schedule
Inputs
With Loan Amount = 15,000, Annual Interest Rate = 11 and Loan Term = 36 as the stated inputs, the result is Monthly Payment = $491.08, Total Repayment = $18,169.96 and Total Interest Paid = $2,678.91. Each value corresponds to the declared output fields.
Common Use Cases
- See exactly how each payment is split between interest and principal
- Find remaining loan balance at any point in time
- Calculate total interest paid after a set number of payments