Building a pro forma analysis

Welcome to the world of pro forma analysis, a term that might sound as daunting as learning a new language but, in reality, is a powerful tool in the arsenal of any business owner or financial enthusiast. A pro forma analysis means creating financial statements that project a company’s future financial performance based on certain assumptions and scenarios. Think of it as the financial crystal ball that allows businesses to anticipate outcomes, plan for various futures, and make decisions today that will set them up for success tomorrow.

I remember the first time I was introduced to a pro forma analysis. It was during my early days in the finance sector, fresh out of college, with enthusiasm to match my inexperience. The document was laid out in front of me, filled with numbers, projections, and terms that seemed as cryptic as hieroglyphics. I recall thinking, “Is this finance, or have I accidentally stumbled into an archaeology lecture?”

In this guide, I aim to be the mentor I had (and sometimes wished I had) during those early days, breaking down pro forma analysis into digestible, manageable parts. So here it is in plain terms, turning the seemingly ancient script of pro forma analysis into a clear roadmap toward your business’s financial future.

The short version

• Pro forma financial statements are essential tools for forecasting and planning the financial future of your business, offering a detailed look at potential revenues, expenses, and cash flows.
• Every error you find is worth writing down, because it refines your forecasting techniques and improve your business’s financial health.

What is a Pro Forma?

At its heart, pro forma analysis is a financial tool that businesses use to forecast future financial performance.

Imagine you’re planning a road trip across the country. You wouldn’t just hop in the car and drive off without mapping your route, would you? Similarly, in business, you cannot commit capital without knowing roughly what comes back and when. That is what a pro forma is for.

Now, why is this so important? For starters, pro forma analysis helps you make educated guesses about your company’s future revenue, expenses, and overall financial health. It’s like looking into a crystal ball, except instead of vague predictions, you get detailed forecasts based on solid assumptions and data.

One of the key purposes of pro forma analysis is forecasting financial performance. This is about understanding how factors like market trends, new product launches, or changes in pricing could impact your finances. By playing out different “what if” scenarios, you can prepare for the future with confidence, making strategic decisions that propel your business forward.

Another significant benefit is its ability to attract investors. Imagine trying to convince someone to invest in a journey without showing them the map or the destination. Pro forma statements serve as that map, providing potential investors with a clear vision of where your business is headed and the financial milestones you expect to hit along the way. In fact, the Securities and Exchange Commission under part 210 requires a pro forma statement under certain circumstances.

Gathering necessary information

Starting a pro forma analysis can feel akin to preparing for a grand culinary adventure. Just as a chef gathers all the necessary ingredients before beginning to cook, you too must assemble the right mix of data to craft your financial forecast. The key ingredients? Historical financial data and market research.

Essential data

1. Your historical financials are the backbone of the whole thing. Pull income statements, balance sheets and cash flow statements going back two to three years. Anything less and you cannot see a trend, only a moment.
2. Market research is what stops the forecast being a straight line drawn from your own past. Industry trends, customer demand and what competitors are doing all move your numbers, and none of them show up in your own history.
3. You need to know how your costs behave and how you price. Which costs move with volume and which do not is the single assumption that changes a pro forma most, and it is the one people guess at.
4. Include any investment or financing plans. A planned loan or a large capital purchase changes all three statements at once, and leaving it out is the most common reason a pro forma stops tying.

Where and how to gather this data

• Start with your own accounting software or financial records, which is where the historical picture already lives. Clean bookkeeping makes this step short; messy bookkeeping is the reason it takes a week.
• For market research, industry reports and databases like Statista or IBISWorld will get you most of the way. Talking to ten actual customers will get you the rest, and it is the step people skip because it is not desk work.
• Public filings and industry association reports are the free version of expensive market research. A competitor’s annual report will tell you their margin structure if you are willing to read it properly.

Personal treasure hunt story

When I first started budgeting for my own startup I had no idea where the numbers were supposed to come from. I went through old files on my own machine, then through online research databases.

Late one night I found an industry report carrying the benchmark I had been guessing at all week. That one document did more for the model than everything else I had gathered.

Pro Forma financial statements

A pro forma analysis has three parts, and they are built in this order.

Pro Forma income statement

First up, we have the pro forma income statement, also known as the profit and loss statement. This is essentially your business’s scorecard over a specific period. It tells you how much revenue you’re bringing in (sales of products or services), subtracts the costs associated with making that money (like materials and labor), and shows what’s left over, which we hope is a profit.

