On January 1, 2018 Friendly Farm Company purchased a new machine at a cost of $350,000....
On January 1, 2018 Friendly Farm Company purchased a new machine at a cost of $350,000. The machine has an estimated useful life of 4 years or 100,000 hours and residual value of $30,000. The machine will be used 30,000 hours in year 1, 40,000 hours in year 2, 20,000 hours in year 3 and 10,000 hours in year 4.
Requirements:
IN EXCEL FORMAT- Prepare a depreciation schedule using each of the three methods: Straight line, Units of Production and Double Declining Balance.
Homework Answers
Answers
- Straight Line method
|
A |
Cost |
$ 350,000.00 |
|
B |
Residual Value |
$ 30,000.00 |
|
C=A - B |
Depreciable base |
$ 320,000.00 |
|
D |
Life [in years] |
4 |
|
E=C/D |
Annual SLM depreciation |
$ 80,000.00 |
|
Year |
Book Value |
Depreciation expense |
Ending Book Value |
Accumulated Depreciation |
|
1 |
$ 350,000.00 |
$ 80,000.00 |
$ 270,000.00 |
$ 80,000.00 |
|
2 |
$ 270,000.00 |
$ 80,000.00 |
$ 190,000.00 |
$ 160,000.00 |
|
3 |
$ 190,000.00 |
$ 80,000.00 |
$ 110,000.00 |
$ 240,000.00 |
|
4 |
$ 110,000.00 |
$ 80,000.00 |
$ 30,000.00 |
$ 320,000.00 |
- Units of production
|
A |
Cost |
$ 350,000.00 |
|
B |
Residual Value |
$ 30,000.00 |
|
C=A - B |
Depreciable base |
$ 320,000.00 |
|
D |
Usage |
100,000 |
|
E = C/D |
Depreciation per ….. |
$ 3.200 |
|
Year |
Book Value |
Usage |
Depreciation expense |
Ending Book Value |
Accumulated Depreciation |
|
1 |
$ 350,000.00 |
30,000 |
$ 96,000.00 |
$ 254,000.00 |
$ 96,000.00 |
|
2 |
$ 254,000.00 |
40,000 |
$ 128,000.00 |
$ 126,000.00 |
$ 224,000.00 |
|
3 |
$ 126,000.00 |
20,000 |
$ 64,000.00 |
$ 62,000.00 |
$ 288,000.00 |
|
4 |
$ 62,000.00 |
10,000 |
$ 32,000.00 |
$ 30,000.00 |
$ 320,000.00 |
- Double Declining balance
|
A |
Cost |
$ 350,000.00 |
|
B |
Residual Value |
$ 30,000.00 |
|
C=A - B |
Depreciable base |
$ 320,000.00 |
|
D |
Life [in years] |
4 |
|
E=C/D |
Annual SLM depreciation |
$ 80,000.00 |
|
F=E/C |
SLM Rate |
25.00% |
|
G=F x 2 |
DDB Rate |
50.00% |
|
Year |
Beginning Book Value |
Depreciation rate |
Depreciation expense |
Ending Book Value |
Accumulated Depreciation |
|
1 |
$ 350,000.00 |
50.00% |
$ 175,000.00 |
$ 175,000.00 |
$ 175,000.00 |
|
2 |
$ 175,000.00 |
50.00% |
$ 87,500.00 |
$ 87,500.00 |
$ 262,500.00 |
|
3 |
$ 87,500.00 |
50.00% |
$ 43,750.00 |
$ 43,750.00 |
$ 306,250.00 |
|
4 |
$ 43,750.00 |
$ 13,750.00 |
$ 30,000.00 |
$ 320,000.00 |
Add Answer to:
On January 1, 2018 Friendly Farm Company purchased a new machine
at a cost of $350,000....
On January 1, 2018 Friendly Farm Company purchased a new machine at a cost of $350,000....
On January 1, 2018 Friendly Farm Company purchased a new machine at a cost of $350,000. The machine has an estimated useful life of 4 years or 100,000 hours and residual value of $30,000. The machine will be used 30,000 hours in year 1, 40,000 hours in year 2, 20,000 hours in year 3 and 10,000 hours in year 4. Requirements: Prepare a depreciation schedule using each of the three methods: Straight line, Units of Production and Double Declining Balance.
On January 1, 2018 Friendly Farm Company purchased a new machine at a cost of $350,000....
On January 1, 2018 Friendly Farm Company purchased a new machine
at a cost of $350,000. The machine has an estimated useful life of
4 years or 100,000 hours and residual value of $30,000. The machine
will be used 30,000 hours in year 1, 40,000 hours in year 2, 20,000
hours in year 3 and 10,000 hours in year 4.
Requirements:
Prepare a depreciation schedule using each of the three methods:
Straight line, Units of Production and Double Declining
Balance....
phs and Excel Assighr On January 1, 2018 Friendly Farm Company purchased a new machine at...
phs and Excel Assighr On January 1, 2018 Friendly Farm Company purchased a new machine at a cost of $350,000. The machine has an estimated useful life of 4 years or 100,000 hours and residual value of $30,000. The machine will be used 30,000 hours in year 1, 40,000 hours in year 2, 20,000 hours in year 3 and 10,000 hours in year 4. Requirements: Prepare a depreciation schedule using each of the three methods: Straight line, Units of Production...
K Excel Assignment #1 - Instructions and Te... On January 1, 2018 Friendly Farm Company purchased...
K Excel Assignment #1 - Instructions and Te... On January 1, 2018 Friendly Farm Company purchased a new machine at a cost of $350,000. The machine has an estimated useful life of 4 years or 100,000 hours and residual value of $30,000. The machine will be used 30,000 hours in year 1, 40,000 hours in year 2, 20,000 hours in year 3 and 10,000 hours in year 4. Requirements: Prepare a depreciation schedule using each of the three methods: Straight...
The FraserRiver Company has purchased a new piece of factory equipment on January 1, 2018, and...
The FraserRiver Company has purchased a new piece of factory equipment on January 1, 2018, and wishes to compare three depreciation methods: straight-line, double-declining-balance, and units-of-production The equipment costs $400,000 and has an estimated useful life of four years, or 8,000 hours. At the end of four years, the equipment is estimated to have a residual value of $20,000. Requirements 1. Use Excel to prepare depreciation schedules for straight-line, double-declining-balance, and units-of-production methods. Use cell references from the Data table....
DEPRECIATION METHODS Ten O'Clock, Inc. purchased a vanon Lamar 2018 for SA0000. Estimated life of the...
DEPRECIATION METHODS Ten O'Clock, Inc. purchased a vanon Lamar 2018 for SA0000. Estimated life of the van was live years, and its estimated residual value was $90.000. Ten O'Clock uses the straight-line method of depreciation. Prepare the depreciation schedule. Depreciation Expense Book Value at End of Year 2018 2019 2018 2019 Method Straight-line On January 1, 2019, Sapphire Manufacturing Corporation purchased a machine for $10,000,000. The corporation expects to use the machine for 24,000 hours over the next six years....
On January 1, 2018, a machine was purchased for $120,000. The machine has an estimated salvage...
On January 1, 2018, a machine was purchased for $120,000. The
machine has an estimated salvage value of $9,600 and an estimated
useful life of 5 years. The machine can operate for 120,000 hours
before it needs to be replaced. The company closed its books on
December 31 and operates the machine as follows: 2018, 24,000 hrs;
2019, 30,000 hrs; 2020, 18,000 hrs; 2021, 36,000 hrs; and 2022,
12,000 hrs.
Compute the annual depreciation charges over the machine’s life
assuming...
On January 1, 2014, a machine was purchased for $120,000. The machine has an estimated salvage...
On January 1, 2014, a machine was purchased for $120,000. The machine has an estimated salvage value of $6,000 and an estimated useful life of 6 years. The machine can operate for 200,000 hours before it needs to be replaced. The company closed its books on December 31 and operates the machine as follows: 2014, 35,000 hrs; 2015, 45,000 hrs; 2016, 55,000 hrs; 2017, 30,000 hrs; 2018, 20,000 hrs; 2019, 15,000 hrs. (a) Compute the annual depreciation charges over the...
5. A machine was acquired on January 1, 2018, at a cost of $80,000. The machine...
5. A machine was acquired on January 1, 2018, at a cost of $80,000. The machine was originally estimated to have a residual value of $5,000 and an estimated life of 5 years. The machine is expected to produce a total of 100,000 components during its life, as follows: 15,000 in 2018, 20,000 in 2019, 20,000 in 2020, 30,000 in 2021, and 15,000 in 2022. (25 marks) Instructions (a) Calculate the amount of depreciation to be charged each year, using...
5. A machine was acquired on January 1, 2018, at a cost of $80,000. The machine...
5. A machine was acquired on January 1, 2018, at a cost of $80,000. The machine was originally estimated to have a residual value of $5,000 and an estimated life of 5 years. The machine is expected to produce a total of 100,000 components during its life, as follows: 15,000 in 2018, 20,000 in 2019, 20,000 in 2020, 30,000 in 2021, and 15,000 in 2022. (25 marks) Instructions (a) Calculate the amount of depreciation to be charged each year, using...
On January 1, 2018 Friendly Farm Company purchased a new machine
at a cost of $350,000. The machine has an estimated useful life of
4 years or 100,000 hours and residual value of $30,000. The machine
will be used 30,000 hours in year 1, 40,000 hours in year 2, 20,000
hours in year 3 and 10,000 hours in year 4.
Requirements:
Prepare a depreciation schedule using each of the three methods:
Straight line, Units of Production and Double Declining
Balance....
phs and Excel Assighr On January 1, 2018 Friendly Farm Company purchased a new machine at a cost of $350,000. The machine has an estimated useful life of 4 years or 100,000 hours and residual value of $30,000. The machine will be used 30,000 hours in year 1, 40,000 hours in year 2, 20,000 hours in year 3 and 10,000 hours in year 4. Requirements: Prepare a depreciation schedule using each of the three methods: Straight line, Units of Production...
K Excel Assignment #1 - Instructions and Te... On January 1, 2018 Friendly Farm Company purchased a new machine at a cost of $350,000. The machine has an estimated useful life of 4 years or 100,000 hours and residual value of $30,000. The machine will be used 30,000 hours in year 1, 40,000 hours in year 2, 20,000 hours in year 3 and 10,000 hours in year 4. Requirements: Prepare a depreciation schedule using each of the three methods: Straight...
The FraserRiver Company has purchased a new piece of factory equipment on January 1, 2018, and wishes to compare three depreciation methods: straight-line, double-declining-balance, and units-of-production The equipment costs $400,000 and has an estimated useful life of four years, or 8,000 hours. At the end of four years, the equipment is estimated to have a residual value of $20,000. Requirements 1. Use Excel to prepare depreciation schedules for straight-line, double-declining-balance, and units-of-production methods. Use cell references from the Data table....
DEPRECIATION METHODS Ten O'Clock, Inc. purchased a vanon Lamar 2018 for SA0000. Estimated life of the van was live years, and its estimated residual value was $90.000. Ten O'Clock uses the straight-line method of depreciation. Prepare the depreciation schedule. Depreciation Expense Book Value at End of Year 2018 2019 2018 2019 Method Straight-line On January 1, 2019, Sapphire Manufacturing Corporation purchased a machine for $10,000,000. The corporation expects to use the machine for 24,000 hours over the next six years....
On January 1, 2018, a machine was purchased for $120,000. The
machine has an estimated salvage value of $9,600 and an estimated
useful life of 5 years. The machine can operate for 120,000 hours
before it needs to be replaced. The company closed its books on
December 31 and operates the machine as follows: 2018, 24,000 hrs;
2019, 30,000 hrs; 2020, 18,000 hrs; 2021, 36,000 hrs; and 2022,
12,000 hrs.
Compute the annual depreciation charges over the machine’s life
assuming...
Most questions answered within 3 hours.
-
The Cost of Equity and
Flotation Costs
Messman Manufacturing
will issue common stock to the public...
asked 4 minutes ago -
a) summarize the challenges facing New Britain today
b) identify some of its strengths
c) suggest...
asked 6 minutes ago -
**86 at 40 not 88. please show how got Tr in calculations thank
you
2) The...
asked 6 minutes ago -
McGlaun Company pays its employees every two weeks. The firm
last paid its employees on September...
asked 20 minutes ago -
You have been gifted a Mogwai as a pet and decide to do a little
online...
asked 25 minutes ago -
given the standard of 200 mg/dl and the absorbance of that
standard is 0.640. What is...
asked 27 minutes ago -
Exercise 8-51 Algo
An accounting professor is notorious for being stingy in giving
out good letter...
asked 35 minutes ago -
month
total distribution cost
level of activity (unit produced)
july
230.000
3500
august
250.000
3750
september...
asked 37 minutes ago -
A smoke detector system uses two devices, A and B. If smoke is
present, the probability...
asked 1 hour ago -
Your division head has assigned another important project to you
and your team. This project is...
asked 49 minutes ago -
Under normal use conditions, the Mean Time To Failure of a
heating coil can be modeled...
asked 1 hour ago -
Consider the probability that fewer than 34 out of 116 CDs will
be defective. Assume the...
asked 1 hour ago