This is where I was really stuck in my statement class. I could not figure out the best way to estimate he future ratios for growth. I was trying regression with not great results, or maybe they were too truthful. In my class we were to also look at the current 10K to find depreciation schedules or projected growth rates for the closest years.
I can think of two possible explanations. First, your Excel spreadsheet is not setup for automatic recalculation. In this case, I believe you go to the Options Menu and Calculation Tab and then click Automatic. The other possibility is that you didn't put formulas in the cells, you put in values. If you put in actual numbers, you'll need to change them to get your new answer. If you put in formulas that look at other cells it will use the new data when it is changed in a cell.
How do you cal culate each line item after sales revenue? i.e. cogs, SGA, Depreciation, Operating profit, taxes? Need the formulas for them so i can enter them in. Thanks
+Lina Satele In this spreadsheet I've assumed that COGS 81% of sales so I multiply .81 by the sales for that year. Likewise for SGA, it's 9%. Operating profit is Sales - COGS - SGA. Taxes are the tax rate in cell B5 times operating profit for the year. Net profit is operating profit minus taxes.
+Ronald Moy, Thanks so much. I'm taking Corporate Finance for my MBA just trying to understand how to calculate the proper formulas in excel for the desired results.Megastat was not a big help, so learning from scratch is always good! Thanks so much for your help! All the best.
Helo! How do I calculate the Operating Profit (EBIT), Taxes, and Net Profit (net income). I'm making a similar sheet in excel and I have been looking how to calculate this. At least I know when I compare the rest with yours mine is ok.
This is pretty terrible when someone like me comes here to get help on how to do something and the person just mumbles and has audio so distorted you can't understand anything the person is saying. I wish people would learn first how to make a video properly before posting it and at least watch it before posting to see how terrible and pathetic it is.
This is where I was really stuck in my statement class. I could not figure out the best way to estimate he future ratios for growth. I was trying regression with not great results, or maybe they were too truthful. In my class we were to also look at the current 10K to find depreciation schedules or projected growth rates for the closest years.
Ok I found how they are calculated, thank you for a great video.
I can think of two possible explanations. First, your Excel spreadsheet is not setup for automatic recalculation. In this case, I believe you go to the Options Menu and Calculation Tab and then click Automatic. The other possibility is that you didn't put formulas in the cells, you put in values. If you put in actual numbers, you'll need to change them to get your new answer. If you put in formulas that look at other cells it will use the new data when it is changed in a cell.
how did you put that "raise to the power of symbol" in the equation?
I found it.. lol.. on my keyboard..duh..
I want to pull my hair out watching this.
How do you cal culate each line item after sales revenue? i.e. cogs, SGA, Depreciation, Operating profit, taxes? Need the formulas for them so i can enter them in. Thanks
+Lina Satele In this spreadsheet I've assumed that COGS 81% of sales so I multiply .81 by the sales for that year. Likewise for SGA, it's 9%. Operating profit is Sales - COGS - SGA. Taxes are the tax rate in cell B5 times operating profit for the year. Net profit is operating profit minus taxes.
+Ronald Moy, Thanks so much. I'm taking Corporate Finance for my MBA just trying to understand how to calculate the proper formulas in excel for the desired results.Megastat was not a big help, so learning from scratch is always good! Thanks so much for your help! All the best.
What formula did you use to come up with your Net Profit?
+flawliss20 Net profit = Sales - COGS - SGA - depreciation - taxes
thanks for the video!
Helo!
How do I calculate the Operating Profit (EBIT), Taxes, and Net Profit (net income).
I'm making a similar sheet in excel and I have been looking how to calculate this. At least I know when I compare the rest with yours mine is ok.
YOU TALK TOO MUCH ABOUT NOTHING!!!
This is pretty terrible when someone like me comes here to get help on how to do something and the person just mumbles and has audio so distorted you can't understand anything the person is saying. I wish people would learn first how to make a video properly before posting it and at least watch it before posting to see how terrible and pathetic it is.