Home 🧮 Residential Calculator 🏢 Commercial Calculator
Training Centre
Training Centre home Calculator Tutorial Videos Broker Training Course Learning Hub Templates Lender Directory
Templates from MyMortgageMate.ca

The two forms lenders ask for first

A rent roll and a personal net worth statement, built for real lender submissions. The maths is done for you.

EXCEL

Rent roll and NOI

Every unit and every income stream on one sheet, with net operating income worked out for you.

  • A unit rent roll: type, size, occupancy and rent, with a Qty column for matching units
  • Drop-downs for residential, commercial, parking and other income
  • Vacancy, operating expenses and NOI, worked out for you
  • Optional quick ratios: cap rate, DSCR, NOI per unit and expense ratio
Download the Excel file Excel (.xlsx) · 49 KB
EXCEL

Personal net worth statement

What the client owns and owes, and what's left. The first thing a commercial lender asks for.

  • Cash, investments, RRSP, TFSA, business interests and more
  • Up to 8 properties, with the equity in each worked out
  • Liabilities, with the mortgage balances carried over for you
  • Net worth calculated, plus a signature line
Download the Excel file Excel (.xlsx) · 42 KB

How to use them

  1. DownloadSave a fresh copy for each client.
  2. Fill in the cream cellsThe grey cells marked AUTO work themselves out.
  3. Check it against the paperworkEvery rent against its lease. Every balance against a statement.
  4. Send it with the deal synopsisRent roll, net worth statement and the MyMortgageMate Deal Synopsis together.
Why these two firstCommercial course, Session 5The net worth statement shows what the client has beyond the deposit. The rent roll is essential. Learn what else goes in a first assessment. Open Session 5

For planning only. Lenders assess every deal differently, so confirm the figures with your lender.