Updated
An apartment-investment guide by Jason Taken, Principal, Jaken Finance Group.
Underwriting a 10–30 unit multifamily property means converting unit-level records into a supported operating budget, a fully funded acquisition and a credible repayment plan. Verify what the apartments collect, price the work and management they require, then test how much debt those economics support. Finish by checking what happens when the current loan matures.
At this size, an extra zero on a small-building spreadsheet is insufficient. Unit mix matters. Several turns can overlap. Management and maintenance duties must be assigned and priced. A capital project can affect access, occupancy, insurance and the closing cash requirement together.
This guide follows a hypothetical twenty-unit purchase. Prices, rents, costs, loan terms and thresholds are invented teaching assumptions. They are not local market evidence or quoted financing. Use the acquisition calculator, refinance calculator, editable Excel workbook and three-page diligence guide alongside your actual records.
1. Define the property and the investment plan
Confirm legal apartment count, parcel boundaries, permitted use, unit configurations, parking and access. Resolve differences among the listing, leases, municipal records, inspection and appraisal. A seller’s unit labels do not independently establish authorized use. Ask the appropriate local officials and advisers about discrepancies.
Identify the strategy: hold existing operations, renovate at turnover, complete a broader repositioning or refinance an existing asset. Write the sequence of work, leasing and financing. A stabilized permanent-loan request and a property with substantial vacancy or construction need different reviews.
The five-unit underwriting guide introduces property-income analysis at a smaller scale. For ten through thirty units, retain that discipline while adding unit-level schedules, operational responsibility and a capital timeline. Do not assume greater unit count automatically makes an investment diversified or easier to finance.
2. Assemble a dated operating evidence file
Request the current rent roll, leases and amendments, trailing twelve months of income and expenses, current-year results, collection records, tax information, insurance, utilities and service agreements. Obtain payroll and management records, delinquency, concessions, turnover history, capital invoices and the proposed purchase terms.
Create a source index showing the period, provider and date of each record. Compare the operating statement’s revenue with collections and explain differences. Security deposits, owner contributions, refinance proceeds and sale of equipment should not become recurring rental income.
Reconcile unusual expenses with invoices and duties that continue after closing. A seller calling something an add-back does not make it available for debt payments. Record unresolved items separately and identify who will supply the evidence. Keep tenant names and sensitive financial information out of public templates and initial inquiries.
3. Underwrite the rent roll one apartment at a time
Record unit identifier, floor plan, contractual rent, lease dates, concessions, current status and collection issues. Review which units are vacant, offline for work, occupied without current payment or subject to a future lease start. Those conditions affect cash differently.
The example contains eight apartments at $1,200 monthly, eight at $1,500 and four at $1,800. Scheduled monthly rent is $28,800; annual potential rent is $345,600. The online tool groups apartments by supported rent. The workbook allows individual entries for up to thirty apartments.
Use supported achievable rent for a vacant apartment only within a clearly labeled projection. Keep current contractual income distinct from future renovated income. Higher asking rent at a competing property does not establish comparable condition, concessions, tenant demand or the time needed to lease your units.
4. Translate occupancy into economic income
Physical occupancy measures occupied apartments. Economic performance measures what the property actually collects after vacancy, concessions and bad debt. A building can be physically full while collecting materially less than its rent roll suggests.
The example assumes 7% total loss against scheduled rent: $345,600 × 7% = $24,192. Add $6,000 of already collected other income to obtain $327,408 effective gross income, or EGI. Rental loss is not applied again to that other-income input.
Verify laundry, parking, pet and utility-reimbursement income separately. Reimbursements need matching treatment of the related expenses. Do not reduce utilities by a reimbursement and also count the same amount as additional income. Explain any deposits or one-time fees before treating them as recurring revenue.
5. Reconstruct expenses for the proposed ownership
Build expenses from the property and operating plan. Review post-purchase taxes with local assessment rules and qualified advisers. Obtain a current insurance indication for the actual occupancy, condition, systems and planned work. The seller’s premium is not your insurance quote.
Inspect owner-paid utilities, common areas, landscaping, waste removal, administration, legal and accounting needs. Reconcile recurring repairs with work orders and turnover history. A recently completed project can reduce one future cost without eliminating ordinary maintenance throughout the property.
The example assumes annual taxes of $36,000, insurance $16,000, utilities $12,000, recurring repairs $12,000, payroll $18,000 and other expenses $8,000. These fixed operating costs total $102,000. They are a teaching budget, not recommended per-unit expense ratios. Replace each category with evidence applicable to the asset.
6. Assign management and maintenance responsibilities
Obtain a management proposal describing fees, minimum charges, leasing commissions, renewal charges, inspections, bookkeeping and maintenance coordination. Identify expenses charged separately. A percentage fee can look inexpensive until the excluded tasks are added.
Then map payroll and contracted services to actual duties. Who receives emergency calls, handles vacancies, supervises contractors, cleans common areas and inspects units? Avoid paying for the same role in both management and payroll, but do not erase necessary labor because the seller performed it personally.
The example charges management at 6% of EGI, or $19,644.48, in addition to the separately identified payroll duties. No staffing ratio is implied. Confirm the operating team can execute the proposed renovation and leasing plan within its compensation and workload.
7. Reconcile NOI and net cash flow
Net operating income, or NOI, reflects property operating income before debt service and income taxes. This model deducts a separate replacement reserve below NOI to obtain net cash flow, or NCF, for coverage and distributions. Keep the lender’s accepted definitions visible.
| Twenty-unit annual operating example | Amount |
|---|---|
| Scheduled potential rent | $345,600 |
| Assumed rental loss | ($24,192) |
| Other collected income | $6,000 |
| Effective gross income | $327,408 |
| Fixed operating expenses | ($102,000) |
| Management at 6% of EGI | ($19,644.48) |
| NOI before replacement reserve | $205,763.52 |
| Separate replacement reserve | ($10,000) |
| NCF for the illustrated coverage test | $195,763.52 |
Fannie Mae’s small-loan NCF guidance separately identifies operating expenses and replacement reserves in that program’s calculation. It is a reference for a named execution, not permission to substitute its requirements into every bank or private loan. Reconcile lender adjustments with your own budget.
8. Build a capital-project schedule
Inspect unit interiors, shared systems, roof, drainage, electrical service, plumbing, life-safety items and common areas with the appropriate professionals. Determine which issues require immediate action, which are tenant-turn improvements and which belong in a future replacement schedule.
The example’s $180,000 initial plan includes ten unit renovations at $8,000 each, a $45,000 roof, $25,000 of mechanical work and three $10,000 allowances for site or safety work, project professional costs and other scope. Add a 10% contingency, or $18,000, to this particular budget.
Those costs require bids and a practical sequence. Confirm access, tenant disruption, approvals, deposits and contractor availability. Initial work, recurring repair expense and annual replacement reserves address different cash needs. Allocate costs consistently rather than counting the same project in several categories.
9. Reconcile sources, uses and actual cash availability
| Hypothetical acquisition uses | Amount |
|---|---|
| Purchase price | $2,800,000 |
| Closing and financing costs | $84,000 |
| Initial capital projects | $180,000 |
| Capital contingency | $18,000 |
| Additional operating cash | $80,000 |
| Total uses | $3,162,000 |
| Purchase-only loan | ($1,900,000) |
| Buyer contribution | $1,262,000 |
The closing-cost allowance excludes the project professional costs already in the capital budget. The $80,000 cash allocation is funded once; it is not another recurring annual expense. Confirm how reserves, escrows, credits and deposits affect the settlement statement.
This model assumes the capital plan is cash-funded in the acquisition uses. If financing includes future improvement draws, build a separate disbursement schedule. A total commitment is not necessarily an initial advance, and reimbursement after an inspection may not fund a contractor deposit when it is due.
10. Compare three independent debt constraints
Start with the proposed loan’s actual interest basis, amortization, maturity, fees and covenants. For illustration, a $1,900,000 loan at a fixed 7% with thirty-year monthly amortization requires approximately $151,689 annual principal and interest. The example matures after five years.
Coverage is $195,763.52 NCF divided by the unrounded annual payment, approximately 1.29 times. Taxes and insurance have already reduced operating income, so they are not added to principal and interest again. Confirm whether other debt belongs in the lender’s coverage calculation.
Under assumed limits of 70% purchase LTV, 1.25 minimum NCF coverage and 8.5% minimum NOI debt yield, the loan screens are:
| Constraint | Calculation | Illustrated limit |
|---|---|---|
| Purchase LTV | $2,800,000 × 70% | $1,960,000 |
| Coverage | NCF ÷ assumed coverage ÷ annual payment per dollar | $1,961,649 |
| NOI debt yield | $205,763.52 ÷ 8.5% | $2,420,747 |
The lowest is $1,960,000, before other lender restrictions. Debt yield here means NOI divided by loan principal; it does not use annual debt service. These assumptions are editable investor screens. Actual valuation, lender definitions, reserves, borrower review and program limits can reduce proceeds further.
11. Separate the investment’s different returns
The price-based capitalization rate is approximately 7.35%: NOI divided by the $2,800,000 price. This ignores closing costs and the initial capital plan. Debt yield is approximately 10.83%, using the smaller $1,900,000 loan as its denominator. They answer different questions.
After the annual reserve and debt payment, cash flow is approximately $44,075. Divide the unrounded result by $1,262,000 buyer cash to obtain 3.49% cash-on-cash return before tax. Principal reduction, appreciation, sale costs and income taxes do not belong in that annual cash-distribution measure.
Decide whether the supported return compensates you for the work, concentration and capital at risk. An attractive cap rate or permitted loan amount does not establish your investment hurdle. Calculate returns on the actual cash you must contribute, including funded liquidity and immediate work.
Calculate the 10–30 unit acquisition
Interactive underwriting worksheet
10–30 unit multifamily acquisition calculator
Group 10–30 apartments by underwritten rent, reconstruct operating cash flow, and compare purchase LTV, coverage and debt-yield limits. All capital work is funded in the closing budget.
Illustrative results for the starting assumptions. Change inputs and select Update underwriting.
- Annual cash after reserve and debt
- $44,075
- Net cash flow / annual debt service
- 1.29×
- Buyer cash including capital work and liquidity
- $1,262,000
- Lower modeled purchase-loan limit
- $1,960,000
| Total apartments | 20 |
|---|---|
| Scheduled monthly rent from unit mix | $28,800 |
| Effective annual gross income | $327,408 |
| Fixed operating costs, including payroll | $102,000 |
| Management expense | $19,644 |
| NOI before replacement reserve | $205,764 |
| Net cash flow after reserve | $195,764 |
| Annual principal and interest | $151,689 |
| NOI / proposed loan, or debt yield | 10.8% |
| Loan limit from your cash-flow coverage assumption | $1,961,649 |
| Loan limit from purchase LTV | $1,960,000 |
| Loan limit from your NOI debt-yield assumption | $2,420,747 |
| Capital contingency funded in uses | $18,000 |
| Total purchase uses | $3,162,000 |
| Annual cash-on-cash return before tax | 3.5% |
| Downside annual cash after debt | $7,885 |
| Downside coverage | 1.05× |
| Scheduled balance at maturity: copy to the exit tool | $1,788,500 |
- All rates, loan limits and thresholds are editable assumptions. The lowest of LTV, cash-flow coverage and NOI debt yield is a mathematical screen before lender, borrower and property requirements.
- Coverage deducts the reserve below NOI once. Debt yield uses NOI before that reserve divided by the purchase loan. Confirm the actual lender definitions.
- This purchase-only loan does not fund later improvement draws. Initial capital work, contingency and operating cash are included in closing uses and buyer cash once. No renovated rent increase is assumed.
- The downside changes rental loss and fixed costs, including payroll. Management stays a percentage of effective income. Review actual step changes and staffing needs separately.
- The exit calculator is independent. When you change the purchase financing, copy the updated maturity balance into its payoff input.
Use the Excel underwriting model for individual rents and a project-by-project capital schedule. The workbook and calculator start with the same weighted rent mix and financial example. Blue workbook inputs are editable; its base-or-downside selector recalculates one acquisition budget.
12. Test vacancy and operating costs together
The downside assumes 15% rental loss and a 10% increase in fixed operating expenses, including payroll. Management remains 6% of EGI and the annual replacement reserve stays $10,000.
EGI falls to $299,760. Fixed costs rise to $112,200, with management of $17,985.60. NOI becomes $169,574.40 and NCF becomes $159,574.40. After the same debt payment, only $7,885 remains annually. Coverage falls to approximately 1.05 times.
The property remains slightly cash-positive under those assumptions, but the cushion is thin. An additional $10,000 of recurring expense would eliminate it. Test the specific costs and revenue exposures you find during diligence. A fifteen-percent economic loss is not automatically equivalent to three vacant apartments when rents vary across units.
13. Examine renovation and collection timing monthly
A single annual loss percentage can hide the first month the operation runs short. Place unit turns, contractor deposits, payroll, taxes, insurance, debt and collections on a monthly calendar. Track the lowest cash balance and who provides any temporary funding.
For example, taking four $1,500 apartments offline for three months removes $18,000 of scheduled rent before other collection effects. That is a timing calculation, not an additional automatic deduction from the annual example. Determine whether the modeled 7% loss already includes those turns; otherwise adjust the operating assumptions.
Keep future renovated rents outside the in-place case until timing and evidence support them. Budget relocation, leasing, approvals or other transaction-specific obligations with qualified advisers. Do not assume every renovation can proceed simultaneously while the remaining units produce an uninterrupted stabilized income stream.
14. Calculate the balance due at maturity
Thirty-year amortization does not create a thirty-year loan commitment. Under the acquisition example, approximately $1,788,500 remains after the scheduled payments through the fifth year. Add actual payoff interest, prepayment charges and other obligations when the time comes.
Identify the intended sale or refinance before purchase. Confirm what operating history, completion evidence, occupancy and borrower information the proposed replacement lender would review. Extension options, if any, have their own conditions; they should not be treated as automatic.
The OCC’s refinance-risk guidance explains why the ability to replace existing debt requires attention throughout a commercial loan’s life. An investor should maintain its own maturity calendar and contingency funding plan rather than relying only on the current payment fitting.
15. Work through a refinance that leaves a gap
Assume a future lender accepts $225,000 NOI and a $12,000 reserve, leaving $213,000 NCF. An assumed 7% valuation cap implies approximately $3,214,286 of value. None of those future figures is guaranteed or derived automatically from the purchase budget.
At 70% refinance LTV, value supports $2,250,000. An assumed 9% NOI debt-yield floor supports $2,500,000. But with 1.30 coverage, an 8% replacement rate and twenty-five-year amortization, cash flow supports only approximately $1,769,054. Coverage is the binding constraint.
Subtract $60,000 of assumed refinance costs and funded reserves: net proceeds before payoff are about $1,709,054. Compare that with the modeled $1,788,500 balance. Approximately $79,446 of additional cash is required. A higher value alone does not remove this shortfall because debt payments constrain the loan.
Calculate replacement debt and the payoff gap
Interactive underwriting worksheet
Multifamily refinance and payoff-gap calculator
This is an independent exit scenario. Copy the acquisition calculator’s maturity balance into payoff after changing that scenario; the two tools do not synchronize inputs.
Illustrative results for the starting assumptions. Change inputs and select Update underwriting.
- Lower modeled replacement loan
- $1,769,054
- Refinance cash needed, including costs
- $79,446
- Modeled surplus after costs and payoff
- $0
- Assumed exit property value
- $3,214,286
| Accepted net cash flow after reserve | $213,000 |
|---|---|
| Value-based refinance limit | $2,250,000 |
| Cash-flow coverage refinance limit | $1,769,054 |
| NOI debt-yield refinance limit | $2,500,000 |
| New annual senior-loan principal and interest | $163,846 |
| All modeled annual debt payments | $163,846 |
| Net cash flow / all annual debt | 1.30× |
| Loan proceeds after refinance costs, before payoff | $1,709,054 |
| Signed cash balance after costs and payoff | -$79,446 |
- Negative net cash flow cannot support a positive new loan under this model. Other continuing debt reduces the senior payment available under the total-debt coverage test.
- Debt yield uses NOI divided by the new senior loan; continuing debt principal is not included in that denominator. Ask whether your lender applies a different definition.
- A positive surplus is not approved cash-out. Cash-out restrictions, lender caps, valuation, required reserves, payoff dates and other conditions can reduce available funds.
- This tool does not forecast income or connect automatically to the acquisition calculator. Enter separately supported exit NOI, reserve, terms, payoff and costs.
The online tools are independent. When acquisition financing changes, copy its updated maturity balance into the exit payoff field. The workbook links the scheduled balance to its refinance sheet. Enter separately supported exit income, costs and loan assumptions; the acquisition downside selector does not forecast future NOI.
16. Match loan structure to property condition
Compare financing on the same budget and accepted income. A fixed-rate amortizing purchase, a floating-rate bridge and a facility with construction holdbacks create different payment, liquidity and exit questions. Review the rate basis, floor, amortization, maturity, fees, recourse, reporting, reserve and prepayment provisions.
Fannie Mae’s conventional multifamily term sheet describes a particular permanent-financing category. It is not a promise of that execution for every twenty-unit acquisition. Eligibility, size, condition, sponsorship and lender requirements still need review.
Use the 10-plus-unit financing guide and multifamily bridge guide to prepare the financing discussion. Clearly disclose substantial vacancy, uncertain legal units, deferred work and any reliance on future rents before the lender sizes the request.
17. Review the buyer and the closing conditions
Underwrite your ability to own the property as carefully as its ability to pay debt. Identify the borrowing entity, owners, guarantors and operating team. Prepare the financial information requested by the actual lender. There is no universal experience, net-worth or liquidity requirement established by the example’s unit count or coverage ratio.
Reconcile accessible cash with the $1,262,000 illustrated contribution and your other obligations. An investment account, expected sale, undrawn credit line and unrestricted bank cash have different availability and conditions. Identify money committed to other properties, capital calls, debt maturities or personal obligations before describing the remainder as available for this purchase.
Consider correlated exposure across your portfolio. If several properties depend on the same employer, manager, contractor or insurance market, their stresses can arrive together. A reserve that looks sufficient for one apartment building may also be expected to support another project. State who will fund a shortfall if those obligations overlap.
Review the settlement budget with the lender and closing team. Tax and insurance escrows, replacement accounts, deposits and lender-controlled cash can have different release conditions. Determine which amounts are already in closing costs, which remain operating cash and which are additional requirements. Do not present restricted funds as unrestricted post-closing liquidity.
Abstract the leases and material agreements rather than assuming all twenty apartments use identical documents. Record deposits, prepaid amounts, rent credits, renewal terms, outstanding repair promises and any disputed balances. Have qualified advisers determine transfer, notice and compliance obligations for the actual jurisdiction. A promising rent roll does not resolve those commitments.
18. Turn the model into a purchase decision
Document the assumptions that make the offer work: supported collections, the post-purchase expense budget, capital scope, buyer contribution, downside cash, financing conditions and maturity plan. Separate verified facts from unresolved questions and projections. State what discovery would change the price or stop the purchase.
Have the appropriate advisers review title, tenancies, entity structure, contracts, building issues and local requirements. Coordinate diligence and financing deadlines with the availability of records and reports. The budget should reflect the conditions you can actually satisfy before closing.
Use the downloadable diligence guide to organize the file. Request commercial financing review with the address, legal unit count, rent roll, operating records, capital plan, price, proposed loan and available cash. Include your operating experience and the specific uncertainties the lender needs to evaluate.