How To Make A Pro Forma Income Statement

how to create a proforma income statement

If it’s negative, it means you won’t have enough cash on-hand to run your business, according to your current trajectory. Projections about the future are not required to follow the strictest accounting standards, but companies must avoid committing fraud when creating pro formas. 500,000 book value of the plant (i.e., the construction cost) and the annual depreciation allowance percentages from the MACRS table .

At some point, we need to hire someone or find a more scalable method. When we know how many units we need to sell, we may get a clearer picture of what else we need to do. For instance, we may now better understand how many customers we need, the number of leads we need from marketing, and maybe even the marketing budget required to achieve these numbers. For instance, if we’re selling products, and each product sells for $100, then our forecasted revenue equates to the sale of 1,200 units, which is easier to digest. If today, our monthly revenue is $100,000, then a 20% increase equates to $120,000 six months from today.

how to create a proforma income statement

The balance sheet will project changes in your business accounts over time. Pro forma profit after taxes is figured by subtracting the pro forma tax bill of $70,500 from the pro forma profit before taxes of $235,000. Your pro forma profit after taxes, in this case, would be projected at $164,500. Pro forma profit before taxes is figured by subtracting the pro forma expenses from the how to create a proforma income statement pro forma gross profit, or $315,000 from $550,000, for a pro forma profit before taxes of $235,000. Let’s assume salaries and other expenses will increase by 5 percent. So, you multiply your historical salaries of $200,000 and your historical expenses of $100,000 by 105 percent each. Your pro forma salaries for next year will be $210,000 and your pro forma expenses will be $105,000.

Step #2 Add In Your Assumptions

The key idea is that we’re looking for businesses in a similar industry or with a similar business model. If we can find examples at a smaller scale, when things are less complicated, that’s probably best. Otherwise, we may need to look at larger, public companies and drastically simplify their costs to arrive at some starting point. Once we’ve converted all costs into a percentage of revenue, we simply multiply each one by the forecasted revenue to get our costs for the pro forma. Creating your pro forma is straightforward if you understand just a few concepts. We’ll first cover the process for existing businesses, so if you’re only interested in new companies, feel free to skip ahead. Subtract total liabilities from total assets to determine projected shareholder equity.

  • Taxes owed by the plant are shown in Line , equal in this example to 35% of taxable net income, as long as taxable net income is positive.
  • According to the SEC, when the dividends from stock exceed or are planned to exceed the current earnings, the EPS must be calculated.
  • Since pro forma financial statements and financial projections are quite similar, they may be considered synonymous.
  • Subtract total liabilities from total assets to determine projected shareholder equity.
  • Learn more about the standards we follow in producing Accurate, Unbiased and Researched Content in our editorial policy.
  • By contrast, pro forma financial statements are based on current financial statements and change based on events and assumptions.

An investor is any individual or entity that has a financial stake in a business, with the expectation of a financial return. Likewise, businesses use this information to paint a picture of future success to persuade potential investors and/or to maintain the confidence in their current investors. If you want to create your own pro forma financial statement, there are numerous templates available online for free. Here are the basic components of a standard pro forma income statements. Step one is estimating revenue outlooks for your business, and this step is commonly referred to as pro forma forecasting. Base your estimates on objective measures that you can back up with hard data. Research your topics and consult with experts to determine an average annual revenue stream, cash flow, and asset accumulation projections.

Use historical trends such as the percentage of gross revenue that you typically spend on materials and labor. Also figure in specific upcoming expenses that are on your radar, such as a rent increase or equipment purchase. Subtract the total projected expenses from total projected revenue to calculate your pro forma net profit. These assumptions can be off by a little or a lot, but the bottom line is their outcomes should not be weighed too heavily in decision-making without other indicators to back up the assumption. And as we mentioned earlier, they are not in compliance with GAAP, which means they have to be labeled as pro forma and cannot replace formal financial statements.

Pro Forma Earnings Per Share

When preparing pro forma financial statements, the pro forma cash flow statement is prepared at last. Based on the adjustments in the pro forma income statement, other balances in the pro forma balance sheet should also be adjusted. For example, if the business based its pro forma income statement on a 20% expected increase in its revenues, then it is highly likely that the debtor balances of the business will also go up. Similarly, the cost of goods sold will also increase in line with the increase in the revenues of the business, thus, resulting in higher creditor and inventory balances. Pro forma financial statements are financial reports issued by an entity, using assumptions or hypothetical conditions about events that may have occurred in the past or which may occur in the future. These statements are used to present a view of corporate results to outsiders, perhaps as part of an investment or lending proposal. A budget may also be considered a variation on pro forma financial statements, since it presents the projected results of an organization during a future period, based on certain assumptions.

