What this means for the deal
- Define the property interest, legal and physical perimeter, decision date, hold and transaction mandate before calculating value.
- Reconcile rent roll income to every current lease, amendment, security record, arrears position and rollover event.
- Normalize operating statements without silently treating recoveries as NOI or excluding owner-paid costs.
- Place TI, commissions, deferred maintenance, environmental work and reserves in the actual months they are expected to occur.
- Separate amortization from loan maturity and preserve any balloon or refinancing need as a visible cash event.
- Cap the forward twelve months after the assumed sale, deduct selling costs and stress both terminal NOI and exit cap rate.
- Treat GST/HST, transfer charges and income-tax consequences as jurisdiction- and transaction-specific reviewed inputs—not generic percentages.
Identify the property, interest, decision and intended reliance
Start with the purchaser, property, legal description, civic address, province or territory, property type, ownership interest, acquisition structure, expected closing date, underwriting date and decision owner. Record whether the analysis supports an initial screen, letter of intent, financing request, investment committee decision, due-diligence waiver, price amendment or closing. A model prepared for internal screening is not automatically suitable for lender, investor, tax or appraisal reliance.
Define the physical and economic perimeter. Confirm land, buildings, condominium or strata interests, parking, storage, signage, equipment, fixtures, chattels, licences, easements, rights, encumbrances and any excluded assets. The Appraisal Institute of Canada’s CUSPAP framework requires a formal appraisal assignment to identify the property, interest and relevant physical, legal and economic attributes. A browser workbench does not perform that professional assignment.
| Control | Record | Why it matters |
|---|---|---|
| Property | Legal description, civic address and stable ID | Prevents evidence from moving between assets |
| Interest | Fee simple, leasehold, condominium or another interest | Controls what is actually being acquired |
| Decision | Screen, bid, waiver, financing, approval or close | Sets the required evidence and reviewer |
| As-of date | Exact underwriting and evidence date | Makes staleness and later events visible |
| Reliance | Named users and professional mandates | Prevents an internal model becoming an unsupported opinion |
Obtain the documents before polishing the return
Create a controlled index covering title and survey, purchase agreement and amendments, rent roll, every lease and amendment, guarantees and security, arrears and disputes, estoppels, operating statements, current budget, tax and assessment records, utility history, service contracts, insurance and claims, environmental reports, building-condition and engineering reports, plans, permits, zoning and occupancy records, capital projects, warranties, financing terms and transaction-tax advice. Keep received, reviewed and resolved as separate states.
Reconcile names, dates, areas, suites, deposits, options, defaults, notices and payment facts across the sources. A vendor rent roll may be current but still conflict with an executed lease, later amendment, ledger or tenant confirmation. Preserve the discrepancy and accountable reviewer instead of replacing the legal or operating record with the number that makes the deal work.
- Identify every missing document, incomplete schedule, unsigned instrument and stale report.
- Record who owns the review and which condition, holdback, price change or closing deliverable may result.
- Keep environmental and building-condition reliance language, date, scope and intended users visible.
- Confirm whether reports may be assigned, relied upon or updated for the purchaser and lender.
- Store approved evidence in the organization’s controlled repository; the device-local workbench is an analysis file, not the data room.
Start with leases and operating records—not a quoted cap rate
Build income one source line at a time: contract base rent, percentage rent, recoveries, parking, storage, signage, antenna, licence and other property income. For each line, record the annualized starting amount, active months, first growth month, exact recurrence interval, growth amount or percentage, vacancy treatment, evidence state and source. A lease with steps every five years should not be forced into an annual escalation field.
Separate gross potential income from vacancy and credit loss. Identify current vacancy, free rent, bad debt, abatements, collection issues, early terminations, options and known rollover. Do not apply one generic vacancy percentage to recoveries or other income unless that treatment matches the approved analysis. Use the Rent Roll and Leasing Pipeline tools when suite-level occupancy and prospect timing materially drive the forecast.
Build expenses from actual statements and contracts: property tax, insurance, utilities, repairs, maintenance, cleaning, security, landscaping, snow, management, administration and other owner-paid costs. Reconcile accounting classifications, accruals, one-time items, recoveries and related-party charges. Net operating income is effective property income less property operating expenses under the stated convention; it is not automatically cash available to equity.
A stabilized annual reserve cannot replace the actual capital path
Translate building-condition, environmental and leasing evidence into dated capital events. Separate immediate closing work, deferred maintenance, code or compliance work, environmental investigation and remediation, lifecycle replacement, tenant improvements, landlord work, leasing commissions and recurring reserves. Record scope, estimate basis, contingency, tax, timing, approval, source and whether the amount is a cash event or an accounting reserve.
Connect lease rollover to downtime, free rent, TI, commissions, legal cost, base-building work and changed recoveries. The Rent Roll and Leasing Pipeline tools can carry suite-level timing; the acquisition workbench then receives only the approved monthly events. Do not assume that every expiring tenant renews, every vacancy leases on schedule or every capital project produces its forecast saving.
| Layer | Typical source | Underwriting treatment |
|---|---|---|
| Immediate work | Condition, environmental and code review | Acquisition cash or early-month event |
| Lifecycle capital | Engineering plan and reserve study | Dated projects and recurring reserve events |
| Rollover TI | Lease, market evidence and leasing plan | Month tied to vacancy and commencement scenario |
| Commission | Brokerage agreement and leasing plan | Payment month and conditions |
| Efficiency work | Audit, design and incentive terms | Separate party capital and verified savings |
Separate purchase economics, financing costs and potentially recoverable tax cash
Start with purchase price and add the entered transfer or registration charge, legal and due-diligence cost, immediate capital and other closing costs. Keep financing fees separate so an unlevered property return does not absorb a debt-specific cost without explanation. Reconcile deposits, holdbacks, adjustments, prepaid amounts, arrears, tenant deposits, vendor credits and assumed contracts through the actual closing statement.
Commercial real-property sales are generally taxable supplies unless a specific exemption or other statutory treatment applies, according to the Canada Revenue Agency. Place of supply follows the province where the property is located. Registration status, purchaser self-assessment, input tax credits, elections, mixed use, asset allocation and timing can materially change the cash path. The workbench therefore accepts a potentially recoverable GST/HST cash amount and recovery month but never determines eligibility or tax payable.
Transfer charges also vary. Alberta uses land-title registration fees and levies; British Columbia applies property transfer tax to taxable transactions based generally on fair market value; Ontario land transfer tax uses value of consideration; Québec municipal mutation duties use a statutory tax base and indexed bands, with possible municipal rates. Confirm the current transaction with qualified legal and tax advisers and the responsible authority. Do not transplant one province’s table into another property.
Amortization, interest-only period and maturity answer different questions
Record loan amount, interest rate, payment convention, amortization, interest-only months, contractual term, fees, reserves, recourse, guarantees, covenants, prepayment terms, funding conditions and source. The workbench calculates monthly interest and principal from the entered terms. It does not supply a lender rate, maximum loan-to-value, minimum debt-service coverage or approval standard.
A twenty-five-year amortization does not mean the loan lasts twenty-five years. If a five-year term matures before the entered sale, the remaining principal is a balloon. Preserve that outflow and a refinancing issue. A replacement loan requires its own amount, rate, fees, conditions and timing; it must not appear automatically merely because the investment case assumes a longer hold.
Review DSCR, debt yield, loan to price, annual debt service and break-even occupancy together. State whether DSCR uses NOI before or after reserves and which debt obligations are included. Covenant compliance and lender definitions come from the financing documents, not from a generic ratio label.
Use forward NOI and test what happens when the exit disappoints
Calculate terminal NOI from the twelve months immediately after the assumed sale month so the capitalized income reflects the next owner’s forward period. Divide by the entered exit capitalization rate, then deduct percentage selling costs, fixed disposition costs and other entered deductions. The result is a scenario—not a market-value opinion. A qualified appraisal has a defined property interest, effective date, scope, data, analysis and intended reliance under applicable professional standards.
Build unlevered cash flow from acquisition economic cost, property NOI, capital and net sale before debt. Build levered cash flow from initial equity, property cash after debt, tax cash timing, any balloon and net sale after debt. Calculate NPV using the entered discount rate and IRR from the monthly cash flow. Show equity multiple beside IRR because timing and total dollars answer different questions.
Stress terminal NOI and exit cap rate independently. A lower cap rate can create apparent value even when operations disappoint; stronger NOI can be offset by market repricing. Add separate downside cases for lease rollover, vacancy, capital, interest rate, refinancing, environmental work, tax and closing delay when those risks are material. Sensitivity is not probability and does not replace a supported scenario narrative.
| Measure | Calculation lens | What it does not prove |
|---|---|---|
| Going-in cap | Year-one NOI ÷ purchase price | Market value or total return |
| Yield on cost | Year-one NOI ÷ acquisition economic cost | Stabilization or sale value |
| DSCR | NOI ÷ scheduled debt service | Covenant compliance or liquidity |
| IRR | Rate setting monthly NPV to zero | Forecast certainty or adequate return |
| Equity multiple | Positive equity cash ÷ negative equity cash | Timing or risk |
| NPV | Cash discounted at entered rate | Correct discount rate or appraisal conclusion |
Turn every unresolved risk into an owner, condition or explicit acceptance
Prepare an investment committee brief showing mandate, price and total closing cash, year-one operations, capital schedule, debt, maturity, exit, unlevered and levered returns, sensitivity, evidence coverage, material findings and open decisions. Explain changes from the prior version and preserve the approved file. A single headline IRR without its rent, capital, debt and exit bridge is not a controlled decision record.
For each unresolved item, choose the appropriate response: obtain evidence, commission specialist work, change price, add a representation, warranty, covenant, condition, holdback, indemnity or insurance requirement, revise financing, defer approval, or accept the risk through the authorized process. Qualified counsel should determine drafting and legal effect; other specialists should determine findings within their mandates.
Before closing, reconcile the final purchase agreement, financing, entity, title, adjustments, taxes, deposits, tenant security, insurance, environmental and building deliverables. After closing, move approved rent, dates, obligations, options, capital, debt and evidence into the operating systems. Preserve the closing binder and the final approved underwriting rather than overwriting it with the next budget.
Frequently asked questions
Is this commercial property underwriting tool an appraisal?+
No. It is a user-entered planning model. A formal opinion of value on an identifiable property requires an appropriate professional mandate, evidence, analysis and reporting under applicable standards such as CUSPAP for AIC members.
Does it supply a Canadian market cap rate?+
No. Enter a sourced scenario and test the sensitivity grid. Cap rates vary by property, interest, location, tenancy, date, condition, growth, capital and market evidence.
How does the tool calculate terminal value?+
It sums the modelled NOI for the twelve months immediately after the entered hold, divides that forward NOI by the entered exit cap rate and deducts entered selling and disposition costs.
Does the debt model assume refinancing?+
No. If the entered loan term ends before sale, the remaining principal becomes a balloon at maturity and the file flags the refinancing gap. Replacement financing must be separately sourced and modelled.
Does GST/HST increase acquisition cost?+
The answer depends on the transaction, registration, use, elections and applicable law. The tool keeps potentially recoverable tax cash separate from economic cost and models recovery only in the month entered by the user. Obtain qualified tax advice.
What should be reconciled before relying on NOI?+
At minimum: rent roll to leases and amendments, ledger and arrears, recoveries, operating statements, current budget, service contracts, tax and insurance, vacancies, options, known notices, capital work and rollover assumptions.
Where the factual guidance comes from
These links support narrow factual points in this guide. They do not replace review of the proposal, executed lease or advice for the actual transaction.
Appraisal Institute of Canada — CUSPAP 2026 ↗Official current overview of the Canadian Uniform Standards of Professional Appraisal Practice and their application to professional assignments completed on or after April 1, 2026.Canada Revenue Agency — Commercial real property sales and rentals ↗Official GST/HST memorandum explaining that commercial real-property sales are generally taxable unless a specific exemption or treatment applies.Canada Revenue Agency — GST/HST place-of-supply rules ↗Official current explanation that the place of supply for a sale or lease of real property is generally the province where the property is located.Government of Alberta — Register a land title document or plan ↗Official Alberta land-title registration overview and current direction to the governing fee schedule and legal assistance.Province of British Columbia — Property transfer tax ↗Official B.C. overview of taxable property transfers, fair-market-value basis, rates, returns, exemptions and professional filing practice.Government of Ontario — Calculating land transfer tax ↗Official Ontario land-transfer-tax rates and calculation framework based on value of consideration.Gouvernement du Québec — Droits sur les mutations immobilières ↗Official Québec explanation of municipal mutation duties, tax base, indexed statutory bands and municipal variation.This guide is general educational information and financial-workflow support. It is not legal, tax, accounting, engineering, environmental, appraisal or brokerage advice. Verify source documents and obtain appropriate professional advice before acting.