Pro Forma balance sheet

Next on our list of financial statements is the pro forma balance sheet. If the income statement was about the flow of the game, the balance sheet is the snapshot at halftime. It shows everything your company owns (assets) and owes (liabilities), plus equity, at a specific point in time.

Pro Forma cash flow statement

Last but certainly not least, we have the pro forma cash flow statement. This one tracks the flow of cash in and the cash disbursements out of your business. It helps ensure you don’t run out of liquid assets (cash) by showing when you might need a financial water station. Breaking it down, it covers operating activities (daily business operations), investing activities (buying and selling assets), and financing activities (loans and investments).

Free Excel Template, Pro Forma financial statements

Make sure to download a copy of our free Excel template to follow along with the examples and build your own pro forma!

Creating a Pro Forma income statement

Crafting pro forma income statements might initially seem like you’re trying to assemble a piece of furniture with instructions in another language. But fear not! I’ll guide you through this process with clear steps. Let’s break it down together, shall we?

Step 1: project your revenues

The first step is akin to predicting how popular your lemonade stand will be at the neighborhood block party. You’ll need to consider factors such as past sales data, market trends, and any upcoming products or services. If you’re just starting, look at industry benchmarks or conduct market research to make educated guesses. Remember, optimism is good, but realism pays the bills. Aim for a balance between hope and practicality.

Step 2: estimate your costs of goods sold (COGS)

Now, think about what it costs to squeeze those lemons and stir in that sugar. COGS includes the direct costs attributable to the production of the goods sold in your business. This can range from raw materials to labor directly tied to service delivery. Err on the side of caution here. Better to be pleasantly surprised than caught off guard.

Step 3: calculate gross margin

Subtract your COGS from your projected revenues to find your gross margin. This figure is like the pot of gold at the end of the rainbow, showing you what’s left after covering the direct costs of your products or services. It’s a the one that matters indicator of your business’s financial health and efficiency.

Step 4: outline operating expenses

Operating expenses are the costs associated with running your business that aren’t directly tied to making your product or service. Think of these as the essentials needed to keep the lights on and the doors open, rent, utilities, marketing, salaries for non-production staff, and so on.

Step 5: forecast net income

Finally, subtract your operating expenses from your gross margin to arrive at your net income. This give your pro forma earnings and is the moment of truth, revealing whether your business is on track to make a profit or if adjustments are needed. It’s like the final score of a game, showing you where you stand after all the plays have been made.

Practical advice

• Lean conservative on the estimates. A forecast that comes in slightly ahead builds credibility, and one that misses high costs you the benefit of the doubt on the next three.
• Build more than one version. Run the income statement with material costs up and with demand down, because the question you will be asked is what happens if, and a single number is not an answer to it.

Example from my experience

I once worked with a café owner who was looking to expand their business. We used local population data and identified coffee consumption trends to project potential sales growth. By considering factors like the increase in remote workers seeking café spots and the popularity of seasonal beverages, we crafted a realistic revenue projection.

The exercise was eye-opening. Not only did it help refine the café’s strategy, but it also prepared the owner for potential challenges ahead. And yes, the pumpkin spice latte season was indeed a hit!

Crafting your Pro Forma balance sheet

Starting a pro forma balance sheet can feel a bit like setting up a sophisticated piece of furniture with an array of parts spread before you. You know it’s going to look fantastic once assembled, but first, you’ve got to figure out where everything goes. By the end you will have every piece in place and know what each one represents.

Understanding the basics

Pro forma balance sheets are essentially a snapshot of your business’s financial health at a future point in time. It outlines three key components: assets, liabilities, and equity.

• Assets are everything the business owns that has value: cash in the bank, inventory, receivables, equipment, and the coffee machine nobody has ever depreciated properly.
• Liabilities are what you owe. Loans, unpaid supplier bills, accrued wages, and the informal borrowing that never made it onto a schedule but is still money going out.
• Equity is what is left when you subtract liabilities from assets. It is the owners’ share, and it is a residual rather than something you set, which is why it moves whenever either of the other two does.

Projecting with precision

When projecting your assets, consider both your current resources and those you plan to acquire. Remember, accuracy is key. Overestimating assets can lead to overly optimistic equity calculations, akin to thinking you can run a marathon without training. Underestimating, however, might deter potential investors or lenders.

For liabilities, factor in existing debts and anticipated future borrowings. This foresight is the one that matters for maintaining a realistic view of your financial obligations and ensuring you don’t find yourself in hot water down the line.

