how to compute nopat with given values on excel?

better pic of excel sheet

Question Completion Status Office Update To keep up to date with security updates, xes, and mprovements. 123 X file. Go to the financial statements and compute NOPAT for 2017 c 2011 37.00 2017 102.006.00 71,451.00 35,135.00 2011 177,866.00 1119.00 902.00 Ox $3,177.87 47.722.00 1. $1,472.44 25,148.00 O $760.56 Totalnet Revenues Cont of sales Grosso Operating expenses Pullment Martin Technology and content General and me Other partinggit Totalpringe Operating Intrepense income before con Provision for more 11.410.00 1.21 10.00 L.M.00 17.00 31,121.00 11 17,600.00 Y, 1400 2.412.00 17.00 45.00 I. 14.00 12.00 1.425.00 11.420.00 16.00 11400 SL.00 410600 11 a $2,570.33 . La 0.00 2.00 LA PES. 2,267.00 Net Income 4 points Save As QUESTIONS MOON BESON 22. Taxate be careful aboutounding in the following actions Office Update To keep veto-date with security updates, and improvement Check for Updates Question Completion State mile. Go to the Tinancial statements and compute NOPAT for 2017 . 2012 107,000.00 71,651.00 35.155.00 $3,177 87 3018 135,000.00 1.265.00 11,722.00 2013 177.166.00 111.934 00 65.832.00 O $1,472.44 Total Revenue Costoskes Grosso Operating Punt Martting Tocho con General und die Other operating experiene Tutaleperty rines - $760,56 17.418.00 7,211.00 1,085.00 2.412.00 36700 04 $2,570,33 11.410.00 4.00 12.540.00 1,242.00 17.00 31, 132.00 22.00 Ches 14.00 500.00 2520.00 10,000.00 260.00 1,600 21400 11.6.600 4.106.00 04.00 42.00 9.00 Interest Income before com 418.00 MSC 001 1612.00 FLAS001 2267.00 Provision for income tawes Net Income QUESTION 4 points Save A 14.060W 37 22.00 Tax Rate be careful about runding) Other things held constant, which of the following actions would increase the amount of cash on a company's Orton Comotion State O Office Update Time to date with security votes, and improvements Check for up file. Go to the financial statements and compute NOPAT for 2017 C 2011 2011 107306.00 71,651.00 355.00 $3,177.87 2015 177,866.00 111.94.00 12.00 135. 17.00 $1,265.00 47.722.00 Oh $1,472,44 17/610.00 7.221.00 16,000 D$760.56 Total et Revenues Cost of Gross Pro Operating sense iment Marley Technology and content General and administrative Other operating pane, at Total operating Operating income Interest pense Income before income Provision for cometa A.00 167.00 11,410.00 5.254.00 12.540.00 1747.00 171.00 31.121.00 2.221.00 C. 1.440.00 100001 16.00 25.249.00 10.069.00 32,620 00 3.600 214.00 16.00 410600 . 140300 4 $2,570.33 4100 4100 149400 3,692.00 (1.425.00 2.267.00 2.611.00 QUESTIONS Save A Tax Rate the carborounding LOGON 3897 22.600 Other things held constant, which of the following actions IR PARA ANAP A % Clipboard Font Conditional Formatting Format as Table Cell Styles Alignment Number Cells Editing Analyze Data Office Update To keep up-to-date with security updates, fixes, and improvements... Check for Up 123 fe 3 2017 2018 2019 4 177,866.00 5 107,006,00 71,651.00 35,355.00 135,987.00 88,265.00 47,722.00 111,934.00 6 65,932.00 7 8 9 13,410.00 5,254.00 10 Total net Revenues Cost of sales Gross Profit Operating expenses: Fulfillment Marketing Technology and content General and administrative Other operating expense, net Total operating expenses Operating income Interest expense Income before income taxes Provision for income taxes Net Income 17,619.00 7,233.00 16,085.00 2,432.00 167.00 25,249.00 10,069.00 22,620.00 3,674.00 12,540.00 1,747.00 171.00 11 12 214.00 13 33, 122.00 14 61,826.00 4,106.00 1704.00) 15 43,536.00 4,186.00 (494.00) 3,692.00 (1,425.00) 2,267.00 2,233.00 (765.00) 1,468.00 (500.00) 968.00 16 3,402.00 17 (769.00) 2,633,00 18 19 20 Tax Rate (be careful about rounding) 34.060% 38.597% 22.604% 22 24 25 26 27 25 30 Cash Flow Ratio Dalance Sheet Free Cash Flow Income Statement 100 acBook Air