Contents
In short

A pro forma income statement is a projected or as-if profit and loss statement built on stated assumptions instead of closed books. Companies use it to show what results would look like under a plan, a scenario or a transaction such as an acquisition. It is not a GAAP statement, so every assumption and adjustment has to be listed.

A pro forma income statement is a projected or as-if profit and loss statement: revenue, costs and profit under a set of assumptions instead of closed books. Companies build one to plan the next years, compare scenarios, raise money or a loan, or show what last year would have looked like if an acquisition had already closed.

Most guides show a pro forma built by growing last year's sales by a percentage and keeping every cost as a percent of sales. That works for a shop. It does not work for a subscription company, where next year's revenue is mostly decided by the ARR you already have, the customers you will lose and the expansion you will sell. This guide builds the statement the way a SaaS finance team should: from an ARR bridge, with a range of scenarios, a reconciliation from adjusted numbers back to GAAP, and a free template that does all of it.

Free pro forma template (Excel and Google Sheets)
Six tabs: Start here, Assumptions, ARR bridge, Pro forma P&L, Scenarios, Acquisition. No macros, no sign-up. In Google Sheets use File, Import, Upload.

What is a pro forma income statement?

A pro forma income statement is an income statement prepared on assumptions: either a projection of future years or a restatement of past results as if a transaction had already happened. The two uses share a format and a name, and they answer different questions.
Pro forma projectionTransaction pro forma (as-if)GAAP income statementNon-GAAP measure
Question it answersWhat will results look like under this plan?What would last year have looked like with the deal done?What happened?What happened, excluding or including certain items?
PeriodFuture yearsA past year and the interim period sinceA closed past periodA past or future period
Built fromDrivers and assumptionsHistorical statements plus adjustmentsThe general ledgerA GAAP line plus or minus named items
RulesNone required; label it pro formaSEC Regulation S-X Article 11 for public filersUS GAAP (ASC 606 for revenue)SEC Regulation G for public disclosure
AuditedNoNoYes, for audited companiesNo
Typical readerBoard, investors, lenders, managersInvestors in a merger or acquisitionEveryoneInvestors, analysts
The first column is what most people searching for a pro forma income statement need: a three-year projected P&L for a plan, a fundraise or a loan. The second matters when you buy or sell a business. The last two columns explain why a pro forma is never presented as if it were the company's reported results.
Put this to work on your numbers
Run your own numbers with the free Profit and Loss Statement Template, then see how ORM builds it into a custom model.

What does a pro forma income statement include?

It includes the same lines as your actual income statement, from revenue down to net income, plus the assumptions that produce each line. Keeping the lines identical to your actual P&L is what makes the pro forma useful later, because each year you can put actual results next to the plan line by line. For a SaaS company the lines, and the driver behind each one, look like this.
LineHow a SaaS pro forma projects itDriver to write down
Subscription revenueAverage ARR of each quarter, divided by fourNew-logo ARR, expansion rate, churn and contraction rate
Professional services revenueA share of new-logo ARR (implementation sold with new deals)Services attach rate
Cost of subscription revenueSubscription revenue x (1 minus subscription gross margin)Hosting, support and customer success cost
Cost of services revenueServices revenue x (1 minus services margin)Delivery team utilization
Sales and marketingBookings x the cost to acquire each dollar of ARRNew CAC ratio, expansion CAC ratio
Research and developmentA share of revenue, or the engineering hiring planR&D % of revenue or headcount
General and administrativeA share of revenue, or the G&A hiring planG&A % of revenue or headcount
Depreciation and amortizationFrom the fixed asset and capitalized software scheduleCapex plan
Interest and taxesCash balance and debt; tax rate on taxable profitRate assumptions
Memo: stock-based compensationA share of revenue or the grant scheduleNeeded for the non-GAAP reconciliation
Two lines carry most of the weight. Revenue sets the size of everything else, and sales and marketing is usually the largest cost. That is why the revenue build deserves more care than any other part of the statement.

