On the sheet name Depreciation Schedule Create a Double declining Depreciation Schedule that restricts: Cost restricted to positive numbers Scrap restricted to positive numbers Less than the cost Life restricted to between 3 and 10 years And shows only years that are equal to or less than life Use Named Ranges Cost 100,000.00 Scrap 30,000.00 Life in Years 9 Year Book Value Beg Dep Exp Acc Dep Book Value End 0 100,000.00 100,000.00 $22,222.22 $22,222.22 77,777.78 2 77,777.78 $17,283.95 $39,506.17 60,493.83 3 60,493.83 $13,443.07 $52,949.25 47,050.75 4 47,050.75 $ 10,455.72 $63,404.97 36,595.03 5 36,595.03 $6,595.03 $70,000.00 30,000.00 30,000.00 $0.00 $70,000.00 30,000.00 30,000.00 $0.00 $70,000.00 30,000.00 30,000.00 $0.00 $70,000.00 30,000.00 30,000.00 $0.00 $70,000.00 30,000.00