AutoSaveO hamil_Miller-Nobles 6e-12e-Using Excel_Ch09-Ch10 Start - Read-Only - Excel Sign in File Home Insert Draw Page Layout Formulas Data Review View Help Tell me what you want to do I Share 3:. Trace Precedents Show Fomulas a Trace Dependents Error CheckingWatch CalculationHCalculate Shoel Define Name Calculate Now Use in Formula Insert AutoSum Recently Financial Logical Text Date&Lookup & Math&More Name Function Used-Time Reference Trig Functions- Manager Create from Selection Remove Arrows . Evaluate Formula Window Options Function Library Cefined Names Formula Auditing G27 (Always use cell references and formulas where appropriate to receive full credit. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values.) "For calculations in each of the four tables below refer only to the values calculated in the same table or provided in the DATA table DATA $ 400,000.00 20,000.00 16 Residual Value 17 Useful Life (Years) Useful Life (Hours) Gain End of Year 1 8,000 $6,000.00 19 Straight Line Depreciable Cost Depreciation Accumulated Depreciation Year Rate 23 24 25 26 27 28 29 30 The minimum amount to sell the factory equipment in order to have a gain of $6,000 at the end of Year 1? Instructions ENTERANSWERS - Type here to search 10 00 PM 4/10/2019