Pro Forma Financial Statements: How to Build the P&L, Balance Sheet and Cash Flow

Pro forma financial statements are financial statements built on assumptions rather than completed transactions. They use the same three formats as your real statements (income statement, balance sheet, cash flow statement) but show what the numbers would look like under a set of stated conditions: next year's growth plan, a new loan, an acquisition, a price increase. They are not GAAP statements, they cannot be filed with the IRS, and they are only as good as the assumptions underneath them.

The part most owners get wrong is where a pro forma starts. It does not start with a revenue target. It starts with a clean set of historical statements, because every credible projection is an argument about how the real numbers will change, and you cannot argue about numbers you do not have.

What does "pro forma" actually mean?

"Pro forma" is Latin for "as a matter of form," and in US finance it carries two distinct meanings that get confused constantly:

• Forward-looking projections. A 12 to 36 month forecast of the P&L, balance sheet and cash flow under a stated plan. This is what a bank, an SBA lender or an investor means when they ask a small business for pro formas.
• Adjusted "as if" historical figures. Restating periods that already happened as though a transaction had occurred at the start of them. If you buy a competitor in September, the pro forma full-year P&L shows the combined company as if you had owned it since January. Public companies do this under SEC Regulation S-X Article 11; private buyers and sellers do an informal version constantly during diligence.

Both senses share one property: the format is normal, the inputs are hypothetical. The arithmetic does not change. What changes is that you are now responsible for defending every number you typed in.

What are the three pro forma statements, and what order do you build them in?

The three pro forma statements are the pro forma income statement, the pro forma balance sheet and the pro forma cash flow statement. Build them in that order, because each one feeds the next. The income statement produces net income and depreciation. The balance sheet needs net income to roll equity forward. The cash flow statement is derived from both.

Stopping early is the most common structural error. People build a pro forma P&L, see a profit, and quit. The P&L cannot tell you whether you will run out of cash: it says nothing about receivables, inventory, capital spending or loan principal. Those live on the balance sheet, and the cash flow statement reconciles the two. Build one statement and you have a sales forecast, not a pro forma.

How do you create pro forma financial statements?

Five steps, in order:

1. Close and clean the historical base. Two to three years of actuals, correctly categorized, reconciled to the bank. This anchors every ratio you are about to project.
2. Write the assumptions down as a list, before you touch a formula. Growth rate, gross margin, headcount, rent, capex, days sales outstanding, inventory days, days payable, interest rate, tax rate.
3. Build the pro forma income statement, driving each line off an assumption rather than a gut number.
4. Build the pro forma balance sheet using working capital days, the fixed asset roll-forward and the debt amortization schedule.
5. Derive the pro forma cash flow statement from the two, and check that ending cash ties to cash on the balance sheet. If it does not, something is wrong, and it is usually working capital.

Pro forma income statement example

Here is an illustrative example. All numbers are made up for teaching purposes, but they are internally consistent, so you can follow the math. A small US hot sauce brand did $2.4M in wholesale revenue last year on 45% gross margins and squeaked out $30,000 of net income. Two regional grocery chains have signed on for next year. The owner wants a $250,000 SBA loan to buy a bottling line and fund the inventory build.

Line	Actual (last year)	Assumption	Pro forma (next year)
Revenue	$2,400,000	+25% from two signed chain accounts	$3,000,000
Cost of goods sold	$1,320,000 (55%)	54% on a written volume quote from the co-packer	$1,620,000
Gross profit	$1,080,000 (45%)		$1,380,000 (46%)
Payroll	$520,000	3% raises, plus 2 hires at $67,200 fully loaded	$670,000
Rent and warehouse	$96,000	Signed expansion lease	$120,000
Marketing	$168,000 (7%)	6.5% of revenue	$195,000
Freight and fulfillment	$120,000 (5%)	5% of revenue, per 3PL rate card	$150,000
G&A	$84,000	Insurance and software renewals	$92,000
Depreciation	$40,000	Existing $40,000 plus half-year on $180,000 of new equipment (5-year life)	$58,000
Operating income	$52,000		$95,000
Interest	$12,000	Existing note plus new $250,000 loan at 10.5%	$36,000
Taxes	$10,000	25% effective rate	$14,750
Net income	$30,000		$44,250

That is a defensible pro forma P&L. Every line traces to something a lender can ask about: a purchase order, a supplier quote, an offer letter, a lease, a rate card, an amortization schedule. Notice how much of the extra gross profit gets consumed by the cost of producing it. Revenue grows 25%, net income grows about 48%, and that is with margins moving in your favor. More believable than a projection where profit triples.

How do you build the pro forma balance sheet and pro forma cash flow statement?

Project the pro forma balance sheet with ratios, not guesses. Hold the working capital days constant unless you have a specific reason to change them, roll the fixed assets forward, and roll equity forward with net income. Then derive the pro forma cash flow statement and let cash be the answer, not an input.

Continuing the example. Last year ended with $110,000 cash, $240,000 of receivables (36.5 days), $330,000 of inventory (91 days of COGS), $145,000 of payables (40 days) and $260,000 of net fixed assets. Holding those same days against the new revenue and COGS:

• Receivables: 36.5 days of $3,000,000 = $300,000, up $60,000.
• Inventory: 91 days of $1,620,000 = $405,000, up $75,000.
• Payables: 40 days of $1,620,000 = $178,000, up $33,000.
• Net fixed assets: $260,000 + $180,000 capex - $58,000 depreciation = $382,000.

Now the pro forma cash flow statement, indirect method: net income $44,250, add back depreciation $58,000, then subtract the working capital build. Receivables (-$60,000), inventory (-$75,000), prepaids (-$4,000), payables (+$33,000), accruals (+$7,000) net to -$99,000. Cash from operations is $44,250 + $58,000 - $99,000 = $3,250.