They can show the projection of what money will be tied up in receivables, equipment, and inventory. Further, they can represent if your company could run out of money, and how much is necessary to keep it afloat. If your company has a high debt-to-equity ratio, it will show on the balance sheet.

how to create a proforma income statement

The limitation of these statements is that they show the business owner nothing more than a prediction. No matter how good or bad that portrayal may seem, it’s only a good guess as to what may happen. Free cash flow to the firm represents the amount of cash flow from operations available for distribution after certain expenses are paid. Set a production schedule that will let you reach your goal, and map it out over the time period you’re covering. In this case, you’ll want to earn an additional $1,500 income every month, for 12 months. Let’s say you want to increase your income by $18,000 over the course of one year. Get financed, by showing lenders or investors how you would use their money to sustainably grow your business.

Pro Forma Example: How To Create Your Financial Statements

However, if she loses in Vegas, she will have to borrow more, her new debt quadrupling her liabilities and decreasing her net worth by that much more. It is particularly valuable in predicting when your business may experience a cash shortage. It is also valuable in tracking what is leading to the cash shortage and, hence, makes it easier to figure out what you might want to change to alleviate the shortage. Use these sheets to predict how certain events will impact the business.

Like a pro forma income statement, a pro forma balance sheet would be created by building a balance sheet for a given date based on projected values. For example, create a pro forma balance sheet for 12 months in the future and populate the fields with projected asset values, liabilities, and equity in a year. Datarails’ FP&A solution is a one-stop solution for effective planning and building pro forma financial statements. This ultimately provides you with the resources to compare forecasts, budgets, and business plans and prepare accurate pro forma financial statements that are realistic for business planning.

  • Use these sheets to predict how certain events will impact the business.
  • Building accurate pro forma financials requires an in-depth financial analysis of your present business.
  • You can use a pro forma income statement to review the projected operational business costs against the current fiscal budget.
  • No worries, this article will gently accompany you in your knowledge journey.
  • The final column is your pro forma, which gives you the historical profit and loss.
  • When we know how many units we need to sell, we may get a clearer picture of what else we need to do.

Here’s a basic list of common small business startup costs that turned up with a quick search. If we want to extend this forecast further into the future, we simply focus on increasing our revenue-driving activities (as long as they’re working). When we have some idea of how we’re going to drive sales, we can look at how the transaction between the business and the customer occurs, which is a critical part of our revenue model. To get some ideas, look at how companies with similar business models generate new business. The chosen method often determines at what price we need to sell our product to make a profit. There are many different revenue drivers, but our chosen method for generating new business should be appropriate for the amount we charge customers. We don’t want to spend three months courting a new client to sell them a $20 product.

Cost Of Goods Sold Cogs

Simply put, pro forma financial statements are financial reports that are created on hypothetical assumptions. For example, in creating a pro forma income statement, you would need to forecast revenue for future periods. This can be done by analyzing past sales, orders for products or services in the current period or any backlog orders yet to be fulfilled. A realistic revenue amount can then be forecasted and used in a pro forma income statement. A pro forma income statement, along witha pro forma cash flowanda pro forma balance sheet, form the primary financial projections for a business. They should also be included with in the financial ofa business plan. These models forecast the expected result of the proposed transaction, with emphasis placed on estimated net revenues, cash flows, and taxes.

  • 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.
  • Simply import financials and then use the dashboard on the Pro Forma Template to choose various custom scenarios.
  • Whether you’re trying to interpret pro forma financial statements or prepare them, these projections can be useful in guiding important business decisions.
  • Next, add up all your operating expenses, as well as any other expenses like income taxes and cash disbursements.
  • Use realistic market assumptions and not just numbers that make you or your investors feel optimistic.
  • Start with an income statement from your most recent fiscal year and identify which items you will adjust for the projection.

