Best Pro Forma Income Statement Template For 2022

how to create a proforma income statement

They have articles governing the preparation of pro forma financial statements for public companies. These are Regulation S-X Article 11, and Regulation S-X 8-05 for smaller companies from 17 CFR 210. Additionally, the SEC may require that pro forma financial statements be submitted when a company is filing for an initial public offering .

  • First off, you’ll need to set a sales goal for the period you’re looking into.
  • If a piece of new machinery is going to be purchased, there will be an increase in the Property, Plant and Equipment of the company.
  • Generally, pro forma financial statements tend to portray a business as being more successful than it really is, and having more financial resources available than may actually be the case.
  • If you’re ready to try this process independently, you’ll generally need to use spreadsheet software like Microsoft Excel to put the pro forma together.
  • Carry out extensive research and review prior financial statements in order to arrive at the best assumptions.
  • In fact, business owners, investors, creditors, and other key decision-makers all use pro forma financial statements to measure the potential impact of business decisions.

Because it’s impossible to predict the future, pro forma financial statements should only be considered an estimate. Pro forma financial statements illustrate how a company’s financial position might change in the future.

Pro Forma Income Statements For Existing Businesses

The pro forma income statement is based on the most recent income statement of the business, which is usually the financial statements of the last period. Furthermore, pro forma financial statements can be used as a reporting tool to the stakeholders of the company, for instance, the owner, potential investors, creditors, etc. For example, businesses may be required to report any effects of changes in the accounting policies of the business using pro forma financial statements. Pro forma financial statements are a great tool to evaluate alternatives. Most businesses have limited resources, and pro forma reports can help you make better decisions with what you have. Financial statements, including the balance sheet, income statement, and cash flow statement, based on a set of assumptions.

For our widget vendor, let’s say the business owner would initially like to look backward at historical profit & loss. Granted, pro formas aren’t quite to Sorcerer Supreme levels of omniscience, but they sure do come in handy when it’s time to look at a what-if scenario or two. Want to know what the financial results from a potential business combination might look like a year from now? Or maybe you want to look backward and see where you might be today if that combination occurred last year.

how to create a proforma income statement

For the same period, it also looks at the business they are acquiring. Using this combination, the projections shows how they would have done together. Use this free template to create your own historical with acquisition pro forma documents. They must also ensure they label all pro forma information as such, to avoid confusion with historical information, and list the specific assumptions and uncertainties about them they are making. Compiled pro forma financial statements can form the basis for calculating financial ratios and financial models, which test assumptions and relationships of your company’s plan. You can use them to study how changes in the price of labor, materials, overhead, and the cost of goods affect the bottom line.

Types Of Pro Forma Statement

Use the balance sheet template below to create your own balance sheet. This pro forma balance sheet can also be used for corporate retail or wholesale businesses. Used to show company results to investors, pro forma financial statements are often combined with generally accepted accounting principles adjusted statements. Pro forma financial statements are not computed using GAAP and are often called non-GAAP. GAAP-adjusted statements are uniform financial statements guided by rules of the Financial Accounting Standard Board . Once the balances related to the figures in the pro forma income statement are adjusted, the remaining balances should be evaluated individually for any expected changes.

To illustrate why this distinction matters, let’s imagine you and I start a business, and in the beginning, we expect sales to be relatively low; say one hundred units. Fixed costs stay relatively constant – at least for a while – and are more important in the beginning because they’ll make up a higher percentage of overall costs.

Then, add assets, owner’s equity, and total liabilities to complete the pro forma balance sheet. There are many reasons why producing pro forma financial statements could be beneficial for your business. Pro forma financial statements are essentially “what-if” generators, giving you the ability to play through different hypothetical scenarios and explore their potential impact on your business. It may be prepared in advance of a transaction to project the future status of the company. For example, if a company is planning to acquire another company, it may prepare a pro forma financial statement to estimate what effect the acquisition would have on its finances. According to Russell’s projections, he reaches the highest earnings when he hires a full-time administrative assistant. More significantly, the pro forma income statement reveals that hiring a part-time assistant is nearly as lucrative as bringing someone on full-time.

Before extending capital or credit, investors and lenders might ask for pro forma statements to understand your outlook on company performance. For new businesses with no historical financial statements, lenders look at pro forma statements for a realistic vision of your company’s future. Many of the items listed above are part of the GAAP, but not included in pro forma reporting, making it rife for possible deception. This discrepancy is part of the reason the distinction between pro forma and GAAP financial statements is important.

Limitations Of Pro Forma Financial Statements

Pro forma financial statements are documents that are prepared to try to predict future success of a business. They do not follow generally accepted accounting principles, or GAAP, which are general reporting requirements that all U.S. business must follow.

Now the income statement, balance sheet, and other data can be used to create the statement of cash flows. For example, the company might merge with or purchase another business, and the outcome could affect both cash flow and profits.

From a business perspective, companies use pro forma financial statements to present an analyze the different aspects of potential investments, planned transaction, and more. These projections usually estimate the impact of a transaction on different areas of the business, including cash flows, projected revenues, tax costs, and more. Using pro forma reports, companies can project the impact of a business move based on recent, accurate financial data. The most common pro forma financial statements are projected balance sheets, income statements, and cash flow statements.

Finally, with the pro forma income statement and balance sheet compete, we can knock out the cash flow statement as well. Therefore, whatever prompts the need for pro forma statements, you must be sure to adhere to any mandatory guidelines.

The Monday Com Pro Forma Template For Excel

