Prepare the depreciation tables for A. Straight Line, B. Double Declining Balance, and C. Units of Activity.

Next Journalize the purchase of the truck, the first year's depreciation expense, and the disposal of the truck. (including explanations)

Here's the data:

Purchased on January 1, 2012 for $13,000. Has an estimated residual value of $1,000.

Useful life of 5 years or 100,000 miles.

Sold on December 31st, 2013

100 Depr Scheds Barb's Florists Solution with JE thru Disposal and T accounts XX Watch all video's provided. They are a demonstration of Joe's Delivery which is similar to this assignment. Verify your print format is Portrait, half inch marrins and one bare. Be sure to rename vour file: Lname. Fname Barb's.xls 200 Total points Straightline Table DDB Table Depreciation Schedules Barb's Florists Name: Units Table $13,000 $1,000 Purchased new truck Jan 1, 2012 Sold Dec 31, 2013 for $7,500 JE'S T Accounts Late Misc Cost Expected salvage value Estimated useful life in years Estimated useful life in miles 1 2 00 100,000 200 50 100% Intro thru SL Depr 8 min >> A. Prepare the straight line depreciation table. Straight-line Year Depr % Dupree Exp Purchase C: Journalize Purchase and DDB Depreciation: General Journal Date Account DR JE Purchase for cash: CR Accum Depree Book Value Notes/calculations Truck Date of Purchase Life (years) Depreciation Rate % Cost Salvage Value Depreciable Cost 1st year #Months Date of Disposal Sales Price (cash) JE Depreciate Asset (Dbl Declining Bal) Yr1 JE Dispose Asset (DDB Depr) Dec 31, 2013 B. Double-Declining 5 Min >> Prepare the double declining balance depreciation table. Truck Date of Purchase Life (years) Year Depr% Depree Exp Accum Deprec Book Value Purchase Denreciation Rate : Cost Salvage Value Depreciable Cost 1st year # Months Date of Disposal Sales Price (cash) D. Post T Accounts: based on DDB Depreciation Cash Beginning >> 750001 Gain/Loss C. Units of Activity 4 Min>> Actual usage of the machine was as follows: Yr 1:12000, Yr 2: 18000 Yr 3: 21000 Yr 4:14000 Yr 5: 60000 Prepare the Units of Activity depreciation Schedule Truck Truck Actual Miles Depree Exp Accum Depree Book Value 1 Year Purchase Accum Depreciation Date of Purchase Life (veurs) Depreciation Rate % Cost Salvage Value Depreciable Cost Estimated # units Slunit depr rate 1st year #Months Date of Disposal Sales Price (cash) Depres Exp Year 1 >> Year 2 >>