Template, CAD 27

Rental propertyanalyzer.

Enter the price, the financing, the rent and the running costs. The workbook returns monthly cash flow, cap rate, cash-on-cash return and debt service coverage.

Get it for CAD 27 What is inside

Price: CAD 27, one time
Opens in: Google Sheets and Excel
Built by: Salman Feroz, CPA, CMA and team
Code word: RENTAL

Rental property analyzer: a real screen from the workbook, with sample figures — A real screen from the template, shown with sample figures.

What is inside

7 parts, one workbook

Inputs are marked in colour. Everything else calculates. The first sheet is a one-page guide.

01Purchase, closing and renovation costsIncluded
02Financing with the Canadian mortgage payment methodIncluded
03Rent, other income and vacancyIncluded
04Operating expensesIncluded
05Monthly and annual cash flowIncluded
06Cap rate, cash-on-cash return and debt service coverageIncluded
07Side-by-side comparison of three propertiesIncluded

Who it is for

Rental property analyzer: who gets the most from it

Cash flow, cap rate and debt coverage before you make an offer.

Built by The Accounting Doc team in Pickering, Ontario, from the working files we use with clients.

First-time and repeat rental investors
Realtors preparing numbers for investor clients
Owners comparing two or three properties

Get the rental property analyzer for CAD 27

CAD 27, one time. Tell us where to send it and we email you a secure payment link. The workbook is delivered to your inbox once it is paid.

Purchase, closing and renovation costs
Financing with the Canadian mortgage payment method
Rent, other income and vacancy
Operating expenses

Rental property analyzer: your questions

What does the rental property analyzer cost?

CAD 27, one time. No subscription. You pay through a secure payment link and the file is emailed to you.

What do I need to open it?

It is a workbook that opens in Google Sheets (File, Import, Upload) and in Excel 2016 or later. No macros, so nothing to enable.

Can I use it for more than one business?

Yes, for your own businesses. Please do not resell or redistribute the file.

What if it does not fit my business?

Reply to the delivery email and tell us what is missing. We will point you to the right template or adjust the approach with you.

Is this accounting or tax advice?

No. It is a working tool. Your own numbers and decisions should be reviewed with your accountant, and we are glad to be that accountant.