Excel Formula Income Minus Expenses

A company has revenue of 50 000 the cost of goods sold is 15 000 operating expense 5 000 and loss from the operations of a discounted component is 1 200.

Excel formula income minus expenses. Income and expense spreadsheets can be useful tools to help you see where your personal or business finances stand. I have an excel work sheet with current income of 2 560 00 in cell b4. How to create a formula for income expenses in excel. This income statement template was designed for the small business owner and contains two example income statements each on a separate worksheet tab see the screenshots the first is a simple single step income statement with all revenues and expenses lumped together.

Click the cell that you want to use to calculate your total in the income column select the list arrow and then choose the sum calculation. Net income 54 200 net income formula example 2. The second worksheet shown on the right is a multi step income statement that calculates gross profit and operating income. When you have a new income or expense to add click and drag the blue resize handle in the bottom right corner of the table.

After you ve assembled. Net income total revenue total expense. There are now totals for the income and the expenses. In cell e1 is the word growth rate.