Question
Bills Lawn Care Mini Practice Part 5 In June, Bill made several purchases to accommodate his growing business. June 2 Purchased a storage location for
Bills Lawn Care Mini Practice Part 5
In June, Bill made several purchases to accommodate his growing business.
June 2 Purchased a storage location for lawn care equipment, paid $45,000 for a building on 1 acre. The land is appraised at $8,000. The building has an estimated life of 10 years with a $5,000 salvage value. Bill paid $2,000 down and financed the remaining purchase price with a 5% 5 year note.
4 Purchased a trailer to haul lawn care equipment for $2,300, estimated life is 5 years with no salvage value. Bill paid for the purchase in cash.
5 Purchased a gas powered trimmer for $1,200 and a commercial leaf-blower for $1,500. Bill estimates they will each have a two year life and no salvage value. Bill paid for both of these pieces of equipment on account.
These are in addition to the three assets Bill acquired in May:
Date Item Cost Estimated Life Salvage Value
May 2 Truck $5,000 5 years $500
5 Lawn Mower 300 2 years $0
5 Aerator 500 2 years $0
Depreciation was recorded in May for these assets using the straight-line method however Bill is considering other depreciation methods and has asked you to prepare a comparison of the straight-line method with the double declining balance (200% DDB) method before he decides.
Instructions:
Using the chart of accounts provided below and the Excel template provided with this assignment, record the transactions for the new assets purchased in June, 2014. Start with Page 7 for the journal entries. Explanations are optional.
Prepare a monthly schedule of depreciation for each of the seven assets for 2014 using 1) straight-line and 2) 200% DDB. (Assume assets purchased before the 15th of the month will be depreciated as if owned for the entire month). Remember that you are calculating monthly depreciation, not annual and adjust your depreciation rate. Carry your depreciation rate to four decimals and round the depreciation expense to two decimals.
Bill has decided that equipment will be depreciated using straight-line and the building using 200% DDB. Prepare the adjusting journal entries for depreciation for the month of June, 2014. Start with Page 8 for the adjusting journal entries. Explanations are optional.
BILLS LAWN CARE
CHART OF ACCOUNTS
ASSETS REVENUES
101 Cash 401 Lawn Service Revenue
110 Accounts Receivable 410 Sales Revenue
112 Allowance for Doubtful Accounts 415 Sales Returns and Allowances
115 Notes Receivable 420 Interest Income
116 Interest Receivable
120 Supplies COST OF GOODS SOLD
130 Prepaid Insurance 501 Purchases
140 Inventory 505 Purchase Returns and Allowances
150 Equipment
152 Land EXPENSES
153 Building 620 Supplies Expense
155 Accumulated Depreciation Equipment 630 Fuel Expense
156 Accumulated Depreciation - Building 640 Repair and Maintenance Expense 650 Advertising Expense
LIABILITIES 660 Insurance Expense
201 Accounts Payable 670 Depreciation Expense
220 Notes Payable 680 Interest Expense
225 Interest Payable 690 Bad Debt Expense
OWNERS EQUITY
301 Owners Capital
305 Owners Drawings
310 Income Summary
1.
| GENERAL JOURNAL | Page | ||||
| DATE | DESCRIPTION | POST. REF. | DEBIT | CREDIT | |
| GENERAL JOURNAL | Page | ||||
| DATE | DESCRIPTION | POST. REF. | DEBIT | CREDIT
| |
|
| |||||
2.
| Asset Information: Truck, $5,000 cost, 5 year life, $500 salvage value | |||||||||
| Computation | Monthly Depreciation Expense | End of Year | |||||||
| Month | Depreciable Cost | Depreciation Rate | = | Accumulated Depreciation | Book Value | ||||
| May-14 | |||||||||
| Jun-14 | |||||||||
| Jul-14 | |||||||||
| Aug-14 | |||||||||
| Sep-14 | |||||||||
| Oct-14 | |||||||||
| Nov-14 | |||||||||
| Dec-14 | |||||||||
| Asset Information: Lawn Mower, $300 cost, 2 year life, $0 salvage value | |||||||||
| Computation | Monthly Depreciation Expense | End of Year | |||||||
| Month | Depreciable Cost | Depreciation Rate | = | Accumulated Depreciation | Book Value | ||||
| May-14 | |||||||||
| Jun-14 | |||||||||
| Jul-14 | |||||||||
| Aug-14 | |||||||||
| Sep-14 | |||||||||
| Oct-14 | |||||||||
| Nov-14 | |||||||||
| Dec-14 | |||||||||
| Asset Information: Aerator, $500 cost, 2 year life, $0 salvage value | |||||||||
| Computation | Monthly Depreciation Expense | End of Year | |||||||
| Month | Depreciable Cost | Depreciation Rate | = | Accumulated Depreciation | Book Value | ||||
| May-14 | |||||||||
| Jun-14 | |||||||||
| Jul-14 | |||||||||
| Aug-14 | |||||||||
| Sep-14 | |||||||||
| Oct-14 | |||||||||
| Nov-14 | |||||||||
| Dec-14 | |||||||||
| Asset Information: Building, $37,000 cost, 10 year life, $5,000 salvage value | |||||||||
| Computation | Monthly Depreciation Expense | End of Year | |||||||
| Month | Depreciable Cost | Depreciation Rate | = | Accumulated Depreciation | Book Value | ||||
| Jun-14 | |||||||||
| Jul-14 | |||||||||
| Aug-14 | |||||||||
| Sep-14 | |||||||||
| Oct-14 | |||||||||
| Nov-14 | |||||||||
| Dec-14 | |||||||||
| Asset Information: Trailer, $2,300 cost, 5 year life, $0 salvage value | |||||||||
| Computation | Monthly Depreciation Expense | End of Year | |||||||
| Month | Depreciable Cost | Depreciation Rate | = | Accumulated Depreciation | Book Value | ||||
| Jun-14 | |||||||||
| Jul-14 | |||||||||
| Aug-14 | |||||||||
| Sep-14 | |||||||||
| Oct-14 | |||||||||
| Nov-14 | |||||||||
| Dec-14 | |||||||||
| Asset Information: Trimmer, $1,200 cost, 2 year life, $0 salvage value | |||||||||
| Computation | Monthly Depreciation Expense | End of Year | |||||||
| Month | Depreciable Cost | Depreciation Rate | = | Accumulated Depreciation | Book Value | ||||
| Jun-14 | |||||||||
| Jul-14 | |||||||||
| Aug-14 | |||||||||
| Sep-14 | |||||||||
| Oct-14 | |||||||||
| Nov-14 | |||||||||
| Dec-14 | |||||||||
| Asset Information: Leaf Blower, $1,500 cost, 2 year life, $0 salvage value | |||||||||
| Computation | Monthly Depreciation Expense | End of Year | |||||||
| Month | Depreciable Cost | Depreciation Rate | = | Accumulated Depreciation | Book Value | ||||
| Jun-14 | |||||||||
| Jul-14 | |||||||||
| Aug-14 | |||||||||
| Sep-14 | |||||||||
| Oct-14 | |||||||||
| Nov-14 | |||||||||
| Dec-14 | |||||||||
3.
| Asset Information: Truck, $5,000 cost, 5 year life, $500 salvage value | ||||||
| Computation | Monthly Depreciation Expense | End of Year | ||||
| Month | Depreciable Cost | Depreciation Rate | = | Accumulated Depreciation | Book Value | |
| May-14 | ||||||
| Jun-14 | ||||||
| Jul-14 | ||||||
| Aug-14 | ||||||
| Sep-14 | ||||||
| Oct-14 | ||||||
| Nov-14 | ||||||
| Dec-14 | ||||||
| Asset Information: Lawn Mower, $300 cost, 2 year life, $0 salvage value | ||||||
| Computation | Monthly Depreciation Expense | End of Year | ||||
| Month | Depreciable Cost | Depreciation Rate | = | Accumulated Depreciation | Book Value | |
| May-14 | ||||||
| Jun-14 | ||||||
| Jul-14 | ||||||
| Aug-14 | ||||||
| Sep-14 | ||||||
| Oct-14 | ||||||
| Nov-14 | ||||||
| Dec-14 | ||||||
| Asset Information: Aerator, $500 cost, 2 year life, $0 salvage value | ||||||
| Computation | Monthly Depreciation Expense | End of Year | ||||
| Month | Depreciable Cost | Depreciation Rate | = | Accumulated Depreciation | Book Value | |
| May-14 | ||||||
| Jun-14 | ||||||
| Jul-14 | ||||||
| Aug-14 | ||||||
| Sep-14 | ||||||
| Oct-14 | ||||||
| Nov-14 | ||||||
| Dec-14 | ||||||
| Asset Information: Building, $37,000 cost, 10 year life, $5,000 salvage value | ||||||
| Computation | Monthly Depreciation Expense | End of Year | ||||
| Month | Depreciable Cost | Depreciation Rate | = | Accumulated Depreciation | Book Value | |
| Jun-14 | ||||||
| Jul-14 | ||||||
| Aug-14 | ||||||
| Sep-14 | ||||||
| Oct-14 | ||||||
| Nov-14 | ||||||
| Dec-14 | ||||||
| Asset Information: Trailer, $2,300 cost, 5 year life, $0 salvage value | ||||||
| Computation | Monthly Depreciation Expense | End of Year | ||||
| Month | Depreciable Cost | Depreciation Rate | = | Accumulated Depreciation | Book Value | |
| Jun-14 | ||||||
| Jul-14 | ||||||
| Aug-14 | ||||||
| Sep-14 | ||||||
| Oct-14 | ||||||
| Nov-14 | ||||||
| Dec-14 | ||||||
| Asset Information: Trimmer, $1,200 cost, 2 year life, $0 salvage value | ||||||
| Computation | Monthly Depreciation Expense | End of Year | ||||
| Month | Depreciable Cost | Depreciation Rate | = | Accumulated Depreciation | Book Value | |
| Jun-14 | ||||||
| Jul-14 | ||||||
| Aug-14 | ||||||
| Sep-14 | ||||||
| Oct-14 | ||||||
| Nov-14 | ||||||
| Dec-14 | ||||||
| Asset Information: Leaf Blower, $1,500 cost, 2 year life, $0 salvage value | ||||||
| Computation | Monthly Depreciation Expense | End of Year | ||||
| Month | Depreciable Cost | Depreciation Rate | = | Accumulated Depreciation | Book Value | |
| Jun-14 | ||||||
| Jul-14 | ||||||
| Aug-14 | ||||||
| Sep-14 | ||||||
| Oct-14 | ||||||
| Nov-14 | ||||||
| Dec-14 | ||||||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started