How to Build a Conservative Pro Forma for a Minnesota Rental

What 'Conservative' Actually Means in a Pro Forma

A conservative pro forma is not a pessimistic one. It is a model that survives the scenarios you can reasonably expect, with margin for the ones you cannot. For Minnesota rentals, that means accounting for seasonality, winter operating costs, and the reality that the early ownership period of ownership often looks different from the trailing twelve months the seller hands you.

The test of a conservative pro forma is not whether it produces a good number. It is whether the number it produces is still acceptable when one or two assumptions move against you.

Start From Verified Income, Not Listing Income

Begin with current in-place rents from actual leases, not the listing's projected rents. If a unit is vacant, use a rent range that a property manager who works in that ZIP code will confirm based on current condition. Build a separate line for any rent increase you plan to take, and only credit that increase in the year you can realistically execute it.

Minnesota landlord-tenant rules around notice and lease renewal mean rent changes often lag the calendar. Confirm timing with a property manager or a real estate attorney rather than assuming an immediate bump.

Use a Planning Vacancy, Not a Marketing Vacancy

Vacancy in a pro forma should reflect turnover time, marketing time, and the gap between leases, not the listing's optimistic assumption. Include the time required to make a unit rent-ready between tenants. For Minnesota properties with winter turnovers, include realistic lease-up time in the slower months.

Use vacancy as a planning number that protects the model, not a forecast of what the property will actually do. If reality is better, that is upside.

Build Operating Expenses From the Bottom Up

Pull the seller's trailing twelve months as a starting point, then rebuild each line from your own sources. Property taxes will likely be reassessed after sale; confirm the likely range with the county assessor's office for that municipality. Insurance should be quoted by a Minnesota landlord insurance agent for your ownership entity, not estimated from the seller's policy.

Utilities the owner pays should be pulled from actual bills, not averages. For older Twin Cities duplexes with shared meters, this matters. Snow removal, lawn care, and trash should reflect actual quotes from vendors who work that neighborhood.

Model Maintenance and Capital Reserves Separately

Operating maintenance, the small repairs that happen every year, belongs on the operating line. Capital reserves, the funds you set aside for roof, mechanicals, siding, windows, and major plumbing, belong on a separate line below operating income.

Use a reserve range based on the property's age and the condition you observed. A 1920s Minneapolis duplex with original windows and a 20-year-old roof carries a different reserve profile than a 1995 suburban single-family. Build the reserve into the model rather than hoping it does not come due.

Stress-Test With Conservative, Moderate, and Optimistic Scenarios

Run three scenarios on the same model. Conservative uses lower rents, higher vacancy, higher expenses, and a near-term capital event. Moderate uses your central estimates. Optimistic uses the seller's numbers. The decision is not which scenario you believe; it is whether the property still works in the conservative case.

If the property only pencils in the optimistic case, the model is telling you that the price assumes everything goes right. That is rarely a defensible underwriting position.

Layer in Financing Without Cherry-Picking Terms

Use financing terms a lender has actually quoted you for this property, not the most aggressive case you have seen for someone else. Confirm rate, points, reserves required, and any seasoning rules with your lender. Underwrite a slightly higher rate than your quote to leave margin if the lock moves.

Do not model a refinance into a better rate as part of the base case. Model it as upside. If the base case only works after a future refinance, the model is depending on something outside your control.

Translate the Model Into a Go or No-Go Decision

Once the conservative scenario is built, compare the resulting cash flow and cash-on-cash to your strategy memo. If conservative cash flow is positive and your reserves are funded, the property clears the financial gate. If conservative cash flow is negative, the property may still be worth buying for appreciation or repositioning, but you are buying a non-cash-flowing asset and your strategy needs to reflect that.

Walk through the model with your lender, your CPA, and your property manager before writing. Each of them will catch assumptions you missed. That review is part of what makes the pro forma conservative.

Validate the Model With a Property Manager Before Writing

A property manager who places tenants and handles maintenance in that submarket will catch model errors faster than almost any other adviser. Share the full operating model with them and ask which lines they would change. They will often adjust rent, turnover, maintenance, and management lines in ways that move the conservative scenario.

The goal of the conversation is not to win the conservative argument; it is to find out where your assumptions diverge from someone who works that market every week. Their feedback usually makes the model more accurate without making it more optimistic.

Confirm the Model With Your Lender Early

Walk the model through with your lender before you write the offer. Lenders evaluate properties on their own metrics, and a model the lender finds defensible is more likely to produce financing on the terms quoted. Differences between your numbers and the lender's typically surface in expense assumptions, vacancy assumptions, and reserve requirements.

Resolving those differences early prevents late-stage financing surprises that would otherwise force a re-pricing or a re-trade during the inspection period.

Save the Model and Revisit It Annually

After closing, keep the original conservative pro forma. Each year, compare actual results to the conservative, moderate, and optimistic scenarios. Properties tend to track one of the three more closely than the others, and over time you learn which assumptions in your modeling are reliable and which need to be adjusted on the next deal.

This discipline turns underwriting from a one-time exercise into a feedback loop. The next pro forma is better than this one because the last pro forma had a scorecard.

Use the Pro Forma to Decide What Not to Buy

The most useful pro formas are the ones that lead to a 'no.' A conservative model that does not pencil is telling you something specific: the price assumes conditions that may not hold, the property carries capital risk the deal cannot absorb, or the rent assumption requires a market that does not yet exist.

Walking away from a deal because the conservative model fails is harder than it sounds. The optimistic model usually looks attractive, and there is always a story for why the optimistic case will arrive. The discipline is in trusting the conservative model anyway.

Over time, the pro formas that led to walks become as valuable as the ones that led to purchases. They build a record of what your underwriting protected you from, which strengthens the discipline for the next round. Investors who can defend their walks are usually also the ones who can defend their buys.

Keep the Pro Forma Current Through the Hold

After close, refresh the pro forma periodically with actual rents, actual expenses, and updated capital reserve estimates based on what has been done and what remains. The refreshed model informs hold-versus-sell decisions, refinance timing, and capital allocation across the broader portfolio. A live model is more useful than a static one that stops mattering the day after the close.

Reconcile Seller Numbers Against Your Own Operating Model

Seller-supplied numbers are a starting point, not a substitute for your own operating model. When you receive a rent roll, expense summary, or pro forma from the listing side, rebuild it in your own spreadsheet line by line instead of copying it. For each line, ask whether the figure looks consistent with what you would expect for a property of this age, condition, and submarket. Where a seller number looks optimistic, replace it with a more conservative assumption and note the reason. Where a seller number looks reasonable, keep it but flag it for verification with a property manager, lender, or local operator. The goal is a side-by-side view that shows where your conservative pro forma diverges from the seller picture and by how much. That gap is often where the real negotiation lives, and it can also reveal whether the property fits your risk tolerance before you spend money on inspections.