Can I Afford This Property?Commercial real estate financing, worked out

Comparing two apartment acquisition scenarios with the same source documents

A practical guide to preparing side-by-side financing scenarios for a multifamily acquisition, including a concrete evidence checklist and worksheet to organize source documents for lender review.

Source: CodexTopic: Using financing models and packages974 wordsUpdated 2026-11-19

A practical guide to preparing side-by-side financing scenarios for a multifamily acquisition, including a concrete evidence checklist and worksheet to organize source documents for lender review.

Prepare a side-by-side comparison worksheet

When you have two acquisition scenarios for the same apartment property, the first step is to organize the key financial inputs into a single comparison document. Suggested approach: create a worksheet that lists each scenario side-by-side with rows for purchase price, estimated stabilized net operating income (NOI), planned capital expenditures, and requested loan amount. Record the source of each figure—for example, the purchase price from the signed purchase contract or letter of intent, and the NOI from a trailing twelve-month (T-12) operating statement. This worksheet becomes the reference point for discussing how each scenario affects the financing discussion. You can load a fictional example to see how inputs are structured, then enter your own figures, including zero explicitly when a cost is zero.

Distinguish the rent roll from the T-12 statement

A current rent roll is a snapshot of in-place tenants, unit types, and contracted rents as of a single date. A T-12 is a historical summary of actual income and expenses over the past twelve months. Before comparing totals between the two scenarios, identify the timing difference: the rent roll shows what is leased today, while The T-12 reports historical income and expenses on its stated accounting basis. To reconcile them, record the gross rent from the rent roll and the collected income from the T-12, then note any vacancy, concessions, or bad debt that explains the gap. This comparison helps you estimate a realistic stabilized NOI for each scenario. [1] The OCC Commercial Real Estate Lending handbook notes that banks typically maintain signed operating statements and rent rolls for the property, as applicable, as part of the loan file. Preparing this reconciliation now supports a more informed discussion with your lender.

Break out income, expenses, and cash flow layers

For each scenario, separate the following layers: - Gross rent: total contracted rent from the rent roll - Collected income: actual rent collected after vacancy and concessions (from the T-12) - Net operating income (NOI): collected income minus operating expenses (from the T-12, adjusted for known changes) - Capital expenditures (capex): planned improvements, such as unit renovations or roof replacement - Debt service: estimated annual loan payments based on your assumed interest rate and amortization period - Equity cash flow: NOI minus debt service and capex

Record each figure on your worksheet. This layering shows where each scenario produces different cash flow outcomes. For example, one scenario may assume higher capex to increase rents, while another assumes lower capex with slower income growth. The OCC handbook explains that debt yield—the ratio of NOI to debt—provides a measurement of risk independent of interest rate, amortization period, and capitalization rate, and lower debt yields indicate higher leverage. [1] By calculating NOI and the proposed loan amount for each scenario, you can compare debt yields and discuss how leverage affects the risk profile.

Identify assumptions versus source facts

On your worksheet, clearly mark which figures are from source documents and which are your assumptions. Source facts include: purchase price from the contract, current rent roll, T-12 historical income and expenses, and any existing appraisal or property condition report. Assumptions include: projected rent growth, planned renovation costs, estimated stabilized vacancy rate, and assumed interest rate or amortization period. When you discuss the scenarios with a lender, you can point to the source facts for verified figures and explain the reasoning behind each assumption. This distinction helps the lender assess the reliability of your projections.

Organize supporting documents for lender review

Suggested list of documents to prepare: - Signed purchase contract or letter of intent - Current rent roll (dated within 30 days) - Trailing twelve-month operating statement (T-12) - Two years of historical financial statements for the property (if available) - Property condition report or inspection summary - Capital expenditure budget and timeline - Sponsor financial statement or personal financial statement - Preliminary appraisal or broker opinion of value (if available)

The OCC handbook indicates that banks typically maintain signed financial statements for borrowers and guarantors, and operating statements and rent rolls for the property, as applicable, along with title insurance, appraisals, and other documents in loan files. [1] Organizing these documents now prepares you for a smoother lender review process.

Evidence checklist for each scenario

Create a checklist to confirm you have the following for each acquisition scenario: - [ ] Purchase price and terms from a signed document - [ ] Current rent roll with unit types, rent amounts, and occupancy status - [ ] T-12 income and expense statement - [ ] Stabilized NOI estimate with supporting calculations - [ ] Capital expenditure plan with costs and projected returns - [ ] Loan amount and assumed terms (interest rate, amortization, term) - [ ] Debt yield calculation (NOI divided by loan amount) - [ ] Equity cash flow projection after debt service and capex - [ ] Comparison of key metrics between the two scenarios

Use this checklist to identify any gaps before submitting your request.

Frequently asked questions

How do I know which scenario a lender will prefer?

Lenders evaluate each scenario based on risk, including debt yield, loan-to-value ratio, and debt service coverage ratio. Prepare both scenarios with clear source facts and assumptions, then ask the actual lender for their underwriting criteria. The OCC handbook notes that debt yield provides a common metric to quickly size up a loan or assess its risk, but should be considered along with other criteria and loan amounts and be supported by prudent DSCR and LTV ratios. [1]

What if my T-12 and rent roll show different income figures?

That is common. The rent roll shows contracted rent, while The T-12 reports historical income and expenses on its stated accounting basis. Record both figures on your worksheet and identify the reasons for the difference, such as vacancy, concessions, or bad debt. This reconciliation helps you estimate a realistic stabilized NOI for each scenario.

Model this deal and request financing

Run a multifamily acquisition or value-add model with your own numbers in the financing workbench. Results are calculated on the server with the assumptions shown. If you choose to send the request, you get a preliminary lender-package PDF and can attach your rent roll, T-12 or OM.

Opens the financing workbench operated by Wraith Real Estate. Nothing goes to any lender without Wraith's review and your agreement.

Open the acquisition model

Talk through your financing

Working on a real property? Send us the deal and a financing advisor will review it and get back to you. It costs nothing to ask and does not commit you to anything.

Contact us

Requests are reviewed by Wraith Real Estate, a commercial real estate debt advisor (not a lender).

Sources

  1. OCC Commercial Real Estate Lending handbook