Profit & Loss Statement (Annual / 3-Year)

About the Profit & Loss Statement (Annual / 3-Year)

The annual, three-year profit and loss statement zooms out from the month-to-month grind to answer the question investors and lenders actually care about: is this business growing, and is it growing profitably? By placing three consecutive years next to each other, it turns a pile of transactions into a trend line for revenue, margins, and net profit that anyone can read in seconds.

This longer view is where you catch the things a single year hides. A company can post a good current-year profit while its gross margin quietly erodes, or grow revenue impressively while expenses grow even faster. Laying Year 1, Year 2, and Year 3 side by side — with year-over-year growth calculated automatically — exposes whether momentum is real or borrowed.

It is the format most commonly requested in a loan application, an investor deck, or a business sale, because three years is long enough to show a pattern but short enough to stay believable and defensible.

How the Profit & Loss Statement (Annual / 3-Year) works

The worksheet mirrors a standard P&L but with three yearly columns instead of twelve monthly ones. You enter revenue lines, cost of goods sold lines, and operating expense lines for each of the three years. It sums each section, then computes Gross Profit = Revenue minus COGS and Operating Income (labeled Net Profit here) = Gross Profit minus Operating Expenses for every year.

Alongside the dollar figures it displays margins as percentages: gross margin is gross profit divided by revenue, and net margin is net profit divided by revenue. Watching margins rather than raw dollars is the point — a business can double revenue and still be getting weaker if margins are sliding.

The year-over-year growth row applies the standard formula (current year minus prior year, divided by prior year) to total revenue, so Year 2 and Year 3 each show a growth percentage. Because it stops at operating income, the bottom line excludes tax, interest, and depreciation, keeping the focus on operating performance across the three years.

Worked example

Using the defaults, Year 1 revenue is Product Sales $100,000 plus Services $50,000 = $150,000. COGS is Materials $30,000 plus Direct Labor $20,000 = $50,000, giving Gross Profit of $100,000 and a 66.7% gross margin. Operating expenses (Rent $12,000, Marketing $15,000, Payroll $50,000) total $77,000, leaving Net Profit of $23,000 — a 15.3% net margin.

Year 2 revenue climbs to $210,000 ($150,000 product + $60,000 services), so year-over-year revenue growth reads (210,000 − 150,000) / 150,000 = 40%. Year 2 COGS of $75,000 yields $135,000 gross profit, and $92,000 of expenses leaves $43,000 net profit. Year 3 revenue of $280,000 gives 33.3% growth over Year 2, $180,000 gross profit, and roughly $68,000 net profit — a clear story of rising revenue with margins holding steady.

Tips & common mistakes

• Keep category names identical across all three years. If Year 1 lists 'Marketing' and Year 3 splits it into 'Ads' and 'Events,' your trend comparison breaks and the growth percentages mislead.
• Watch margin percentages, not just revenue. Rising revenue with a falling net margin often means you are buying growth with unsustainable spending.
• If a year included a one-time event — a large equipment sale, a lawsuit settlement, a pandemic dip — note it, because a reader will otherwise misread the growth rate.
• For a lender or investor, pair this with your balance sheet and cash flow forecast; three years of P&L alone does not prove you can pay bills on time.
• Restate prior years if you change how you classify costs, so all three columns use the same rules and the comparison stays honest.

Profit & Loss Statement (Annual / 3-Year): frequently asked questions