How to reconcile a calculator result with a lender's actual loan terms
A practical guide for CRE sponsors to compare their own financial analysis against a lender's underwriting, using a concrete evidence checklist to identify gaps and prepare a more informed financing request.
A practical guide for CRE sponsors to compare their own financial analysis against a lender's underwriting, using a concrete evidence checklist to identify gaps and prepare a more informed financing request.
When you run numbers through a financing workbench, you get a scenario based on your assumptions. A lender's actual loan terms will reflect their own underwriting criteria, risk assessment, and portfolio strategy. This guide helps you reconcile the two by preparing a structured evidence checklist, understanding where differences arise, and knowing what information to gather before a formal lender submission.
Build your own financing analysis scenario
Start by recording your property's current financial data in a single workpaper. This is your baseline, not a lender commitment. Label each input clearly: purchase price, expected rehab costs, stabilized occupancy, and projected rent growth. The calculator uses these to produce an unreviewed scenario . Your task is to verify each assumption against actual property records before comparing it to any lender term sheet.
Prepare the evidence checklist
Create a spreadsheet or document with these line items. For each, record the source and date of the information. This becomes your reconciliation tool when a lender returns different figures.
Income and rent roll - Current rent roll: a snapshot of in-place leases, showing unit type, tenant, lease start/end, monthly rent, and concessions. - Trailing twelve months (T-12): actual historical income and expenses for the past 12 months, typically provided by the seller or property manager. - Compare the rent roll's gross potential rent to the T-12's actual collected income. The difference reveals collection loss, concessions, or vacancy that your scenario may have assumed away.
Operating expenses - T-12 expense categories: utilities, repairs, management fees, insurance, property taxes. - Identify any non-recurring expenses in the T-12 (e.g., a one-time roof repair) and adjust your pro forma to reflect normalized ongoing costs.
Net operating income (NOI) - Calculate NOI from the T-12: gross income minus operating expenses, excluding debt service. - Compare this to your scenario's projected NOI. If your scenario assumes higher rents or lower expenses, note the gap.
Capital expenditures (capex) - List recent and planned capital improvements: roof, HVAC, parking lot, unit renovations. - Record actual costs from invoices or contractor estimates. Your scenario's rehab budget should match these numbers.
Debt service - For an existing loan, record current principal, interest rate, payment, and maturity. - For a new loan, use your scenario's assumed rate and amortization to calculate annual debt service. - Compare debt service to the T-12 NOI. A lender will evaluate whether cash flow is adequate to meet debt service requirements [1].
Equity cash flow - Subtract annual debt service from NOI, then subtract any planned capex. The remainder is the cash flow to equity before taxes. - If this is negative, a lender may require additional sponsor equity or a lower loan amount.
Compare your scenario to lender underwriting factors
A lender's actual loan terms will depend on their evaluation of risk, not just your projected NOI. The OCC's Commercial Real Estate Lending handbook outlines several underwriting considerations that affect loan structure [1].
Debt service coverage - The OCC guidance describes that when reviewing credit files for income-producing properties, examiners assess the adequacy of cash flow to meet debt service requirements, commenting on trends in NOI, vacancy, and expenses [1]. Your scenario's DSCR may differ from the lender's calculation if they use different vacancy or expense assumptions.
Sponsor experience and equity - The OCC handbook states it is not prudent for a bank to extend unsecured working capital loans to fund a developer's equity investment or cover cost overruns, as overruns may be indicative of an undercapitalized project or inexperienced developer [1]. Be prepared to document your sponsor's track record and the source of equity.
Liquidity and loan type - CRE loans are ordinarily illiquid, and sales can be challenging due to variations in property type, location, tenant quality, and underwriting [1]. A lender may offer less favorable terms for a property type or location they consider harder to sell.
Identify gaps between your assumptions and lender data
After you have your evidence checklist and the lender's preliminary term sheet, compare each line item. Common gaps include:
Ask the actual lender specific questions
Rather than assuming what all lenders demand, prepare a list of questions for the lender you are working with. Based on the OCC's guidance, consider asking:
- What LTV ratio are you targeting for this property type and location?
- What minimum DSCR do you require, and how do you calculate NOI (e.g., do you use actual T-12 or a stabilized pro forma)?
- Do you have any restrictions on loan type, such as for land acquisition or speculative development [1]?
- What documentation do you need for sponsor equity and experience?
- Are there any supervisory loan-to-value limits that apply to this transaction [1]?
Reconcile and adjust your request
After gathering the lender's answers, update your scenario. If the lender requires a lower LTV, reduce your loan amount and recalculate debt service. If they use a higher vacancy rate, adjust your NOI. The goal is not to force your scenario to match the lender's, but to understand where differences come from and whether you can address them with better data or a different property.
Your reconciled analysis becomes the basis for a more informed financing request. This gives the reviewer the same data you used, reducing back-and-forth.
Frequently asked questions
How do I know if my T-12 is accurate? Compare the T-12 totals to bank statements and tax returns for the same period. Look for missing months or categories. If the seller provides the T-12, ask for the property management software report that generated it. Discrepancies should be noted in your workpaper.
What if my scenario shows positive cash flow but the lender says no? The lender may be using a different vacancy assumption, expense ratio, or debt service coverage minimum. Ask for their specific underwriting criteria. You may need to adjust your purchase price, increase equity, or find a property with stronger historical performance.
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).