Monthly Annuity Loan Scenario
Calculate using the labelled inputs: Monthly Annuity Loan Scenario.
Enter a finite value within the formula’s domain and supported numeric range.
The entered base rate plus margin is held constant for this entire schedule. No current benchmark or future reset path is supplied.
| Month | Payment | Principal repaid | Interest | Remaining principal |
|---|
Calculation and assumptions
annual_total=base+margin; r=annual_total/1200; A=P·r/(1−(1+r)^(-N)); r=0: A=P/N; monthly_interest=round(balance·r,2)
Add the entered base annual percentage and bank margin in percentage points, not a percentage of the base. Enter a full nominal rate with margin zero to use the original mode. Both components are nonnegative, up to six decimal places, with combined rate at most 100%. The sum uses exact decimal arithmetic before monthly conversion. This is a constant-rate scenario, including when a benchmark such as WIBOR is entered; no current rates, contractual floors or scheduled resets are fetched. Divide the combined nominal annual rate by 12. The annuity rounds once; monthly interest rounds to cents, halves away from zero. The final payment clears the remaining balance and may differ. No fees, insurance, APR or statutory total cost is computed.
Values must satisfy the formula’s domain. Nonzero results too small or too large for reliable representation are rejected.
Frequently asked questions
How is the result calculated?
annual_total=base+margin; r=annual_total/1200; A=P·r/(1−(1+r)^(-N)); r=0: A=P/N; monthly_interest=round(balance·r,2)
What assumptions apply?
Add the entered base annual percentage and bank margin in percentage points, not a percentage of the base. Enter a full nominal rate with margin zero to use the original mode. Both components are nonnegative, up to six decimal places, with combined rate at most 100%. The sum uses exact decimal arithmetic before monthly conversion. This is a constant-rate scenario, including when a benchmark such as WIBOR is entered; no current rates, contractual floors or scheduled resets are fetched. Divide the combined nominal annual rate by 12. The annuity rounds once; monthly interest rounds to cents, halves away from zero. The final payment clears the remaining balance and may differ. No fees, insurance, APR or statutory total cost is computed.
How precise are the results?
Monetary totals use two decimal places, with exact halves rounded away from zero at the steps described. Ratios and other numbers show up to ten significant digits. Display precision does not improve input accuracy. Values must satisfy the formula’s domain. Nonzero results too small or too large for reliable representation are rejected.