That means taking info from the income statement, then using the cash flow statement format to plot out where your money is going, and what you’ll have on hand at any one time. This pro forma statement can be part of a larger cash flow forecast used for decision making. While they all fall into the same categories—income statement, balance sheet, and cash flow statement—they differ based on the purpose of the financial forecast. This is a projection of a company’s year-to-date results, to which are added expected results for the remainder of the year, to arrive at a set of full-year pro forma financial statements. This approach is useful for projecting expected results both internally to management, and externally to investors and creditors. Assumptions form the bedrock of pro forma statements; hence, a reliable pro forma statement is a financial model prepared on the back of realistic and justifiable assumptions.

Next, you should create a production schedule that will allow you to achieve this goal and map it across the time period. “What if” is one of those key turns of phrase that business owners need to think about virtually all the time. Some firms exclude unsold inventory of their statements, which, in a way, portrays inefficient management to produce inventory that cannot be sold. Create a best, likely, and worst-case scenario separately in the statement. The loss your business incurs because of the cat widgets really makes a big dent in your income, so you decide to stop manufacturing and selling cat widgets.

Hopefully, our fictitious business helps illustrate the role variable costs play in growth. Even though they may seem small initially, they will significantly impact the business’s profitability later on. As we covered in the existing business section, variable costs increase as sales grow . These costs become more important as you scale the business because they depend on revenue, which means you can’t grow revenue without growing these costs.

By doing so, managers can decide which business decisions look more beneficial and which ones to avoid. A pro forma cash flow, along witha pro forma income statementanda pro forma balance sheetare the basic financial projections for your business and should be included with your business plan.

What Can I Do To Prevent This In The Future?

The sales total and customer payment history help the firm determine the accounts receivable balance. There are both benefits and downsides to the assumption structure that pro forma is built upon. Cash Flow From Operating Activities indicates the amount of cash a company generates from its ongoing, regular business activities. She holds a Bachelor of Science in Finance degree from Bridgewater State University and has worked on print content for business owners, national brands, and major publications. Creating different scenarios – conservative, likely, and ambitious can help you understand the range of outcomes and help you set targets and plan for stable, sensible progress. Your goal should be to observe and analyze the cost-benefit ratio of each situation and prepare accordingly based on your plan.

A firm might construct a pro forma income statement based on projected revenues and costs for the following year. Likewise, a firm may wish to develop a set of pro forma statements to determine the effect of a projected stock buyback. This projection looks backward at another company’s financial statements.

how to create a proforma income statement

The purpose of pro forma is to analytically predict how well a business will perform in the future to help business owners make the best decisions. This also informs potential investors of which businesses to invest in for future investment opportunities.

Companies use it to see the real financial health on a monthly and annual basis. A pro forma cash flow statement contains a list of all the expected cash inflows and outflows from different business operations, like investing. Businesses use these reports to create budgets and run risk assessments. Once a percentage is determined, it should be applied to both the revenues and cost of goods sold of the business in its last income statement.

They can determine whether yourmarketing campaigns need an extra boostduring the fall months. All in all, they provide you with invaluable information—the sort of information you need to make the right choices for your business.

Fixed costs are simple because they don’t change, but variable costs aren’t as straightforward. Use your best judgment to determine some way to estimate each variable cost. When in doubt, rely on the common size percentages we discussed in the existing business section. Some examples of variable costs include sales commissions or materials , and fixed costs might be rent or salaries. Once we have some reasonable assumptions regarding how many customers we’ll acquire, how much money they’ll pay, and when they’ll pay, we should have enough information to calculate revenue. The simplest example is a customer giving the business money in return for some product or service.

Building accurate pro forma financials requires an in-depth financial analysis of your present business. When creating pro forma financial statements, ask an accountant to provide additional guidance. Small business owners draft pro forma financial statements to quantify the impact of potential business decisions, such as taking out a loan to grow your business. Pro forma financial statements give you and your team something to consider before signing on the dotted line. In other words, they’re basically the same financials you’re already accustomed to, just using hypothetical data. So as you’ll see once we discuss how to create pro formas in just a little bit, they don’t require you to recreate the financial reporting wheel, at least in terms of format. Since the preparation of the balance sheet depends on figures obtained from the income statement, the pro forma balance sheet is the next pro forma financial statement to be prepared.

Since pro forma financial statements and financial projections are quite similar, they may be considered synonymous. However, financial projections can be built from nothing for a startup company, using specific industry-specific assumptions. By contrast, pro forma financial statements are based on current financial statements and change based on events and assumptions. In other words, pro forma financial statements start from real financial data.