Calculating OCF and the depreciation tax shield - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In 37 do Calibri 11 - A A' % Paste BIU - . &. A - A Alignment Number Conditional Format as Cell Cells Formatting Table - Styles 8 Clipboard Font Styles points IV X Skipped A B D E F G H J eBook 3 Consider the following income statement. Fill in the missing numbers and then calculate the OCF. What is the depreciation tax shield? A Tax rate 22% Complete the following analysis. Do not hard code values in your calculations. Sales $ 713,500 Variable costs 49,730 Depreciation 87,400 EBT Taxes Net Income OCF Depreciation tax shield 21 22