A discounted apartment or condo is not automatically a good rental investment. This worksheet-style guide shows how to screen a property using achievable rent, vacancy, HOA costs, financing, taxes, insurance, maintenance, and cash flow so you can compare apartments on sale using consistent assumptions.
Overview
Apartment investment analysis begins with a simple question: after all ordinary costs are paid, does the property produce an acceptable result for the amount of cash invested? The advertised purchase price is only one input. A property with a low price can still be expensive to own if it has high association fees, rising insurance costs, weak rental demand, or restrictions on leasing.
Use this process as an initial screen, not as a substitute for an inspection, lender review, title search, tax advice, or legal advice. The goal is to identify which listings deserve deeper due diligence and which assumptions need to be verified before you make an offer.
For each apartment or condo, calculate four core outputs:
- Effective rental income: expected rent after allowing for vacancy and collection loss.
- Operating expenses: recurring costs such as HOA dues, taxes, insurance, maintenance, management, utilities, and reserves.
- Net operating income (NOI): income left before mortgage payments and income taxes.
- Cash flow and return: the result after debt service, compared with the cash required to buy the property.
Keep the assumptions visible. A worksheet that can be edited is more useful than a single optimistic projection.
How to estimate an apartment investment deal
1. Establish achievable rent
Start with rent supported by comparable apartments with similar location, size, condition, parking, amenities, furnishing, and lease terms. Do not use the highest nearby listing without checking whether it has upgrades or included services your property will not offer. Separate advertised asking rent from rent that appears achievable after a normal marketing period.
If the unit may be furnished, rented to students, or offered for a shorter term, model that strategy separately. Higher potential rent can come with more turnover, furnishing costs, utilities, or management work. For a basic annual estimate:
Scheduled gross rent = monthly rent × 12
Effective gross income = scheduled gross rent − vacancy and collection allowance
For example, if projected rent is $2,200 per month and you use a hypothetical 5% vacancy allowance, scheduled rent is $26,400 and effective income is $25,080. The 5% figure is an assumption to test, not a universal rule.
2. List every recurring operating cost
Include the costs that are easy to overlook in apartment deals. These may include:
- Association or HOA dues and any building-specific fees
- Property taxes and local assessments
- Landlord insurance, including any required supplemental coverage
- Routine maintenance and replacement reserves
- Property management or leasing fees
- Owner-paid water, heating, internet, parking, or other utilities
- Licensing, accounting, advertising, and legal costs where applicable
- Expected turnover, cleaning, repainting, and unplanned repairs
Ask whether HOA dues cover items such as exterior insurance, water, trash, or common-area maintenance. Avoid double-counting included expenses, but do not assume that the association covers repairs inside the unit. Review the association budget, reserve information, recent meeting materials, insurance details, pending litigation disclosures, and special-assessment history where available.
3. Calculate NOI before financing
NOI is useful because it separates the property’s operating performance from your personal loan terms.
NOI = effective gross income − operating expenses
Do not subtract mortgage principal or interest when calculating NOI. Those are financing costs and should be analyzed separately.
4. Add financing and measure cash flow
Request a realistic loan estimate rather than relying on a generic mortgage calculator. Record the purchase price, down payment, loan amount, interest rate, term, monthly principal and interest, lender fees, mortgage insurance if applicable, and any rate-adjustment risk.
Annual cash flow before income taxes = NOI − annual debt service
Then estimate the cash required to acquire the property:
Total cash invested = down payment + closing costs + immediate repairs + furnishing or setup costs + initial reserves
Two useful comparison measures are:
- Cap rate = NOI ÷ purchase price
- Cash-on-cash return = annual cash flow before income taxes ÷ total cash invested
These measures should not be treated as promises. They are tools for comparing assumptions across properties.
Inputs and assumptions worksheet
Copy the following fields into a spreadsheet for every listing. Use one column for the initial estimate and another for verified or revised figures.
| Category | Input | Calculation or question |
|---|---|---|
| Purchase | Purchase price | Is the price reduced, contingent on concessions, or subject to a competing offer? |
| Income | Monthly achievable rent | What do comparable units support after adjusting for condition and amenities? |
| Income | Vacancy and collection allowance | Use a clearly stated percentage and test a higher case. |
| Association | HOA or condo dues | What is included, and are increases or special assessments documented? |
| Property | Taxes and insurance | Use property-specific estimates where available. |
| Operations | Maintenance and reserves | Include appliances, flooring, plumbing, HVAC, and turnover. |
| Management | Leasing and management fees | Check whether fees apply to collected rent, new leases, or renewals. |
| Financing | Down payment, rate, term, and loan costs | Replace assumptions with a lender quote before making an offer. |
| Compliance | Rental rules and permits | Confirm lease limits, minimum terms, owner-occupancy rules, and required approvals. |
For a broader ownership-cost review, see How to Evaluate Condos and Apartments on Sale. If the listing includes a rent concession or special, compare the effective economics rather than treating the promotion as permanent income.
Worked example: a hypothetical condo rental
Assume a condo is offered at $240,000. This example uses fictional assumptions to demonstrate the method; it is not a current market forecast.
- Monthly rent: $2,200
- Vacancy and collection allowance: 5%
- HOA dues: $450 per month
- Property taxes: $3,000 per year
- Insurance: $900 per year
- Maintenance reserve: 5% of scheduled rent, or $1,320
- Management: 8% of effective gross income, or about $2,006
- Owner-paid utilities and miscellaneous costs: $600 per year
Scheduled rent is $26,400. After the vacancy allowance, effective gross income is $25,080. The estimated operating expenses total approximately $13,226, producing an NOI of about $11,854. The implied cap rate is approximately 4.9% ($11,854 ÷ $240,000).
Now assume 20% down and a hypothetical 7% fixed-rate, 30-year loan. The loan amount would be $192,000, with annual principal and interest of roughly $15,300. Estimated cash flow before income taxes would therefore be about negative $3,450 per year before closing costs and initial reserves.
That result does not automatically mean the property is unacceptable. An investor might change the financing, negotiate the price, identify unsupported expenses, or decide that long-term appreciation or personal objectives matter. It does mean the property should not be described as cash-flow positive under these assumptions. Recalculate with a lower rent, higher vacancy, a special assessment, or a major repair to see how sensitive the result is.
Compare at least three cases: a base case, a conservative case with lower rent and higher expenses, and an upside case supported by specific evidence. Give the conservative case the greatest weight when deciding how much cash you can safely commit.
When to recalculate
Revisit the worksheet whenever a material input changes. That includes a new purchase price, inspection findings, a lender’s rate quote, revised property taxes, an insurance renewal, a change in HOA dues, a proposed special assessment, or new information about rental restrictions.
Refresh rent and vacancy assumptions periodically, especially when comparing listings in a changing market. Recalculate before submitting an offer, after receiving the association documents, and after the inspection. A discounted listing may become less attractive if the discount is offset by repairs, fees, or a below-market rental cap.
Before moving forward, complete these actions:
- Verify achievable rent with several comparable units and document the differences.
- Obtain written HOA, tax, insurance, and financing figures.
- Confirm that the association and local rules permit your intended rental strategy.
- Run base, conservative, and upside scenarios.
- Set a maximum purchase price based on your required return and cash-flow tolerance.
- Keep a reserve for vacancies, repairs, assessments, and financing changes.
Use the finished worksheet alongside a property inspection and document review. For preparation before applying or making an offer, the Apartment Deal Application Checklist can help organize financial and property documents. The strongest apartment investment decisions come from rerunning the numbers when the facts change, not from relying on the advertised discount alone.