working with the following : Sales, Cost of sales, Gross profit, Net income, Net Profit, net profit %, Operating expenses, Operating income and Operat

[quintin]

Hi ,
I would like to find out if the spreadsheet i've done is correct - working with the following : Sales, Cost of sales, Gross profit, Net income, Net Profit, net profit %, Operating expenses, Operating income and Operating profit margin.

Thnk You

 

[royUK]

It might be!

How do you expect us to know?

 

[quintin]

It might be!

How do you expect us to know?

I need to find out what the formulas are and if they are correct

sales	500	500
cost of sales	100	100
gross profit	400	IF(SUM(D1:D2),D1-D2,"")
Net Income	350	SUM(D1-(D2+D10))
Gross Profit Margin	80%	IF(D1,D3/D1,"")
NET PROFIT	350	SUM(D1-(D2+D10))
NET PROFIT %	90%	SUM(D1-D10)/D1
OPERATING EXPENSES	50	50
OPERATING INCOME	450	SUM(D1-D10)
OPERATING PROFIT MARGIN	90%	SUM(D11/D1)

<tbody>
</tbody>

 

[KINGSOFTUSER]

Hope this helps.

Earnings before interest and taxes - Wikipedia, the free encyclopedia

 

[royUK]

here's an example Income Statement