Using excel to create 3 methods of depreciation table ( double declining, Straight line Depreciation,Sum-of-the-years? digits)

Using the excel language like =if( ). Instrumentsare in the attached files.

On the sheet name Depreciation Schedule Create a Double declining Depreciation Schedule that restricts: Cost: Positive Scrap: less than the cost but not negative Life: restricted to between 2 and 10 years Display: Only years that are equal to or less than life Cost Cost Scrap Life 100,000 1,000 10 Book Value Beginning Fraction Year 0 1 2 3 4 5 6 7 8 9 10 100,000 80,000 64,000 51,200 40,960 32,768 26,214 20,972 16,777 13,422 20% 20% 20% 20% 20% 20% 20% 20% 20% 20% Depreciation 20,000 16,000 12,800 10,240 8,192 6,554 5,243 4,194 3,355 12,422 Accumulated Depreciation Book Value End 100,000 20,000 80,000 36,000 64,000 48,800 51,200 59,040 40,960 67,232 32,768 73,786 26,214 79,028 20,972 83,223 16,777 86,578 13,422 99,000 1,000 \fOn the sheet name Depreciation Schedule Create a Double declining Depreciation Schedule that restricts: Cost: Positive Scrap: less than the cost but not negative Life: restricted to between 2 and 10 years Display: Only years that are equal to or less than life Cost Cost Scrap Life 100,000 1,000 10 Book Value Beginning Fraction Year 0 1 2 3 4 5 6 7 8 9 10 100,000 80,000 64,000 51,200 40,960 32,768 26,214 20,972 16,777 13,422 20% 20% 20% 20% 20% 20% 20% 20% 20% 20% Depreciation 20,000 16,000 12,800 10,240 8,192 6,554 5,243 4,194 3,355 12,422 Accumulated Depreciation Book Value End 100,000 20,000 80,000 36,000 64,000 48,800 51,200 59,040 40,960 67,232 32,768 73,786 26,214 79,028 20,972 83,223 16,777 86,578 13,422 99,000 1,000