How do you create a pro forma income statement?

Start from the last year of actual results, project revenue from an ARR bridge, project each cost from a driver, then run the same statement for a low, base and high case. Eight steps:
  1. Close the base year. Enter the last full year of actuals and the ending ARR of that year. The pro forma starts where the books end, so the first projected year has a real number to grow from. The profit and loss statement template holds the same SaaS lines for actuals month by month.
  2. Build the ARR bridge by quarter. Beginning ARR, plus new-logo ARR, plus expansion, minus churn and contraction, equals ending ARR. New-logo ARR comes from pipeline, win rate and rep capacity; the method is in how to build a driver-based revenue forecast. Forecast renewals and expansion separately from new business: renewal amounts and dates are mostly known in advance, new business is not.
  3. Spread bookings by quarter. Bookings do not arrive evenly. Across ORM customers, Q4 is typically the largest quarter, followed by Q2, then Q3, then Q1. A flat 25% per quarter overstates revenue in a year when most bookings land late.
  4. Turn ARR into revenue. Subscription revenue for a quarter is roughly the average of beginning and ending ARR, divided by four, because a deal signed mid-quarter only earns part of the quarter. ARR is not revenue, and the gap between them is covered in ARR vs GAAP revenue.
  5. Project costs from drivers. Cost of revenue from gross margin, sales and marketing from the bookings it has to buy, R&D and G&A from headcount or a share of revenue. Write the driver next to every line.
  6. Finish below the line. Depreciation and amortization, interest income and expense, and tax on positive pretax income.
  7. Run the range. Change only the revenue drivers between a low, base and high case, and let the costs that depend on them move too.
  8. Label it and reconcile it. Head every page "pro forma", list the assumptions, and if you show adjusted EBITDA or non-GAAP operating income, show the bridge from the GAAP line.

Pro forma income statement example: a SaaS company at $8M ARR

Below is an illustrative three-year pro forma for a B2B SaaS company that ended its base year, FY2026, with $8,000,000 of ARR and $7,700,000 of revenue. Every number is made up to show the mechanics, and the same company is in the example download, so you can trace each figure to a formula.

The base case assumes $2,000,000, $2,400,000 and $2,800,000 of new-logo ARR in the three years, 12% annual expansion and 10% annual churn and contraction on beginning ARR, both applied a quarter at a time. New bookings land 20%, 26%, 22% and 32% in Q1 to Q4, which follows the quarter order ORM sees across customers.

First, the ARR bridge that drives revenue:

ARR bridge (base case)FY2027FY2028FY2029
Beginning ARR$8,000,000$10,174,647$12,795,803
+ New-logo ARR$2,000,000$2,400,000$2,800,000
+ Expansion ARR$1,047,882$1,326,935$1,659,973
- Churn and contraction ARR$873,235$1,105,779$1,383,311
Ending ARR$10,174,647$12,795,803$15,872,465
ARR growth27.2%25.8%24.0%
Net revenue retention (approximate)102.2%102.2%102.2%
One quarter shows how revenue comes out of it. In Q1 FY2027 the company starts at $8,000,000, books $400,000 of new ARR (20% of $2,000,000), adds $240,000 of expansion (12% / 4) and loses $200,000 (10% / 4), ending at $8,440,000. Subscription revenue for the quarter is ($8,000,000 + $8,440,000) / 2 / 4 = $2,055,000. Four quarters of that add up to $9,004,184 for the year. The retention row is approximate because quarterly expansion and churn also apply to customers won earlier in the same year; a cohort-based net revenue retention would differ slightly.

Then the pro forma income statement itself:

