Business Type: Real Estate / Property Management
The Goal: Use SUM logic for Net Operating Income (NOI) and Percentage logic for ROI.
Category | Monthly | Annual | Formula / Logic | ||
|---|---|---|---|---|---|
A | B | C | D | ||
1 | Gross Rental Income | $4,500.00 | $54,000.00 | Total rent from all units | |
2 | Vacancy Factor (5%) | $225.00 | $2,700.00 | Gross * 0.05 (Safety buffer) | |
3 | Property Taxes | $400.00 | $4,800.00 | Local government tax | |
4 | Insurance | $150.00 | $1,800.00 | Landlord insurance policy | |
5 | Maintenance/Repairs | $250.00 | $3,000.00 | 5-10% of rent for repairs | |
6 | Management Fees | $360.00 | $4,320.00 | 8% for a property manager | |
7 | NET OPERATING INCOME (NOI) | $3,115.00 | $37,380.00 | Income - All Expenses |
If the property is being sold for $500,000, we find the Cap Rate to see if it's a "good deal" compared to the neighborhood.
The property is being sold for
Capitalization Rate (Market Value) %
Insight: In most markets, a 7-8% Cap Rate is a very solid investment.
If you put $100,000 down (20%) and your mortgage is $2,200/month, how much cash is actually hitting your pocket?
Down Payment
Your Mortgage
Annual Cash Flow
Cash-on-Cash Return (%)
We use IF logic to help an investor decide if they should buy or pass.
The Formula: =IF(Cash on Cash > 0.12, "π HOME RUN", IF(Cash on Cash > 0.08, "β STRONG BUY", "β οΈ PASS / NEGOTIATE"))
The "Pass/Fail" Filter
Property | Cap Rate (%) | Cash-on-Cash (%) | Status | ||
|---|---|---|---|---|---|
A | B | C | D | ||
1 | 123 Main St | 7.48 | 10.98 | β
STRONG BUY | |
2 | 456 Oak Ave | 5.2 | 4.5 | β οΈ PASS / NEGOTIATE | |
3 | 789 Pine Ln | 9.1 | 14.2 | π HOME RUN |
Form Template Insights
Important Note:
This analysis provides strategic insights to help you get the most from your form's submission data for powerful follow-up actions and better outcomes.
AI-Generated Content: This template and its accompanying guidance are AI-generated to provide a practical starting point for your form-building needs. Please review and customise the content to ensure it is accurate, appropriate and suitable for your intended use.
This guide is provided for general informational and planning purposes only. It does not constitute professional, legal, financial, medical, employment, privacy, regulatory, or advice of any other kind, nor does it certify that this template is suitable or compliant for any particular jurisdiction or purpose.
Laws, regulations, industry practices and business requirements vary. You are responsible for reviewing and customising the template to suit your intended use and obtaining advice from appropriately qualified professionals where necessary.
Please delete this section before publishing your form. See our Terms of Service for further information.
Purpose: This tool is used to evaluate the financial viability of a rental property. It strips away the emotional appeal of a building and focuses on Cash Flow, Market Yield, and Equity Growth. It allows investors to compare different properties "apples-to-apples" regardless of price or location.
Real estate is a capital-intensive business. A mistake in estimating expenses or overestimating rent can lead to a "negative carry" (where you pay money every month to own the property). This form identifies those risks before you sign a contract.
Your form owners need to understand that the "Net Operating Income" is the heartbeat of every other calculation.
This form provides three "Strategic Shields" for the investor:
To configure an element, select it on the form.