| GB 518 UNIT 02 ASSIGNMENTS | NOTE: To earn full credit, you MUST include your Excel Formula/computations in the YELLOW Cells. |
||||||||||||
| Exercise 3-7, Page 137 in the textbook |
|||||||||||||
| Your Name –>: | Faye M Williams | ||||||||||||
| Determine the missing anounts: | |||||||||||||
| Case | Net Income | Net Sales | Profit Margin | ||||||||||
| a | $ 5,390.00 | $ 44,830.00 |
12% | ||||||||||
| b | $ 87,644.00 |
$ 398,954.00 |
2% | ||||||||||
| c | $ 93,385.00 |
$ 257,082.00 |
36% | ||||||||||
| d | $ 55,234.00 |
$ 1,458,999.00 |
16% | ||||||||||
| e | |||||||||||||
| Analysis and Interpretation: | |||||||||||||
| Profit margin is a useful measure of a company’s operating results, it is the ratio of its net income to net sales. This ratio is interpreted as reflecting the percent of profit in each dollar of sales. Formula = Net Income / Net Sales |
|||||||||||||
| Exercise 3-7 is worth 16 points. | |||||||||||||
