How to Create a Pro Forma

To create pro forma statement involves thought, evaluation and vision, regardless of the purpose. Pro forma, which is Latin for "as a matter of form," can have somewhat different meanings depending on what you are creating and why. The most common usage is applied to accounting, finance and business. A sample pro forma will show your business's projected revenues, expenses and profits should be conservative and realistic amounts.

TL;DR (Too Long; Didn't Read)

A pro forma statement is different from a financial statement. While a financial statement is based on actual past figures (revenues, operating expenses, etc.), a pro forma statement is based on future projections under informed assumptions.

Consider Your Goal

Think about what you want to accomplish with a pro forma and how you'd like to accomplish your goal. Creating an effective pro forma does not typically respond to "brain storming". It does involve focused thinking and planning.

Evaluate Your Revenue

Focus on the revenue side of your equation first. You must start somewhere, and there are good reasons to concentrate on revenues and incoming cash flows first. Your projected income drives the remainder of your projections. The level of sales and revenue strongly influences the need and size of operating expenses.

For example, if you're planning on making relatively few big ticket sales to a small customer base, you shouldn't need a large telephone or customer servicing department. The size and manner of your company's income, for these reasons, should be your first consideration.

Estimate Operating and Financing Expenses

Estimate your operating and financing expenses. Some operating expenses will be relatively fixed (rent or lease, some utilities, signage), while others will vary with the size and type of your revenue (advertising, salaries and wages, inventory purchases, postage). Don't overlook any operating expenses because they may not be important or material, since they can add up to a significant number. Financing expenses, in the form of interest and fees on business loans, should also be estimated carefully.

Don't focus merely on current financing. Project future debt service expenses for loans that you believe will be needed during the pro forma period.

Forecast Profits and Taxes

Forecast profits, taxes and profit distribution. Your profit level will be determined as you subtract your operating and financing expenses from your projected revenues. You should analyze this figure. For example, if your industry typically considers a 10% net profit before taxes as reasonable, and your first pro forma draft indicates a 25% net profit level, you should reexamine your projections.

Find justification for your projections or revise your forecast for some revenue and expenses. Classify an appropriate portion of original net profit for loan principal payback and/or asset purchases

Create Pro Forma Narrative

Write a meaningful narrative supporting each line item in your pro forma. You need a text narrative to explain to all readers (including yourself) the source of the numbers you project.

For example, assume you project widget sales for the next year to generate revenue of $750,000. Write a narrative explaining how many widgets will be sold, the individual or average prices of each, the accounting periods in which these sales will be made, and how much cash and accounts receivable (monies owed by customers) will result. The simple projection of an annual number is relatively meaningless without the accompanying text to explain its composition.

References

Resources