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

How to freeze a financing model version before sharing a package

A practical guide to locking down your financial model, reconciling rent rolls and operating statements, and preparing a version log before submitting a loan request to lenders.

Source: CodexTopic: Financing process and document control1397 wordsUpdated 2026-11-19

A practical guide to locking down your financial model, reconciling rent rolls and operating statements, and preparing a version log before submitting a loan request to lenders.

When you share a financing package with lenders, every number in your model becomes part of the underwriting conversation. If the model changes after submission—because you updated a rent assumption, corrected a budget line, or added a new unit—the lender's analysis may no longer match what you originally presented. Freezing a version means you commit to a single, dated set of projections and assumptions before the package leaves your hands. This article walks through the steps to prepare that frozen model, reconcile it with supporting documents, and document what you decided.

Identify the reporting basis and reconcile periods

A current rent roll is a snapshot of occupancy and rent on a single day. A trailing twelve-month (T-12) operating statement shows twelve historical months of income and expenses. These two documents use different time frames, so comparing them directly can lead to confusion. Before you freeze your model, record the date of the rent roll and the ending month of the T-12. Then reconcile the totals: gross potential rent on the rent roll should match the most recent month's income on the T-12, after adjusting for any concessions or free rent periods. If they do not, ask the property manager or accountant to explain the difference and note that explanation in your version log. This step ensures that your model's starting point is consistent with the property's actual performance [1].

Distinguish gross rent, collected income, NOI, capex, debt service, and equity cash flow

Your financial model likely contains several layers of cash flow. Label each line clearly: - Gross rent: total rent billed before any vacancy or collection loss. - Collected income: rent actually received after vacancy, credit loss, and concessions. - Net operating income (NOI): collected income minus operating expenses, before debt service and capital expenditures. - Capital expenditures (capex): spending on major improvements or replacements, not routine repairs. - Debt service: scheduled principal and interest payments on the loan. - Equity cash flow: what remains after all operating expenses, capex, and debt service.

When you freeze the model, verify that each layer flows from the one above it. For example, NOI should equal collected income minus operating expenses. If the model uses a different definition, note it in the version log. Lenders will test your projections against their own underwriting standards, and clear labeling reduces back-and-forth questions [1].

Prepare a borrowing base schedule for tract development or phased projects

If your project involves a tract development, phased construction, or multiple units, lenders may use a borrowing base formula to limit advances. The borrowing base specifies the maximum amount the lender will advance based on collateral type, value, eligibility criteria, and advance rates [1]. Before freezing your model, prepare a schedule that shows: - Each phase or unit type. - The estimated cost and value per unit. - The advance rate you are assuming. - The total borrowing base availability.

This schedule becomes part of your frozen model. If the lender asks for a separate borrowing base certificate later, you can reference the same assumptions. Also include any limits on speculative units or models, as banks often impose covenants on the number of unsold units a builder may have at one time [1].

Document model assumptions and version changes

Create a version log that records: - Date and time the model was frozen. - Version number (e.g., v2.1). - Key assumptions: rent growth rate, vacancy rate, expense escalations, interest rate on the proposed loan, capitalization rate used for exit valuation. - Any changes from the previous version and why they were made.

Keep this log with the model file. If a lender asks about a specific number, you can trace it back to the frozen version and the assumption that produced it. This practice also helps you avoid accidentally sending an outdated version to a different lender. The OCC's commercial real estate lending handbook notes that banks typically require appraisals for each model or floor plan in a residential tract development, and the model appraisal includes the value of a base lot without options or upgrades [1]. Your frozen model should reflect the same distinction: base unit values separate from optional features.

Reconcile the pro forma with the operating history

Your pro forma projects future income and expenses. It should be grounded in the T-12 operating statement, not created from scratch. Compare each line item in the pro forma to the historical average from the T-12. If the pro forma assumes lower vacancy or higher rent than the property has achieved, note the rationale—for example, planned renovations or a change in management. Lenders will evaluate whether your assumptions are realistic given the property's track record. The OCC handbook emphasizes that banks consider the passage of time and current market conditions when assessing appraisal validity [1]. The same principle applies to your financial model: historical data anchors your projections in reality.

Prepare a sources and uses of funds statement

Lenders want to see where every dollar of the loan and equity is going. Build a sources and uses table that lists: - Sources: loan amount, equity, any other capital. - Uses: acquisition cost, construction or renovation budget, closing costs, reserves, interest reserve (if applicable).

Total sources must equal total uses. Freeze this table as part of your model. If the project is a construction loan, the budget should be detailed enough to show each major line item, and draws should be tied to completion milestones. The OCC handbook notes that banks typically finance larger tract developments in phases and may require separate loans or sublimits for each phase [1]. Your sources and uses statement should reflect the same phasing if applicable.

Create a model freeze checklist

Before you send the package, run through this checklist: - [ ] Rent roll date is recorded and reconciled with T-12. - [ ] T-12 ending month is recorded. - [ ] Gross rent, collected income, NOI, capex, debt service, and equity cash flow are labeled and flow correctly. - [ ] Borrowing base schedule is prepared (if applicable). - [ ] Version log is complete with assumptions and change history. - [ ] Pro forma is reconciled with operating history. - [ ] Sources and uses statement balances. - [ ] Model file is saved with version number and date in the filename. - [ ] No unprotected cells or formulas remain that could change the output.

Once you check every item, consider the model frozen. Do not make further edits without creating a new version and updating the log. When you share the package, include the frozen model file and the version log. If a lender asks for a sensitivity analysis or a different scenario, create a separate version and label it clearly.

How this affects the financing discussion

A frozen model gives the lender confidence that the numbers are stable and that you have thought through the assumptions. It also protects you: if the lender later claims you changed a key projection, you can point to the frozen version. The OCC handbook describes how banks use borrowing base formulas and covenants to manage risk [1]. When you present a well-documented, frozen model, you demonstrate that you manage risk the same way. This can lead to a smoother underwriting process and fewer follow-up questions.

FAQs

What if I need to update the model after I have already sent it to a lender?

Create a new version with a clear version number (e.g., v2.2) and update the version log with the changes and reasons. Send the updated version to the lender with a brief note explaining what changed and why. Do not overwrite the original frozen version.

Should I include sensitivity scenarios in the frozen model?

You can include a separate tab or sheet with sensitivity scenarios (e.g., higher vacancy, lower rent growth), but keep the base case frozen. Label each scenario clearly so the lender knows which one is your primary projection.

Does the model freeze apply to construction draws as well?

Yes. For construction loans, freeze the initial budget and draw schedule. If the budget changes later, create a new version and update the lender. The OCC handbook notes that banks finance construction in phases and may require separate loans or sublimits [1]. Your frozen model should reflect the same phased approach.


Ready to move forward? Send us the property, the business plan, and the capital you need. We will tell you how we would approach it.

Run the numbers on your deal

Try your own NOI, value and lender tests to see which one limits the loan: DSCR, LTV or debt yield.

Open the loan sizing calculator

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
  2. Wraith commercial real estate debt