How to Screen an Apartment Investment Deal: Cash Flow, HOA Costs, Financing, and Rental Demand Worksheet
real estate investingapartment cash flowcondo investmentrental yieldproperty underwriting

How to Screen an Apartment Investment Deal: Cash Flow, HOA Costs, Financing, and Rental Demand Worksheet

OOnsale Apartments Editorial Team
2026-11-20
6 min read

Use this apartment investment worksheet to estimate rent, HOA costs, financing, cash flow, cap rate, and rental demand before buying.

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.

CategoryInputCalculation or question
PurchasePurchase priceIs the price reduced, contingent on concessions, or subject to a competing offer?
IncomeMonthly achievable rentWhat do comparable units support after adjusting for condition and amenities?
IncomeVacancy and collection allowanceUse a clearly stated percentage and test a higher case.
AssociationHOA or condo duesWhat is included, and are increases or special assessments documented?
PropertyTaxes and insuranceUse property-specific estimates where available.
OperationsMaintenance and reservesInclude appliances, flooring, plumbing, HVAC, and turnover.
ManagementLeasing and management feesCheck whether fees apply to collected rent, new leases, or renewals.
FinancingDown payment, rate, term, and loan costsReplace assumptions with a lender quote before making an offer.
ComplianceRental rules and permitsConfirm 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:

  1. Verify achievable rent with several comparable units and document the differences.
  2. Obtain written HOA, tax, insurance, and financing figures.
  3. Confirm that the association and local rules permit your intended rental strategy.
  4. Run base, conservative, and upside scenarios.
  5. Set a maximum purchase price based on your required return and cash-flow tolerance.
  6. 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.

Related Topics

#real estate investing#apartment cash flow#condo investment#rental yield#property underwriting
O

Onsale Apartments Editorial Team

Real Estate Editors

Senior editor and content strategist. Writing about technology, design, and the future of digital media. Follow along for deep dives into the industry's moving parts.