Question

In: Accounting

1. ) Prepare a depreciation schedule for the assets in the following transactions using the straight...

1. ) Prepare a depreciation schedule for the assets in the following transactions using the straight line method of depreciation:

A. Flash Enterprises purchased 3 new delivery trucks at a cost of $45,000 each. Each truck has an estimated useful life of 5 years.

B. Flash needed a new forklift to be used in warehouse operations at a cost of $12,500. The old forklift was traded in for $1,500. The new forklift has an estimated useful life of 4 years.

2.) Analyze the results of the below:

A. Flash has an opportunity to sell one of the trucks from (1A) above after 3 years for a price of $19,000. Should they accept the offer? Why or why not?

B. The used forklift from (1B) above had an original cost of $10,000 and a book value of $500 at the time of trade in. Calculate any gain or loss and show the appropriate journal entry.

3. Inventory Evaluation:

Units Units Cost Total Cost

Beginning Inventory 160,000 $2.00 $320,000

Purchase #1 60,000 $2.50 $150,000

Purchase #2 60,000 $3.50 $210,000

Ending Inventory 30,000

A. Calculate the value/cost of ending inventory & cogs using the following methods:

LIFO

FIFO

AVG COST (round unit cost to nearest cent)

B. Assuming the company has NOT determined which inventory method to use, Which method should they use for income tax purposes? Why?

C. The sold units had an average price of $5.00. Calculate gross profit and gross profit % using the method you chose in (B).

Solutions

Expert Solution

1) A. Amount of Depreciation per annum (1 trucks) =

= = $9,000 p.a. PER TRUCK
  

DEPRECIATION SCHEDULE FOR 3 TRUCKS
YEAR OPENING BALANCE DEPRECIATION CHARGED CLOSING BALANCE
1 $135,000 ($45,000*3) $27,000 ($9000*3)

$108,000

2 $108,000 $27,000 $81,000
3 $81,000 $27,000 $54,000
4 $54,000 $27,000 $27,000
5 $27,000 $27,000 0


B. Amount of depreciation p.a. =

= = $3,125

DEPRECIATION SCHEDULE FOR FORKLIFT
YEAR OPENING BALANCE DEPRECIATION CHARGED closing balance
1 $12,500 $3,125 $9,375
2 $9,375 $3,125 $6,250
3 $6,250 $3,125 $3,125
4 $3,125 $3,125 0

2) A. Book Value of 1 Truck at the end of 3 years = ( Closing Balance of Year 3 in Table above / 3 )
= ($54,000 / 3 )
= $18,000
or = (purchase price - 3 years depreciation )
= ( $45,000 - (3*$9,000)) = $18,000
Sales Price being Offered = $19,000

Since sales price being offered is greater than the book value by $1,000, Flash should sell the truck.


B. Value offered at the time of Trade-In : $1,500
Book Value at the time of trade in : $500
Gain = $1,500 - $500 = $1,000
Journal:
New Forklift Dr. $1,500
To Old Forklift $500
To Profit & Loss A/c $1,000


Related Solutions

