Gross Profit (GP) Forecast Template And Spreadsheet

What’s the gross profit on the products and services that you sell in your small business? Organize your gross profit numbers in this easy-to-use template or spreadsheet.

Gross Profit (GP) Forecast – 1 Year Worksheet PDF
Gross Profit (GP) Forecast – 1 Year Worksheet Excel

The gross profit (GP) forecast template and spreadsheet include categories for five types of your products and services, with slots for the gross profit for each product or service and the number of products and services sold. The step-by-step instructions that are included on the worksheet (e.g. “line A x line B = line C”) make it easier to calculate the gross profit (GP) for your small business.

Gross profit is the amount of money you make, after you pay for your cost of goods (COG), but before you subtract monthly overhead expenses.

The gross profit forecast spreadsheet can be used to predict your gross profit this year, or to recap your gross profit from last year.

Related Small Business Classes Online
How To Calculate Gross Profit (GP)

Jennifer Croft Comments
Would-be entrepreneurs often confuse gross profit and net profit, as do small business owners with years of experience. Gross profit is the amount of money you make after you subtract cost of goods. For example, if you sell $10,000 worth of products and services this month, and your cost of goods is $2,000, you have $8,000 in gross profit. Net profit is the amount of money you make after you subtract your overhead expenses. For example, if your monthly overhead expenses are $3,000, then your net profit (before taxes) will be $5,000 ($8,000 in gross profit, minus $3,000 in overhead).

Click here for a resource for StrengthsFinder training.