A mixed-use property needs separate commercial and residential operating schedules before a consolidated investment cash flow. The components have different lease terms, vacancy patterns, recovery provisions, turnover costs, and legal requirements. A single blended vacancy rate or expense ratio can hide the risk that drives the acquisition.
Combine the schedules only after identifying shared expenses and allocating them consistently. The purpose is an accurate total property model, not an arbitrary allocation that makes each component look profitable. All figures below are hypothetical.
Build two rent schedules
For apartments, list each supportable unit, signed rent, lease dates, concessions, deposits, arrears, and collections. Distinguish physical occupancy from economic performance. An occupied unit with unpaid rent is not equivalent to a current payer.
For commercial space, abstract base rent, increases, options, expiration, free rent, reimbursements, landlord delivery obligations, tenant improvements, commissions, and material rights. The commercial rent roll should identify the actual legal tenant and guarantor where applicable.
Reconcile both schedules to leases and collected cash. A seller’s summary can annualize a recently signed lease before cash rent starts, omit informal concessions, or include rent from space whose lawful use remains unverified.
Fannie Mae’s multifamily cash-flow guidance provides an example of the emphasis placed on supported income and individually reconciled adjustments. It is a program-specific source, not a universal underwriting rule for every mixed-use lender. Fannie Mae underwritten cash flow
Use different vacancy mechanics
Apartment vacancy can be modeled unit by unit or through a supported recurring assumption, with concessions and collection loss identified separately. Commercial vacancy should reflect actual lease expiration, tenant prospects, downtime, free rent, and capital required before rent begins.
A single storefront can represent a large share of a small building’s revenue. If it leaves, the building does not experience a smooth average vacancy; it loses that entire cash stream for a period while costs continue.
Do not apply both a full specific commercial downtime event and an unrelated blanket vacancy deduction to the same rent without explaining the overlap. Likewise, do not omit recurring apartment losses because the commercial unit has a long lease.
Show monthly cash during concentrated events. Annual totals can conceal the equity needed before a new tenant’s first payment or after a large shared repair.
Classify expenses before allocating
Separate directly attributable residential expense, directly attributable commercial expense, and common building expense. Examples of direct costs can include unit turnover or commercial leasing fees. Shared roof, structure, insurance, taxes, and some utilities need a documented approach.
Allocation for internal analysis is different from contractual recovery. An owner may allocate a common bill by area to evaluate components while a lease allows a different recovery or none. The consolidated property expense must remain the actual total.
Record the chosen method and why it is useful. Area, consumption, equipment served, or another evidence-based measure may be appropriate for different costs. Avoid a universal percentage applied to every bill.
Reconcile allocated totals back to actual expenses. A model can accidentally omit the common balance or charge the same expense twice when component tabs are built separately.
Read legal obligations separately
Commercial lease provisions should not be copied into apartment assumptions. Chicago’s residential landlord-tenant framework has its own scope and exceptions, requiring current property-specific legal review. Chicago Residential Landlord and Tenant Ordinance
For both components, verify lawful use and occupancy through qualified professionals and actual records. A commercial tax description or historical operation does not establish that every advertised apartment or basement area is supportable.
Chicago’s occupancy provisions have requirements and exceptions depending on the building and work. Obtain an actual determination for the intended configuration rather than a generic rule based on unit count or sale. Chicago occupancy provisions
If a component’s use remains unresolved, show a conservative case without the income and identify the cost and process to resolve it. An unverified revenue line should not silently support the loan amount.
A hypothetical six-apartment and storefront model
Assume six apartments have total annual scheduled rent of $144,000. Concessions, vacancy, and collection loss total $12,000, leaving $132,000 of residential rental income.
The storefront has $60,000 annual base rent and $12,000 of supported recoveries, with $3,000 of collection and vacancy adjustment in the stabilized case. Commercial income is $69,000. Combined effective income is $201,000.
Residential direct expenses are $25,000, commercial direct expenses are $8,000, and shared operating expenses are $70,000. Total operating expenses are $103,000, producing $98,000 NOI.
If the owner allocates shared expenses 65% residential and 35% commercial for internal analysis, the residential share is $45,500 and commercial share is $24,500. Component contributions are $61,500 and $36,500 respectively, totaling the same $98,000 NOI. The allocation does not create or remove property income.
Separate capital from recurring operations
Schedule apartment turns, commercial improvements, leasing commissions, roof work, facade work, systems, and recurring replacements. Some costs may be below NOI under the chosen convention, but all belong in investment cash flow.
A commercial lease expiration can require more cash than several apartment turns. Conversely, repeated apartment turnover can create steady capital leakage even while the storefront remains stable. Model both rather than choosing one average reserve.
Review who pays and when. A tenant reimbursement after completion does not fund the initial contractor deposit. A lender holdback can require equity advances. The consolidated model needs the actual cash sequence.
Avoid confusing a reserve contribution with the final expenditure. Depending on the model, deducting both without tracking the reserve account can double-count the cash burden. Show opening reserves, contributions, spending, and ending reserves explicitly.
Stress cross-component effects
A restaurant’s ventilation or noise problem can reduce apartment demand. A facade repair can disrupt storefront access and residential entrances. A heating failure can affect multiple rent streams at once.
Test shared events rather than assuming all risks are independent. If the commercial tenant leaves while a roof project is due, the owner may lose rent and recoveries just as capital demand rises.
A hypothetical six-month storefront vacancy removes $30,000 base rent before free rent or replacement rent differences. If $6,000 of recoveries is also lost, and reletting requires $40,000 improvements plus $12,000 commissions, the isolated exposure is $88,000 before other carrying effects.
That amount is nearly the model’s $98,000 annual NOI. A stabilized property presentation can therefore look robust while the rollover year requires substantial equity.
Present financing clearly
Provide lenders with both component schedules, the consolidated cash flow, lease abstracts, collections, legal-use evidence, capital plan, and rollover model. Ask how the actual program treats commercial space, income, vacancy, and lease quality.
A lender’s eligibility and cash-flow adjustments may differ from the sponsor’s investment model. Do not apply single-family mixed-use guidance to commercial multifamily financing or assume that one program’s approach governs all lenders.
Reconcile the lender’s underwritten income and expenses to the investor’s model before relying on proceeds. Show how a lower commercial contribution or higher tax assumption changes coverage and required equity.
Annotate the monthly model so another investor can audit it
Use separate rows for apartment scheduled rent, apartment loss categories, commercial contractual rent, commercial concessions, recoveries, direct expenses, shared expenses, capital, debt, and reserve movements. Each material input should identify its document or assumption.
For the commercial schedule, use actual lease dates and a clear convention for partial months. For apartments, avoid annualizing a midyear increase across months before it became effective. The monthly model should reproduce historical collections before it becomes a forecast.
Add a reconciliation column or schedule showing the difference between seller NOI, normalized investor NOI, lender cash flow, and cash available to equity. The labels should explain whether a difference is a revenue adjustment, expense correction, capital provision, or financing movement. That prevents disagreements caused simply by different definitions.
A hypothetical lender may deduct $8,000 more commercial income and add $6,000 of reserves compared with the investor. The $14,000 difference should be visible rather than hidden by replacing the investor’s entire NOI with an unexplained lender number. Both views can be useful when their purposes and assumptions are clear.
Keep component allocation out of the consolidated cash calculation where it would duplicate cost. For example, an internal roof-reserve split can help report residential and commercial performance, but the property contributes the total reserve only once. Review the workbook by tracing cash through its layers, not just checking whether a final return looks plausible.
Reconcile tenant deposits separately so they do not inflate operating revenue or freely distributable cash.
Use the model in ownership
Track collections and expenses by component while retaining a complete property total. Reconcile recoveries and common bills regularly. Update the capital schedule and lease events rather than reporting only annualized rent.
For valuation, evaluate comparable properties and buyer expectations for the actual mix. A blended cap rate can be useful if supported, but it should not hide a weak commercial component or uncertain use.
The investor should be able to explain where each dollar comes from, which cost supports it, what happens at turnover, and how shared systems connect the components. That is the foundation for a financeable and manageable mixed-use investment.