Due diligence - the financials

The most expensive number in a real estate deal is often technically correct.

It is just correct for the wrong period, before the missing invoice, under the old tax bill, with a management fee of zero because the seller managed it personally. Then somebody applies a cap rate and sends the mistake to closing dressed as value.

Financial due diligence rebuilds the property’s economic history from records that were not created to sell the property. The point is not to catch a villain. The point is to separate what happened, what can be proved, and what your ownership will probably cost.

A spreadsheet can organize evidence. It cannot promote itself to evidence.

Every dollar needs three passports

Label every important number before you trust it:

1. Reported: what the seller’s operating statement says.
2. Verified: what leases, tenant ledgers, bank deposits, invoices, payroll, and other source records support.
3. Underwritten: what a prudent buyer expects after correcting timing, omissions, new ownership costs, and the actual operating plan.

These are different currencies. Do not add them together just because Excel accepts the formula.

For income, the rent roll shows what residents are scheduled to pay. The tenant ledger shows what management posted. The bank statement shows what arrived. The delinquency report shows what did not. A signed lease without cash is a receivable, not a mortgage payment.

For expenses, a low repair line can mean excellent maintenance. It can also mean unpaid vendor bills, deferred work, owner labor, or capital spending parked outside the operating statement. “Cheap” describes the number. “Complete” describes the diligence.

Four adjustments send a $660,000 bill

Take a hypothetical 40-unit property with this reported trailing twelve months:

Reported item	Amount
Collected rent and other recurring income	$564,000
Operating expenses	($354,000)
Reported NOI	$210,000

At a 6.50% capitalization rate, $210,000 implies a value of about $3.23 million. That is the number the sales package wants framed.

Then the source records get a vote:

• The county’s current assessment and published tax process support an $18,000 increase after sale.
• The current insurance renewal indication is $14,000 above the expired policy cost in the T-12.
• The seller charged no management fee. At 3% of $564,000, the buyer needs $16,920 in the operating budget.
• A $6,000 legal bill was genuinely nonrecurring and can be removed.

Normalized NOI becomes:

$210,000 - $18,000 - $14,000 - $16,920 + $6,000 = $167,080

At the same 6.50% capitalization rate, that supports about $2.57 million. The difference is roughly $660,000.

No disaster occurred. Four ordinary ledger lines were forced to show identification. That is enough to change price, loan proceeds, required equity, reserves, and the decision to close.

The cap-rate math is an illustration, not an appraisal. The lesson is the chain of support. If a dollar changes value, find its receipt before you admire its multiplication.

Rebuild income from the deposit backward

Inspect current and historical rent rolls, executed leases, concessions, security-deposit ledgers, delinquency and bad-debt reports, receivables, and bank statements. Match occupied units to leases. Match charges to the tenant ledger. Match posted collections to deposits.

Then separate recurring income from one-time charges. Laundry, parking, storage, utility reimbursements, pet charges, and commercial income should each have an agreement, rate, or operating record behind them. “Other income” is not a business line. It is a drawer where unsupported dollars go to avoid questions.

Do not stop when the annual total ties. Review it by month and by unit. A deposit can reconcile for the year while hiding a concession program, a collection slide, or cash that arrived late enough to matter.

Make every expense produce a receipt

Pull the transaction-level general ledger, accounts-payable aging, invoices, contracts, payroll registers, utility bills, tax bills, insurance policies and renewal indications, loss runs, management agreements, and capital records.

Match the largest entries to invoices and bank disbursements. Compare monthly patterns and usage, not just totals. Water expense that falls 40% for one quarter deserves a question. Repairs that vanish immediately before marketing deserve an invoice search.

Where available, compare property statements with tax returns, debt statements, and reserve accounts. The IRS requires records supporting Schedule E items. A tax return and a sale package do not have to present every item identically, but a material mismatch needs a written explanation from someone qualified to give it.

One more trap: work performed by the owner, a related company, or an employee can be economically real even when the property ledger shows no market-rate charge. Ownership changes. The work sends its invoice to you next.

The T-3 can be a very flattering witness

A weak property can look cured when someone annualizes its best three months and leaves the other nine outside the room.

Maybe concessions briefly lifted collections, repair invoices lagged, and seasonal utilities fell. Multiply that T-3 by four and the annual result looks handsome. You have not found stabilized operations. You have purchased a cropped photograph.

The cousin of that trick is the add-back parade. Payroll, repairs, marketing, or management gets called “one-time” because the buyer plans to operate differently. Fine. Show the contract termination, invoice history, operating change, and replacement cost. A cost rarely disappears; it changes account numbers and waits for the buyer.

An add-back without evidence and a replacement assumption is a withdrawal from the credibility account.

When the records argue, stop taking averages

Slow the deal down when:

• bank deposits do not reconcile to reported collections;
• occupied units lack executed leases or material lease terms differ from the rent roll;
• concessions appear in leasing reports but not in the operating statement;
• accounts payable are old, large, or absent from the seller’s expense story;
• payroll excludes people visibly doing property work;
• insurance uses an expired cost instead of a current indication;
• taxes use the seller’s bill without analyzing reassessment rules;
• repairs collapse immediately before the property goes to market;
• utility usage and billed occupancy tell different stories; or
• management cannot produce a transaction-level general ledger.

Missing support is not proof of fraud. It is proof that the number remains unverified. Give uncertainty its own line instead of laundering it through an average.

Questions that make the file answer in dollars

• Which deposits support the last three months of reported rental collections?
• What share of receivables is more than 30, 60, and 90 days old?
• Which residents received concessions, payment plans, or credits not yet posted?
• Which invoices have been incurred but remain unpaid?
• What work was deferred during the last twelve months, and where is it documented?
• Which employees, owner resources, or related companies provided work below market cost?
• Which expense resets first after closing: taxes, insurance, payroll, utilities, or contracts?
• For each proposed add-back, what record proves the cost ended, and what replaces the work?

Route unresolved issues to the property manager, lender, insurance broker, tax professional, or attorney qualified to resolve them. Diligence is not improved by guessing in a more confident font.

Build the ten-line reconciliation before discussing price

Choose the five largest income lines and five largest expense lines. Give each four columns: reported amount, source document, buyer adjustment, unresolved question.

Reconcile those ten lines before negotiating from the seller’s NOI. Do not average away a missing bank deposit or a current insurance quote. Price follows supportable cash flow. The sales summary follows the seller’s instructions.

Current authoritative references

• Fannie Mae Multifamily Selling and Servicing Guide, including its current treatment of rent rolls, concessions, vacancy, and underwritten net cash flow.
• Freddie Mac Multifamily Seller/Servicer Guide, Chapter 40, which identifies current rent rolls and property income-and-expense statements among required operating records.
• IRS 2025 Instructions for Schedule E, including the recordkeeping requirement for reported rental income and expenses.
• IRS Publication 527, Residential Rental Property, for federal rental-income and expense categories. Tax treatment is fact-specific; use a qualified tax professional for the actual return.