If so, they may issue pro forma financial statements that include the corrections they believe are necessary to provide a better view of the business. The Securities and Exchange Commission takes a dim view of this kind of adjusted reporting, and has issued regulations about it in their Regulation G. A company may be seeking funding, and wants to show investors how the company’s results will change if they invest a certain amount of money in the business. This approach may result in several different sets of pro forma financial statements, each designed for a different investment amount. A pro forma balance sheet typically has all the components of an actual balance sheet, the major difference is that some or all of the financial reports have been forecasted based on expected events. For this reason, some people interchange the terms ‘pro forma balance sheet’ and ‘balance sheet forecast’. A pro forma balance sheet will show the forecasted assets, liabilities, and equity position of a business or organization at any period in view.

It’s hard to provide a general rule to forecast costs for new businesses because the costs required to run a food truck are much different from those needed to run a software business. These costs can be rent, salaries, insurance, and other expenses that don’t fluctuate much with a given level of revenue.

how to create a proforma income statement

That’s what makes pro formas so powerful and, to that point, why we’re going to spend the next few minutes discussing their applications and how to create them. Do you want to learn more about what’s behind the numbers on financial statements?

How Data Rails Helps In Preparing Pro Forma Financial Statements

Once an estimated tax expense is determined, the net profit after tax should be calculated. While pro forma financial statements project the future, there is no guarantee that those predictions are accurate.

  • Enterprise See how you can align global teams, build and scale business-driven solutions, and enable IT to manage risk and maintain compliance on the platform for dynamic work.
  • Attract investors and lenders by demonstrating how sustainable the business model is.
  • Pro forma taxes are figured by taking your estimated tax rate—in this case, 30 percent—and multiplying it by the pro forma profit before taxes of $235,000.
  • Businesses create annual budgets that fall in line with a company’s profitability and production goals.
  • A financial forecast may be used in lieu of pro forma financial statements.
  • Base your estimates on objective measures that you can back up with hard data.

The pro forma income statement computes how much money a business will make after all expenses have been subtracted from total revenues. The pro forma balance sheet displays information about everything a company owns and all debt that it owes. It also computes how much the company is worth, after total liabilities have been subtracted from total assets. Pro forma financial statements are best prepared before any major transactions are entered into, so that business decision makers feel more assured that they can meet company goals. This is called managerial accounting, or when decision-makers prepare financial statements to meet proposed company goals. Pro forma documents are statements that are based on interpretations of the future; not how well a company is financially performing presently. The phrase pro forma refers to the practice of estimating the progress of operations of a business.

Pro Forma Income Statement Example

With the help of our easy-to-create automations and custom rules, proactively setting up all sorts of hypothetical scenarios will run all day, every day. A pro forma template helps teams understand what data is needed to model different scenarios how to create a proforma income statement based on pre-built questions. It’s as easy as “fill in the blanks,” … but this can still be pretty labor-intensive. There are plenty of pro forma statement templates in tools like Excel, Google Sheets, or even a Work OS like

The difference is that the financial forecast details the company’s expected results of operations as a single-point estimate or a range. The legal liability of the company may increase upon submitting forecasts instead of pro forma income statements, but the practice may be more relevant for certain businesses. For this reason, professionals typically turn to forecasts and financial projections to guide their plans and answer critical “what if” questions. Pro forma financial statements are a common type of forecast that can be useful in these situations. They include the pro forma cash flow statement, the pro forma income statement, and the pro forma balance sheet. Statements of cash flow, or cash flow statements, measure the sources of a company’s cash and how it uses that cash over the stated period. Pro forma statements of cash flow estimate how much cash inflow and outflow is expected in one or more future periods.

What Is Pro Forma?

In other words, you get an idea of what your financial results would have been if the event had already occurred. These are factually supported by the data from the original financial statements. Here’s a closer look at what pro forma financial statements are, how they’re created, and why they’re a key aspect of financial decision-making. A pro forma income statement is a document that shows a company’s adjusted income if certain financial entries have been removed in a period of time.

Once you understand the purpose, importance, and practicality of making pro forma income statements, you can draft them. When you make a pro forma income statement, make sure you are as detailed as possible throughout the process. You can use pro forma income statement projections to establish best and worst case financial scenarios. This helps you realize the range of outcomes your startup can realistically expect in terms of your income.

A pro forma is simply a financial statement written as you expect things to look, at some point in the future. Nobody expects a pro forma to be completely accurate, but it should be based on real information and written to reflect your good faith expectations. A full-year projection is just what the name suggests—accounting for the current year. For example, if it’s currently April and you want to perform a full-year pro forma projection, you would account for all the financials up to April and project the remainder of the year. It’s illegal for publicly traded companies to mislead investors with pro forma financial results that do not use the most conservative possible estimates of revenue and expense. Here’s a good template you can use to format and create your 3-year proforma income statement.

Whether you “might” lose an account or make an acquisition, pro forma financial statements allow a glimpse into the future. For these purposes, pro forma statements are typically created as a part of a financial forecast in financial accounting.

Sometimes, in pro forma documents, unsold inventory is even excluded. Not all these things should be left off, but the decisions of what is left off should be well thought out and explained to potential investors, so they have a clear indication of what they are viewing. Knowing how the pro forma documents are compiled and what is left out is also critical when comparing different pro forma statements. Understanding this methodology and the decisions behind it will enable accurate comparisons and information to investors.

About the author

Leave a Comment

Comment (required)

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Name (required)
Email (required)