PLEASE SHOW ALL WORK ON XL( how you plug in evreything).

D 1 2 G H 2/1/2012 3 Module 7. Student Ch 07-15 Build a Model 4 a. Using the financial statements shown below, calculate net operating working capital, total net 5 operating capital, net operating profit after taxes, free cash flow, and return on invested capital for 6 the most recent year. 7 8 Lan & Chen Technologies: Income Statements for Year Ending December 31 9 (Thousands of Dollars) 2012 2011 10 Sales $945,000 $900,000 11 Expenses excluding depreciation and amortization 812,700 774.000 12 EBITDA $132.300 $126.000 13 Depreciation and amortization 33 100 31,500 14 EBIT $99,200 $94,500 15 Interest Expense 10.470 8,600 16 EBT $88.730 $85,900 17 Taxes (40%) 35,492 34 360 18 Net income $53,238 $51,540 19 20 Common dividends $43,300 $41,230 21 Addition to retained earnings $9.938 $10,310 22 23 Lan & Chen Technologies: December 31 Balance Sheets 24 (Thousands of Dollars) 25 Assets 2012 2011 26 Cash and cash equivalents $47.250 $45,000 27 Short-term investments 3.800 3,600 28 Accounts Receivable 283,500 270,000 29 Invento es 141.750 135.000 30 Total current assets $476,300 $453.600 31 Net fixed assets 330 750 315.000 32 Total assets $807 050 $768,600 33 34 Liabilities and equity Build a Model Solution Sheet2 Sheet3