Please use the provided excel and show work / formula in working cell for a thumb up.

At the end of fiscal year 2014, Emerson Electric Co. (EMR) had net property, plant, and equipment equal to 3.5 billion. The ending balance for 2013 was 3.507 billion, and the firm had depreciation expense during 2014 equal to 0.727 billion. How much did the company spend on new property plant, and equipment during 2014?

Please use the provided excel and show work / formula in working cell for a thumb up.

PROBLEM 6-10 Given: ($ billions) Net Property, Plant and Equipment (20 $ 3.507 Less: Depreciation Expense (2009) 0.727 Plus: Capex (2009) Net Property, Plant and Equipment (20 $ 3.500 Solution Legend = Value given in problem = Formula/Calculation Analysis required = Qualitative analysis or Short answer required = Goal Seek or Solver cell = Crystal Ball Input = Crystal Ball Output Solution