simple income and expenditure template excel

In general, interest expense and income tax expense are not included as operating expenses, which gives rise to the term EBIT or 'earnings before interest and taxes' - another name for Operating Income.

In the multi-step income statement, the operating income is calculated as the Gross Profit minus the total Operating Expenses.

Don't include interest expense and income taxes (they will be included later). This section is where you include all your operating expenses such as advertising, salaries, rent, utilities, insurance, legal fees, accounting fees, supplies, research and development costs, maintenance, etc. The cost of goods sold can be calculated by adding beginning inventory, goods purchased, raw materials and direct labor for goods manufactured, and then subtracting the ending inventory.įor service businesses, COGS might not be such a large factor, so that is why the SingleStep worksheet doesn't have a separate COGS section. Use the MultiStep worksheet in this case. So, you'll see Cost of Goods Sold broken out into its own section, with Gross Profit calculated as the Net Sales minus Cost of Goods Sold. Cost of Goods Sold (COGS)įor a retail company, one of the main expenses is the cost of goods sold. You will likely want to customize the Revenue section to highlight your company's main sources of revenue. In the income statement template, there are categories for Sales revenue, Service revenue, Interest revenue, and Other revenue. The income that is generated by providing a service, selling a product, earning interest on investments, renting extra office space, licensing technologies, selling advertising space, or licensing the use of your brand name. Net Income = Total Revenue - Total Expenses Revenues

Simple income and expenditure template excel