What Lenders and Investors Want to See in a Financial Model

Lenders and investors want a financial model they can believe. That means assumptions they can trace to your actual results, a cash forecast and not just a profit forecast, and an honest view of what happens if things go worse than planned. Fancy formatting doesn't matter much. Clear thinking does.

For an established manufacturer, the people reading the model are usually a bank, a private equity buyer, a minority partner or a family successor. They each read it for a different reason. But they all test the same thing: does this plan fit the business that actually exists?

Who reads a manufacturer's financial model, and why?

A lender wants to know if you can pay the debt back. They focus on cash flow, debt payments and covenant tests, like the debt service coverage ratio.

A private equity buyer will build their own model. Yours shows them you understand what drives the business. It also anchors the conversation about growth they might be paying for.

A partner or successor wants to know what they're buying into and whether the business can fund a buyout over time.

Keep all three in mind. A model built only to impress tends to fail with all of them.

What should the model include?

A model for a manufacturer should have three linked statements: the P&L, the balance sheet and the cash flow statement. If the three don't tie, a lender will notice in minutes.

I'd build it monthly for the next 12 to 24 months and annually for three to five years after that. The monthly view shows seasonality and cash pinch points. The annual view shows where the business is headed.

The core pieces are:

• An assumptions page, with every key driver in one place.
• Revenue by customer group or product line, built from volume and price.
• Material, labor and overhead costs, separated.
• A capital spending schedule with depreciation.
• Working capital: receivables, inventory and payables in days.
• A debt schedule with interest, principal and covenant tests.
• Owner distributions and taxes.
• Two or three scenarios.

Why must revenue projections match real capacity?

This is the first place a manufacturing model breaks. Sales can't grow faster than the plant can make product. A lender or buyer who knows manufacturing will check.

Here's an illustrative example. A shop runs two CNC machines, each available 4,000 hours a year, so 8,000 hours in total. Last year they used 6,400 hours, which is 80% capacity utilization. The model shows sales up 30% on the same product mix.

30% more work needs about 8,320 hours (6,400 times 1.3). That's more than the 8,000 available. So the plan needs a third machine, a second shift, outsourcing or a price increase in place of volume. If the model shows none of those, the reader stops trusting the revenue line.

Tie each revenue assumption to something real: customer forecasts, open quotes and win rates, a new program, or added capacity. "We think the market will grow" is not enough.

What do lenders and investors look for in margins and costs?

They want margins that make sense against your history. If gross margin has been 24% for three years and the model shows 31% next year, you need a reason. A price increase, a cheaper supplier, automation that cuts labor hours. Show the math.

Split costs into those that change with volume and those that don't. Material and direct labor move with production. Rent, salaries and insurance mostly don't. That split shows how profit moves when volume changes, which is what a lender wants to stress test.

Be specific about material cost risk. If steel, aluminum or resin is a big share of cost, or tariffs affect your inputs, show what you assumed and what happens if it moves.

Why does cash flow matter more than profit?

A growing manufacturer can show rising profit and still run short of cash. Growth ties up money in receivables and inventory before customers pay. A model that ignores this will be wrong in exactly the way lenders worry about.

Here's an illustrative example. Sales grow from $5.0 million to $6.5 million, an increase of $1.5 million. Customers pay in 45 days. Cost of goods is 70% of sales, and you hold 60 days of inventory.

Item (illustrative)	Math	Cash tied up
Added receivables	$1,500,000 x 45 / 365	$184,932
Added inventory	$1,050,000 x 60 / 365	$172,603
Total		$357,535

That's about $358,000 of cash the business needs before the extra profit shows up in the bank, partly offset by any increase in payables. If the model shows the line of credit staying flat through that growth, the reader knows something is missing. Our post on the 13-week cash flow forecast covers the short-term side of this. The glossary entry on the cash conversion cycle explains the days math.

How should the model show capital needs?

If you're asking for money, show exactly where it goes and what it produces. A new press line, a building expansion, a working capital line to support a new customer. Each one should have a cost, a timing and an expected return.

Show equipment replacement too, not just growth spending. A buyer will ask how much it costs to keep the plant running at today's level. If the model shows no maintenance capital spending for five years, that's a red flag. Our capital planning work builds this schedule from your equipment list.

Why do scenarios matter?

Every lender and buyer knows the base case won't happen exactly. They want to see that you know it too.

I'd show three cases: base, downside and upside. The downside should be real. For example, your largest customer cuts orders by a third, or material costs rise 10% with only half passed on. Then show what you would do: cut overtime, delay a purchase, draw on the line.

Most important for a lender, show whether covenants still pass in the downside. If they don't, it's better to know now and negotiate the terms up front.

Why are simple models more convincing?

A model with 40 tabs and hard-coded numbers is hard to check. A reader who can't follow it won't trust it.

Keep the logic visible. One assumptions page. Formulas that flow in one direction. Clear labels. A reader should be able to change one driver, like price or volume, and see the effect flow through to cash.

Why should the model match your actual financials?

The first year of the model should start from your actual balance sheet and run on the same chart of accounts as your monthly financials. If the model shows 26% gross margin and your P&L has never shown more than 22%, the reader will ask which one is right.

This is why clean books come first. Our post on getting financials ready to sell covers that. Once the actuals are reliable, compare them to the model every month. A model that's kept current is far more useful than one built once for a bank meeting.

What red flags do lenders and buyers see in models?

• Revenue that jumps with no capacity, customer or pricing reason.
• Margins well above anything in the past three years.
• No working capital build as sales grow.
• No maintenance capital spending.
• Owner distributions and taxes left out.
• Debt payments that don't match the loan terms.
• A balance sheet that doesn't balance.

Any one of these makes a reader question the rest. Our post on financial modeling vs. forecasting explains how the two fit together if you're building both.

If you want help building a model a lender or buyer will trust, that's part of our budgeting and forecasting and fractional CFO work for manufacturers.

Frequently Asked Questions

How many years should a manufacturing financial model cover?

Usually monthly for 12 to 24 months, then annual for three to five years. Lenders focus on the near term, and buyers look further out.

Do private equity buyers use my model?

They usually build their own. Your model still matters because it shows you understand the drivers and sets the starting point for discussion.

What's a common mistake in a manufacturer's model?

Ignoring working capital. Growth ties up cash in receivables and inventory, and a model without that will overstate cash.

Should the model include a downside case?

Yes. Lenders want to see whether covenants still pass if sales or margins fall, and what you would do about it.

Can I build the model in Excel?

Yes. Many lender and buyer models are in Excel. What matters is clear logic and ties to your actual financials, not the software.