Read that again. A profitable year, $95,000 of operating income, and operations throw off three thousand dollars. Investing then takes $180,000 for the bottling line and financing adds $215,000 (a $250,000 draw less $35,000 of principal repayments). Ending cash is $148,250, which ties exactly to the balance sheet. Without the loan, cash lands at negative $66,750 in the middle of a good year.

That only shows up when you build all three statements. A growing business funds its growth out of cash it does not have yet. For the mechanics of each statement, our guide to how to prepare financial statements walks through the construction step by step.

Base, upside, downside: why the good case can be the scariest one

Never hand anyone a single-scenario pro forma. Three cases, same structure, different dials. Same illustrative example:

	Downside (+8%)	Base (+25%)	Upside (+40%)
Revenue	$2,592,000	$3,000,000	$3,360,000
Gross margin	45%	46%	46%
Operating income	($4,480)	$95,000	$152,000
Net income	($40,480)	$44,250	$87,000
Cash from operations	($14,080)	$3,250	($17,600)
Ending cash	$130,920	$148,250	$127,400
Debt service coverage	0.75x	1.95x	2.55x

Two things fall out of that table that no single-case forecast would ever show you. First, the downside case breaks the loan: coverage of 0.75x is well under the 1.15x to 1.25x most banks want, because the lease, the equipment and one of the hires are committed regardless of whether the volume arrives. Second, and less intuitive, the upside case ends the year with less cash than the base case. Growing 40% means carrying $336,000 of receivables and $453,600 of inventory instead of $300,000 and $405,000. The extra profit is real, and it is sitting in a warehouse and in your customers' AP departments. Fast growth is a cash consumer. That is the finding worth having.

Which assumptions actually matter in a pro forma P&L?

In most small businesses, four assumptions move 90% of the answer: revenue growth, gross margin, headcount and working capital days. Everything else is rounding. Sanity-check them like this:

• Revenue. Break it into units times price, or accounts times average order value. If you cannot name where the growth comes from, it is a wish. A step change needs a signed contract, a hired rep or a funded campaign behind it.
• Gross margin. Assume it holds flat unless you have written evidence otherwise. Margin expansion is the most abused line in every projection ever built.
• Headcount. Revenue per employee is a brutal reality check. If your plan takes it from $200,000 to $400,000 with no change in how the work gets done, the plan is wrong.
• Working capital days. DSO, inventory days and DPO from your actual history. If the plan needs faster collections to work, the plan needs a collections project attached to it.

One more discipline: back-test the method. Apply it to last year and see whether it would have predicted the year you actually had. If it would not have, fix the method before you show anyone the future.

Are pro forma financial statements GAAP compliant?

No. GAAP statements report transactions that occurred. Pro forma statements report assumptions about transactions that have not occurred, and they often exclude items management considers one-time. They cannot be audited, cannot be used to file taxes, and should be labeled "pro forma" on every page. Public companies presenting pro forma figures must also reconcile them to the GAAP numbers.

What is the difference between a pro forma and a budget?

A budget is an internal plan you commit to and measure against, usually for one fiscal year, and usually with departmental accountability attached. A pro forma is a projection of what happens if a specific scenario plays out, often for an outside reader (a bank, a buyer, an investor). Same arithmetic, different audience and different obligation.

How many years of pro forma statements do lenders want?

Banks typically want three to five years of projected income statements, balance sheets and cash flow statements, with the first year broken out monthly. SBA lenders generally require at least a one-year pro forma income statement plus a written narrative explaining how you reach the numbers. Investors usually want three years, with a monthly first year.

Expect the monthly first year to get the real scrutiny, because that is where the cash gap shows up. Annual numbers hide the month you cannot make payroll. And if the projections exist because you are selling the business rather than borrowing against it, pair them with an independent estimate of what the company is actually worth, since a buyer will discount your forecast heavily and price off normalized earnings anyway. Your own optimism is not a valuation input.

What mistakes make pro forma projections useless?

The recurring ones, in the order lenders spot them:

• Hockey-stick revenue with flat headcount and flat overhead. Growth costs money. If revenue doubles and payroll does not move, nobody believes the model, and they stop reading.
• Forgetting working capital. The example above is the whole lesson: $44,250 of profit produced $3,250 of operating cash. Receivables and inventory absorb the growth first, and they get paid back last.
• Ignoring the cash timing gap. You pay for materials and payroll in month one and collect in month three. An annual pro forma smooths that over. A monthly one exposes it, which is the point. The same discipline runs through burn rate and runway math.
• No taxes, or the wrong entity's taxes. An S corp or LLC pushes tax to the owners, but the distributions to cover it are still cash leaving the business. Model them.
• Confusing loan principal with expense. Interest hits the P&L. Principal does not, but it absolutely leaves the bank account. It only appears if you build the pro forma cash flow statement.
• No downside case. A forecast with one column reads as marketing. Three columns reads as management.

Where AIStatements fits

AIStatements does not build projections. It builds the historical base every projection has to start from. Upload a QuickBooks, Xero or spreadsheet export and it returns a formatted statement pack (income statement, balance sheet and cash flow statement) with written analysis and the ratios you need as inputs, including margins and DSO, in about 60 seconds. Get two or three years cleanly grouped, and the pro forma becomes an argument about assumptions instead of an archaeology project.

The usual boundary applies: this is software that formats and analyzes the data you give it, not accounting, audit, tax or investment advice. Projections you put in front of a lender, a buyer or an investor deserve a look from a CPA who knows your business.