How to Build a Rental Pro Forma a Lender Will Believe

A pro forma is a one-year forecast of a property's income, expenses and cash flow, usually extended across the planned hold. Anyone can type optimistic numbers into a template. What separates a pro forma a lender believes from one a lender ignores is sourcing: every line traces to a document or a stated, defensible assumption.

The example in this post is a six-unit building. The broker's version shows an NOI of $76,108 and a 1.83 DSCR. The sourced version shows $53,025 and 1.28. The lender will arrive at something close to the second figure no matter which one you hand over, so the only open question is whether you look like a borrower who knew that already.

What a pro forma is for and who reads it

The pro forma does two jobs. Before the offer, it is your own decision tool: it tells you what the property is worth to you and what loan it can carry. After the offer, it is a persuasion document aimed at people who are paid to doubt it.

Lenders discount investor projections because most of the ones they see are sloppy in the same direction: rents at the top of the market, no vacancy, no management fee because the buyer plans to self-manage, the seller's old tax bill, and a repair budget that would not cover one water heater. An underwriter who finds one of those rebuilds the file with the lender's own assumptions and trusts nothing else in it. A sourced pro forma gets read differently. When the underwriter's rebuild matches yours, the conversation moves on to terms.

The income section: rents, other income, vacancy assumptions

Income has four lines, and the structure matches how the calculators compute it:

Effective Gross Income = Gross Potential Rent + Other Income - Vacancy - Credit Loss

Gross potential rent. Source: the rent roll, backed by the signed leases. Enter occupied units at their lease rent. If you plan to raise rents, show that as a separate, dated step with comparable listings attached, and keep year one close to in-place rents. A lender sizes the loan on what the building collects now. The process for testing a rent roll against leases and deposits is in verifying seller rent rolls.

Other income. Source: the trailing 12 months of statements. Laundry, parking, storage and pet rent count at the level the property has collected. Income you hope to add later belongs in a later year, labeled as a plan.

Vacancy. Source: two numbers side by side. The first is the property's own history from the trailing 12 months. The second is submarket vacancy from a published source such as census rental vacancy data, a brokerage market report or a local apartment association survey. Use the higher of the two as your base case. Expect the lender to apply a floor, commonly 5%, even when the building is full.

Credit loss. Source: the delinquency column of the trailing statements. If the seller cannot show collections separately from billings, that gap is a finding in itself.

The expense section: every line and where to source each number

Here is the year-one pro forma for the example: a six-unit building from 1978, purchase price $700,000, all units at $1,450 a month. Every figure is an example. The source column is the part to copy.

Operating expenses are 47% of effective gross income. The cap rate at $700,000 is 7.6%.

A few of those sources deserve a closer look.

Property taxes come from the assessor, never from the seller's bill. Ask how a sale affects assessed value in that jurisdiction, then compute the tax on the value you expect after closing. In the example the seller pays $9,800 on an old assessment, and the post-sale figure is $12,600.

Insurance comes from a quote on your own policy. The seller's premium reflects a different owner, a different year and sometimes a blanket policy across several properties.

Utilities come from the provider. Many utilities will release billing history for an address with the owner's authorization. Two years is better than one because it catches a leak or a rate change.

Repairs come from invoices, then get a second check against a per-unit figure for a building of that age. When the invoices show far less than the cross-check, the likely explanation is deferred maintenance, and your inspection should confirm it.

Management goes in at a quoted fee even if you will do the work. The lender will add it regardless, because the lender's question is what the property earns if someone else has to run it.

Below the line: debt service, capex reserves, cash flow

NOI ends the operating statement. Three more items get you to the cash you keep.

DSCR = NOI / Annual Debt Service, so $53,025 divided by $41,559 is 1.28. With $210,000 down and an example $14,000 of closing costs, cash invested is $224,000 and cash-on-cash return is 4.2%.

Know how your lender defines the ratio. Lenders commonly require a minimum DSCR of 1.20 to 1.25, and many of them subtract a replacement reserve from NOI before computing it. Done that way, the example's NOI after reserves is $50,925 and DSCR is 1.23. A deal that clears 1.25 by your math can miss it by the lender's. Ask for the lender's definition before you submit, and show the ratio their way.

Now compare the broker's version of the same building.

The $23,083 difference in NOI is the distance between a loan request that sails through on paper and one that barely qualifies. The building will perform like the right-hand column either way.

For one to four units the mechanics differ. Conventional lenders underwrite the borrower's personal income and commonly count 75% of the rent toward it, while DSCR loans size from the property much as a commercial lender does. The pro forma still does its first job, which is telling you the truth about the deal. The single family calculator follows the same income and expense structure for those properties.

The assumptions page: rates, growth, and exit

Year one is mostly documents. Years two through ten are mostly assumptions, so put them all on one page where a reader can challenge them.

Two rules keep this page credible. First, every assumption is either sourced or conservative, and you say which. Second, growth never does the heavy lifting. If expenses grow slower than rents in your model, NOI margins widen every year by assumption alone, and an underwriter will spot it.

The exit works the same way. Year-one NOI of $53,025 growing 3% a year gives a year 11 NOI of $71,261, and at an 8.0% exit cap the projected sale price is $890,765. Setting the exit cap above the going-in cap says you are not counting on the market to pay more per dollar of income in ten years than it pays today.

Add one stress line. At an example 8% rate, debt service on the same loan rises to $45,383 and DSCR falls from 1.28 to 1.17. Showing that you ran the downside case yourself is worth more to a credit committee than a rosier base case.

Package it for the lender

A complete package, in the order an underwriter reads it:

1. A one-page summary: property, price, loan request, year-one NOI, DSCR by the lender's definition, cash invested and your reserves after closing.
2. The year-one pro forma next to the seller's trailing 12 months, with a short note on every line where the two differ and why.
3. The rent roll and lease abstracts, with your verification notes.
4. The source documents: assessor printout, insurance quote, utility history, management proposal, contractor bids, inspection summary.
5. The assumptions page.
6. The ten-year projection with the exit and the stress case.
7. Your side of the file: personal financial statement, schedule of real estate owned, proof of liquidity and a short summary of your experience.

Practical next steps: build year one in the multifamily calculator, entering the seller's numbers first and then replacing each line as its document arrives. Keep a running list of lines still unsourced, and do not submit until it is empty or each remaining item is labeled as an assumption. When the analysis is done, Pro's PDF export turns it into the lender-ready package described here, with every assumption documented on the page, so the underwriter sees the numbers and the reasoning in one file.