Show the same mixed-use property under distinct, explicitly entered recognition rules and preserve a reconciliation to actual cash.
A mixed-use property can produce one set of actual cash receipts and several different underwriting results. The difference may come from a lender’s treatment of commercial leases, the definition of eligible income or the denominator used in an income limitation. Reallocating expenses between apartments and storefronts cannot cure an eligibility issue or create more consolidated property cash.
Start with an operating model that reconciles to leases and collections. Then create a separate channel worksheet for the specific loan being considered. Fannie Mae’s conventional multifamily cash-flow calculation, for example, separately identifies commercial income and related adjustments. That is evidence that a program’s prescribed calculation matters; it is not a universal mixed-use rule and should not be confused with single-family lending guidance. Fannie Mae, required underwritten net cash flow calculation
Ask which percentage is being measured
“Commercial percentage” can refer to rentable area, gross income, adjusted income or value. These measures can differ substantially. Record the numerator, denominator, measurement date and source. A building with 30% commercial floor area can have a larger or smaller commercial share of receipts, depending on rents and occupancy.
For each proposed channel, distinguish a property eligibility test from an income-recognition adjustment. An eligibility test may determine whether the channel can be used at all. An income adjustment may reduce sizing even when the property otherwise fits. Do not turn an unresolved eligibility question into a numerical haircut and assume the problem is solved.
| Channel worksheet field | Required entry |
|---|---|
| Property and ownership eligibility | Specific rule, exception process and decision owner |
| Space measure | Approved area schedule and treatment of common areas |
| Commercial lease recognition | Actual required status, remaining term and documentation |
| Income limitation | Exact numerator, denominator and calculation order |
| Expense treatment | Required expenses, recoveries and reserve convention |
| Evidence date | Applicable guide version and transaction-specific confirmation |
This register is a comparison framework. Current lender requirements must be supplied and verified; the scenarios below deliberately use fictional rules to demonstrate the arithmetic.
Hypothetical example: an income cap with a moving denominator
Assume apartments generate $600,000 of annual effective income and commercial space generates $300,000, including all recognized recoveries in the investor’s model. Total property operating expenses are $450,000. Investor NOI is $450,000. Commercial floor area is 30%, while the commercial share of actual income is $300,000 ÷ $900,000, or 33.33%.
Illustrative Channel A allows recognized commercial income, C, to be no more than 25% of total recognized income, including C itself. The apartments’ $600,000 remains fully recognized. The condition is therefore C ÷ ($600,000 + C) ≤ 25%. Solving gives C ≤ $200,000. Taking 25% of the original $900,000 would produce $225,000, which fails the stated rule because $225,000 ÷ $825,000 is 27.27%.
Illustrative Channel B instead recognizes 90% of the $300,000 commercial receipts with no additional income cap in this example. It recognizes $270,000. Both channels retain the full $450,000 of operating expenses. Excluding commercial income does not make the building’s roof, taxes or insurance disappear.
| Measure | Investor model | Fictional Channel A | Fictional Channel B |
|---|---|---|---|
| Residential income | $600,000 | $600,000 | $600,000 |
| Commercial income recognized | $300,000 | $200,000 | $270,000 |
| Total income recognized | $900,000 | $800,000 | $870,000 |
| Property expenses | $450,000 | $450,000 | $450,000 |
| Cash flow for this comparison | $450,000 | $350,000 | $420,000 |
Using an entered 1.25× coverage requirement and an 8% annual debt constant, the income-based capacities are $4.5 million, $3.5 million and $4.2 million respectively. These are not quotes and exclude other possible constraints. The $1 million difference between the investor model and Channel A comes from recognition rules, not missing property receipts.
Keep allocation and recoveries auditable
An internal allocation might assign $315,000 of expenses to apartments and $135,000 to commercial space. Those numbers still total $450,000. Changing that split cannot change the consolidated cash flow unless an actual expense or collectible recovery changes. Keep internal allocation out of the eligibility denominator unless the actual rule calls for it.
Likewise, a reimbursement is both a receipt and a response to a particular expense. Check whether the channel definition includes it in commercial income, nets it against expense or treats it another way. Using gross receipts in one part of the worksheet and net recoveries in another can create an apparent compliance result that does not follow the specified method.
Choose the channel with a complete reconciliation
Present the investor model, each proposed channel calculation and a bridge explaining every difference. Attach the lease evidence, measured area, relevant guide extract and any transaction-specific clarification. If a required interpretation remains unresolved, label proceeds provisional and identify the person responsible for resolving it.
The useful result is not simply the largest calculated loan. It is a loan request supported by the right definitions, complete expenses and a documented explanation of why the property belongs in that channel. A transparent reconciliation also makes it easier to update the request when a commercial lease changes or a program’s requirements are revised.
Sources and evidence
- Fannie Mae conventional underwritten cash-flow calculationSection 203.02, Required Underwritten NCF table, Calculation of Commercial Income, PDF page 25, items 8–11 · Checked 2026-10-21 · Only the separation principle is cited; all channel percentages and capacity assumptions in the example are fictional.
Source dates and applicability matter. Report an error or a changed source.