TOOL 01
Mortgage Calculator
Commercial loan payment, amortization schedule, and balloon balance. P&I + escrow (taxes & insurance).
$
$
$
MONTHLY PAYMENT
$33,605
PITI = Principal + Interest + Tax + Insurance
LOAN AMOUNT
$3,750,000
DOWN PAYMENT
$1,250,000
MONTHLY P&I
$27,105
ANNUAL DEBT SERVICE
$325,263
TOTAL INTEREST PAID
$4,381,577
BALLOON @ YR 10
$2,969,258
Amortization Schedule
First 25 years of payments
| Year | Principal | Interest | Balance |
|---|---|---|---|
| 1 | $55,198 | $270,065 | $3,694,802 |
| 2 | $59,336 | $265,927 | $3,635,466 |
| 3 | $63,784 | $261,479 | $3,571,682 |
| 4 | $68,565 | $256,698 | $3,503,117 |
| 5 | $73,704 | $251,559 | $3,429,413 |
| 6 | $79,229 | $246,034 | $3,350,184 |
| 7 | $85,168 | $240,095 | $3,265,016 |
| 8 | $91,552 | $233,711 | $3,173,464 |
| 9 | $98,414 | $226,849 | $3,075,050 |
| 10 | $105,791 | $219,472 | $2,969,258 |
| 11 | $113,721 | $211,542 | $2,855,537 |
| 12 | $122,246 | $203,017 | $2,733,291 |
| 13 | $131,409 | $193,854 | $2,601,882 |
| 14 | $141,259 | $184,004 | $2,460,623 |
| 15 | $151,848 | $173,415 | $2,308,775 |
| 16 | $163,230 | $162,033 | $2,145,545 |
| 17 | $175,466 | $149,798 | $1,970,079 |
| 18 | $188,618 | $136,645 | $1,781,461 |
| 19 | $202,757 | $122,506 | $1,578,704 |
| 20 | $217,955 | $107,308 | $1,360,749 |
| 21 | $234,293 | $90,971 | $1,126,457 |
| 22 | $251,855 | $73,408 | $874,602 |
| 23 | $270,733 | $54,530 | $603,869 |
| 24 | $291,027 | $34,236 | $312,842 |
| 25 | $312,842 | $12,421 | $0 |
Highlighted row = balloon payment year. Balance must be refinanced or paid off at term end.
Estimates only. Assumes fixed rate, monthly compounding, no prepayment. For binding underwriting, consult Adrian Ramirez, CCIM directly.