How to Build a Rental Pro Forma a Lender Will Believe

A rental property pro forma forecasts income, expenses and cash flow under stated assumptions. Build it beside actual operating records so the reader can see what changes and why. Projected income is not evidence of what the property currently earns.

This guide works through a hypothetical six-unit rental, from $107,400 of potential income to about $9,366 of annual cash flow after debt service and a reserve. A separate short-term rental example shows why seasonal occupancy, cleaning charges and platform fees need their own lines. All dollar figures are illustrative US dollars, not market quotes or a lending commitment.

What a pro forma is for and who reads it

Before an offer, the pro forma helps you decide what the investment can support. During financing, it gives the lender a forecast to review against its own rules. After closing, it becomes a budget you can compare with actual performance.

Keep three columns conceptually separate: trailing actual results, your first-year forecast and a stabilized future case. A vacant unit that might lease at $1,600 is not currently collecting $1,600. If renovation or a lease expiration delays that rent, put the timing in year one and the fully achieved rent in the stabilized case.

For apartments above commercial space, the mixed-use valuation and vacancy example separates the two income schedules and follows improvements, commissions and missing rent month by month. It shows why a stabilized value and the cash needed before stabilization belong in separate calculations.

Do not label a model "lender approved" because its DSCR clears a number you found online. Loan sizing can also depend on value, borrower strength, liquidity, property condition and program rules. The OCC's Commercial Real Estate Lending handbook describes DSCR as NOI divided by annual debt service and discusses how cash-flow volatility affects the appropriate coverage. It does not give every rental one universal passing ratio.

How it works · illustrated

The six-unit example follows the same dollars through three stages. The ledger drawing is conceptual; the later bar shows the allocation to scale.

After vacancy and credit loss

$100,092

Effective income before operating expenses.

After operating expenses

$53,025

NOI before the mortgage and capital reserve.

After debt and reserve

$9,366

Annual cash flow before income tax, rounded.

Do not substitute revenue or NOI for the cash you can spend. The example assumes no initial repairs or additional cash reserve at closing; those would increase required equity.

Original RentalCalcs illustration · Hypothetical example, USD · Reviewed October 14, 2026. Conceptual artwork, not a monetary scale. Assumptions and sources appear in the adjacent worked example.

The income section: rents, other income, vacancy assumptions

Start with the rent roll and signed leases, then reconcile collections to the operating statements. Our seller rent-roll verification guide covers that evidence trail. Separate rent billed, cash received, concessions and unpaid balances so you do not treat all four as collected income.

Effective gross income = potential rent + other income - vacancy - credit loss - concessions

The example building has six units at $1,450 a month: 6 x $1,450 x 12 = $104,400 of gross potential rent. Add $3,000 of laundry and parking income. Assume vacancy is 6% of potential rent and credit loss is 1% of potential rent, with no separate concession allowance.

That produces $100,092 of effective gross income. Other income is assumed collectible as modeled; it receives no additional haircut in this illustration.

Vacancy and credit loss have different causes. An empty unit loses rent because it is not occupied; a delinquent occupied unit may generate a collection loss. Compare property history with relevant submarket evidence and document your selected assumptions. Simply taking the higher of two rates can be misleading when one source measures physical vacancy and another measures dollar loss. The vacancy-rate guide helps identify that distinction.

For proposed rent increases, attach comparable evidence and the expected start month. Set market rent from matched comps, not from the amount needed to meet your return target. The Fannie Mae Form 1007 illustrates the physical, location and lease-term evidence used in a single-family rent appraisal. A self-prepared comp sheet does not replace a lender-required appraisal.

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

Here is the first-year operating statement for the fictional six-unit building, built in 1978 and purchased for $700,000. The amounts are assumptions; the evidence column describes what you would obtain for a real property.

The result is $53,025 NOI, a 47.0% operating expense ratio against effective income and a 7.6% cap rate at the assumed $700,000 price. These totals remain useful even before expanding the full expense table. The percentage assumptions are not recommended budgets for every six-unit property. Use the expense-ratio comparison method to match the income denominator and included costs before applying a benchmark.

Taxes deserve both a backward and forward check. Keep the seller's bill as evidence of the current expense, then ask the assessor how a sale, exemptions and reassessment affect this property. The example's $12,600 is a hypothetical post-purchase estimate, not a rule that taxes everywhere equal purchase price times a fixed rate.

For insurance, get a quote covering your intended use and deductibles. For utilities, obtain available billing history with the owner's authorization and account for current rates and who will pay. Seller totals can cover a different time period, occupancy level or policy.

Repairs, turnover and capital projects need separate definitions. Low repair invoices may reflect good condition, owner labor, incomplete records or deferred work; investigate rather than assuming which explanation is true. Keep routine work out of the capital reserve if it is already in operating expenses. Use the capital reserve guide to connect major replacements with inspection findings and remaining useful life.

Show a market management cost even when you plan to self-manage, as a comparison of the property's economics with paid operation. A separate owner-operated case can show the cash fee avoided and work retained. Ask the lender which cost it will underwrite; do not assume your unpaid labor eliminates its allowance.

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

Debt payments and the capital reserve come after NOI in this model. Tax depreciation is not a cash operating expense here. Closing costs and initial renovations belong in the acquisition and equity schedule, rather than quietly disappearing because they are outside NOI.

