Buildings Furniture Equipment Land 1,500,000.00 55,000.00 20,000.00 200,000.00 Use SLN and VDB depreciation functions. Use an IF formula to enter o if this period is greater than the useful life of the asset. Depreciation Schedule Salvage Useful Life Method Period 14 14 tem Buildings Furniture Furniture Furniture Furniture Furniture Furniture Equipment Equipment Equipment Equipment Equipment Land Depreciation 1,500,000.00 10,000.00 2,000.00 1,500.00 8,500.00 8,000.00 25,000.00 2,000.00 1,500.00 7,500.00 8,000.00 1,000.00 200,000.00 1,775,000.00 Straight Line Straight Line Straight Line Straight Line Straight Line Straight Line Straight Line Double Declining Double Declining Double Declining Double Declining Double Declining 200,000.00 500.00 Sold this year for $5,000 10 500.00 500.00 1,000.00 10 4 10 14 800.00 500.00 250.00 4