The Fraser flver Compary has purchased a new plece of factory equlpmest on laniary 1, 2018, and whshes to compare three depreciation methods stralghtins, double declining thalance, and units-of production. The equipment costs $400,000 and hws an estimuted uselul life of four years, or 8000 madine hours. At the end of four yeart, the efqupment is estimated to hame a residual value of 520.000. Requitements 1. Use tacel to paepare depreciation schedules for atraight lins, dostle dedining bat ante, and unts of produrtion method. 3. At Decenter 31, zois, fimes Hiver b trying to ortentine in at ahould seit the factory equipment, Fimer Aiver will anly yell the factory equipment if the company ewrns a gain of rxcerskinh 1. Create formulas with absolute and relative cell references. 2. Fermat the cells as acrountire eumber formac. 1. the the rocelfunation nce to calodale double dedining talance depreciation, Use fxcel to prepare depreciation schedules for straight -thes, double declining-balance, and units of irroduction methods. nequirement 2 Piepare a second depreciation sthedule for double-dedining bulanoe method, using the Escel finition Dof. The tooe furction cannot be used in the iast year of the asset's useful life. fequiremest 1 At Decenter 31, 2014, Fraser Biverin trying to determine if it thould sell the foctory equilpment. fraser hiver will only sell the factory equiprsent if the company earns a zain of at lent Sc,000, for each of the depreciation methody, what is the minimum amount that feaser Biver will sel the factory equipment for in oriter to hame a cain of \$5.000? fieling trice at the end ef Yoar 1 that resills in a gan of 56000 Seling pripe to the and of Year 1 that results in a gan of $6,000 Double Declinine Balance usina DDE functian Wighivo trice at the and of Year 1 that results in a 9 ais of 56.000. Being picin is the and of Year 1 bat reoults in a gan d $6,000