What the template includes
- Revenue: sales and other income.
- Cost of goods sold and gross profit, gross margin.
- Operating expenses: salaries, rent, utilities, marketing, admin.
- EBITDA and EBITDA margin, depreciation, interest expense.
- Profit tax (rate can be changed) and net profit.
- Annual totals and each line as a share of revenue.
How to use it
- At the end of each month, copy revenue and expenses from your accounting data into the yellow cells.
- Enter all amounts excluding VAT.
- If you pay simplified tax, set the profit tax rate to 0% and put the simplified tax in the "Admin and other" line.
- Watch how margins change month by month: if a margin falls, the cause is in prices, costs of goods or the cost structure.
Profit is not cash. You can be profitable and still run short of cash: to see this, use it together with the 13-week cash flow forecast.
To calculate margin by product, use the product costing template; to calculate profit tax, the profit tax calculator.