Amortization
Amortization is the schedule over which a loan’s principal is repaid through regular payments, and in commercial real estate the amortization period is often longer than the loan term, leaving a balance due at maturity.
What are the payment and balance formulas?
Monthly payment = loan x r / (1 - (1 + r)^-n)
Balance after k payments = loan x (1 + r)^k - monthly payment x ((1 + r)^k - 1) / r
Annual loan constant = 12 x monthly payment / loan
- Loan: the original principal.
- r: the annual interest rate divided by 12.
- n: the number of monthly payments in the amortization period (360 for 30 years).
- k: the number of payments made so far.
Each payment covers that month's interest (balance x r) first, and the rest reduces principal. Early payments are mostly interest. An interest-only period postpones principal entirely, which lowers the payment and leaves the balance unchanged.
How does the sample loan amortize?
Illustrative figures. The 96-unit community is refinanced with a $9,000,000 loan at 6.25 percent on a 30-year (360-month) amortization with a 10-year term.
| Item | Amount |
|---|---|
| Monthly payment | $55,414.55 |
| First payment: interest ($9,000,000 x 6.25% / 12) | $46,875.00 |
| First payment: principal ($55,414.55 - $46,875.00) | $8,539.55 |
| Year one total (12 payments) | $664,974.60 |
| Year one principal / interest | $105,461.64 / $559,512.96 |
| Balance after year one | $8,894,538.36 |
| Balance at maturity, after 120 payments (monthly schedule, rounded to the cent) | $7,581,393.77 |
The file rounds the year's payments to $665,000, which gives 1.31x coverage on $871,000 of NOI. Over ten years the borrower repays $1,418,606.23, or 15.8 percent of the loan, and owes the rest at maturity. The annual constant is 7.39 percent.
For comparison, interest only at 6.25 percent would cost $9,000,000 x 6.25% = $562,500 a year, and coverage would look like 1.55x, but the full $9,000,000 would be due at maturity.
How do lenders use amortization?
Amortization does two jobs. It sets the payment, and therefore coverage, and it reduces the balance the property must refinance at maturity. A shorter amortization lowers maturity risk but raises the payment; a longer one or an interest-only period flatters coverage today and pushes risk to the end of the term. Many lenders set maximum amortization periods by property type.
Typical policy treatment (illustrative): the sample lender allows up to 30-year amortization on stabilized apartments and tests coverage on the amortizing payment even where an interest-only period is offered.
What are common amortization mistakes?
- Quoting coverage on interest-only payments for a loan that will amortize during most of its term.
- Using an amortization period longer than the remaining useful life of the building.
- Confusing term and amortization, so the balloon at maturity is missed.
- Rounding the annual constant before multiplying it by the loan.
Where does amortization appear in the credit memo?
The loan terms section states the rate, term, amortization and any interest-only period. The coverage section states which payment the DSCR uses, and the maturity analysis shows the balance due and how it would be refinanced.
Related terms
Maturity risk, DSCR, loan sizing, term sheet, stress testing.
Where LenderBox does this work
With loan sizing and deal structuring, LenderBox sizes the loan at today's rate and under stress and tests the proposed terms against your credit box, so the amortization your team quotes has been checked against coverage first.