LineFY2026 actualFY2027 pro formaFY2028 pro formaFY2029 pro forma
Subscription revenue$7,100,000$9,004,184$11,385,439$14,217,688
Professional services revenue$600,000$500,000$600,000$700,000
Total revenue$7,700,000$9,504,184$11,985,439$14,917,688
Cost of subscription revenue$1,350,000$1,710,795$2,163,233$2,701,361
Cost of services revenue$450,000$375,000$450,000$525,000
Gross profit$5,900,000$7,418,389$9,372,206$11,691,327
Gross margin76.6%78.1%78.2%78.4%
Sales and marketing$3,300,000$4,038,306$4,901,548$5,807,978
Research and development$1,900,000$2,281,004$2,636,797$2,983,538
General and administrative$1,200,000$1,425,628$1,677,961$1,939,299
EBITDA-$500,000-$326,549$155,899$960,512
EBITDA margin-6.5%-3.4%1.3%6.4%
Depreciation and amortization$150,000$160,000$180,000$200,000
Operating income-$650,000-$486,549-$24,101$760,512
Interest income$40,000$40,000$40,000$40,000
Income before taxes-$610,000-$446,549$15,899$800,512
Income tax (21% of positive pretax income)$0$0$3,339$168,108
Net income-$610,000-$446,549$12,560$632,405
Revenue growth30.5%23.4%26.1%24.5%
Rule of 40 (revenue growth + EBITDA margin)24.0%20.0%27.4%30.9%
The drivers behind the cost lines: subscription gross margin of 81%, which is the Benchmarkit 2025 median; services sold at 25% of new-logo ARR and delivered at a 25% margin; $1.60 of sales and marketing for every $1 of new-logo ARR and $0.80 for every $1 of expansion; R&D falling from 24% to 20% of revenue and G&A from 15% to 13%. The tax line uses only the 21% federal corporate rate from IRS Publication 542, with no state tax and no loss carryforwards, which a real company with past losses would use to lower its tax bill.

How to read it:

  • Revenue lags ARR. The company exits FY2027 with $10.2M of ARR and books $9.5M of revenue, because new ARR only earns revenue from the day it starts. A pro forma that sets revenue equal to ending ARR overstates the year.
  • Sales and marketing follows bookings, not revenue. At $1.60 per dollar of new ARR, this company spends less than the Benchmarkit median New CAC Ratio of $2.00 and the median Expansion CAC Ratio of $1.00. Even so, S&M is 42.5% of revenue in FY2027, above the 37% median, because it is paying for ARR that turns into revenue over the next years. At the median ratios instead, FY2029 sales and marketing would be $7,259,973 and EBITDA would be -$491,483.
  • Profit comes from the cost lines that scale. Gross margin barely moves. EBITDA goes from -6.5% to 6.4% of revenue mostly because R&D and G&A grow slower than revenue. If those percentages are a hope rather than a hiring plan, the pro forma is too.

What the low and high cases show

A board should see the plan as a range, so the template runs three cases that change only new-logo ARR, expansion and churn. In ORM's experience, a board trusts a forecast that is consistent, traceable and framed with a realistic range: a low case, an on-target case and an upper bound. The low case here books about 20% less new ARR, expands at 9% and churns 13%. The high case books about 20% more, expands at 15% and churns 8%.
FY2029LowBaseHigh
Ending ARR$12,519,355$15,872,465$19,336,953
Total revenue$12,113,185$14,917,688$17,755,969
Sales and marketing$4,336,833$5,807,978$7,400,561
EBITDA$1,169,495$960,512$646,304
Net income$797,501$632,405$384,180
Net income, three years combined$1,428,968$198,416-$1,379,776
Net revenue retention95.8%102.2%107.7%
The low case earns the most profit. It books less, so it spends less on sales and marketing, and the lost growth only shows up in ARR. Ending ARR is $3.4M lower than the base case, and with net revenue retention under 100% the existing customer base is shrinking. A pro forma that shows only net income would make the weakest plan look like the best one. Put ending ARR and retention on the same page as the profit lines, and every pro forma tells you what the profit costs in growth.

How do you calculate pro forma revenue, costs and net income?

