Operating evidence and financing
What this package helps you examine
A mixed-use property should be modeled as connected but distinct income components. Apartments, shops, offices and other space can have different lease terms, collection patterns, expense responsibilities and lender treatment. The central question is whether the combined economic cash flow and the cash flow accepted for the chosen financing both support the transaction.
Reconcile components before consolidating
Build separate residential and commercial schedules, then reconcile them to one property ledger. Identify unit counts, rentable areas, vacant space and shared facilities. Allocate common expenses with a documented method and retain direct costs in the relevant component. Intercompany rent and internal reimbursements must not create extra income when the owner controls both sides.
Distinguish economic income from channel treatment
A property may collect commercial rent that a particular financing channel treats differently when underwriting multifamily debt. Preserve an economic cash-flow column and a separate lender-adjusted column. Fannie Mae's conventional NCF calculation identifies commercial-income treatment in a program-specific framework; this guide does not prescribe a commercial-space or income eligibility limit. Confirm the current rule and property classification with the lender.
Stress the weak component and shared obligations
Model commercial vacancy without assuming apartment income automatically fills the resulting gap. Some common costs continue while the commercial unit is empty, and re-leasing capital can fall due before rent starts. Conversely, residential turnover can coincide with a commercial expense true-up. Show the timing of each component and the property's total funding need, including any legal or structural dependence between uses.
Use the workbook
- Use Assumptions!D5 for Base (1) or Downside (2), and the labeled scenario input rows. Enter source data in Use Components!D10:L21; preserve formula cells and an untouched workbook copy.
- Keep residential and commercial source inputs distinct and reconcile their combined costs. A lender adjustment changes accepted sizing cash; it does not determine mixed-use program eligibility.
- Reconcile Operations to Summary. Apply the entered lender adjustment separately to the modeled cash flow. Sizing uses amortizing debt service, while first-year payments reflect the entered interest-only period.
- In Assumptions, replace illustrative value, LTV, DSCR, debt yield, rate, amortization and requested ceiling with the intended scenario. Review capacities in Debt and Funding. The smallest modeled capacity does not establish eligibility or approval.
- Closing equity includes the entered opening cash and restricted reserves. Additional operating cash need is measured after that opening cash, so do not add it twice. Inspect monthly cash and remaining principal at maturity.
- Read Review for model conventions and limitations. Save each scenario with its supporting evidence and date; actual lender definitions, legal rights and professional findings control the transaction.
Questions to prepare for a lender
Do all areas and income streams reconcile?
Unit and space schedules matched to plans, leases and the general ledger.
How are common costs allocated?
Written allocation basis, actual invoices and lease recovery provisions.
What income will the selected lender accept?
Current program classification and a written lender cash-flow reconciliation.
Can residential income carry vacant commercial space?
Separate component operating results and a dated commercial re-leasing budget.
Are uses legally and physically compatible?
Occupancy evidence, title, easements and relevant technical reports.
What funds simultaneous turnover and capital needs?
Monthly combined cash plan with verified uncommitted equity.
03 / Prepare
Build the evidence file
Use this as a preparation checklist. The lender determines the documents, definitions and review conditions for the actual transaction.
Cash flow and operations
- Residential rent roll and commercial tenant schedule kept separately.
- Executed residential and commercial leases, concessions and amendments.
- Collections and arrears by component, with bank reconciliation.
- Monthly operating statements and direct-versus-shared expense ledger.
- Expense allocation method and commercial recovery calculations.
- Lender-adjustment bridge showing excluded or differently treated income.
Property and collateral
- Floor plans, unit and area reconciliation and actual-use evidence.
- Title, survey, access, shared facilities and recorded restrictions.
- Condition reports separating residential, commercial and common systems.
- Fire, life-safety, separation and other issues identified by qualified reviewers.
- Commercial re-leasing or conversion work scope and bids.
- Environmental and other third-party reports for the actual combined property.
Sponsor and execution
- Sponsor experience managing both residential and commercial tenants.
- Entity chart and any related-party business or lease relationships.
- Property management and commercial leasing responsibilities.
- Liquidity after committed improvements and other debt obligations.
- Debt and guaranty schedule across the sponsor's portfolio.
- Equity evidence for the combined downside funding requirement.
Closing and funding
- Written lender confirmation of the applicable property/program classification.
- Requested tenant confirmations, consents and assignment documentation.
- Complete sources and uses, including component-specific repair holdbacks.
- Insurance and escrow instructions for the actual combination of uses.
- Existing debt payoff and any partial-release requirements.
- Dated unresolved-items log with a separate owner for each component.
Watch for these assumptions
- Do not apply a multifamily eligibility rule to an entire mixed-use building without confirming its classification.
- Allocating a shared cost differently changes component profit but should not change total property expense.
- Exclude the same lost rent only once when using both vacancy and lender income adjustments.
- A fully occupied apartment component does not erase a commercial repair or lease-up cash requirement.
Before you rely on the result
- Prove the physical inventory and total ledger reconcile before comparing lenders.
- Maintain separate economic and lender-accepted cash-flow columns.
- Fund the weaker component through the date replacement collections are supportable.
Scope and limitations
- Educational analysis; not a financing offer, appraisal, legal opinion or program eligibility determination.
- Workbook figures and thresholds are illustrative editable assumptions, not current lender quotes or universal underwriting standards.
- Document requests depend on the lender, transaction, jurisdiction and property; address unresolved issues with the relevant qualified professional.
Sources and applicability
Fannie Mae Section 203.02, Calculation of Commercial Income, was checked against the retained official September 28, 2026 PDF downloaded during same-day library research (PDF page 25). A new web-reader request returned 403. The citation supports program-specific income treatment, not a universal mixed-use percentage or eligibility conclusion.
- 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-21Only the separation principle is cited; all channel percentages and capacity assumptions in the example are fictional.