Question

(20 points) A landscaping service periodically purchases a new tractor. Costs for the tractor are expected to stay close to $30,000 for the next decade. 0&M expenses for tractors are typically $1,000 in the first year, increasing by $2,000 each year. (At the end of the 4th year, they would therefore be $7,000.) The company's MARR is 10%. The company uses MACRS GDS tables for depreciation of their tractors, and tractors are considered to have a 3-year property life. Given this information, use a replacement analysis to determine when the com 3. pany should replace tractor no later than the end of the year the the tractor, assuming that they will replace each tractor has depreciated to $O.

Answer 1

The machine should be replaced in 4 year.

AutoSaveOrE A Ashwani Singh (. SMx and Avg time Excel - File Home Insert Page Layout Formulas Data Review View Developer Help Tell me what you want to do Share Comments B Trace Precedents h Show Formulas a Trace DependentsEror Checking ×Remove Arrows . Define Name Calculate Now Use in Formula Watch CalCalculate Sheet Insert AutoSum Recently Financial Logical Text Date & Lookup & Math &More Function . Used- Time-Reference Trig. Functions . Function Library Manager鄮Create from Selection Evaluate Formula Window Options Defined Names Formula Auditing Calculation SECURITY WARNING External Data Connections have been disabled Enable Content H10 ㄨㄚ丘 Presentwor th as of Cummulative Annual maintainance A/P, equivalent End of Maintenance beginning Summation of 1 Year Cost of year present worth Depreciation cost 30,000 10%,n total cost 909.09 $10,000.00 1000 $909.09 2000 $1,652.89 2,561.98 $10,000.00 5000 $3,756.57$6,318.56 $10,000.00 7000 $4,781.09 $11,099.65 30,909.09 30.90909 $30,909.09 $32,561.98 10.50387 $10,503.87 $36,318.56 4.318497$4,318.50 $41,099.65 2.529054 $2,529.05 10 12 13 14 15 17 SMK Analysis Avg time Cohort Data Sheet1 Ready + 100%