Ultimate Profit & Loss Projection Spreadsheet Template for Google Sheets & Excel

Ten revenue streams across twelve months, each month typed and each row totalled. Beneath sits an annual block that reads the grid above it: each stream's annual total, its monthly average, its share of total revenue, and the month-on-month growth implied by its own January and December. Separating revenue into streams rather than one line is what makes the rest of the workbook answerable. A business whose recurring revenue is flat while one-off fees carry the year has a different problem from one growing evenly, and a single revenue row hides which of the two you are.

Four cost of goods sold categories across the same twelve months, with a gross profit block underneath that sets the month's revenue against the month's direct costs and states the margin. Keeping cost of goods sold on its own sheet rather than mixed into operating expenses is what makes gross margin meaningful - it is the difference between what a sale costs to deliver and what it costs to run a business at all.

Operating expense categories across twelve months, with an annual summary reading each category's total and monthly average. These are the costs that do not move with a sale, which is why they sit apart from cost of goods sold and why they stay put across all three scenarios.

The consolidation. Revenue, cost of goods sold, gross profit and margin, operating expenses, operating income, other income and net income and margin - every month across, an annual column down the right, and every figure read from the three data sheets rather than retyped. Underneath sits an annual block that sets the plan against the actual line by line, with the variance in money and as a percentage. The planned column is the annual column of the statement directly above it, so it moves when the forecast moves; the actual column is yours to fill in as the year closes.

Three revenue multipliers in editable cells - conservative, base and optimistic - and everything beneath them reads those cells and the statement. Revenue and cost of goods sold scale together, which leaves gross margin unchanged; operating expenses do not scale at all, which is what makes the three columns differ by much more than the multiplier does. That is the whole point of the sheet. A business with heavy fixed costs sees a twenty percent revenue shortfall arrive at the bottom line multiplied, and a comparison that scaled everything proportionally would never show it. The monthly net income rows follow the same logic, so the month a scenario turns from red to black is visible rather than inferred.

Annual revenue, gross profit and net income across the top, read from the statement, with the gross and net margins those imply beneath them, plus the first month the statement turns profitable - and two charts: revenue against expenses month by month, and where the money goes by category. The two margins are worth reading together. A gross margin that holds while the net one falls says the cost of delivery is fine and the cost of running the business is not, which is a different problem with a different fix.