Question

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% << Extra Credit Complete A, B, C, D 7.5 minutes > 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 >>

Answer 1

Ans. (a). Depreciation as per Straight Line Method

= ($13,000 - $1,000) / 5 = $2,400 per year

Journal

Date	Particulars	Amt	Amt
01-Jan-12	Truck To Cash	13,000	13,000
31-Dec-12	Depreciation on Truck To Accumulated Depreciation	2,400	2,400

(b). Depreciation as per Double Declining Balance Method

= $13,000 x 36.92% = $4,800

Journal

Date	Particulars	Amt	Amt
01-Jan-12	Truck To Cash	13,000	13,000
31-Dec-12	Depreciation on Truck To Accumulated Depreciation	4,800	4,800

(c). Depreciation as per Units of Activity Method

= ($13,000 - $1,000) / 100,000 = $0.12 per mile

Journal

Date	Particulars	Amt	Amt
01-Jan-12	Truck To Cash	13,000	13,000
31-Dec-12	Depreciation on Truck*** To Accumulated Depreciation	2,400	2,400

*** It has been assumed that the truck has been used uniformly over the period of 5 Years, i.e., 20,000 miles per year