How many periods can I project?

You can project from 1 to 12 periods (months or quarters). For longer projections, consider running two separate forecasts.

What is COGS as a percentage?

COGS (cost of goods sold) as a percentage of revenue is your gross margin in reverse. If you sell goods at 60p cost for every £1 revenue, your COGS % is 60%.

Should I use a monthly or quarterly projection?

Monthly projections are better for cash flow planning. Quarterly projections are better for strategic planning and investor presentations.

Profit & Loss Projection Calculator

Forecast your business profit and loss over multiple periods. Enter your starting revenue, growth assumptions, cost structure, and tax rate to generate a period-by-period P&L projection.

Starting revenue (£) Monthly revenue growth rate (%) COGS as % of revenue Starting monthly OpEx (£) Monthly OpEx growth rate (%) Tax rate (%) Number of periods

How it's calculated

Revenue(n) = Initial Revenue × (1 + Growth Rate)^(n−1)
Gross Profit = Revenue − COGS
Net Profit = (Gross Profit − OpEx) × (1 − Tax Rate)

Frequently Asked Questions

How many periods can I project?: You can project from 1 to 12 periods (months or quarters). For longer projections, consider running two separate forecasts.
What is COGS as a percentage?: COGS (cost of goods sold) as a percentage of revenue is your gross margin in reverse. If you sell goods at 60p cost for every £1 revenue, your COGS % is 60%.
Should I use a monthly or quarterly projection?: Monthly projections are better for cash flow planning. Quarterly projections are better for strategic planning and investor presentations.