For each scenario, you are presented with a five-year colander. Complete each according to the information presented. Some rows may not have entries.

  

 what equations to put on an excel spreadsheet to get the answer for each column.

 Show the formula used to find the answer

#1 #2 You purchase a $8,000 computer for your business with a three-year useful life. At the end of three years the computer is only worth $400. You choose to depreciate this equipment using straight line depreciation. Complete the following chart (as it covers a five-year period not all rows may have entries) Chart A Period: Year 1 year 2 year 3 year 4 year 5 Chart B Book value at start of period Period: Year 1 year 2 year 3 year 4 year 5 $8,000.00 You purchase an industrial $5,000 die cutting machine for your business that has a four-year useful life. At the end of four years the equipment is worth ZERO. You choose to depreciate this equipment using double declining depreciation. Complete the following chart (as it covers a five-year period, not all rows may have entries) Book value at start of period Depreciation $ amount $5,000.00 Book value at end of period Depreciation $ amount Book value at end of period