Use Microsoft Excel to calculate EBITDA (earnings before interest, tax, depreciation, and amortization) profit margin.

For example, if your revenue is $100,000, and your COGS is $50,000, your gross profit margin would be (100,000 - 50,000)/100,000. This equation returns a gross profit margin of 50%. 2. Operating ...

Using the aforementioned formula, the bank's net interest margin is 2.92%. With its NIM squarely in positive territory, investors may wish to strongly consider investing in this firm.

The gross margin formula is very similar to return on sales in that you use the same revenue number. The only difference is that you divide the gross profit number, which precedes operating profit ...