A lesson I learned the hard way

Early on I was tasked with creating a pro forma balance sheet for a small bakery. I accounted for every ingredient, right down to the yeast, but forgot to include the new industrial oven the bakery was planning to purchase.

That oven was the heart of the bakery’s expansion plan, significantly impacting both assets and liabilities. The oversight led to a considerable underestimation of future liabilities (since the oven was to be financed) and, by extension, equity. Needless to say, I had to redo the entire analysis, a humbling reminder of the importance of double-checking your work and considering all aspects of your business operations.

Preparing a Pro Forma cash flow statement

Ah, the pro forma cash flow statement, the unsung hero of financial projections. It’s like the pulse check for your business, ensuring you don’t end up gasping for air (financially speaking). Let’s get into how you can forecast cash inflows and outflows with the precision of a skilled gardener ensuring their plants thrive.

Forecasting cash inflows

Cash inflows are essentially the lifeblood of your business. These come from sales, returns on investments, loans, and any other sources that inject cash into your business. To forecast these, start by looking at your sales trends. Are there certain times of the year when you make the lion’s share of your sales? Factor in new product launches or seasonal promotions you’re planning. Also, consider the payment terms you’ve negotiated with clients, not all income might be as prompt as we’d wish.

Imagine you’re planning how much water your garden needs. You’d consider the rain forecast (seasonal trends), whether you’re planting more thirsty plants (new products), and how well your soil retains moisture (cash on hand).

Forecasting cash outflows

Next up, cash outflows, which include expenses like rent, salaries, supplier payments, and any loan repayments. This step rewards patience more than speed. Break down your expenses into fixed (rent, salaries) and variable (materials, utilities) categories. Remember, some payments don’t occur monthly but quarterly or annually, so factor these into your timeline accurately.

It’s similar to knowing when to water your garden and when to add fertilizer or pesticide. Some plants need constant attention (fixed costs), while others may only need seasonal care (variable costs).

Case study from my experience

I recall a time when I was helping a friend forecast the cash flow for their startup. In our enthusiasm, we planned for significant marketing spend without accounting for the delayed income from their payment terms. Halfway through the season the account was empty and the invoices were not due for another six weeks. They took a short-term loan to cover the gap. It was a lesson in watching the whole picture rather than one line of it.

Analyzing your Pro Forma financial statements

Imagine your pro forma statements as a detailed map of the terrain ahead. Just as a hiker uses a map to decide whether to cross a river at its narrowest point or take a bridge, you use your pro forma financial statement to navigate through business decisions.

For example, if your cash flow statement predicts a cash surplus, you might decide it’s the perfect time to invest in that new piece of equipment. Conversely, a forecasted tight spot might suggest delaying expansion plans in favor of shoring up reserves.

Common pitfalls when creating Pro Forma statements

• Over-optimism is the most common failure and the hardest to see in your own work. Every assumption bends slightly favorable, none of them look unreasonable alone, and the total is a forecast nobody can hit.
• Ignoring what the market is doing produces a forecast that is internally consistent and externally wrong. Your own history cannot tell you a competitor just cut prices.
• Forgetting to update it is what turns a useful pro forma into a document people stop opening. Set a cadence for revisiting it before you need one.

A worked example, on numbers you can check

Every pro forma article ends with an invented shop and invented numbers. This one uses F9 Coffee Co., the seven-store chain I use for teaching, because two of its stores opened inside the data I have and that lets me show you the thing pro formas get wrong.

The scenario

The chain wants an eighth site. Six stores are already trading and the numbers are known, so building the pro forma looks like arithmetic. Take what a store does, apply it to the new one, done.

Step 1, the unit economics

Across 18 months and $35,962,652 of revenue, the chain runs like this:

Line	% of revenue
Labor	32.2%
Cost of goods sold	29.2%
Marketing	5.2%
Rent	4.9%
Utilities	1.6%
Operating income	26.9%

That is a genuinely useful starting point, and it is where most pro formas stop. One warning already: rent is 4.9% on average and the actual monthly rent runs from $10,000 in Astoria to $24,800 on the Upper West Side. If you carry a percentage across instead of the number in the lease you are out by 148% before you start.

Step 2, the projection everyone builds

A mature store here does about $203,000 a month. Twelve months of that is $2,435,405 of year-one revenue, and at a 26.9% operating margin that is $655,000 of operating income. Put that in front of a lender and it looks like a good site.

