How did i solve this excel problem wrong? I added them all up at the end but did not get an equal result. Where did i messed up and how do i solve the problem?

Module 01 Problem: Purchases, Repairs, Depreciation and Disposal of Fixed Assets Prepare a depreciation schedule for three delivery vehicles. Assume all vehicles below are purchased between January 1 and January 5. #1 Van: January 1 purchased a used delivery van for $20,000. The residual value is $5,000 and the useful life is 3 years. Use straightline depreciation. Used Delivery Van Depreciation Accumulated Expense Depreciation Cost 20,000 $ 5,000 5,000 5,000 5,000 10,000 15,000 Book Value $ 20,000 15,000 10,000 5,000 #2 Van: January 3 purchased a new delivery van for $45,000. The residual value is $10,000 and the useful life is 5 years. Use double declining depreciation. New Delivery Van Depreciation Accumulated Expense Depreciation Year S Cost 45.000 S 2, 18,000 10,800 6,200 18,000 28,800 35,000 Book Value 45,000 27,000 16,200 10,000 #3 Van: January 4 purchased a third vehicle with special equipmen! installed to meet a client's needs for $60,000. It is estimated it will be driven 100,000 miles and have a residual value of $15,000. Use units of production depreciation method. 40,000 miles are driven the first year, 30,000 miles the second year, 20,000 miles the third year and 15,000 miles the fourth year. Special Equipped Van Depreciation Accumulated Expense Depreciation Year Cost 60,000 $ 18,000 13,500 9,000 6,750 18,000 31,500 40,500 47,250 Book Value 60,000 42,000 28,500 19,500 12,750 Module 01 Problem: Purchases, Repairs, Depreciation and Disposal of Fixed Assets Use this journal page for all transactions. Use Delivery Vehicles account for all delivery vehicles/vans. Use Excel formulas in the cells to document your calculations. Date Transaction Year 1 13-Mar Maintained delivery vehicles. Oil changes and general service work by Sally's Service Garage was completed, $200 on account. 20-Apr Sold delivery vehicle for $8,000 cash. The original vehicle was purchased for $42,000 and had accumulated depreciation of $38,000. 10-May Added a new transmission to a delivery van. The transmission was purchased and installed for $1000 on account, by Sally's Service Garage. It is estimated the transmission will extend the expected life by two years. 20-Aug Discarded office furniture with a $250 book value. The furniture was originally purchased for $900. 31-Dec Record the annual depreciation expense on the used delivery van from part one. #1 van. Year 2 1-Jul Sold the used delivery van in part 1 (van #1) for $10,000 cash. Update and record the depreciation expense on the used delivery van and record the sale. HINT: The date on the sale is year 2 of ownership. Year 1 depreciation is recorded already. 1-Sep Purchased a new delivery vehicle with an original cost of $48,000. A van with an original cost of $37,000 and accumulated depreciation of $30,000 was traded in for the new vehicle. The dealer gave a trade-in allowance of $5,000. Dan's Dependable Delivery paid for the new vehicle with a note payable. Record the exchange. General Journal Page 1 Credit 42,000 4,000 Date Account Post Ref. Debit March 13 Repair Expense $ 200 Accounts Payable-Sally's Service Garage 1 April 20 Cash $ 8,000.00 Accumulated Depreciation I $ 38,000.00 Equipment Gain on Sale May 10 Equipment $ 1,000.00 Account Payable-Sally's Service Garage 1 August 20 Accumulated Depreciation $ 650.00 Loss on Sale $ 250.00 | Equipment Decembe 31 Depreciation Expense $ 5,000.00 Accumulated Depreciation July 1 Depreciation Expense | $ 7,000.00 1,000 900 5,000 7,000 $ 10,000.00 $ 1,800.00 $ 2,000.00 Accumulated Depreciation 1 Cash Accumulated Depreciation Loss on Sale Equipment Septembe 1 Equipment (new) Accumulated Depreciation Loss on Sale Note Payable Equipment (old) Totals $ 48,000.00 $ 30,000.00 43.000 37.000