The Handy Calculators logoTheHandyCalculators.com

    Multifamily Income Proforma Calculator

    Underwrite an apartment building or rental complex: NOI, cap-rate value, value per unit, DSCR, and cash-on-cash return.

    Autosave on

    How to use this calculator

    1. Enter the rent roll basics. Type the unit count and the in-place (or stabilized) average monthly rent. We'll multiply units × rent × 12 to roll up gross potential income automatically.
    2. Set vacancy and other income. Enter a stabilized vacancy & credit-loss percentage and any annual ancillary income (laundry, parking, pet fees, RUBS reimbursements).
    3. Tune operating expenses. Adjust each OpEx line to reflect the actual operating statement or your underwriting. Hover any field's tooltip for industry rules of thumb.
    4. Pick a market cap rate. Use the prevailing cap rate for similar Class A/B/C apartments in the submarket. Value is computed instantly as NOI ÷ cap rate.
    5. (Optional) Add financing. Open the Financing & returns panel to model LTV, interest rate, and amortization. You'll get DSCR, debt service, and cash-on-cash return.
    6. Read the results. Review NOI, estimated value, value per unit (per door), DSCR, and cash flow. Use Print/PDF or the export button to share.

    Tips

    • Rule of thumb for replacement reserves: $250–$350 per unit per year.
    • Lender vacancy floors are typically 5–7% even when in-place vacancy is lower.
    • Agency lenders (Fannie/Freddie) usually require 1.25× DSCR minimum on stabilized multifamily.

    Income

    $
    %
    $
    Annual
    Gross potential rent: $532,800

    Operating expenses (annual)

    $
    $
    $
    %
    % of EGI
    $
    $
    $

    Valuation

    %
    Value = NOI ÷ cap rate
    %
    Loan = value × LTV
    $
    Optional — overrides LTV when > 0
    %
    yrs

    AI explanation

    Free: 3 explanations per day. Or use your own AI key — your key stays in your browser.

    Export this proforma
    Save your inputs and results as PDF, Excel, CSV, or JSON.
    Net operating income (NOI)
    $384,652
    Expense ratio 25.8%
    Estimated value
    $6,410,867
    @ 6% cap
    Effective gross income
    $518,160
    Vacancy loss $26,640
    Value per unit
    $267,119
    24 units
    Annual debt service
    $324,330
    $27,027 / mo
    DSCR
    1.19
    Lenders typically want ≥ 1.25
    Cash flow (after debt)
    $60,322
    Cash-on-cash return
    2.69%
    On $2,243,803 equity

    DSCR analysis

    Average

    Workable for bridge or value-add lenders, but below the 1.25x agency floor for stabilized assets.

    1.19x
    $384,652 NOI ÷ $324,330 debt
    What's driving this DSCR
    • Interest rate+11.1%
      Drop rate 100 bps to 5.75% → 1.32x DSCR.
    • Debt service+11.1%
      Cut loan 10% (~$416,706 less debt) → 1.32x DSCR.
    • NOI+10.0%
      Each 10% NOI lift → +$38,465/yr → 1.30x DSCR.
    • Amortization+4.4%
      Extend to 35 years → 1.24x DSCR.
    Impact = % DSCR change if that input alone moved to a friendlier level (NOI +10%, rate −100 bps, amort +5 yrs, loan −10%).

    Proforma summary

    Gross potential income$532,800
    Less: vacancy & credit loss($26,640)
    Plus: other income$12,000
    Effective gross income$518,160
    Less: management fee($25,908)
    Less: other operating expenses($107,600)
    Net operating income$384,652
    ÷ Cap rate6%
    Estimated property value$6,410,867

    Built for brokers, appraisers, and investors. Enter unit count and average rent and we'll roll up gross potential income, vacancy, OpEx, NOI, and capitalize it at your market cap rate — plus value per door and levered returns.

    How multifamily valuation works

    Apartment buildings are valued by income, not by square foot. The market sets a cap rate for the asset class and submarket, you divide stabilized NOI by that rate, and the result is what an institutional buyer will pay. A 24-unit Class B property generating $260,000 of NOI in a 6.0% cap-rate market is worth approximately $4.33 million ($260k ÷ 0.060), regardless of whether the building is 22,000 or 26,000 square feet.

    Per-unit (or per-door) pricing is the second yardstick. The same $4.33M building works out to about $180,000/door. Brokers, lenders, and appraisers use per-door pricing for rapid comp checks across a submarket — if recent 1985-vintage Class B sales are trading at $165–$190/door and your underwriting comes in at $230/door, you know something in the inputs is off.

    Replacement cost per door is the third triangulation point. If new construction in the submarket lands at $275/door all-in, a 1980s vintage Class B asset trading at $190/door is at a 31% discount to replacement — a margin of safety that helps justify the value-add thesis even if cap rates drift.

    Worked example: a 24-unit Class B at $1,850 rent

    Start with revenue. 24 units × $1,850/month × 12 = $532,800 of gross potential rent. Apply a 5% vacancy & credit loss assumption and add $12,000 of other income (laundry, parking, pet fees), and effective gross income comes to roughly $518,160.

    Subtract operating expenses: $38k taxes + $12k insurance + $18k utilities + $24k repairs + $9.6k reserves + $6k other + 5% management of EGI (~$25.9k) = about $133,500. NOI ends up around $384,600 — a 26% expense ratio on EGI, in line with stabilized Class B norms.

    Capitalize that NOI at a 6.0% market cap rate: $384,600 ÷ 0.060 = $6.41M of estimated value, or about $267,000/door. Layer in 65% LTV at 6.75% over a 30-year amortization and debt service is roughly $324,000/year, producing a 1.19× DSCR — below the 1.25× Fannie Mae minimum, meaning either the LTV needs to drop to ~60% or rents need to grow before agency debt clears.

    What goes into NOI (and what doesn't)

    NOI = effective gross income (EGI) − all operating expenses. EGI is gross potential rent minus vacancy and credit loss, plus any other income (laundry, parking, pet fees, RUBS reimbursements). Operating expenses include property taxes, insurance, utilities not billed back to tenants, third-party management, routine repairs and maintenance, replacement reserves, and admin/marketing/turnover costs.

    NOI deliberately excludes debt service (covered separately in DSCR and cash-on-cash calculations), depreciation (a non-cash accounting item), capital expenditures above the replacement reserve (which are tracked on a separate capex budget), and income taxes (entity-level, not property-level). Keeping NOI 'clean' this way is what allows cap rates to compare across deals with different financing and ownership structures.

    Replacement reserves are the line most often missed by amateur underwriters. Industry practice is $250–$350 per unit per year for stabilized multifamily; new construction can use $200, while 1970s and earlier vintage often need $400–$500. Skipping reserves inflates NOI and produces a value that no professional buyer will pay.

    Cap rate, DSCR, and cash-on-cash — how they relate

    Cap rate is an unlevered yield: NOI ÷ price. It measures the property's income relative to its value, independent of how the deal is financed. A 6% cap rate means $6 of NOI per $100 of value per year.

    DSCR (debt service coverage ratio) is NOI ÷ annual debt service. Agency lenders (Fannie Mae, Freddie Mac) typically require 1.25× minimum on stabilized multifamily; bridge and value-add lenders may accept lower in-place DSCR if the pro-forma stabilized DSCR clears the threshold. A 1.25× DSCR means the property generates 25% more income than the mortgage requires, providing the cushion lenders need to feel comfortable underwriting the loan.

    Cash-on-cash return is annual pre-tax cash flow ÷ total cash invested (down payment + closing costs + initial capex). It's the actual yield on your equity check. Levered cash-on-cash should exceed the cap rate when interest rates are below cap rates (positive leverage); when interest rates exceed cap rates (negative leverage), adding debt actually reduces your equity return — a regime the multifamily market entered in 2022–2023.

    Class A, B, and C — quick definitions

    Class A: newer construction (typically post-2000), top-of-market rents, full amenities (pool, gym, concierge, in-unit laundry, structured parking). Lowest cap rates (sub-5% in many markets), highest per-door pricing, and lowest yields. Often institutionally owned.

    Class B: workforce housing, typically 1980s–early 2000s vintage, average condition, surface parking, basic or no amenities. The bread-and-butter of private multifamily investing. Cap rates usually 50–150 bps above Class A in the same submarket.

    Class C: older vintage (often pre-1980), basic finishes, may need significant capex. Often the target for value-add strategies (interior renovations, common-area upgrades, fee income additions) that push rents and re-trade at a lower cap rate after stabilization.

    Frequently asked questions

    How is value per unit (per door) calculated?

    Estimated property value ÷ number of units. It's the most common quick metric brokers use to compare multifamily deals in a submarket.

    What vacancy rate should I use?

    Stabilized urban infill is often 4–6%. Class B/C value-add or tertiary markets typically use 7–10%. Lender underwriting usually floors vacancy at 5–7% even when in-place is lower.

    What's a typical management fee for multifamily?

    3–5% of EGI for properties over 50 units, 5–8% for smaller assets. Self-managed owners should still book a market rate fee for accurate underwriting.

    What DSCR do agency lenders want?

    Fannie Mae and Freddie Mac typically require a 1.25x DSCR minimum on stabilized multifamily, with more conservative ratios for higher leverage or value-add deals.

    How do I value a 24-unit apartment building?

    Multiply units × average monthly rent × 12 to get GPI, subtract vacancy and add other income to get EGI, subtract OpEx to get NOI, then divide NOI by the market cap rate. A 24-unit building at $1,850 rent and 35% expense ratio at a 6% cap is worth roughly $4.3M (~$180k/door).

    What's the difference between gross potential rent and effective gross income?

    Gross potential rent (GPI) assumes 100% occupancy at market rent. Effective gross income (EGI) subtracts vacancy and credit loss and adds other income (laundry, parking, fees). NOI is calculated from EGI, not GPI.

    What replacement reserves should I underwrite?

    $250–$350 per unit per year for stabilized multifamily. New construction can use $200. 1970s and earlier vintage often need $400–$500. Skipping reserves inflates NOI and produces a value no professional buyer will accept.

    How does negative leverage work in multifamily?

    When your interest rate is higher than the cap rate, adding debt reduces your cash-on-cash return below the unlevered cap rate. Example: a 5.5% cap acquired with a 7% loan produces lower CoC than buying all-cash. Most of the 2022–2024 acquisition market has been in negative-leverage territory.

    By Larius software engineer, NC real estate broker & CRE/business appraiserLast reviewed: June 2026Reviewed by the Handy Calculators editorial teamHow we build calculators
    Before you act on this result

    This calculator is general education, not advice. Before you sign, file, offer, or fund anything, walk through this quick checklist:

    • Confirm every input (price, rate, taxes, insurance, HOA, fees) against a real document — a Loan Estimate, purchase contract, tax bill, or HOA statement — not a guess.
    • Verify the local rules where the property sits: closing customs, transfer taxes, disclosure requirements, and title practices differ by state and county.
    • Talk to a licensed professional in that jurisdiction — a local real estate broker, closing attorney or title company, CPA, state-licensed appraiser, or mortgage loan officer.
    • Remember Larius is licensed as a real estate broker in North Carolina only. Anything outside NC needs a locally licensed pro.
    • Get material assumptions in writing (rate lock, insurance quote, tax cap, rent comps) before you commit money or sign.

    Read our Editorial FAQ for the full education-vs-advice breakdown, or let us know if a number here looks wrong.

    More in Rental Underwriting

    Underwrite a rental in minutes: cap rate, cash-on-cash, gross & net rental yield, and full multifamily proformas.

    See hub →
    Browse all Real Estate →