Step 3, what happened

Williamsburg opened in March 2025 and its run rate today is $202,950 a month, so the projection above is exactly the one you would have built for it. Here is the first year:

Month	Revenue	% of run rate	Operating margin
1 (Mar 2025)	$68,401	34%	-17.7%
2	$131,701	65%	14.6%
3	$164,801	81%	17.8%
4 (Jun 2025)	$185,901	92%	17.2%
6	$194,700	96%	18.3%
12 (Feb 2026)	$149,200	74%	14.3%

Actual first-year revenue was $2,034,708. The projection said $2,435,405. It was over by $400,697, or 19.7%, and every dollar of that gap is the ramp.

Long Island City, which opened on 8 September 2025, did the same thing in a different shape: month one at 52% of run rate, at 90% of it by month four, and now trading at 121% of it. Same ramp, faster, and a pro forma built on a flat twelfth of the run rate would have been wrong in both directions.

Step 4, the two lines the ramp moves

Revenue is the obvious one. The one people miss is that the cost lines do not ramp with it. Williamsburg’s first month ran a negative 17.7% operating margin, not because anything went wrong but because rent, utilities and a minimum viable staff roster all arrive at full size on day one against a third of the revenue.

That is the number a lender or a board needs, because it is the size of the hole you have to fund before the site pays for itself. A pro forma that shows a 26.9% margin from month one has hidden the only genuinely risky part of the plan.

What the model should have said

• Revenue ramping to the run rate over four to six months, not starting at it.
• Fixed costs at full size from month one, because they are.
• Labor at a floor rather than a percentage, until volume passes the floor.
• Rent from the actual lease, never as a percentage of revenue.
• A cash line showing the worst month, which is what the funding requirement is.

For the record, the budget the chain set for Williamsburg’s first year was $2,166,800, and the store came in 6.1% under it. Someone had allowed for the ramp and was still slightly optimistic, which is roughly the best you should expect from a first-year projection.

Three things to take from it

Do not skip the preparation. Gathering the data and understanding the market is most of the work, and the modeling on top of it is the quick part.

Stay grounded on the estimates. Optimism compounds quietly across a model and then shows up all at once in the cash line.

Plan for the lean months as well as the peaks. A forecast built only on good quarters is a sales target wearing a spreadsheet.

What a model does to this, and what it does not

Building the mechanical half of a pro forma used to be the job. Paste your historical P&L into Claude or ChatGPT, describe the plan, and you will have a three-statement projection with the balance sheet tying and the cash flow rolling forward, in about a minute. It is good at this. The arithmetic and the linkages are exactly the kind of work that should not have been costing you a Saturday.

Three things it will do badly, and all three are the parts that decide whether the projection is any good.

It will not ramp anything unless you make it. Ask for a first-year projection and you get twelve equal months, which is the $400,697 error above, produced instantly and formatted beautifully. You have to hand it the curve, because the curve is a fact about your business that no general model has ever seen.

It will grow every line at the same rate. Revenue up 15% and it will move cost of goods sold, labor, rent and utilities up 15% too. Rent is fixed until the lease renews, labor is a step function, and utilities barely move. A projection where everything scales together is the single most common thing I have to unpick in a model somebody brings me.

And it will be optimistic, because you were. A model takes the assumption you give it and builds a coherent world on top, so a 15% growth assumption you pulled out of the air comes back as a $3 million revenue line with three decimal places of confidence. The formatting is not evidence.

The way I use it is narrow and it works. The model builds the structure and the linkages. I supply the ramp, the fixed costs and the growth rate, and I defend those three to whoever is reading the output, because they are the only parts anybody should be arguing about. Scenario planning is the next step once the base case exists, and building the model itself goes deeper on the mechanics.

Frequently asked questions

Do Pro Forma financial statements have to meet Generally Accepted Accounting Principles?

While it is not a requirement for pro forma financial statements to meet Generally Accepted Accounting Principles (GAAP), it is generally recommended to adhere to these principles for accuracy and consistency.

What is a Pro Forma invoice?

Pro forma invoices are a commercial invoice that outlines the anticipated costs and terms of a transaction or sale. It is typically used in international trade to provide an estimated cost for goods or services before they are delivered.

Have any questions on building pro forma financial statements? Are there other topics you would like us to cover? Leave a comment below and let us know! And make sure to subscribe to our Newsletter to receive exclusive financial news right to your inbox.