How to Calculate Operating Expenses in Excel. An Excel spreadsheet is designed to automate the task of repetitive calculations. It can be an invaluable tool for ascertaining the income, capital ...

For example, if your sales income is $100,000, subtract the $30,000 operating expenses and the $50,000 facilities expenses to get your net profit of $20,000.