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 oniy years that are equal to or less than life Use Named Ranges Cost Scrap Life in Years Year '000'40\\U1-DOJNI'O 100,000.00 30,000.00 9 100,000.00 77,777.78 60,493.83 47,050.75 36,595.03 30,000.00 30,000.00 30,000.00 30,000.00 Book Value Beg Dep Exp $22,222.22 $17,283.95 $13,443.07 $10,455.72 $6,595.03 $0.00 $0.00 $0.00 $0.00 Acc Dep $22,222.22 $39,506.17 $52,949.25 $63,404.97 $70,000.00 $70,000.00 $70,000.00 $70,000.00 $70,000.00 Book Value End 100,000.00 77,777.78 60,493.83 47,050.75 36,595.03 30,000.00 30,000.00 30,000.00 30,000.00 30,000.00