Microsoft excel help

AsrarHussain

Hello all.
I am in college studying Admin and I am using Excel. I am struggling with it at the moment on gross profit, net profit,turn over etc. We have to figure out whether a company is making a loss or profit.

Are there any good websites to use or videos to watch?

shadowloss

I doubt it will help, but the calculations you are looking for have to be manually created and do not appear as a "Standard calculation" in excel. This is more of an accounting question than excel. You can look up profit and loss statement with Google and it should give you the formula for creating the results you are looking for.

PowerMan40

google is your friend

mattg5566

Revenue minus cost of goods= gross profit. Then take gross profit and divide it by revenue = gross profit percent. For net income. Take above gross profit and subtract expenses. For turn over it depends on what turn over you are seeking. Inventory turnover, asset turnover, etc.

AsrarHussain

mattg5566 wrote: »

Revenue minus cost of goods= gross profit. Then take gross profit and divide it by revenue = gross profit percent. For net income. Take above gross profit and subtract expenses. For turn over it depends on what turn over you are seeking. Inventory turnover, asset turnover, etc.

Thank you