The Financial Model Behind a Major Business Decision

One of the biggest misconceptions about financial forecasting is that it's supposed to predict the future.

It doesn't.

No financial model comes with a crystal ball.

What it does provide is a structured way to evaluate risk, test assumptions, and understand what needs to happen for a major investment to succeed.

Recently, I worked with a client through exactly that process.

The Opportunity

My client owns a successful medical practice that had reached capacity.

Every office was occupied, and she wanted to bring on additional practitioners. At the same time, she had another long-term goal: she wanted to own the building her business operated in. Owning commercial real estate can be a powerful way to build wealth while creating more stability for a growing business.

Her question wasn't simply, "Can I buy a building?" It was, "Can my business afford to?"

That's a very different question.

Starting with what we already knew

One reason this project was such a good fit for financial modeling is that we weren't starting from scratch.

The business already had a proven model.

We had years of historical financial data, understood how the practice operated, and knew what a successful provider looked like. That gave us a much stronger foundation than trying to forecast a brand-new business with no track record.

The challenge wasn't figuring out whether the business worked. The challenge was understanding what expansion would look like financially.

Building the financial model

We met several times to work through every assumption before building the projections.

Some of those conversations focused on the financing itself:

• Loan terms

• Interest rates

• Down payment requirements

We also discussed the logistics of becoming both a business owner and a building owner. While I'm not a tax advisor or attorney, I recommended that she work with both professionals to determine the best ownership structure for the property. That included creating a separate entity for the building and understanding how the operating business would pay rent to that entity.

Once those pieces were in place, I built a month-by-month financial model showing what the expansion could realistically look like.

Looking beyond the purchase price

Buying the building was only one part of the equation. The bigger question was what would happen during the months that followed.

Before a single new patient walked through the door, there would already be significant cash flowing out of the business.

There was construction and build-out. Office furniture. Computers and equipment. Utilities. Insurance. Operating expenses. Then came staffing.

New practitioners would need to be hired and paid long before they developed a full schedule of patients. Insurance reimbursements don't happen immediately, so payroll would need to be covered before revenue caught up.

Those timing differences matter.

A business can be profitable on paper while still experiencing a temporary cash flow squeeze.

That's why cash flow – not just projected profit – was one of the most important parts of the model.

Testing the assumptions

No one knows exactly what the future holds.

Instead of pretending we did, we built the model around reasonable assumptions based on the business's history.

We looked at questions like:

• How long would it take a new practitioner to build a full patient schedule?

• What reimbursement rates should we expect?

• How much would payroll increase?

• How would operating expenses change with a second location?

• How many months would the expansion operate at negative cash flow?

• At what point would it become cash flow positive?

We also created multiple scenarios. A best-case scenario. A more conservative scenario. And conversations around the risks associated with each.

The goal wasn't to guarantee an outcome. It was to understand what success would require.

Turning the model into action

Ultimately, the projections showed that while the expansion would require a period of negative cash flow, the business had the potential to support that investment and generate stronger long-term profitability.

My client decided to move forward.

As part of the SBA loan process, she also needed formal financial projections along with written documentation explaining the assumptions behind them.

Because we had already done the work together, creating those documents was straightforward. We simply took everything we had discussed and organized it into the format the lender needed.

She secured the loan, purchased the building, and today she's not only operating a growing practice but also building wealth through commercial real estate ownership.

The value isn't the spreadsheet

People often think financial modeling is about creating complicated spreadsheets. But the spreadsheet is just the tool. The real value comes from asking the right questions before making a major financial commitment.

What assumptions are realistic? How much cash will the business need? What risks should we plan for? When does the investment begin paying for itself?

Those are the conversations that give business owners confidence to move forward – or the clarity to decide they shouldn't.

That's what a good financial model is designed to do. It doesn't predict the future. It helps you make better decisions with the information you have today.