Preparing a unit completion tracker for an apartment business plan
A unit completion tracker helps a sponsor show a lender how renovation and lease-up will actually progress, unit by unit, and how that progression supports the loan repayment structure.
A unit completion tracker helps a sponsor show a lender how renovation and lease-up will actually progress, unit by unit, and how that progression supports the loan repayment structure.
When a commercial real estate sponsor plans to renovate and lease up an apartment property, a lender will typically want to see more than a total renovation budget and a projected stabilized occupancy. The lender will expect periodic reports that show how units are being completed, when they are ready for lease, and how the loan is being repaid as units are finished and occupied. A unit completion tracker is a workpaper that can help organize that information.
This guide explains what a unit completion tracker should contain, how it supports the financing discussion, and how to prepare one for a lender. The focus is on a bridge or construction loan for an apartment renovation and lease-up.
What a unit completion tracker is and why it matters
A unit completion tracker is a document, typically a spreadsheet, that lists every unit in the property and tracks its status through renovation, lease execution, and occupancy. For a lender, this tracker is a monitoring tool. [1] explains that for multiple-unit developments, banks typically require periodic reports that identify each unit by number, its state of completion, release and offering prices, loan balance, selling price, and dates of sale or contract. For an apartment, the lender may want to see similar detail for each unit, including lease execution and occupancy, though the release price structure for a lease-up may differ from a sale.
The tracker helps the lender understand how the loan will be repaid. [1] describes how construction loans for multiple units are structured with release prices: the amount the bank requires to release its lien on a unit when it is sold. For an apartment, the loan repayment structure may be tied to units being leased and the loan being paid down from lease proceeds or a refinancing, but the release price concept in [1] is specifically for sales of units. The tracker shows the lender how many units need to be completed and leased to pay off the loan, and over what period.
What to include in a unit completion tracker
Suggested columns for the tracker:
- Unit number or identifier
- Unit type (one-bedroom, two-bedroom, etc.)
- Square footage
- Renovation scope (cosmetic, full gut, etc.)
- Renovation start date
- Renovation completion date
- Lease execution date
- Lease start date
- Monthly rent
- Security deposit
- Release price (if applicable)
- Loan balance allocated to that unit
- Cumulative loan balance paid down
You can add columns for notes on any delays or special conditions. The tracker should be updated monthly and shared with the lender as part of the regular reporting.
How the tracker connects to the loan repayment structure
[1] describes how lenders use acceleration to ensure the loan is repaid before all units are sold. For an apartment, the same concept applies: the lender may require that a certain percentage of units be leased and the loan paid down to a certain level before the full loan is repaid. The tracker shows the lender how many units need to be completed and leased to meet that acceleration target.
How to prepare the tracker for a lender
- List every unit in the property, even those not being renovated. Include units that are already occupied and those that will be renovated later.
- For each unit, record the current status: pre-renovation, in renovation, post-renovation, leased, or occupied.
- Estimate the renovation timeline for each unit: start date, expected completion date, and any dependencies (e.g., units on the same floor must be done together).
- Estimate the lease-up timeline: when each unit will be available for lease, expected rent, and any concessions.
- Calculate the cumulative loan paydown: for each unit that is leased, apply the release price or a portion of the loan balance to show how the loan is being repaid.
- Review the tracker with the lender to confirm the release price structure and any acceleration requirements.
How the tracker supports the financing discussion
The tracker is not just a reporting tool; it is a planning tool that helps the sponsor and lender agree on the loan structure. [1] notes that the expected absorption rate is an important consideration when establishing limits on construction of speculative units. For an apartment, the absorption rate is the number of units leased per month. The tracker can help the lender assess the expected absorption rate and whether it supports the loan term and repayment schedule, though [1] notes that absorption rate is an important consideration when establishing limits on construction of speculative units.
If the tracker shows that units will be completed and leased faster than expected, the lender may consider adjusting the loan structure, but [1] does not specify that a shorter term or lower leverage would result. If the tracker shows a slower absorption, the lender may require a longer term or higher release prices to ensure repayment.
What the tracker does not do
The tracker is a planning document, not a guarantee. Actual renovation and lease-up may differ from the plan. The lender will want to see that the sponsor has a realistic plan and the capacity to execute it. The tracker helps the lender assess the sponsor's understanding of the project and the risks.
[2] explains that bridge lenders look closely at the business plan and leasing assumptions. The tracker is part of that business plan. It shows the lender how the property will reach stabilized occupancy and how the loan will be repaid.
How to use the tracker during the loan term
Once the loan is in place, the tracker becomes a monitoring tool. [1] recommends that banks obtain periodic reports of the project's progress compared with budgeted projections. The tracker should be updated monthly and shared with the lender. The lender will compare actual progress to the plan and may adjust the loan structure if there are significant deviations.
If the tracker shows that units are being completed faster than expected, the lender may agree to release more units or reduce the release price. If the tracker shows delays, the lender may require additional reserves or a longer term.
How often should I update the unit completion tracker?
Update the tracker monthly, or more frequently if the lender requires. The tracker should reflect the current status of each unit, including renovation progress, lease execution, and occupancy. Share the updated tracker with the lender as part of the regular reporting.
What if the actual renovation timeline differs from the tracker?
Notify the lender as soon as you know about a delay or acceleration. The lender may adjust the loan structure, such as extending the term or changing release prices, based on the new timeline. The tracker is a living document that should be revised as the project progresses.
Does the tracker replace the need for a feasibility study or market analysis?
No. The tracker is a planning tool for the specific property. The lender may still require a feasibility study or market analysis to support the absorption assumptions. [1] notes that for condominium projects with fewer than five units per building, the bank may rely on appraisals of individual units if supported by a feasibility study or market analysis. For larger projects, the lender will want both the tracker and a market study.
Suggested next step
If you are preparing a unit completion tracker for a specific apartment renovation and lease-up, send the property address, the business plan, and the amount and timing of the financing you need. We will tell you how we would approach it.
It is not a lender and does not make loans or loan commitments. All financing is subject to the lender's underwriting and approval. 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).