Use the data from the income statement to create a data table

Use the data table to create a line chart

Calculate revenues in 10% increments from 50% below current sales to 50% above current sales

(Assumes current sales = $1,500,000, fixed assets = $300,000, variable cost ratio = 68%)

Prepare the equation needed to calculate Total Operating Expense at any level of sales

Prepare the equation needed to calculate Total Income Tax at any level of sales

Prepare the equation needed to calculate Net Income at various sales levels

Home Insert Draw Page Layout Formulas Data Tell me Share Comments v Lo A A- % v MEN Conditional Formatting 12 Format as Table Cell Styles Clipboard Font Alignment Number Cells Editing Sensitivity Analyze Data V11 . D E F F G H 1 3 5 Data Table 1 Add Data Table to E4 2 Revenues 3 Operating Expenses 4 Taxes 5 Net Income 6 Data Table (Row Input) 7 Line Graph Total out of out of out of out of out of out of out of 1.0 1.5 1.5 1.5 1.5 6.0 2.0 15.0 8 9 0.0 out of Use the data from the Income Statement below to create a data table. Use the data table to create a line chart. 10 11 12 13 14 15 16 17 18 19 20 21 22 Warren Company Income Statement Year Ending 12/31/17 23 24 25 Net Sales Less Variable Costs Contribution Margin Fixed Costs Operating Income Income Tax (Rate 30%) Net Income $1,514,371 1,029,772 $484,599 301,042 $183,557 54,837 $128,720 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 Calculate revenues in 10% increments from 50% below current sales to 50% above current sales (Assume Current sales = $1,500,000, Fixed Costs = $300,000, Variable Cost Ratio = 68%) Prepare the equation needed to calculate Total Operating Expenses at any level of sales. Prepare the equation needed to calculate Total Income Tax at any level of sales. Prepare the equation needed to calculate Net Income at various sales levels. Create a Data Table Create a Line Chart showing Net Income at the various level of sales from -50% to +50% 48 49 50 E4 Goal Seek Data Table Solver Pivot Table + 100%