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

How to reconcile model inputs with a signed purchase agreement

A step-by-step guide for reconciling the financial model used in your loan request with the actual signed purchase agreement, including a concrete evidence checklist and document workpaper.

Source: CodexTopic: Acquisition model inputs1275 wordsUpdated 2026-11-19

A step-by-step guide for reconciling the financial model used in your loan request with the actual signed purchase agreement, including a concrete evidence checklist and document workpaper.

When you have a signed purchase agreement in hand, your financing request moves from hypothetical to real. Lenders will compare the numbers in your model—purchase price, closing costs, debt service, projected income—against the contract and supporting documents. Reconciling these inputs early prevents last-minute surprises and shows that you have done the work to verify your assumptions.

This guide walks through the specific items to reconcile, the documents you need, and how to prepare a workpaper that bridges the model and the agreement. It assumes you already have a pro forma or acquisition model and now need to align it with the binding terms of the purchase.

Reconcile the purchase price and sources of funds

Start with the total acquisition cost stated in the purchase agreement. Compare it line by line with the sources and uses table in your model. The purchase price in the contract must match the line item for acquisition cost in your sources. If the contract includes a deposit already paid, confirm that the model reflects that amount as equity or a separate line under sources.

Record any adjustments: credits from the seller, prorated property taxes, or holdbacks for repairs. These items change the net cash needed at closing. Your model should show the same net amount. If the contract calls for a deposit held in escrow, note that the lender may require evidence of the deposit and its source. The OCC handbook notes that banks review loan agreement provisions for holdback or retention and confirm that undisbursed loan funds or escrow accounts match retention requirements [1].

Verify the property condition and any required repairs

If the purchase agreement includes an inspection contingency or repair credits, document how those affect the model. For example, if the seller agreed to a credit for roof replacement, your model should show that credit as a reduction in purchase price or as a separate capital expenditure funded from equity or loan proceeds.

Identify any deferred maintenance that the lender may require to be addressed before or shortly after closing. The OCC guidance states that banks may require bonds for projects of material size when the borrower and contractor are separate entities [1]. While this applies to construction, the principle extends to major repairs: lenders may want assurance that critical work will be completed. Add a line in your workpaper for each known repair, its estimated cost, and how it is funded.

Align the operating pro forma with the rent roll and T-12

Once the purchase agreement is signed, update your pro forma to reflect the actual property condition, not the broker's assumptions. Obtain a current rent roll and a trailing twelve-month (T-12) operating statement from the seller. The rent roll is a snapshot of current tenants, rents, and lease expirations. The T-12 shows actual income and expenses over the past twelve months.

Compare the gross rent in the T-12 to the gross rent in your model. If the model assumed higher rent or occupancy than the T-12 shows, you need to justify the difference or adjust the model. The OCC handbook cautions against assumptions relative to current market conditions such as higher than current rents or occupancy rates [1]. Record the actual collected income, not just the gross rent. Distinguish between gross rent, collected income, net operating income (NOI), capital expenditures, debt service, and equity cash flow. Your workpaper should show each of these separately.

Confirm the debt service assumptions against the loan terms

The model likely includes a debt service line for the proposed loan: principal and interest payments. Once you receive an indicative term sheet or have a specific loan structure in mind, reconcile the rate, amortization, and payment timing with the model. If the loan is interest-only for a period, the model must reflect that.

Lenders will also check that the NOI covers the debt service by a comfortable margin. The OCC handbook lists failure to require principal curtailments when appropriate and loans that are renewed on an interest-only basis without appropriate mitigants as underwriting concerns [1]. Your model should show that the property can support the debt service under the actual contract price and operating history.

Prepare a reconciliation workpaper

Create a single document that lists each key input from your model alongside the corresponding figure from the purchase agreement and supporting documents. Use a simple table format with columns for: input name, model figure, source document figure, and variance. For each variance, add a note explaining the reason and whether it is resolved.

Include at minimum: - Purchase price - Deposit amount and source - Closing costs (legal, survey, appraisal, title, loan fees) - Repair credits or holdbacks - Gross rent from rent roll and T-12 - Collected income from T-12 - NOI from T-12 - Debt service (rate, amortization, payment) - Equity contribution

This workpaper becomes part of your loan request. It shows the lender that you have compared the model to the actual contract and operating data, and that you understand any differences.

Ask the lender about covenants and conditions

Every loan has covenants: conditions the borrower must maintain during the loan term. The purchase agreement may include terms that affect these covenants. For example, if the contract limits the number of units you can lease to a single tenant or restricts changes to the property, the lender may want to review those restrictions.

The OCC handbook lists appropriate covenants for construction or development loans, including a limit on the permissible number of speculative units and models [1]. For an acquisition, similar covenants may apply to leasing, additional debt, or capital improvements. Ask your actual lender what covenants they typically include for your property type and business plan. Do not assume all lenders require the same terms.

Review guarantor and sponsor financials

If the purchase agreement requires personal guarantees or a special purpose entity, confirm that your sponsor financials match the entity structure. The lender will request financial statements for the principals and guarantors [2]. Reconcile the equity contribution shown in your model with the actual cash or assets the sponsor will provide at closing.

If the agreement includes an assignment or assumption clause, check whether the lender needs to approve the borrowing entity before closing. The OCC handbook states that banks determine whether each file contains documentation supporting guarantees and subordination agreements [1]. Your workpaper should list the guarantors, their financial capacity, and how their support aligns with the loan request.

Frequently asked questions

What if my model shows a higher NOI than the T-12? Record the difference in your workpaper and explain the basis for your projection. Lenders will compare your assumptions to the actual historical data. If you assume rent growth or expense reductions, be prepared to support them with market evidence or a concrete business plan, such as planned renovations or lease-up. The OCC handbook warns against assumptions that are higher than current rents or occupancy rates without justification [1].

Do I need to include the purchase agreement in my loan request? Yes. The signed purchase agreement is a core document. Lenders will verify the purchase price, deposit, closing date, and any contingencies. Include it along with the reconciliation workpaper.

Can I submit the model before the purchase agreement is signed? You can submit a preliminary model, but lenders will not issue a binding commitment until they have the signed agreement and supporting documents. Use the interim period to prepare the reconciliation workpaper and gather the rent roll, T-12, and sponsor financials. Once the agreement is signed, update the model and submit the complete package.

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