Question

x ? a x 5, HOME = INSERT Calculating operating cash flow - Excel FORMULAS DATA REVIEW - Sign In FILE PAGE LAYOUT VIEW Paste B I U - - A Cells Editing Alignment Number Conditional Format as Cell Formatting Table Styles Styles Clipboard F Font A1 F G H Chevelle, Inc., has sales of $39,500, costs of $18,400, depreciation expense of $1,900, and interest expense of $1,400. If the tax rate is 21 percent, what is the operating cash flow, or OCF? $ Sales Costs Depreciation Expense Interest Expense Tax rate 39,500 18,400 1,900 1,400 21% Complete the following analysis. Do not hard code values in your calculations. Income Statement Sales Costs Depreciation expense EBIT Sheet1 ... +

All Answers should be answered as a formula.

Answer 1

foc =B11+B10-B14 B17 A 1 Sales 2 Costs 3 Depreciation Expense 4 Interest Expense 5 Tax Rate $ $ $ $ 39,500 18,400 1,900 1,400 21% =B1 =B2 =B3 =B8-B9-B10 Income Statement 8 Sales $ 9 Costs $ 10 Depreciation Expense $ 11 EBIT $ 12 Interest Expense $ 13 EBT $ 14 Taxes $ 15 Net Income $ 16 17 Operating Cash Flow $ 39,500 18,400 1,900 19,200 1,400 17,800 3,738 14,062 =B4 =B11-B12 =B13*B5 =B13-B14 17,362 =B11+B10-B14 18