Preparing a property-by-property sponsor track-record schedule
A practical guide to assembling a verified, lender-ready track record of your commercial properties, including a concrete evidence checklist and instructions for reconciling operating data.
A practical guide to assembling a verified, lender-ready track record of your commercial properties, including a concrete evidence checklist and instructions for reconciling operating data.
When a lender reviews a loan request, the sponsor's track record is one of the first things examined. A property-by-property schedule that is complete, consistent, and supported by source documents can distinguish a credible request from one that requires extensive follow-up. This guide explains how to prepare that schedule, what information to include, and how to present it so a lender can verify the claims quickly.
What a track-record schedule should contain
A sponsor track-record schedule is a single document listing every commercial property the sponsor (or the sponsor's key principals) has owned or managed during the past five to ten years. For each property, include:
- Property name, address, and property type (multifamily, office, industrial, retail, hospitality, or other)
- Ownership dates (acquired and disposed, or still owned)
- Gross leasable area and number of units
- Year built and any major renovation dates
- Original purchase price and total project cost
- Source of acquisition (market purchase, foreclosure, development, or other)
- Debt structure at acquisition and at disposition or present
- Brief description of the business plan executed (for example, value-add renovation, lease-up, repositioning)
- Key operating metrics for each year of ownership (occupancy, net operating income, debt service coverage ratio)
- Exit strategy and actual outcome (sale, refinance, or hold)
A suggested way to organize this information is to create a spreadsheet with one row per property and columns for each data point. This format allows the lender to scan the portfolio quickly and identify patterns in performance.
Why lenders review track records
Bank supervisory guidance from the OCC indicates that banks should maintain credit administration practices that include the request, receipt, verification, and maintenance of borrower and guarantor information [1]. A well-prepared track-record schedule demonstrates that the sponsor is organized and transparent, which can reduce the time a lender spends on due diligence.
Lenders use track records to assess: - Whether the sponsor has successfully executed similar business plans in the past - Whether the sponsor's properties have performed consistently over time - Whether the sponsor has experience with the specific property type and market - Whether any past properties experienced financial distress or foreclosure
A complete schedule also helps the lender evaluate the sponsor's overall portfolio, which is a separate underwriting consideration from the bank-level concentration risk addressed in supervisory review [1].
How to verify the information
Each data point on the schedule should be traceable to a source document. For operating metrics, the lender will expect to see rent rolls and trailing twelve months (T-12) of operating statements for each property [1].
A current rent roll is a snapshot of the property's occupancy and rent at a single point in time. A T-12 is twelve consecutive months of historical income and expense data. Before comparing totals from these two documents, note 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 over the past year. A property that is leasing up may have a high current occupancy but a low trailing twelve months of collected income.
To reconcile the two, compare the rent roll's gross potential rent to the T-12's gross collected income. The difference should be explained by vacancy, concessions, bad debt, or timing of move-ins. This reconciliation is a common area where lenders find discrepancies.
Distinguishing key operating metrics
When preparing the schedule, be precise about which metric is being reported. Common terms include:
- Gross rent: The total contractual rent from all leases, before any deductions
- Collected income: The amount actually received from tenants, after vacancy, concessions, and bad debt
- Net operating income (NOI): Collected income minus operating expenses, before debt service
- Capital expenditures (capex): Funds spent on improvements that extend the property's useful life, not routine repairs
- Debt service: The total of principal and interest payments on the loan
- Equity cash flow: NOI minus debt service and capex reserves
Lenders commonly evaluate NOI and debt service coverage as part of cash flow analysis, and the OCC handbook notes the importance of assessing the adequacy of cash flow to meet debt service requirements [1].
Documenting the business plan and outcome
For each property, describe the original business plan and the actual outcome. This is where the track record becomes more than a list of numbers. For example, if the plan was to renovate and increase rents, show the before-and-after metrics. If the property was sold, show the sale price and the return on investment.
If a property experienced financial difficulty, include a brief explanation and what was learned. Lenders generally view transparency about past challenges as a positive indicator of sponsor judgment.
What to include for properties still owned
For properties the sponsor still owns, include current rent roll, trailing twelve months of operating statements, and a pro forma projecting future performance. The pro forma should clearly state the assumptions behind it, such as expected rent growth, vacancy rates, and expense increases [2].
A suggested way to present this information is to attach a separate page for each owned property with the supporting documents listed in a summary table. This makes it easy for the lender to verify the numbers without flipping through multiple files.
Evidence checklist for the track-record schedule
Before submitting the schedule, verify that each item below is complete and matches the source documents:
- [ ] Property name and address match the deed or title report
- [ ] Ownership dates match the closing statement or public records
- [ ] Purchase price and total project cost match the settlement statement and construction budget
- [ ] Gross leasable area and unit count match the appraisal or rent roll
- [ ] Occupancy percentages match the rent roll for each reported period
- [ ] NOI figures match the T-12 operating statements for each reported year
- [ ] Debt service coverage ratios are calculated using the actual loan payments, not the pro forma
- [ ] Business plan descriptions are consistent with the property's actual performance
- [ ] Exit outcomes (sale price, refinance terms) are supported by closing statements or loan documents
- [ ] For properties still owned, the current rent roll date and T-12 period are clearly labeled
This checklist is a suggested way to prepare information. It is not a mandatory lender process, but following it can reduce follow-up questions.
How the track record affects the financing discussion
The track-record schedule is not just a historical document; it directly influences the terms a lender may offer. A sponsor with a consistent record of executing business plans and maintaining adequate debt service coverage may be viewed as lower risk. Conversely, a schedule that shows frequent distress or incomplete information may lead to more restrictive covenants, higher reserves, or a lower loan-to-value ratio.
Lenders also use the schedule to evaluate the sponsor's capacity to manage additional debt. If the sponsor already has several properties with high leverage, the lender may consider the overall portfolio risk before approving new financing [1].
Frequently asked questions
How far back should the track record go?
A suggested timeframe is five to ten years, or the length of the sponsor's career in commercial real estate, whichever is shorter. Include every property owned or managed during that period, even if the outcome was not favorable. Omitting a property that later appears in a credit report can damage credibility.
What if I don't have all the source documents?
Identify which documents are missing and note the gap in the schedule. For example, if the T-12 for a property sold three years ago is unavailable, state that. Lenders may accept estimates from comparable properties, but the estimate should be clearly labeled as such. A gap in documentation does not automatically disqualify a sponsor, but it may lead to more conservative underwriting.
Should I include personal financial statements?
Yes, if the sponsor or a principal will be a guarantor on the loan. The OCC handbook includes verification of borrower and guarantor information as part of credit administration practices for banks [1]. Include personal financial statements for each guarantor, with supporting documentation such as tax returns, bank statements, and brokerage statements. The track-record schedule should cross-reference these statements to show the sponsor's total real estate holdings and liquidity.
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.
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).