Loan Payment Calculator (Amortized) — Notebook Template
Compute fixed monthly payment for an amortized loan (mortgage/auto). Includes total paid and total interest.
What this template does
This is a ready-to-run GetCalcMaster Notebook starter. Open it into Notebook, run once with defaults, then tweak inputs and keep your assumptions next to the math.
How to use it (recommended)
- Open in Notebook.
- Set principal P, APR, and loan term in years.
- Confirm the monthly rate r = APR/12 and n = years×12.
- Compute payment, total paid, and total interest.
- Verify by changing APR slightly and checking sensitivity.
Tip: When a result matters, verify it twice: a unit check + a second method (graph/estimate).
Preview (first cells)
This preview is for readability. The full template loads into Notebook when you click Open.
TEXT
# Loan Payment Calculator (Amortized) This template computes the **fixed monthly payment** for an amortized loan. Variables: - **P** = principal - **APR** = annual percentage rate (decimal) - **r** = monthly rate = APR/12 - **n** = number of payments = years×12 Payment formula: **PMT = P · r(1+r)^n / ((1+r)^n − 1)** Educational use. Real loans may include escrow/insurance/fees.
MATH
P = 300000
MATH
APR = 0.065
MATH
years = 30
MATH
r = APR / 12
MATH
n = years * 12