Multifamily Underwriting Calculator
Analyze a multifamily acquisition using the core operating and financing metrics used by real estate investors and lenders. Enter unit count, rents, vacancy, other income, operating expenses, purchase price, and financing terms to estimate NOI, cap rate, DSCR, debt yield, cash-on-cash return, cash flow, and break-even occupancy. The calculator also compares 20%, 25%, 30%, and 35% down-payment scenarios so you can see how leverage changes cash required, debt service, coverage, and investor return.
- Effective Gross Income
- 1,051,800 USD/year
- Cap Rate
- 8.024%
- Selected Financing — DSCR
- 1.448 x
- Selected Financing — Debt Yield
- 10.699%
- Selected Financing — Cash-on-Cash Return
- 9.195%
- Operating Expense Ratio
- 42.784%
- Selected Financing — Annual Cash Flow
- 186,190.89 USD/year
- Selected Financing — Monthly Cash Flow
- 15,515.907 USD/month
- Break-Even Occupancy
- 77.166%
- Selected Financing — Annual Debt Service
- 415,609.11 USD/year
- Selected Financing — Loan Amount
- $5,625,000.00
- Selected Financing — Initial Cash Required
- $2,025,000.00
- Price per Unit
- 125,000
- NOI per Unit
- 10,030
- Gross Rent Multiplier
- 7.184
- 20% Down — Cash Required
- $1,650,000.00
- 20% Down — DSCR
- 1.357 x
- 20% Down — Debt Yield
- 10.03%
- 20% Down — Annual Cash Flow
- 158,483.616 USD/year
- 20% Down — Cash-on-Cash
- 9.605%
- 25% Down — Cash Required
- $2,025,000.00
- 25% Down — DSCR
- 1.448 x
- 25% Down — Debt Yield
- 10.699%
- 25% Down — Annual Cash Flow
- 186,190.89 USD/year
- 25% Down — Cash-on-Cash
- 9.195%
- 30% Down — Cash Required
- $2,400,000.00
- 30% Down — DSCR
- 1.551 x
- 30% Down — Debt Yield
- 11.463%
- 30% Down — Annual Cash Flow
- 213,898.164 USD/year
- 30% Down — Cash-on-Cash
- 8.912%
- 35% Down — Cash Required
- $2,775,000.00
- 35% Down — DSCR
- 1.671 x
- 35% Down — Debt Yield
- 12.345%
- 35% Down — Annual Cash Flow
- 241,605.438 USD/year
- 35% Down — Cash-on-Cash
- 8.707%
Use this calculator on your website
Add this free Multifamily Underwriting Calculator to your blog, article, or business website. Copy the embed code and publish it in minutes.
Works with WordPress, Webflow, Squarespace, Wix, Framer, Shopify, and any website that supports custom HTML or iframes.
The main underwriting results describe both property performance and financing performance. NOI measures the property's operating income before financing. Cap rate relates NOI to purchase price. DSCR measures the property's ability to cover debt service, while debt yield compares NOI with the loan amount. Cash-on-cash return measures annual pre-tax cash flow relative to initial cash invested. Break-even occupancy estimates the minimum rental-income occupancy needed to cover operating expenses and debt service. The 20%, 25%, 30%, and 35% down-payment scenarios help show the tradeoff between leverage, debt coverage, cash flow, and equity required.
Need a calculator like this?
Calciro can build a custom calculator around your formulas, pricing rules, or lead-generation process — including pricing calculators, quote builders, ROI tools, and internal business calculators.
How to Use This Calculator
Enter the purchase price and unit count, then provide average monthly rent, vacancy and credit loss, annual other income, and annual operating expenses. Add your preferred down payment, loan interest rate, amortization period, and acquisition costs. The calculator first analyzes your selected financing structure, then automatically compares the same property using 20%, 25%, 30%, and 35% down-payment scenarios.
Formula & Methodology
Gross potential rent equals units multiplied by average monthly rent and 12 months. Vacancy and credit loss are deducted, and other property income is added to calculate effective gross income. Operating expenses are deducted from effective gross income to calculate net operating income (NOI). Cap rate equals NOI divided by purchase price. Debt service is calculated using a standard amortizing-loan payment formula. DSCR equals NOI divided by annual debt service. Debt yield equals NOI divided by the original loan amount. Annual pre-tax cash flow equals NOI minus annual debt service. Cash-on-cash return equals annual pre-tax cash flow divided by initial cash invested. Break-even occupancy estimates the percentage of gross potential rental income needed to cover operating expenses and debt service after accounting for other income. Financing scenarios repeat these calculations using 20%, 25%, 30%, and 35% down payments while keeping the property's operating assumptions unchanged.
Example: Underwriting a 60-Unit Apartment Property
Consider a 60-unit apartment property priced at $7.5 million with average rent of $1,450 per unit, 5% economic vacancy, $60,000 of annual other income, and $450,000 of annual operating expenses. The calculator first estimates effective gross income and NOI. It then applies the selected loan assumptions to determine debt service, DSCR, debt yield, cash flow, and cash-on-cash return. The scenario comparison shows how increasing the down payment from 20% to 35% reduces leverage and debt service while increasing cash required. This allows an investor to compare stronger debt coverage against the effect of committing more equity.
This calculator provides a simplified property-level underwriting model. It does not replace a complete rent roll, trailing-12-month operating statement, lender underwriting model, appraisal, property condition assessment, tax analysis, or investment memorandum. It does not separately model concessions, bad debt, loss-to-lease, unit-by-unit rents, utility reimbursements, payroll categories, replacement reserves, capital expenditures, renovation schedules, interest-only periods, adjustable-rate debt, lender reserves, refinancing, supplemental financing, preferred equity, depreciation, income taxes, sale proceeds, investor waterfalls, or changes in rents and expenses over time. Actual lender definitions of NOI, DSCR, debt yield, qualifying expenses, and reserves may differ.
For educational and preliminary real estate analysis only. Results are estimates based on the assumptions entered and do not constitute investment, lending, tax, legal, accounting, appraisal, or real estate advice. Verify property income, expenses, rent rolls, occupancy, financing terms, taxes, insurance, reserves, and acquisition costs independently before making an investment or financing decision.
Related Calculators
- Cap Rate CalculatorCalculate capitalization rate, net operating income and value at a target cap rate using property income and operating expenses.
- Cash Flow CalculatorEstimate monthly and annual rental-property cash flow after vacancy, operating expenses, reserves and debt payments.
- DSCR CalculatorCalculate debt service coverage ratio from gross operating income, vacancy, operating expenses and annual debt service.
Related Guides
- Cap Rate Calculator: What Capitalization Rate Means for InvestorsCalculate cap rate for any rental property. Understand what cap rate means, how it compares to other return metrics, what cap rates look like by market and property type, and its limitations.
- Rental Property Cash Flow: How to Calculate Monthly Net Cash FlowCalculate monthly and annual cash flow for any rental property. Covers gross rent, all expense categories, debt service, and what positive cash flow benchmarks look like by property type.
- DSCR Calculator: Debt Service Coverage Ratio for Real Estate LoansCalculate the Debt Service Coverage Ratio for any investment property. Learn what DSCR lenders require, how it's calculated from NOI, and why it determines whether you qualify for a rental property loan.
- Rental Property ROI: How to Calculate Total Return on InvestmentCalculate rental property ROI including cash flow, equity buildup, and appreciation. Understand cash-on-cash return, total ROI, and the leveraged vs. unleveraged return difference.
Frequently Asked Questions
- What is multifamily underwriting?
- Multifamily underwriting is the process of analyzing an apartment property's income, expenses, financing, risks, and expected returns to determine whether an acquisition makes financial sense.
- How is NOI calculated for a multifamily property?
- A simplified NOI calculation starts with gross potential rent, subtracts vacancy and credit loss, adds other property income, and then subtracts operating expenses. Mortgage payments and other financing costs are generally not included in NOI.
- What is DSCR in multifamily underwriting?
- Debt Service Coverage Ratio compares NOI with annual debt service. A higher DSCR generally indicates more property income available to cover required loan payments.
- What is a good DSCR for a multifamily property?
- There is no universal minimum. Required DSCR varies by lender, loan program, property type, market, borrower, and risk profile. Use the calculator to compare financing structures rather than assuming one threshold applies to every deal.
- How is multifamily cap rate calculated?
- Cap rate equals annual net operating income divided by the property's purchase price or value, multiplied by 100.
- What is debt yield?
- Debt yield equals NOI divided by the original loan amount. Unlike DSCR, it does not depend on the loan's interest rate or amortization period.
- What is cash-on-cash return?
- Cash-on-cash return compares annual pre-tax cash flow after debt service with the amount of cash initially invested in the acquisition.
- What is the operating expense ratio?
- The operating expense ratio shows operating expenses as a percentage of effective gross income. It indicates how much of the collected property income is consumed by operating expenses.
- What is break-even occupancy?
- Break-even occupancy estimates the percentage of gross potential rental income needed to cover operating expenses and annual debt service after considering other property income.
- Why compare 20%, 25%, 30%, and 35% down payments?
- Changing the down payment changes loan size, debt service, DSCR, debt yield, cash flow, cash-on-cash return, and initial cash required. Comparing several leverage levels helps show the financing tradeoff instead of evaluating only one capital structure.
- Does a larger down payment always produce a better investment?
- No. A larger down payment usually reduces debt service and improves DSCR and cash flow, but it also requires more investor capital and may reduce cash-on-cash efficiency. The best structure depends on risk, financing terms, return targets, and available capital.
- Does mortgage payment count as an operating expense?
- No. Debt service is normally analyzed separately from operating expenses so NOI measures property performance independently of financing.
Published 8/8/2026