How do I make a column that calculates gross margin percentage

J

John Mansfield

Jimv,

In column A put your Net Operating Revenue (Gross Revenue
less any Revenue Reductions).

In column B put your Net Operating Income (Net Operating
Revenue less Expense).

In column C, subtract column B from A to Net Operating
Income.

In column D, divide Net Operating Income (column C) by Net
Operating Revenue (column A) to get your Gross Margin
Percentage.

Regards,

John Mansfield
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumproduct with three arrays 2
Multiple Column Lookup - Index, Match functions 1
Break Even Analysis Help --dza 4
Pivot Table Help - Gross Margin % & % of Sales 1
Macro that will select and insert a new row and paste as value 3
Access 2007 pivot - how to calculate eg P/L marings both in curr & 0
How do I count these? 1
how do i set up a profit margin formula 2

Top