Each line is one formula on top of a driver. These are the formulas the template uses, written for one year with the inputs in named cells.
LineFormulaExcel or Google Sheets
Ending ARRBeginning ARR + new-logo ARR + expansion ARR - churn and contraction ARR=B5+B6+B7-B8
Expansion ARR (quarter)Beginning ARR x annual expansion rate / 4=B5Exp_rate/4
Subscription revenue (quarter)(Beginning ARR + ending ARR) / 2 / 4=(B5+B9)/8
Services revenueNew-logo ARR x services attach rate=B6Svc_attach
Gross profitTotal revenue - cost of revenue=B12-B13-B14
Sales and marketingNew-logo ARR x new CAC ratio + expansion ARR x expansion CAC ratio=B6New_CAC+B7Exp_CAC
EBITDAGross profit - S&M - R&D - G&A=B15-B16-B17-B18
Income taxTax rate x positive pretax income=MAX(0,B22)*Tax_rate
Net incomePretax income - income tax=B22-B23
Adjusted EBITDAEBITDA + stock-based compensation=B19+B26
Keep all the inputs on one tab and formulas everywhere else. When someone asks where a number came from, you can point to the driver in one click, and you can change a driver without editing a formula.

What rules apply to pro forma, GAAP and non-GAAP numbers?

A pro forma statement for internal planning has no required format, but the moment a public company shows adjusted or as-if numbers to investors, SEC rules decide how. Two sets of rules matter.

The first is Regulation G, for non-GAAP financial measures such as adjusted EBITDA. 17 CFR 244.101 defines a non-GAAP financial measure as a numerical measure of historical or future performance that excludes amounts included in, or includes amounts excluded from, the most directly comparable GAAP measure. When a public company discloses one, 17 CFR 244.100 requires it to present the most directly comparable GAAP measure and a quantitative reconciliation between the two. For forward-looking measures the reconciliation is required "to the extent available without unreasonable efforts". The same section bars presenting a non-GAAP measure in a way that is misleading.

The second is Article 11 of Regulation S-X, for transaction pro formas. 17 CFR 210.11-01 requires pro forma financial information when, among other cases, a significant business acquisition or disposition has occurred or is probable. 17 CFR 210.11-02 sets the form: condensed historical statements in columns, transaction accounting adjustments that depict the accounting for the deal, and optional management's adjustments for synergies and dis-synergies, each of which needs a reasonable basis. The pro forma statement of comprehensive income covers only the most recent fiscal year and the interim period since.

A private SaaS company does not file under either rule. Following the same habits still pays off with a board or a lender: label adjusted numbers, keep them next to the GAAP number, and show the bridge. In the example, the reconciliation looks like this.

Base caseFY2026 actualFY2027FY2028FY2029
Operating income (as in the statement above)-$650,000-$486,549-$24,101$760,512
+ Stock-based compensation (inside the cost lines)$380,000$475,209$599,272$745,884
+ Amortization of acquired intangibles$0$0$0$0
Non-GAAP operating income-$270,000-$11,340$575,171$1,506,397
EBITDA-$500,000-$326,549$155,899$960,512
Adjusted EBITDA (EBITDA + stock-based compensation)-$120,000$148,660$755,171$1,706,397
Adjusted EBITDA turns positive a year before EBITDA does, and in FY2029 it is $1.7M against $632,405 of net income. Both numbers are correct. Showing only the adjusted one is how a pro forma loses a board's trust.

Transaction pro forma example: adding an acquisition

