Question: The spreadsheet below shows the net income model for a company that sells shoes. A B 1 Net Income Model 2 3 Data 4 5
The spreadsheet below shows the net income model for a company that sells shoes.
| A | B | |
| 1 | Net Income Model | |
| 2 | ||
| 3 | Data | |
| 4 | ||
| 5 | Sales | $10,000,000 |
| 6 | Cost of Goods Sold | $ 6,400,000 |
| 7 | Administrative Expenses | $ 500,000 |
| 8 | Selling Expenses | $ 900,000 |
| 9 | Depreciation Expenses | $ 750,000 |
| 10 | Interest Expenses | $ 70,000 |
| 11 | Taxes | $ 620,000 |
| 12 | ||
| 13 | Model | |
| 14 | ||
| 15 | Gross Profit | $ 3,600,000 |
| 16 | Operating Expenses | $ 2,150,000 |
| 17 | Net Operating Income | $ 1,450,000 |
| 18 | Earnings Before Taxes | $ 1,380,000 |
| 19 | ||
| 20 | Net Income |
Which of the following formulas would be used to calculate the operating expenses?
Group of answer choices
=SUM(B7:10)-B11
=SUM(B7:B9)-B6
=SUM(B7:B9)
=SUM(B7:B10)
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
