Preparing an acquisition model when closing costs are still estimates
Closing costs are rarely final at the time of underwriting. This guide provides an evidence checklist to help sponsors prepare an acquisition model that separates known figures from assumptions, supporting a clearer financing discussion.
Closing costs are rarely final at the time of underwriting. This guide provides an evidence checklist to help sponsors prepare an acquisition model that separates known figures from assumptions, supporting a clearer financing discussion.
Identify the sources and uses table as the central document
The sources and uses table is the core workpaper for any acquisition model. It lists every source of capital — senior loan, mezzanine loan, sponsor equity, hard equity — and every use of that capital — purchase price, closing costs, reserves, and any immediate renovation or leasing costs. Lenders review this table to understand how the deal is capitalized and whether the equity contribution meets their requirements. A suggested way to prepare this table is to start with the purchase price and add a separate line for each closing cost category, even if the exact amount is still an estimate. This allows you to compare the total uses against the total sources and identify any gap before the lender asks.
Record the timing of each closing cost
Some closing costs are paid at closing, others before closing, and a few may be reimbursed from loan proceeds after closing. For example, an appraisal ordered by the lender is typically paid at the time of order, not at closing. Recording the timing of each cost helps the sponsor plan cash flow and ensures the sources and uses table reflects when capital is actually needed. A suggested way to organize this is to create a column for "expected payment date" next to each line item. This is not a mandatory lender process but a practical step to avoid a situation where the sponsor must pay a cost out of pocket before the loan funds.
Compare the acquisition model to the pro forma
The acquisition model covers the day of purchase. The pro forma covers the property's expected performance after closing. These two documents must be consistent. For example, if the acquisition model assumes a certain purchase price, the pro forma should use that same price as the basis for depreciation and debt service calculations. If the acquisition model includes a renovation budget, the pro forma should reflect the timing of that renovation and the resulting rent increases. The OCC handbook notes that the construction budget and the project pro forma are among the most critical elements in determining project feasibility [1]. Similarly, the acquisition model and the operating pro forma together tell the lender whether the sponsor has enough capital to close and enough income to service the debt.
Prepare a closing cost evidence checklist
A concrete workpaper to prepare is a closing cost evidence checklist. This is a single-page document that lists each closing cost category and, next to it, the evidence the sponsor has obtained to support the estimate. For example: - Legal fees: estimate from attorney dated [date] - Title insurance: preliminary commitment from title company dated [date] - Transfer taxes: calculation based on county tax rate and purchase price - Appraisal: quote from appraiser dated [date] - Environmental report: quote from environmental consultant dated [date] - Lender origination fee: term sheet from lender dated [date]
This checklist allows the sponsor to present the acquisition model with confidence, showing the lender which figures are supported by third-party evidence and which are still assumptions. It also helps the sponsor identify missing information before the lender requests it.
Ask the actual lender about their specific requirements
Lenders differ on which closing costs they will finance and which they expect the sponsor to pay from equity. Some lenders include all closing costs in the loan amount; others exclude certain fees such as transfer taxes or prepaid insurance. The OCC handbook states that selling costs to be funded out of sales proceeds, such as brokerage commissions and other closing costs, should not be included in the construction budget [1]. While this guidance is directed at banks and applies to construction budgets for development projects, it illustrates that lenders have specific rules about what counts as a fundable cost. The only way to know a particular lender's policy is to ask. A suggested way to phrase the question is: "Which closing costs do you include in the loan amount, and which do you expect the sponsor to fund from equity?"
How do I handle closing costs that change between the estimate and closing?
Record the estimate in the acquisition model, label it as estimated, and note the source. If the actual cost differs, update the model and explain the change to the lender. A contingency reserve, as described in the OCC handbook, can cover small variances [1]. For larger changes, the sponsor may need to increase the equity contribution or renegotiate the loan amount.
Should I include lender legal fees in the acquisition model?
Yes. Lender legal fees are a closing cost, typically paid by the borrower. Include them as a separate line item in the uses section. Obtain an estimate from the lender or the lender's counsel. If the lender requires a specific firm, ask for a fee estimate before closing.
Can I use the same acquisition model for a bridge loan and a permanent loan?
Not without adjustments. A bridge loan typically funds an acquisition with a value-add business plan, so the acquisition model should include renovation costs and a leasing reserve. A permanent loan typically funds a stabilized property, so the acquisition model should focus on the purchase price and closing costs without renovation line items. The OCC handbook distinguishes between construction, bridge, and permanent loans by property stage [2]. Prepare a separate acquisition model for each loan type.
Submission is a preliminary request, not an engagement or lender submission.
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.
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.
Requests are reviewed by Wraith Real Estate, a commercial real estate debt advisor (not a lender).