A transaction pro forma restates last year as if the deal had closed on the first day, by adding the target's historical results and the accounting the deal creates. Suppose the same company buys a smaller SaaS business with $1,500,000 of revenue, records $2,400,000 of acquired intangibles amortized over six years, and borrows $3,000,000 at 8% to pay for it. All figures are illustrative.
FY2026Buyer (historical)Target (historical)Transaction adjustmentsPro forma combinedManagement's adjustmentsAfter management's adjustments
Revenue$7,700,000$1,500,000$0$9,200,000$0$9,200,000
Cost of revenue$1,800,000$420,000$0$2,220,000$0$2,220,000
Gross profit$5,900,000$1,080,000$0$6,980,000$0$6,980,000
Operating expenses (excluding D&A)$6,400,000$1,000,000$0$7,400,000-$150,000$7,250,000
Depreciation and amortization$150,000$20,000$400,000$570,000$0$570,000
Operating income-$650,000$60,000-$400,000-$990,000$150,000-$840,000
Net interest$40,000$0-$240,000-$200,000$0-$200,000
Income before taxes-$610,000$60,000-$640,000-$1,190,000$150,000-$1,040,000
Income tax (negative = benefit)$0$12,600-$134,400-$121,800$31,500-$90,300
Net income-$610,000$47,400-$505,600-$1,068,200$118,500-$949,700
The transaction adjustments are mechanical: a year of amortization ($2,400,000 / 6 = $400,000), a year of interest ($3,000,000 x 8% = $240,000), and the tax effect of both at 21% (-$640,000 x 21% = -$134,400). The target was profitable on its own, and the combined company loses more than the buyer did alone, because the deal adds amortization and interest. The management's adjustment, $150,000 of seller costs that stop after closing, sits in its own column so a reader can take it or leave it. If the combined company could not use the tax benefit because of its losses, set the tax rate on the adjustments to 0% in the template.

What goes in each tab of the template?

Six tabs: one to explain, one for inputs, the quarterly ARR bridge, the pro forma statement, a scenario comparison and an acquisition pro forma. Yellow cells are inputs, grey cells are formulas.
TabWhat you do thereWhat it gives you
Start hereRead onceSteps, every formula in words, the GAAP note
AssumptionsEnter base-year actuals, ending ARR, new-logo ARR, expansion and churn for each case and year, quarter weights, cost drivers; pick the case in cell C6Every input in one place, with the Benchmarkit medians next to the cost drivers
ARR bridgeNothing; check it12 quarters of beginning ARR, new logos, expansion, churn, ending ARR and subscription revenue for Low, Base, High and the selected case
Pro forma P&LRead itBase-year actual plus three pro forma years, % of revenue columns, the non-GAAP reconciliation, ARR, retention, growth, Rule of 40 and four checks
ScenariosRead itEnding ARR, revenue, S&M, EBITDA, net income and retention for all three cases side by side
AcquisitionEnter the target's last year and the deal termsBuyer, target, transaction adjustments, combined pro forma and a separate management's adjustments column
The checks on the Pro forma P&L tab confirm that the ARR bridge ties every year, that subscription revenue ties to the bridge, that the quarter weights add to 100% and that the low case never ends above the base case. The blank file has the same formulas with empty inputs. For a monthly model with a headcount roster and cash, use the financial forecast template; for cash by billing term and collection timing, the cash flow forecast template. If a lender asks for a pro forma balance sheet and cash flow statement that tie to this plan, carry the same drivers into a three statement model.

What mistakes make a pro forma income statement misleading?

Most misleading pro formas grow revenue by a percentage and hide the assumptions. These are the ones I see most in SaaS plans.
MistakeWhy it misleadsFix
Revenue = last year x growth rateIgnores the ARR already contracted and the churn aheadBuild revenue from an ARR bridge
Revenue = ending ARRARR added during the year earns only part of the yearAverage ARR by quarter, divided by four
Bookings spread evenly by quarterAcross ORM customers, bookings land late in the year and late in each quarterWeight bookings by your own quarter history
One forecast method for renewals and new businessRenewals have known amounts and dates; new business does notBridge renewals, expansion and new logos separately
Sales and marketing as a flat % of revenueIt hides what each dollar of new ARR costsSize S&M from bookings and CAC ratios
A single numberIt hides the risk around the planLow, base and high cases
Adjusted EBITDA with no bridgeReaders cannot see what was removedReconcile to operating income and EBITDA
Assumptions that do not change when the market doesWin rates, deal sizes and cycle lengths moveUpdate the drivers every quarter and say why
The last one is the most common reason a forecast misses. Something in the business or the market changes, a competitor puts pressure on price, buyers take longer to decide, territories get reshuffled, and the plan keeps running on old assumptions. A pro forma is only as current as its drivers.

