Credit portal




How to create a pro forma income statement

how to create a pro forma income statement

Things You'll Need

Current year's income statement to date


Evaluate the business' previous year's income statement. This can either be done line by line or by subheadings. For instance, line by line would look at sales figures for each product line whereas the subheading would be "Total Sales."

Make a simple pro forma income statement by evaluating this year's sales to date as compared to last year's total sales. Calculate the percentage change of this year's sales compared to last year's sales. Take current "Total Sales," divide by the number of months into the year it represents and multiply by 12 to annualize the number. Compare that number to "Total Sales" for last year and figure out the percentage change: (this year's annualized sales -- last year's sales)/last year's sales x 100. For instance, if last year's "Total Sales" were $1,000,000 and this year's annualized sales are $1,100,000, the percentage growth is ($1,100,000-$1,000,000)/$1,000,000 x 100 = 10%.

Create a pro forma income statement by using the calculated

percentage change in sales. In this example, you would multiply all of last year's income statement line items by 1.10 to show a 10% increase. Work the arithmetic through to the bottom to complete a pro forma income statement.

Study your new pro forma statement to determine if your assumptions are valid. Perhaps you will be making the increase in sales with no additional staff and you expect to find a different supplier who will reduce your "Cost of Goods Sold" by 5%. In this case, you would annualize your payroll from your current income statement and use that number in your pro forma statement. You would also take the pro forma "Cost of Goods Sold" you calculated and reduce it by 5%. Plug those numbers in and recalculate a new pro forma income statement

Repeat creating a new pro forma income statement for any and all realistic assumptions about your business. It is not unusual for a business to have several pro forma income statements based upon various assumptions.

Category: Forex

Similar articles: