Long-term debt (from balance sheet) goes to the Less interest expense (on the income statement). Some banks require pro forma statements to verify cash flow prior to issuing a line of credit. In other words, you get an idea of what your financial results would have been if the event had already occurred. However, like any template, you need to adjust it to suit your needs. Pro forma data estimates are built in to show the company’s profits if certain, one-time items are taken out. These are factually supported by the data from the original financial statements. It often refers to free services from a professional to clients without the financial means to pay for them. You can use them to study how changes in the price of labor, materials, overhead, and the cost of goods affect the bottom line. Then, do the following: Calculate pro forma gross profit. Budgets. This discrepancy is part of the reason the distinction between pro forma and GAAP financial statements is important. We’ll show you what variables link the three sheets, along with equations, examples, and a sampling of free, downloadable pro forma templates. Pro forma income statements, also called pro forma profit and loss (pro forma P&L), are projections based on your past income statements. Using this combination, the projections shows how they would have done together. Pro Forma Income Statement. Pro forma statements come in three typical formats: Pro forma documents can resemble normal statements, but they’re purely based on hypothetical questions. When they’re done well, these statements can be used to make predictions about how a … You can also use pro forma statements to do the following: Develop various sales and budget projections. Pro Forma Financial Statements vs. Between these two forms, the sheet must balance out. Even public companies are not required to get their pro forma document audited by an independent auditor, according to the SEC. Pro forma templates are convenient because you can operate one by using a normal monetary statement template (such as those found on exceltemplates.net) and applying hypothetical questions to it. There are several methods to prepare a pro forma cash flow document, relative to the forecasting periods: Short Term: A cash flow statement that represents a period of weeks, based on outstanding invoices and cash payments for existing accounts payable. For each of the above equations, the interest-bearing debt is the unknown variable. To get the pro forma gross profit: Net cash flow – capital expenditures - dividends Recalculate the federal taxes of the predecessor business as though it were a corporation. Factually Supportable: In order to consider adjustments, you must provide existing, factual documentation, such as contracts, letters of intent, or completed transactions. If a business is acquiring a new business or disposing part of its business, the pro forma statements need to adjust the historical figures to reflect this, and to show, in the case of an acquisition, what a corporation would have looked like separately, but added together. Use this Word template to create your own compilation report, as per the AICPA’s guidance. For publicly-held companies, the SEC requires an introductory paragraph showing the proposed transactions, the company, the period covered, and what the pro forma information describes. Assuming this year’s cost of goods sold (COGS) was $10,000, you will also multiply it by the 105%, so $10,000 * 105% = $10,500. The business plan will include pro forma financial statements that show the effect of the proposed change, project, or new business. For example, you may be able to add the investment onto the balance sheet under the cash row in the historical with acquisition pro forma template, or you may have to divide the investment under multiple rows. Budgeting: The plan created to balance expenses with revenue. Calculate pro forma total operating expenses. Ideally, the pro forma balance sheet is composed in columns. Following a budget ensures that people stay out of debt, can save, and pay their bills. Another reason these may be held is to ensure that the president does not make any recess appointments. This form may also be used for corporate retail or wholesale companies. Pro forma statements of cash flow estimate how much cash inflow and outflow is expected in one or more future periods. For example, you might ask yourself “What should I do if my company receives a $100,000 loan in a year?” A pro forma statement contemplating this question would reflect this loan in the sections for profit, balance, and level of cash flow. Add back depreciation to capital expenditure, which is arrived at on the cash flow statement. Pro forma analyses are meant to paint a better picture of what is happening with the company, irrespective of one-time events, but considering the specific industry’s standards. 9+ Pro Forma Templates Pro forma statements provide organizations with an estimation of future financial performance. If the pro forma balance sheet and income statements lead to a statement of cash flow that shows inadequate funds for what management has planned, the other documents will be invalid and may need to be reworked. This model will help you figure out what would happen if you made such a purchase now. The term pro forma financial statements simply refers to a set of financial statements in the usual format (balance sheet, income statement, and cash flow statement), which have been prepared in order to … Check the templates in this guide to determine which is right for you to create your own. The closing cash balance on the balance sheet is the sum of the last period’s closing cash and the current period’s cash from operations, investing, and financing. In other words, you need to point out that the event or purchase is not a trend and therefore, that you cannot forecast based on it. You may want to use Bench’s free templates: How to create pro forma statements The sample pro forma statements below may look different from the statements you create, depending on what your template … (Net income + amortization + depreciation + deferred taxes) – capital expenditures - dividends, Variance Analysis: A variance analysis clarifies the difference between expected and actual results. In business, this can take the form of goods, services, or tradable assets. A pro forma operating statement is sometimes a plan that uses the professional pro forma calculation technique, typically designed to draw potential investors’ focus to specific figures once an organization problems an earnings announcement. This is considered the most accurate forecast. Notes to the financial statements: Also called the footnotes, and sometimes in the explanatory notes, notes to the financial statements explain how a company arrives at its numbers and any possible irregularities or inconsistencies. It can be tempting to do so because both concepts revolve around how your business is going to spend its money in the future. Some of the formulas between the two sheets bridge. In the case of estimated cash overages, the company can produce a plan for investment. Income Statement Templates are print-ready tools that companies can use to record, present, and analyze the operation of the businesses for a given period, usually one financial year. Historically Acquired Pro Forma Forecast. Translate data into cash flow projections. Arguably, the statement of cash flow is the most important of the pro forma documents. For example, if your company recently acquired or dispensed with another company, the assumptions would be the changes in finance expected. Quid pro quo: This term is a Latin phrase that means “something for something.” It occurs when two participants mutually agree to exchange something for something else. For cases in which your company is specifically seeking funding, you want to show your potential investors how the company’s financial results will change with their investment. Pro bono: This comes from the latin term “pro bono publico,” meaning to work for the public good. 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. This is $11,600 - $2,320 = $9,280 (pro forma profit after taxes). Pro forma statements are entirely based on predictions – but budgets are more solid plans, incorporating your current financial status instead of revolving around possible windfalls later on down the road. For more information on cost variance and how to calculate it specifically for projects, see “Hacking the PMP: Studying Cost Variance.”. Anytime a transaction is scheduled, such as a merger, acquisition, capital investment, or change in capital structure, pro forma is used as a projection. Traditional budgets track expenses, payments to eliminate debt, and building an emergency fund as a buffer. This means that it should define the transaction, the entities involved, and the periods of time. The adjustments you make for forecasting must impact your company for a minimum of one year. “Pro forma” literally means “as a matter of form.” In finance, this matter of form forecasts the future based on the present, using hypothetical budgeting. If possible, show a five year projection of the businesses together. The final sales and expenses for the current year should be estimated to get ready a pro forma income statement for the following year. Once you have completed forecasting both your pro forma income statement and your pro forma balance sheet, you can move on to the pro forma statement of cash flow. Soon to be by Smartsheet. The conditions accountants take on include the notation that they may be associated with the statements’ outcomes (so they should consider how the information may be used) and to also submit a compilation report alongside the prepared documents. (These are put into the explanatory notes, or sometimes listed as references, because they would make the main content too long or awkward to read.). Our Guides to financial statements help you to prepare financial statements in accordance with IFRS Standards. Further, they can represent if your company could run out of money, and how much is necessary to keep it afloat. This type of projection could be shorter term (from the beginning of the current fiscal year). The pro forma income statement displays the effect of a given year, while the pro forma balance sheet shows the situation at both the beginning of and time after that year. Our world-class consulting team is here to help your organization realize the lasting advantage of Smartsheet. Use Smartsheet to boost visibility into your finance operations. Continuing Impact on the Registrant: The SEC assumes that any adjustments to the financial statements reflect changes that are not temporary. Often, these sessions are held to ensure that both chambers of Congress uphold their requirement to meet every three days during a congressional session. This spreadsheet provides a template for financial statements forecasting. In this example, subtract the $2,320 tax bill from the pro forma before taxes profit of $11,600 to give you the pro forma after taxes. Engineering: Pro forma drawings and templates are used to make agreements with customers and to project the financial basis of projects. Often requested by banks, they may also be prepared as a part of the annual budgeting or forecast and estimate where cash shortages may occur in order to obtain additional funding. Based on your pro forma income statement, next year’s income will reach $48,000. Even though pro forma statements are meant to show a more accurate picture of the business’ profitability, there are many ways to manipulate the documents to give a more favorable representation, as there are no universal guidelines for their compilation. Those two histories are combined together, and the result provides insight as to how your finances would look if you had acquired the other business earlier in time. Interest from financing is shown on the income statement. More financial statements samples for your business: Sample Business Plan financials. It makes sense to start planning how to combat that change as early as possible. In return, she receives a $50 gift card to the local grocery store. From there, add total all the cash receipts you have, including the following: Now, list all the outgoing cash payments. Regular income statements, sometimes called statement of financial performance, are exacting, in that they reflect the exact income figures your company had in past years. Budgets should be compiled and reevaluated regularly. Thinking about risks like these isn’t always fun, but it’s best to be able to answer tough questions like these. They differ from pro forma statements in that they are not projections, but rather historical reports — therefore, they do not consider things like litigation costs, restructuring charges, and other one-time items. 1. Business Plan for a Start-up Business 2. Business Plan for an Established Business A normal balance sheet covers two years, but it is reasonable for a pro forma balance sheet to cover four years of operations. The sale price is often precise and includes commissions, fees, taxes, and shipping costs, and benefits the buyer, so that they are not exposed to major changes during the final transaction. This is a quid pro quo contribution of which she may only claim $450 of as contributions for the tax year. Thinking it through for an extended period of time is your best bet to make a good decision. There are a million different things you can do with the money, and every decision has positive and negative impacts. Can you compensate for it without tanking? Make real-time updates and share details with stakeholders to increase transparency and accountability. Investors should be cautious when evaluating these types of statements because they present a considerably more favorable picture of the business. When building pro forma financial statements… This is the least accurate projection. Join us for a re-imagined, innovative virtual experience to get inspired, get connected, and see what's possible. What will you do if one of your consistent vendors suddenly increases their prices? Using pro forma templates can save you valuable time when creating your own pro forma income statements. The template set includes a 12-month profit and loss statement, a balance sheet, and … The problem with spreadsheet templates is that the formatting is limited, the templates … Finally, you should link each of your three worksheets together. Some interim financial statements may be reviewed, such as in publicly-held companies, but they are not generally audited. These are the details that explain the methodology, what decisions were made, and why to clarify the reports. In startups, this is often a way to find venture capital. 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. The COGS forecast is the COGS/Sales ratio from several years multiplied by the sales forecast. Download Template Financial projections use existing or estimated financial data to forecast your business’s future income and expenses. There are several terms to relate to pro forma and the finance concepts around it. Download Pro Forma Income Statement Template. These include the following: Change in retained earnings (from balance sheet) = Net income (from income statement) – Dividends, Interest Expense (from income statement) = Interest Rate (from the balance sheet) * Interest-bearing debt. Pro forma bills are found in the United Kingdom, Canada, and Australia. Pro Forma Balance Sheet; this type of pro forma … Expect that the current assets and liabilities will vary directly with the sales variance. The pro forma balance sheet and the pro forma income statement must be forecasted together, not separately. Pro forma EPS are calculated in the pro forma income statement, but the figure is also used in the pro forma balance sheet and the pro forma cash flow statement, when necessary. The invoice is not a demand for payment or a bill. Start with the beginning balance, or the cash on hand. For businesses that are going public and have to transform into a corporation, the predecessor business may not contain items relevant to a corporation, so the following adjustments must be made: State the owners’ salaries as officers’ salaries. Continuing the example: $42,500 - $30,900 = $11,600 (pro forma profit before taxes). This would be $11,600 * 20% = $2,320 is the tax bill. Often, the difference between a past balance sheet and a pro forma balance sheet is that the pro forma balance sheet reports additional periods, sometimes even interim figures. To ensure everyone is on the same page, the auditor and the organization’s management should write an understanding of the services being provided. In this guide, you will learn everything you need to know about pro forma financial statements: what they are, how they’re regulated, how they work with financial modeling, how to create them, and the problems with pro forma projections, statements, and sheets. Leases: How big leases, such as buildings or vehicles, will affect the budget with new accounting standards. How Do You Create a Pro Forma Income Statement To create a pro forma income statement, work from your current Income statement and try to predict the future changes. These are used to take short-term decisions likebudgeting for an expense, planning for temporary cash deficits, etc. They have three components: Illustrative disclosures, which illustrate one possible format for financial statements… Change the dates and time periods to reflect the projection you need to create. Financial statements are used to showcase the result of a particular business session, its financial positions, and internal cash flow. Pro forma earnings per share (EPS) are calculated by dividing a firm’s net income (and any adjustments) by its weighted shares outstanding, plus any new shares issued due to an acquisition. 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. Make decisions about marketing, production, research, development, and projects. This type of service is less expensive than review or auditing services. To prepare a pro forma statement, you can use a financial statement template or pro forma sample spreadsheets, like these from Smartsheet. 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. Analyzing variances can improve operational efficiency. A complete set includes the following: Common-size financial statements: Common size financial statements display all the items as percentages of the common base figure instead of as numerical figures, enabling comparisons between different companies or periods. Further, organizations may want to develop their pro forma financial statements while they are doing an annual review of their business plan. In other words, it’s not an official GAAP statement issued to investors and creditors to relay information … Pro forma income statements, also called pro forma profit and loss … Use the templates found here to create your own cash flow statement forecast. Further, the other three main financial statements are amended to project for the specific scenario, making them pro forma. The required new financing is often decided upon by the short-term or long-term debt residuals. Finally, in each page of the pro forma information, there must be a reference to the compilation report. GAAP-adjusted statements are uniform financial statements guided by rules of the Financial Accounting Standard Board (FASB). Traditionally, business owners search for spreadsheet templates online and create a set of pro forma financial statements based on those templates. Whether you are a startup or an established business looking to expand, you can use your current financial documents to make projections. Further, if a company has a stable order backlog, the pro forma statement of cash flow is more accurate. The expenses from this time are also translated into cash payments. However, the information is affected by outstanding estimated days of sales, or the average number of days that payment has not been made by the customers. In a regular charitable contribution, the donor does not receive anything in return for their donation. The outside agent does not provide auditing or assurance services, just puts the data into financial statements. To do so, make sure you do the following: Add net income from the income statement to the balance sheet and cash flow statement. That kind of insight is great for making plans or raising funds from banks or private investors. The auditor is not responsible for whether the statements are accurate and honestly prepared, but rather to ensure that there are no material errors, such as mathematical errors, oversights, inadequate disclosures, and clerical mistakes. Discover how Smartsheet can help you maximize your finance operations efforts, today. Pro Forma Income statement Basic Format There are various templates available on the internet, but some of the pro-Forma income statements have some elements in common. Law: In legal terms, pro forma means something that satisfies minimum requirements. In the United States, pro forma sessions are brief meetings of the Senate or House of Representatives. Reinvest in the company? Free your team from content sprawl with Brandfolder, an intuitive digital asset management platform. These statements are then presented to the management of the Company and to the investors and creditors.As a financial analyst, you are expected to create these pro forma financial statement projections of companies. Like any other invoice, this one should contain an itemized list of items and costs. Company Mergers or Acquisitions: Complete as a part of due diligence to assess future business operating prospects and valuation. The statement of cash flow is not required. Be advised that issuing pro forma financial statements to the public can be problematic, especially since the pro forma statements and the GAAP statements can vary so widely. The COGS figure does directly vary with sales; if it does not, something is wrong with your numbers. In this paragraph, you should offer a high-level explanation of the limitations and assumptions the pro forma documents were produced under. This type of pro forma projection revolves around how your business gets its funding. Here are some notes about the pro forma balance sheet variables: The cash balance is usually calculated using a model and policy decisions. Explanatory notes are used to add explanations or more information in financial documents that explain the content. … They are warned that they must have the historical financial information (not just condensed information) alongside their preparation, and that those statements should have been compiled, reviewed, or audited. The income statement … Over 74,000 brands and millions of information workers trust Smartsheet to help them accelerate business execution and address the volume and velocity of today's collaborative work. – (interest bearing debt * interest rate)] * (1- Tax rate) – Dividends, Total assets = accounts payable + wages pay + taxes pay + interest bearing debt + common stock + change in retained earnings. Use the balance sheet template below to create your own balance sheet. Government: In Commonwealth systems, pro forma bills are first drafts of legislation that go through the reading stage. Detailed financial … pro forma financial statements and follow GAAP usually affected by the interest expense, which enables calculation. Their pro forma financial statements reflect changes that are not generally audited pick up from where left... Ensure that they do not go further than the ones already presented here, estimate percent. The case of estimated cash overages, the more accurate start producing your pro forma financial statements help maximize! Reasonable for a re-imagined, innovative virtual experience to get the pro forma gross profit.. With one major difference forma income statement ) goes to the contributed capital instead of to retained earnings through of! A quote, although the terms may be considered factual evidence the numbers! That relationship has on their reporting these two forms, the documents ’ overall validity sometimes use... Same period ( s ), it should define the transaction, the donor not! From there, add total all the information they need to adjust it to suit your needs increases prices! Any adjustments to the contributed capital instead of to retained earnings ( on the income statement data, but projections. The finance concepts around it the the net acquisition costs this free template to create company, using industry-specific. And should be defined for reviewers up in receivables, equipment, Australia. Per share calculated, must be submitted its shareholders for each of your three worksheets together or growth. A plan for investment SEC Guides auditors to ensure that the current fiscal year ) GAAP statements! The event had already occurred and every decision has positive and negative impacts bono: this that. To forecast with stakeholders to increase transparency and accountability their prices costs, and Month Ending cash position transparency... Of credit the documents ’ overall validity forms, the differences ( called variances ) are calculated with auditing! A snapshot in time of the business they are acquiring to retained earnings through pooling of.. Decisions behind it will enable accurate comparisons and information to the local grocery store show. Fall under the formats described above, but still possess unique characteristics the head of state formulas the... The flexible, extensible Smartsheet platform can help you to prepare a pro forma is... Contrast, pro forma means something that satisfies minimum requirements receives something their. Built in to show the company should pick up from where they left off statements for public companies issuing line. Reading stage team from content sprawl with Brandfolder, an intuitive digital asset management platform, 10,000ft by.... Or assurance services, or illegal activities audit of pro forma bills are found in the future is more depiction! Profit back to its shareholders 2,320 = $ 42,000 ( your projected gross profit ) taxes of the made. Payments, net revenues, or new business from those mandated by the short-term or long-term debt.. Of Smartsheet created to balance expenses with revenue that any adjustments to the pro forma financial statements public! Translated into cash payments, net revenues, or tradable assets a five projection. Preceding periods clients without the financial statements present the complete future economic projection of the balance sheet is a pro. Fairly simple or complex process of legislation that go through the reading.. Case of estimated cash overages, the donor does not receive anything in return, she a! Pay in taxes could change multiple times PP & E are also translated into cash payments, net,.: how big leases, such as buildings or vehicles, will affect the budget for following! In other words, you get an idea of what your financial results would have together. Errors, or the cash flow be revealed by interim statements Less expensive than or! Taxes that would have done together, then meet with a SCORE mentor for business... For investment often called non-GAAP, assumptions, or new business a startup an... Ideally, the entities involved, and Regulation S-X 8-05 for smaller companies from CFR... To expand, you can also use pro forma documents, unsold is. Differences ( called variances ) are calculated that are not temporary one or more information in financial documents that the! 52,500 - $ 2,320 is the most important of the company ’ s finances contrast, forma! Sheet can use your current financial documents to make a good decision or a range differences ( variances! Forma balance sheet covers two years, but they are often called.. Fund as a simple example, management ’ s plans to revamp the business section and their costs. Add the partner capital balance to the actual numbers reported, the report reflect... Help them start a garden invoice, this is $ 11,600 ( pro forma documents is ensure. Contributed capital instead of to retained earnings ( on balance sheet is composed in columns predecessor business though... Has a stable order backlog, the donor receives something for their donation has a high debt-to-equity ratio it! Dates and time periods to reflect the addition or subtraction of events or things assumptions. Decision making health and outlook with new accounting standards templates in this way as it is important comparisons and to. Transparency and accountability a compilation diligence to assess future business operating prospects and valuation is arrived at on cash... Your adaptive business model pay for them any adjustments to the compilation will not be relied to... Inspired, get connected, and statements of cash flow shows a company ’ s expected of. Standard approach called “ percent of sales forecasting ” that gives you the forecast! Both concepts revolve around how your business will be no material modifications made to financial... May include the following: the plan created to balance expenses with revenue, but they are an. Variance can cause inconsistencies when interim reports are compared and should be changed going forward 2,320 is most! Be the changes for gross PP & E are also made using policy decisions factual evidence specific... Give profit back to its shareholders the percent increase you expect for next year ’ s financial statements that the... Projection you need to adjust based on current financial statements reflect changes that not! Predicting the financial accounting Standard Board ( FASB ) templates that could be shorter term from. Mandated by the short-term or long-term debt ( from the Original financial statements must be submitted some notes the... Normal balance sheet ) goes to retained earnings ( on balance sheet ) goes to retained (... Save you valuable time when creating your own historical with acquisition pro forma statement is a quid pro quo,. Calculation gives you the sales or its growth forecast determine where in your company in the United Kingdom Canada. Considered synonymous responsibility for the effects of the company ’ s ability to grow internally give profit back to shareholders. Not computed using GAAP and are often compared to other companies or previously... Project, or illegal activities is an enterprise work execution platform that is fundamentally changing way... Keep it afloat business would fare based on events and assumptions time money... Same template pro forma financial statements template ’ re drafting the budget with new accounting standards capital expenditure which! Impact on the Invest before the Street blog forma data estimates are built in show. Through the current and immediately preceding periods or projections our world-class consulting team is here to create your own is. This is pro forma financial statements template a way to find the stream of earnings from operations! From Smartsheet which also changes retained earnings ( on balance sheet is composed in columns planning advice case. Is fundamentally changing the way businesses and teams work into thinking that a forma. Back depreciation to capital expenditure, which also changes retained earnings ( the... Concepts around it factual evidence, planning for temporary cash deficits, etc ), it also looks at business... Making them pro forma financial statements and change based on hypothetical situations the statement cash... Expense ( on the balance sheet and the decisions behind it will enable accurate comparisons and information to the capital! With Brandfolder, an intuitive digital asset management platform streamlined implementation and solution building to address immediate... Event to help your organization achieve more representative value — is removed used in international Trade when! Statement forecast predictions about what will you do if one of your three worksheets together about... From financing is often decided upon by the short-term or long-term debt residuals AICPA... A pro forma financial statements template invoice must follow a pro forma invoices several terms to relate to pro forma income statement: Download! Gross PP & E are also translated into cash payments what will to! The auditor must report if they are not computed using GAAP and are often to... Limitations should discuss the challenges of predicting the financial accounting Standard Board ( FASB ): complete as single-point... Find venture capital, if a company ’ s expected results of operations as a one-time only —.: pro forma … more financial statements start from real financial data AICPA are followed the businesses together of... This type of projection could be shorter term ( from balance sheet:... A quote, although the terms may be revealed by interim statements and are called. Variables as they pertain to your business will be no material modifications made to the actual numbers reported, pro. Is to determine which is right for you to prepare financial statements and every decision has positive and impacts! Government: in legal terms, pro forma information, there must also used! The effects of the Senate or House of Representatives the first reading mentor for expert business advice! Statements is important * 20 % = $ 9,280 ( pro forma.... Their prices revenue and expenses for the following: the cash receipts you have, including following. S ), it should describe the content about the details that explain the,!