Projected profit and loss statement: build and check it

A projected profit and loss statement estimates what a company will earn and spend during a future period, using assumptions that managers can explain and change. Start with units and net selling prices, attach the costs of those sales, and work down to net income. Then check the arithmetic and the assumptions separately.

Start with the actual export and an assumptions sheet

Use the latest closed monthly P&L as the account map. Export month, account code, account description, department and amount. Add sales units and net revenue by product, payroll by department, supplier unit costs, recurring overhead commitments and the depreciation and debt schedules.

Tie the historical revenue and expense totals to the closed ledger before projecting anything. Preserve the company's existing distinction between cost of goods sold and operating expenses. The SEC's financial statement guide describes gross profit as net revenue less cost of sales, followed by operating expenses, interest and income tax on the way to net income.

The historical profit and loss statement example explains those lines. Here, the additional job is to explain why each future line should change.

Record an owner and evidence beside every assumption: signed customer orders for volume, approved prices for revenue, supplier quotes for unit cost and the staffing plan for payroll. Label the version and preparation date. A forecast without that record is difficult to challenge or compare later.

Build one month from explicit drivers

Consider a hypothetical Ohio industrial distributor planning November 2026. Its existing facilities can handle the assumed volume without adding a shift. The table is the assumptions sheet, with labels in column A and values in column B.

These are illustrative assumptions, including the tax rate. Finance should use its own reviewed tax estimate rather than treat that rate as a statutory rule.

Projected revenue = Units sold × Net price per unit

Projected net income = Revenue − Cost of goods sold − Operating expenses − Interest − Estimated income tax

Enter the following spreadsheet formulas in the result cells. Costs are positive amounts that the formulas subtract.

B12 = B2*B3
B13 = B2*B4
B14 = B12-B13
B15 = SUM(B5:B7)
B16 = B14-B15
B17 = B16-B8
B18 = B17*B9
B19 = B17-B18

The projected statement is:

Gross margin is =B14/B12, or 40.0%. Operating margin is =B16/B12, or 14.2%, rounded to one decimal place. Keep unrounded values in the workbook.

For several product lines, calculate revenue and cost on each line, then sum them. The sales projection method covers the separate job of testing the volume assumptions in detail.

Prove the statement before reviewing the outcome

Run a zero check that adds all deductions and net income back to revenue:

=B12-SUM(B13,B15,B8,B18,B19)

The result is zero: $1,200,000 minus $720,000, $310,000, $5,000, $41,250 and $123,750. Check that depreciation appears in the relevant expense lines once and that interest ties to the debt schedule.

Build the other months from their own inputs, rather than multiplying November by the number of months in the year. Seasonal shipments, annual insurance renewals and hiring dates can change the monthly pattern. The SBA's business planning guidance recommends greater first-year detail in financial projections, using quarterly or monthly periods.

The monthly P&L template provides a reporting layout for actual, budget and variance. Keep the driver assumptions beside that layout so reviewers can trace a projected line back to its cause.

Change one input and see what moves

Reduce November units to 9,000, a 10.0% volume downside. Hold price, unit cost, operating expenses, interest and the tax assumption unchanged.

Gross margin remains 40.0%, but operating margin falls to 11.3%, rounded to one decimal place. Fixed operating expenses absorb a larger share of the lower revenue. This gives managers a concrete question: which commitments can change if shipments miss plan?

When actual results arrive, preserve the projection and add the actual column. Compare the same accounts and period, then investigate volume, price, unit cost and spending separately. A trailing 12-month income statement supplies historical context for that review; it does not replace a forward projection.

Where it goes wrong

• Bookings treated as revenue. A signed order supports a shipment assumption, but its booking date does not automatically determine the revenue period.
• Purchases treated as cost of sales. Inventory purchased for later sale does not all belong against this month's projected revenue.
• Every cost treated as variable. Payroll, rent and capacity additions need their own timing and operating assumptions.
• Profit treated as available cash. Customer payment dates, inventory funding and capital spending require a separate cash schedule.
• The original projection overwritten. Replacing the approved version removes the baseline needed to judge the variance and learn from it.

Compare your projection with actual results in Covirage

Bring your projected P&L workbook and matching actual accounting export to Covirage. Covirage maps the columns, its tools compute and check revenue, cost, margin and variance figures, and the external AI model explains the movements with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.

See Covirage for finance teams for the reporting context.