Decision tools
Commercial mortgage calculators
Commercial Mortgage Payment Calculator (Canada)
A commercial mortgage payment depends on the loan, the rate, the amortization and how the rate compounds. Canadian mortgages usually quote semi-annual compounding. Because the term is shorter than the amortization, a balance is still owing at maturity. This calculator shows it and the coverage your NOI provides.
- Semi-annual or monthly compounding
- Interest-only option
- Balance at maturity
- DSCR from NOI
- CSV export and share link
DSCR Calculator for Commercial Property (Canada)
DSCR (debt service coverage ratio) is net operating income divided by annual mortgage payments. Lenders set a minimum. CMHC's MLI Select, for example, requires at least 1.10 for standard rental. The ratio caps how much you can borrow regardless of value.
- NOI from rent, other income, vacancy, expenses and management
- DSCR against a lender minimum
- Largest loan at the target DSCR
- Expense ratio
Cap Rate Calculator: Cap Rate and Property Value
Cap rate is net operating income divided by price or value. Turned around, value equals NOI divided by the cap rate. Small cap rate changes move value a lot, which is why lenders test value at their own cap rate before setting the loan.
- Solve for cap rate or value
- Value at nearby cap rates
- Direct capitalization
Commercial LTV and Loan Sizing Calculator
A commercial loan is sized by the tightest of several tests: loan-to-value, debt service coverage and sometimes debt yield. The maximum loan is the smallest of the three, and the one that binds tells you what to change: more equity, more NOI or different terms.
- Max loan by LTV, DSCR and debt yield
- Binding constraint
- Requested loan check with shortfall
- Loan constant
Commercial Refinance and Cash-Out Calculator
A commercial refinance replaces the current mortgage with a new loan sized on today's value and NOI. Cash out is the new loan minus the current balance, prepayment penalty and costs. If the new loan is smaller than the payout, the refinance needs equity or a different structure.
- New loan by LTV and DSCR
- Cash out after penalty and costs
- Old vs new payment
- Rate-and-term comparison