# Calculate Expenses and Profit of Each Product

Now that you’ve found your profit margins,
sales, and profits. To the right of the “Margin” column, add
Out-of-Pocket Costs Gross Sales
and Profit. The Out-of-Pocket Cost is the number of items
originally in stock multiplied by the cost per unit. This number tells you how much you spent to
create your entire stock of each item. Begin typing your formula in cell H2, Type
an equals sign, and then add the cell number for Original Stock. In this case, B2. Add an asterisk to indicate multiplication. Then, input the cell for Total Cost Per Unit. In this example, it’s E2. Press Enter. The result of the formula appears in the cell. Double check the math, then drag the formula
to the rest of the column. Now move on to gross sales. Gross sales describes the total amount of
money you received for an item. In cell I2, type an equals sign, then multiply
the total number of items sold by the retail price. Press enter, and copy the formula down the
rest of the column. Next, determine your profit. In an online business, or any company, understanding
profitability is critical. A company can’t stay in business without
making a profit Profit is gross sales minus out-of-pocket
costs. In cell J2, type an equals sign, then subtract
costs from sales. Press enter, and drag to copy the formula