Buildings Furniture Equipment Land 1,500,000.00 55,000.00 20,000.00 200,000.00 U

Question

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

Explanation / Answer

item cost salvage useful life method period depreciation buildings 1500000 200000 50 SLN 14 364000 furniture 10000 500 10 SLN 14 0 furniture 2000 0 10 SLN 8 1600 furniture 1500 0 10 SLN 6 900 furniture 8500 500 10 SLN 4 3200 furniture 8000 500 10 SLN 3 2250 furniture 25000 1000 10 SLN 2 4800 equipment 2000 0 5 VDB 14 0 equipment 1500 0 5 VDB 5 1383.36 equipment 7500 800 5 VDB 4 6528 equipment 8000 500 5 VDB 3 6272 equipment 1000 250 5 VDB 2 640 land 200000 0

Related Questions

Navigate

• Browse (All)
• Browse B
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.