Using Excel create depreciation schedule for the Straight-Line and Double-Declining-Methods for the following Long-Term assets: Asset...
Using Excel create depreciation schedule for the Straight-Line and Double-Declining-Methods for the following Long-Term assets: Asset 1 – Office Furniture Acquisition cost $30,000 Residual value $5,000 Useful life 7 years-------- Asset 2 – Delivery Truck Acquisition cost $40,000 Residual value $5,000 Useful life 5 years------- Asset 3 – Computer Acquisition cost $2000 Residual value $0 Useful life 4 years For each asset create its own Tab (Sheet) in the Excel worksheet and name the corresponding sheet by the asset. At...
Prepare a depreciation schedule to be used for tax purposes for a $60,000 dump truck using...
Prepare a depreciation schedule to be used for tax purposes for a $60,000 dump truck using the 200% declining-balance method and the mid-year convention.
a company using straight line depreciation has an ending gross investment in fixed assets of $750,...
a company using straight line depreciation has an ending gross investment in fixed assets of $750, an accumluted depreciation of $300 and an annual depreciation expense of $150. the total depreciable life of the fixed assets and the age if the plant and equipment are respectively 5 years and 2 years 8 years and 2 years 7 years and 5 years 2 years and 5 years
Tax Depreciation Lab Assignment: Prepare an excel Spreadsheet to calculate MACRS depreciation on the following assets....
Tax Depreciation Lab Assignment: Prepare an excel Spreadsheet to calculate MACRS depreciation on the following assets. Use the MACRS tables to look up the proper % to use for depreciation each year. Business Assets: Date Item                             Purchased        Amount           Bus. Use         Life Truck                           2/05/17            $28,000             100%            5 yr. Mower 2                      3/08/17               12,000             100%            7 yr Seeder                         3/01/16                 3,400             100%            7 yr Equipment                   6/25/16                 1,595             100%            7 yr             Laptop                         5/18/16           ...
Prepare a schedule of depreciation​ expense, accumulated​ depreciation, and book value per year for the equipment...
Prepare a schedule of depreciation​ expense, accumulated​ depreciation, and book value per year for the equipment under the three depreciation​ methods: straight-line,​ units-of-production, and​ double-declining-balance. Show your computations. ​Note: Three depreciation schedules must be prepared. 2. Which method tracks the wear and tear on the equipment most​ closely? Mama'sMama's Fried Chicken bought equipment on JanuaryJanuary 22, 20182018, for $ 18 comma 000$18,000. The equipment was expected to remain in service for four years and to operate for 3 comma 0003,000...
Part 1: Prepare a depreciation schedule showing depr. exp., accumulated depreciation and ending book value, year-by-year....
Part 1: Prepare a depreciation schedule showing depr. exp., accumulated depreciation and ending book value, year-by-year. 3 schedules for the 3 methods: straight-line, units-of-production, double declining basis. Asset is a delivery Truck. Est. Life … 4 Orig. Cost Basis 26,300.00 Est. Residual Value 1,500.00 Est. total mileage 100,000 miles driven, Yr 1 23,400 miles driven, Yr 2 20,100 miles driven, Yr 3 33,100 miles driven, Yr 4 23,400 Part 2: Assuming the truck is sold at the end of yr....
Motown Corporation uses the straight-line depreciation method for book purposes and has the following assets. ROUND...
Motown Corporation uses the straight-line depreciation method for book purposes and has the following assets. ROUND ALL ANSWERS TO THE NEAREST DOLLAR. asset Depreciable basis placed in service service life furniture $88,000 1/15/x0 3 years computer equipment 22,600 6/30/x1 5 years office machinery 68,000 11/1/x3 7 years manufacturing equipment 108,000 2/15/x2 10 years year ending 12/31/x3 a. Calculate current year depreciation expense on the furniture and record the journal entry: b. Calculate current year depreciation expense on the computer and...
#1: Prepare a depreciation schedule: Z Company's fiscal year runs July 1st to June 30th. The...
#1: Prepare a depreciation schedule: Z Company's fiscal year runs July 1st to June 30th. The company purchased a new machine which was installed and operational at the beginning of the second quarter in October. Machine purchase price of $145,800 with an additional installation cost of $10,000, and has an estimated useful life of four years from installation and estimated salvage value of $5,600. Required: 1. Prepare a depreciation schedule showing Net Book value (beginning and ending), depreciation expense, and...
Please show all work and provide explanations Prepare a depreciation schedule showing depr. exp., accumulated depreciation...
Please show all work and provide explanations Prepare a depreciation schedule showing depr. exp., accumulated depreciation and ending book value, year-by-year. 3 schedules for the 3 methods straight-line, units-of-production, double declining basis. Asset is a delivery Truck. Est. Life ………… 5 Orig. Cost Basis 24,500.00 Est. Residual Value 2,500.00 Est. total mileage 100,000 miles driven, Yr 1 21,400 miles driven, Yr 2 19,700 miles driven, Yr 3 18,900 miles driven, Yr 4 23,400 miles driven, Yr 5 16,600 Part 2:...
Given the following data for operating departments A and B prepare a schedule using the direct...
Given the following data for operating departments A and B prepare a schedule using the direct and step method of allocation to allocate service department costs to the operating departments .                                      Costs    # of employee           Square feet      Operating dept A             1600           100                          400                   Operating dept B             1300           100                          300                   Maintenance                   3000           100                          300                   Payroll                          2100           100                          300                   For the step method begin with the payroll department
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT