Every experienced real estate investor has a property analysis spreadsheet. It is the tool that separates serious investors from people who buy on gut feeling and hope for the best.
A good spreadsheet takes a potential deal and breaks it down to a single question: does this property make financial sense? It accounts for every dollar coming in, every dollar going out, and every metric that matters. And it does this in minutes—not hours—so you can evaluate dozens of deals and focus your time on the ones worth pursuing.
Here is how to build one from scratch and use it to make smarter investment decisions.
Section 1: Property Information
Start your spreadsheet with the basics. This section is straightforward, but it keeps your analyses organized—especially when you are evaluating multiple properties at once.
- Property address
- Property type (single-family, duplex, triplex, 4-plex, 5+ unit building)
- Number of units
- Year built
- Square footage (total and per unit)
- Listing/purchase price
- Listing date and days on market
This section also helps you recall the property months later when you are reviewing past analyses. Include a notes field for anything notable—great location, needs a new roof, motivated seller, whatever stands out.
Section 2: Revenue
This is where your income projections live. Be thorough and realistic.
Gross Potential Rent
List each unit separately with its current rent. If the building has six units, you want six lines:
| Unit | Bedrooms | Current Rent | Market Rent |
|---|---|---|---|
| 1 | 2BR | $1,300 | $1,450 |
| 2 | 2BR | $1,350 | $1,450 |
| 3 | 1BR | $1,050 | $1,100 |
| 4 | 1BR | $1,000 | $1,100 |
| 5 | 2BR | $1,400 | $1,450 |
| 6 | 2BR | $1,250 | $1,450 |
Total current rent: $7,350/month ($88,200/year) Total market rent: $8,000/month ($96,000/year)
Listing both current and market rent shows you the upside. If current rents are well below market, there is an opportunity to increase income after purchase. This is especially valuable when using tools like the CMHC MLI Max Loan Calculator to see how higher rents affect your maximum financing on 5+ unit buildings.
Other Income
Do not overlook non-rent revenue:
- Parking: $50-150/spot per month
- Laundry: $100-300/month for coin-operated machines
- Storage: $25-75/unit per month
- Late fees and application fees
- Cable/internet markups (if bundled)
These add up. A building with 10 parking spots at $100 each generates $12,000 per year in additional income. That extra income improves your NOI, your cap rate, and your cash flow.
Total Gross Potential Income is the sum of gross potential rent plus all other income.
Different financing structures change that annual debt service by thousands — book a free strategy call with LendCity and we’ll run your numbers through residential and CMHC multifamily options so you see which structure actually produces the cash flow you need.
The right financing product can change the math on this entirely — explore our DSCR loans guide for the options most investors use.
Section 3: Vacancy and Credit Losses
No property generates 100% of its gross potential income every month of every year. Your spreadsheet needs to account for reality.
Vacancy Rate
Apply a percentage to account for units sitting empty between tenants. Standard benchmarks:
- Strong rental markets (low vacancy cities, high demand): 3-5%
- Average markets: 5-7%
- Weaker markets or properties with turnover challenges: 7-10%
Credit Loss
This accounts for tenants who do not pay. Even with good screening, some rent goes uncollected. Budget 1-2% for credit losses.
Total Vacancy and Credit Loss = Gross Potential Income x (Vacancy Rate + Credit Loss Rate)
Effective Gross Income = Gross Potential Income - Vacancy and Credit Losses
Using our example: $88,200 x 5% = $4,410 in vacancy and credit losses, leaving $83,790 in effective gross income.
Section 4: Operating Expenses
This section requires the most detail and the most honesty. Underestimating expenses is the number one reason new investors end up with properties that underperform their projections.
Build your expense section with these line items:
Property Taxes
Get the actual figure from the municipal tax assessment, not the seller’s word. Property taxes can change after a sale if the property is reassessed at the new purchase price. In some jurisdictions, this is automatic. Budget for the potential increase.
Insurance
Get an actual quote for landlord/investment property insurance. It costs more than homeowner insurance. Include liability coverage, fire, flood if applicable, and loss of rent coverage.
Maintenance and Repairs
Budget 5-10% of gross income for ongoing maintenance: plumbing fixes, appliance repairs, painting between tenants, minor electrical work, and general wear and tear. Older buildings trend toward the higher end. Newer buildings can be lower, but never budget zero.
Property Management
Even if you plan to self-manage, include 8-10% of effective gross income. Why? Because your time has value, and your spreadsheet should reflect what it costs to run the property sustainably. If you ever want to step back from day-to-day management, or if you buy more properties and cannot handle them all, this expense becomes very real.
Utilities (Owner-Paid)
Water and sewer are commonly paid by the owner even when tenants cover their own heat and electricity. Common area electricity (hallways, laundry room, parking lot lights) is also an owner expense. Get actual utility bills from the seller for the past two years.
Landscaping and Snow Removal
If the property has grounds that need maintenance, budget accordingly. In Canadian climates, snow removal is a real and recurring cost from November through April.
Pest Control
Regular pest treatment prevents expensive infestations. Budget $500-1,500 per year depending on building size and location.
Legal and Accounting
Lease reviews, eviction proceedings, tax preparation, and bookkeeping. Budget $1,000-3,000 per year.
Advertising and Leasing
Cost of advertising vacant units, tenant screening fees, and any leasing commissions. Budget $500-1,500 per year depending on turnover.
Capital Expenditure Reserves
This is separate from maintenance. Capital expenditures are major replacements: roof ($15,000-50,000), boiler ($10,000-25,000), windows ($500-1,000 per window), parking lot repaving ($5,000-20,000), and appliances ($500-2,000 each). Budget 5-10% of gross income annually to fund these future costs.
Total Operating Expenses = Sum of all expense line items
A common rule of thumb: operating expenses typically run 35-45% of gross income for well-maintained buildings and 45-55% for older buildings with more maintenance needs. If your numbers fall well outside this range, double-check your assumptions.
Your interest rate sensitivity table shows a 2% hike drops DSCR to 1.03 — schedule a free strategy session with us and we’ll structure financing that keeps you above lender minimums even when rates move at renewal.
Section 5: Net Operating Income
NOI = Effective Gross Income - Total Operating Expenses
This is the most important number on your spreadsheet. NOI tells you what the property earns from operations before financing. It is the foundation for cap rate, DSCR, and property valuation.
Using our example:
- Effective Gross Income: $83,790
- Total Operating Expenses (42%): $37,044
- NOI: $46,746
If you’re exploring this further, our guide to Triple Net Lease Strategy for Canadian Real Estate Investors covers the details.
Section 6: Debt Service
Now bring in the financing. This section calculates your mortgage payments based on your loan terms.
Inputs:
- Purchase price
- Down payment percentage and dollar amount
- Mortgage amount (purchase price minus down payment, plus any insurance premiums)
- Interest rate
- Amortization period
- Term (how long until renewal)
Outputs:
- Monthly mortgage payment (principal and interest)
- Annual debt service (monthly payment x 12)
For a $700,000 purchase with 20% down:
- Mortgage amount: $560,000
- At a competitive rate with 25-year amortization, your annual debt service might be approximately $36,000-40,000
Different financing structures produce dramatically different results. A building with 5+ units might qualify for multifamily mortgage financing through CMHC with up to 50-year amortization, which would significantly reduce the annual debt service. Model multiple scenarios in your spreadsheet to see how financing changes your returns.
For properties under 5 units, residential mortgage financing rules apply, typically with 25-30 year amortization and minimum 20% down for investment properties.
Stress Test Row: Add a second row that calculates debt service at a higher rate. The Canadian mortgage stress test uses the higher of 5.25% or contract rate plus 2%. But beyond qualification, you want to know: what happens to your cash flow if rates increase at renewal? Build this into your spreadsheet so it is always visible.
Section 7: Cash Flow
Annual Cash Flow = NOI - Annual Debt Service
This is the money that actually ends up in your bank account each year (before taxes).
Using our example:
- NOI: $46,746
- Annual Debt Service: $38,000
- Annual Cash Flow: $8,746
- Monthly Cash Flow: $729
If this number is negative, you are losing money every month. Some investors accept negative cash flow in high-appreciation markets, but you should go in with eyes open and sufficient reserves to cover the shortfall.
Section 8: Key Metrics
Your spreadsheet should automatically calculate these metrics from the numbers you have already entered:
Cap Rate NOI / Purchase Price x 100 $46,746 / $700,000 = 6.7%
Cash-on-Cash Return Annual Cash Flow / Total Cash Invested x 100 You need to calculate total cash invested: down payment ($140,000) + closing costs ($18,000) + any renovations. If total cash invested is $158,000: $8,746 / $158,000 = 5.5%
Debt Service Coverage Ratio (DSCR) NOI / Annual Debt Service $46,746 / $38,000 = 1.23
A DSCR of 1.23 means your NOI covers mortgage payments with 23% to spare. CMHC requires minimum 1.1 for MLI Select financing, and most conventional lenders want 1.2 or higher. You can verify these numbers using the CMHC MLI Max Loan Calculator for 5+ unit buildings.
Gross Rent Multiplier (GRM) Purchase Price / Annual Gross Rent $700,000 / $88,200 = 7.9
GRM is a quick-and-dirty screening tool. Lower is generally better (you are paying fewer years of rent for the property). Typical ranges are 8-15 depending on market, with lower numbers indicating better income relative to price.
Price Per Unit Purchase Price / Number of Units $700,000 / 6 = $116,667
Compare this to other buildings in the area to see if the price per unit is reasonable.
Price Per Square Foot Purchase Price / Total Square Footage
Another comparison metric useful for evaluating whether the price is in line with the local market.
Section 9: Sensitivity Analysis
This is what separates a good spreadsheet from a great one. Sensitivity analysis answers the question: what happens when things do not go as planned?
Build a grid that shows your cash flow and key metrics under different scenarios:
Rent Sensitivity
| Scenario | Monthly Rent Change | Annual Cash Flow | CoC Return |
|---|---|---|---|
| Base case | $0 | $8,746 | 5.5% |
| Rents drop 5% | -$368/month | $4,330 | 2.7% |
| Rents drop 10% | -$735/month | -$86 | -0.1% |
| Rents increase 5% | +$368/month | $13,162 | 8.3% |
| Rents increase 10% | +$735/month | $17,578 | 11.1% |
Interest Rate Sensitivity
| Rate Change | Annual Debt Service | Annual Cash Flow | DSCR |
|---|---|---|---|
| Current rate | $38,000 | $8,746 | 1.23 |
| +0.5% | $39,800 | $6,946 | 1.17 |
| +1.0% | $41,700 | $5,046 | 1.12 |
| +1.5% | $43,600 | $3,146 | 1.07 |
| +2.0% | $45,600 | $1,146 | 1.03 |
Vacancy Sensitivity
| Vacancy Rate | Lost Income | Annual Cash Flow | DSCR |
|---|---|---|---|
| 3% | $2,646 | $10,510 | 1.28 |
| 5% (base) | $4,410 | $8,746 | 1.23 |
| 8% | $7,056 | $6,100 | 1.16 |
| 10% | $8,820 | $4,336 | 1.11 |
| 15% | $13,230 | $256 | 1.01 |
These tables tell you where the deal breaks. In our example, a 10% rent drop wipes out cash flow entirely. A 2% rate increase at renewal drops the DSCR below the CMHC minimum of 1.1. Understanding these breaking points before you buy is invaluable.
How to Use the Spreadsheet in Practice
Step 1: Quick screen. When a listing catches your eye, spend 10 minutes filling in rough numbers. Use the asking price, listed rents, and your standard expense percentages. If the quick numbers do not work, move on. Most deals fail at this stage, and that is fine—it saves you hours of deeper analysis.
Step 2: Detailed analysis. For properties that pass the quick screen, request the seller’s financial statements, tax bills, and utility records. Replace your estimates with actual numbers and recalculate. The numbers almost always shift—usually in the less favourable direction.
Step 3: Offer preparation. Use your spreadsheet to determine the maximum price you can pay while meeting your return targets. Work backwards from your required cash-on-cash return or DSCR to find your ceiling price. This gives you a number rooted in financial reality, not emotion.
Step 4: Due diligence verification. After your offer is accepted, verify every number during due diligence. Review actual leases, check tenant payment histories, get your own insurance quotes, and inspect the building for deferred maintenance. Update the spreadsheet with verified data and confirm the deal still works.
Step 5: Post-purchase tracking. Your spreadsheet becomes a living document. Update it quarterly with actual income and expenses. Compare actual performance to your projections. This feedback loop makes your future analyses more accurate.
For comprehensive resources on evaluating deals and structuring your investments, check out our investor resources library.
Common Spreadsheet Mistakes
Using the seller’s numbers without verification. Sellers have every incentive to present their property in the best possible light. Verify everything independently.
Omitting capital expenditure reserves. Your spreadsheet might show positive cash flow, but if you are not reserving for major repairs, one boiler replacement could wipe out three years of profits.
Assuming 100% occupancy. Even the best properties experience vacancy. Always include a vacancy factor.
Ignoring property management. If your deal only works because you plan to self-manage for free, it is a fragile deal. Include management costs to build a sustainable analysis.
Not stress testing. The base case is the optimistic scenario. You need to know what happens when rents drop, rates rise, or a major expense hits. If the deal only works under perfect conditions, it is not a deal—it is a gamble.
Mixing up NOI and cash flow. NOI does not include mortgage payments. Cash flow does. These are different numbers that answer different questions. Keep them separate in your spreadsheet.
Frequently Asked Questions
What spreadsheet software should I use?
How long should it take to analyze a property?
Should I include tax benefits in my spreadsheet?
What if I cannot get the seller's actual financials?
How do I account for renovations in the spreadsheet?
Build Your Spreadsheet, Build Your Confidence
A property analysis spreadsheet removes emotion from your investment decisions. It forces you to face the numbers—good or bad—and make choices based on financial reality.
The investors who consistently build wealth in real estate are the ones who analyze deals rigorously and only buy when the numbers work. Your spreadsheet is the tool that makes that possible.
Build it. Use it on every deal. Refine it as you learn. And when you have a deal that passes your analysis and you need financing structured to maximize your returns, bring your spreadsheet to a strategy call. We will review your numbers, discuss your multifamily financing options or residential mortgage strategies, and help you move from analysis to action.
Disclaimer: LendCity Mortgages is a licensed mortgage brokerage. Content on this page is for educational purposes only and does not constitute legal, tax, investment, securities, or financial-planning advice. Rates, premiums, program terms, and regulations referenced are as of the page's last updated date and are subject to change. Any investment returns, rental yields, tax savings, or case-study figures shown are illustrative only — they are not guaranteed, not typical, and individual results will vary. Consult a licensed lawyer, Chartered Professional Accountant, or registered dealer before acting on any information above. Editorial standards.
Written by
LendCity
Published
July 11, 2026
Reading time
12 min read
Amortization Period
The total number of years required to fully repay a mortgage through regular principal and interest payments. In Canada, standard amortization periods for residential properties are 25 years, while multifamily properties through MLI Select can extend up to 50 years. A longer amortization reduces monthly payments but increases total interest paid.
Amortization
The period over which a mortgage is scheduled to be fully paid off through regular payments of principal and [interest](/glossary/#interest-rate). In Canada, common amortization periods are 25 or 30 years, though the mortgage term (when you renegotiate) is typically 1-5 years. A longer amortization lowers monthly payments, improving [cash flow](/glossary/#cash-flow) but increasing total interest paid.
Appreciation
The increase in a property's value over time, which builds [equity](/glossary/#equity) and wealth for the owner through market growth or [forced improvements](/glossary/#forced-appreciation).
Capital Expenditures
Major one-time expenses for property improvements that extend the useful life of the asset, such as roof replacement, foundation repairs, or new HVAC systems. CapEx differs from regular maintenance and is typically budgeted separately in investment property analysis.
Cap Rate
Capitalization Rate - the ratio of a property's [net operating income (NOI)](/glossary/#noi) to its current market value or purchase price. A 6% cap rate means the property generates $60,000 NOI annually on a $1,000,000 value. Used to compare investment properties regardless of financing. See also [DSCR](/glossary/#dscr) and [Cash-on-Cash Return](/glossary/#cash-on-cash-return).
Cash Flow Optimization
Cash flow optimization is the strategic process of maximizing the net income generated from a rental property by increasing rental revenue and minimizing operating expenses, mortgage costs, and vacancies. For Canadian real estate investors, this often involves tactics such as selecting the right financing structure, leveraging rental income from multiple units, and managing expenses like property taxes and maintenance to ensure the property generates consistent positive monthly returns.
Cash Flow
The money left over after collecting rent and paying all expenses including mortgage, taxes, insurance, maintenance, and property management. Positive cash flow is the primary goal of buy-and-hold investors. See also [NOI](/glossary/#noi), [Cash-on-Cash Return](/glossary/#cash-on-cash-return), and [Vacancy Rate](/glossary/#vacancy-rate).
Cash-on-Cash Return
A metric that measures the annual pre-tax [cash flow](/glossary/#cash-flow) relative to the total cash invested in a property. Calculated as annual cash flow divided by total cash invested (including [down payment](/glossary/#down-payment) and [closing costs](/glossary/#closing-costs)), expressed as a percentage. A 10% cash-on-cash return means you earn $10,000 annually on a $100,000 investment. See also [Cap Rate](/glossary/#cap-rate).
Closing Costs
Fees paid when completing a real estate transaction, including legal fees, land transfer tax, title insurance, appraisals, and adjustments. Closing costs affect your total cash invested and therefore your [cash-on-cash return](/glossary/#cash-on-cash-return).
CMHC MLI Select
A CMHC program offering reduced mortgage insurance premiums and extended amortization (up to 50 years) for multifamily properties with 5+ units that meet energy efficiency or accessibility standards. Popular among investors scaling into larger apartment buildings.
Hover over terms to see definitions. View the full glossary for all terms.