Where does ORM fit?

A pro forma income statement is only as good as its revenue line, and in a SaaS company the revenue line is the sales forecast plus retention. ORM builds forecast models for B2B SaaS companies from CRM and finance data, forecasts new business, renewals and expansion separately, and targets 95% forecast accuracy from day 1 to day 90 of the quarter. That gives finance a current set of revenue drivers to put into the pro forma instead of last quarter's guesses. See sales forecasting software for how it works on your own data.

Sources

All checked on October 25, 2026.

  • Benchmarkit, 2025 SaaS Performance Metrics Benchmarks: median gross margin 77% on total revenue, 81% on subscription and 30% on professional services; sales and marketing 37%, R&D 34% and G&A 24% of revenue; median revenue growth 26%; New CAC Ratio median $2.00 and Expansion CAC Ratio median $1.00.
  • SEC Regulation G, 17 CFR 244.100 and 17 CFR 244.101: definition of a non-GAAP financial measure, the comparable GAAP measure and reconciliation requirement.
  • SEC Regulation S-X Article 11, 17 CFR 210.11-01 and 17 CFR 210.11-02: when pro forma financial information is required, columnar form, transaction accounting adjustments, management's adjustments and periods.
  • IRS, Publication 542, Corporations: the 21% corporate income tax rate.
  • ORM Technologies, observations across its customer base: quarter seasonality, renewals forecast separately from new business, presenting a forecast as a range.

Frequently Asked Questions

How do you calculate a pro forma income statement?

Start from the last year of actual results, then project each line from a driver. For a SaaS company, revenue comes from an ARR bridge (beginning ARR plus new logos plus expansion minus churn), cost of revenue from gross margin, sales and marketing from the bookings plan, and R&D and G&A as a share of revenue. Subtract the costs to reach EBITDA, operating income and net income.

Can I create my own pro forma P&L statement?

Any company can build one in Excel or Google Sheets, because a pro forma for planning has no required format. Use the same lines as your actual P&L so the two can be compared, keep every assumption in one place, and label the statement as pro forma. The free ORM template on this page already has the SaaS lines, three scenarios and the checks.

What does a pro forma income statement look like?

It looks like a normal income statement with different column headings. A projection shows the last actual year next to two to five projected years. A transaction pro forma shows the buyer and the target in historical columns, then an adjustments column, then the combined result. Both list revenue, cost of revenue, gross profit, operating expenses, operating income and net income.

Is a pro forma income statement GAAP?

A pro forma income statement is not a GAAP financial statement. It shows projected or as-if results, so it is never audited as the company's reported results. Public companies that file pro forma information for an acquisition follow SEC Regulation S-X Article 11, and any adjusted measure they publish must be reconciled to the closest GAAP measure under Regulation G.

What is the difference between a pro forma and a forecast?

A forecast is your best estimate of what will happen. A pro forma statement is a projected or as-if income statement built on stated assumptions, which can be a forecast, a target or a what-if case such as a price change or an acquisition. In practice a SaaS company's base-case pro forma usually is its forecast, presented in income statement form.

How many years should a pro forma income statement cover?

Three years is the usual length for planning and fundraising, with the first year by month or quarter and the later years by year. A transaction pro forma filed with the SEC covers only the most recent fiscal year and the interim period since, because it restates history rather than predicting the future.

ORM Technologies
Pete has built custom revenue forecast models for B2B SaaS companies for over a decade.

See how ORM turns these insights into action

ORM builds custom revenue forecast models for B2B SaaS companies. Not dashboards. Prescriptive analytics that tell you what to do next.

Schedule a Demo