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

please help me! and please let me know what equations to put on an excel spreadsheet to get the answer for each column.

PLEASE Show the formula used to find the answer

#1 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 Book value at start of period Depreciation $ amount Book value at end of period Period: Year 1 $8,000.00 year 2 year 3 year 4 year 5 #2 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) Depreciation $ Chart B Book value at start of period Book value at end of period amount Period: Year 1 $5,000.00 year 2 year 3 year 4 year 5 #3 Your purchase a $1,500 paper folding machine for your business that has a 5-year useful life. It also will have a zero salvage value. However, instead of depreciating it you choose to expense it. Complete the following chart Chart C Book value at start of period Expense $ Amount Book value at end of period Period: Year 1 $1,500.00 year 2 year 3 year 4 year 5 #4 What is your tax deduction for each of these, in other words How much will your taxable income be reduced by: Chart A Chart B Chart C Year 2