Using an annual cash-flow table to explain an apartment business plan
This guide helps a sponsor prepare a single, clear annual cash-flow table that connects the property's business plan to the lender's debt-service analysis. It provides a concrete worksheet, explains how each line item affects the financing discussion, and distinguishes source facts from assumptions.
This guide helps a sponsor prepare a single, clear annual cash-flow table that connects the property's business plan to the lender's debt-service analysis. It provides a concrete worksheet, explains how each line item affects the financing discussion, and distinguishes source facts from assumptions.
Start with the lender's question: can the property pay back the loan?
The OCC Commercial Real Estate Lending handbook states that underwriting includes determining whether the borrower demonstrates the capacity to meet a realistic repayment plan from available cash flow and liquidity [1]. A lender wants to see that the property's net operating income (NOI) can cover annual debt service—principal and interest payments. Your annual cash-flow table is the document that shows this relationship clearly. It is not a tax return or a rent roll; it is a forward-looking, annual projection that connects your business plan to the property's ability to service debt.
Build a cash-flow table with these seven line items
Prepare a table in a spreadsheet with one column for each year of your business plan (typically 3-5 years). Each row is a line item. The table should flow from top to bottom, ending with the cash flow available for debt service and then showing the debt-service coverage ratio (DSCR).
Line 1: Gross potential rent. This is the total rent if every unit were leased at market rates. It is a starting point, not a promise. Identify the source of this number: is it from a rent comparability study, a broker opinion, or the current rent roll?
Line 2: Vacancy and collection loss. Record your assumed vacancy rate and any bad debt. A lender will compare this to market averages. The OCC handbook notes that an important objective of underwriting is to develop an NOI that represents a stabilized estimate of income and expenses [1]. Your vacancy assumption should be supportable, not optimistic.
Line 3: Other income. Include parking fees, laundry, pet rent, or any other source. Distinguish this from gross rent. A lender will ask if this income is recurring or one-time.
Line 4: Effective gross income (EGI). This is gross potential rent minus vacancy and collection loss, plus other income. It is the income you realistically expect to collect.
Line 5: Operating expenses. List each major category: property taxes, insurance, management fees, repairs and maintenance, utilities, and any other recurring cost. The OCC handbook warns that a tax return prepared on a cash basis may understate expenses if real estate taxes were not paid during that year [1]. Your table should use accrual-based estimates: record the expense when it is incurred, not when it is paid. Compare each line to comparable properties to check for reasonableness.
Line 6: Net operating income (NOI). This is EGI minus operating expenses. It does not include debt service, capital expenditures, or income taxes. The OCC handbook defines DSCR as NOI divided by annual debt service [1]. This is the key number a lender uses to measure repayment capacity.
Line 7: Capital expenditures (capex) and replacements. Record planned roof replacements, HVAC upgrades, or unit renovations. These are not operating expenses; they are investments in the property. A lender will want to see that you have accounted for these separately, because they affect cash flow but are not part of NOI.
Reconcile your table with the rent roll and T-12
A current rent roll is a snapshot of today's occupancy and rents. A T-12 is twelve months of historical operating data. Your cash-flow table is a forward projection. To make the table credible, reconcile it to these documents.
Rent roll reconciliation. Compare your gross potential rent to the rent roll. If the rent roll shows actual in-place rents lower than your projection, explain the gap. For example, if you plan to raise rents after renovations, show the timing and amount of the increase. The rent roll is evidence of current reality; your table is a plan to improve it.
T-12 reconciliation. Compare your operating expenses to the T-12. The OCC handbook notes that operating statements prepared on a cash basis can differ from accrual-based statements [1]. If the T-12 shows property taxes paid in one lump sum, but your table spreads them monthly, note the difference. If the T-12 includes an unusually high repair cost from a one-time event, flag it as non-recurring. A lender will look for consistency between historical data and your projections.
Explain how the table affects the financing discussion
The cash-flow table directly supports the lender's analysis of repayment capacity. The OCC handbook states that the primary focus of a commercial loan review is the borrower's capacity to repay, and that the review should assess cash flow from business operations on a global basis [1]. Your table shows the property's cash flow in isolation, but a lender will also consider your overall financial condition, including any contingent liabilities [1].
Debt-service coverage ratio (DSCR). Calculate DSCR by dividing NOI by annual debt service. The OCC handbook explains that the determination of an appropriate DSCR should consider the loan amortization period and the expected volatility of the cash flow [1]. A stable property with long-term net leases may support a lower DSCR than a value-add property with variable income. Your table should show the proposed loan amount, interest rate, and amortization period, then calculate the annual debt service and the resulting DSCR.
Global cash flow. The OCC handbook recommends that cash flows be assessed on a global basis, integrating cash flows from business financial statements, tax returns, and Schedule K-1 forms [1]. Your table is for the property only. A lender will ask for your personal financial statement and tax returns to see your total debt obligations. Be prepared to show how the property's cash flow fits into your broader financial picture.
Prepare a worksheet to support your table
Create a separate worksheet that lists each assumption in your cash-flow table and the source of the data. For example:
This worksheet shows the lender that your numbers are grounded in evidence, not guesswork. The OCC handbook states that underwriting includes determining whether the borrower demonstrates the capacity to meet a realistic repayment plan [1]. A worksheet with sourced assumptions supports that determination.
Frequently asked questions
What is the difference between NOI and cash flow available for debt service? NOI is EGI minus operating expenses. Cash flow available for debt service is NOI minus capital expenditures and income taxes. A lender will focus on NOI for DSCR, but will also ask about capex because it reduces the cash available to make loan payments.
Should I include income taxes in the cash-flow table? Yes, if the property is held in a taxable entity. The OCC handbook notes that realistic projections should include property and income taxes [1]. If the property is held in a pass-through entity, the tax liability flows to your personal return. A lender will ask for your personal tax returns to see the full picture.
How do I handle a property with a rent roll that is below market? Show the current rent roll in your reconciliation worksheet, then show your projected rents in the cash-flow table. Explain the plan to close the gap, such as renovations or lease expirations. A lender will want to see that the plan is realistic and supported by market data.
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).