The loan uses standard monthly amortization: monthly rate 7% / 12 and a 25-year term. The annual debt payment is about $41,559. If the quoted payment includes tax and insurance escrow, separate those amounts before subtracting debt service; they are already in operating expenses above.

NOI-based DSCR is 53,024.64 / 41,558.62, or 1.28. If the lender's numerator subtracts this $2,100 reserve first, the ratio is 1.23. Show the lender's definition alongside yours and use its actual coverage requirement. A 1.25 cutoff would separate these two calculations, but it is an assumed cutoff for comparison, not an eligibility promise.

Cash-on-cash return is about 4.2% on $224,000 invested: $210,000 down plus $14,000 closing costs. This simplified equity amount assumes no initial repairs or extra funded reserve at closing. Add them to the denominator when they apply. Principal reduction builds equity but is not cash available to spend this year. For a smaller rental, use the single-family calculator to carry the same separation into the decision.

What an optimistic pro forma can hide

The original example can also be modeled with just 3% total rent loss, the seller's $9,800 tax bill, $3,000 of repairs and no management, turnover or administrative expense. That produces $76,108 NOI and 1.83 DSCR on the same loan.

Both are forecasts. Neither column tells you what the building will certainly earn. The more useful model makes every adjustment visible so inspection, quotes and collection records can confirm or change it.

For a smaller property's local application, the San Diego owner budget and lease-start calendar separates an annual condo forecast from the cash needed before receipts begin. It also shows why local fees and HOA-covered costs require their own source records.

Building an STR pro forma from nights and payouts

A short-term rental pro forma needs the same income-to-cash structure, with different operating inputs. Build revenue month by month or by clearly defined seasons. Record calendar nights, blocked nights, bookable nights, booked nights, average daily rate and average stay. A booked calendar can include owner use or maintenance blocks, so availability alone does not prove paid occupancy.

This separate hypothetical property has 365 calendar nights and 35 blocked nights, leaving 330 bookable nights. The seasonal buckets below total those 330 nights; the blocked nights are already excluded. Rates are accommodation revenue before cleaning charges and platform fees.

Those 192 paid nights equal 58.2% of bookable nights but only 52.6% of calendar nights. Label the denominator whenever comparing occupancy figures. The weighted average rate is $36,960 divided by 192, not a simple average of the three seasonal rates.

Assume four nights per stay, or 48 stays, with a $100 cleaning charge and a $100 cleaning bill per stay. Cleaning adds $4,800 to guest charges and the same amount to operating costs. It still loses money after a platform fee applied to that cleaning charge.

Airbnb's fee guidance describes a transition to a single host fee, with most single-fee hosts paying 15.5% and exceptions. Older bookings can retain their earlier fee structure. Check the fee on the actual reservation or account; do not hard-code a universal 3% or 15.5% assumption. Our illustration uses 15.5% of accommodation plus host cleaning charges, with no separate co-host deduction or fee tax added.

The base case already loses about $605 after debt and reserves. The downside loses about $5,224. In the sensitivity, booked nights and cleaning turns both fall 20% at the same seasonal rate mix; fractional expected stays are acceptable in a forecast, not a literal booking schedule. Fixed operations and maintenance do not fall. Replace those simplified costs with quotes and a month-by-month budget.

No guest service fee or platform-remitted occupancy tax is counted as owner revenue in this model. Record any taxes you must collect and remit separately.

Verify permitted use, licensing, insurance and local obligations before underwriting the strategy; start with our short-term rental legality guide. Compare the result with the same property's annual-lease alternative using the short-term versus long-term rental guide. The six-unit example above is a different property and is not that comparison.

The assumptions page: rates, growth, and exit

Keep each assumption beside its source date, owner and next verification step. A conservative guess is still a guess; label it as provisional instead of calling it sourced.

Growing year-one NOI of $53,024.64 by 3% for ten increments gives about $71,261 of year-11 NOI. Dividing that by 8% gives a hypothetical gross sale price of about $890,759. This is before selling costs, the remaining loan, taxes and any required work. It is not net equity proceeds or a property appraisal.

Stress the first year as well as the exit. At an 8% loan rate with the same $490,000 balance and 25-year amortization, annual principal and interest rises to about $45,383 and NOI-based DSCR falls to 1.17. If the actual loan is fixed at 7%, this is a financing or refinancing scenario, not a prediction that next year's payment changes.

The St. Louis owner-budget example separates the stabilized annual forecast from inspection, make-ready and cash needed before the first receipts.

Package it for the lender

Ask for the lender's checklist and model definitions first. Then assemble a concise summary, the forecast beside trailing actual results, the verified rent roll, supporting source documents, an assumptions register and the downside cases. Include the acquisition cash needed and remaining liquidity, not just a return percentage.

The pro forma evidence worksheet provides a blank register for the amount, source date, actual-versus-forecast status and remaining verification. It also separates NOI, reserves, debt service and cash invested so the same cost is not counted twice.

For the six-unit case, build the operating model in the multifamily calculator, replacing provisional inputs as documents arrive. Keep source documents with any exported analysis; a PDF of a forecast cannot verify its assumptions by itself. The useful end product is a model another reader can reconstruct and challenge, with uncertainty visible before a loan or purchase decision.