Question
In: Accounting
Computer the Depreciation Schedule by using SLD, SOYD, and DDB methods the university pursed a lab...
Computer the Depreciation Schedule by using SLD, SOYD, and DDB methods
the university pursed a lab Mass-Spectrometer that has 5 years depreciable life. The instrument costs school $900 with a Salvage Value of $70 after the end of the service life.
1-Built a Depreciation Schedule for this asset by all three methods
2-Build a graphic of each method
3-Which method will you recommend to the university and why?
Solutions
Expert Solution
| SLD | ||
| Year | Depreciation for the year | Written down value |
| 1 | $ 166 | $ 734 |
| 2 | $ 166 | $ 568 |
| 3 | $ 166 | $ 402 |
| 4 | $ 166 | $ 236 |
| 5 | $ 166 | $ 70 |
| SOYD | |||||
| Year | Remaining years of use full life | SYOD | Applicable % | Depreciation for the year | Written down value |
| 1 | 5 | 15 | 33% | $ 276.67 | $ 623.33 |
| 2 | 4 | 15 | 27% | $ 221.33 | $ 402.00 |
| 3 | 3 | 15 | 20% | $ 166.00 | $ 236.00 |
| 4 | 2 | 15 | 13% | $ 110.67 | $ 125.33 |
| 5 | 1 | 15 | 7% | $ 55.33 | $ 70.00 |
| DDB | ||
| Year | Depreciation for the year | Written down value |
| 1 | $ 360.00 | $ 540.00 |
| 2 | $ 216.00 | $ 324.00 |
| 3 | $ 129.60 | $ 194.40 |
| 4 | $ 77.76 | $ 116.64 |
| 5 | $ 46.64 | $ 70.00 |
| SLD | ||
| Year | Depreciation for the year | Written down value |
| 1 | =(900-70)/5 | =900-B3 |
| 2 | =(900-70)/5 | =C3-B4 |
| 3 | =(900-70)/5 | =C4-B5 |
| 4 | =(900-70)/5 | =C5-B6 |
| 5 | =(900-70)/5 | =C6-B7 |
| SOYD | |||||
| Year | Remaining years of use full life | SYOD | Applicable % | Depreciation for the year | Written down value |
| 1 | 5 | =(B11*(B11+1))/2 | =B11/C11 | =D11*(900-70) | =900-E11 |
| 2 | 4 | 15 | =B12/C12 | =D12*(900-70) | =F11-E12 |
| 3 | 3 | 15 | =B13/C13 | =D13*(900-70) | =F12-E13 |
| 4 | 2 | 15 | =B14/C14 | =D14*(900-70) | =F13-E14 |
| 5 | 1 | 15 | =B15/C15 | =D15*(900-70) | =F14-E15 |
| DDB | ||
| Year | Depreciation for the year | Written down value |
| 1 | =900*(2/5) | =900-B20 |
| 2 | =C20*(2/5) | =C20-B21 |
| 3 | =C21*(2/5) | =C21-B22 |
| 4 | =C22*(2/5) | =C22-B23 |
| 5 | =C23-70 | =C23-B24 |
we recommend DDB method as the school will get depreciation benefit more in earler years.
ekkarill92 answered 1 year agoRelated Solutions
Computer the Depreciation Schedule by using SLD, SOYD, and DDB methods the university pursed a lab...
Computer the Depreciation Schedule by using SLD, SOYD,
and DDB methods
the university pursed a lab Mass-Spectrometer that has 5 years
depreciable life. The instrument costs school $900 with a Salvage
Value of $70 after the end of the service life.
1-Built a Depreciation Schedule for this asset by all three
methods
2-Build a graphic of each method
3-Which method will you recommend to the university and why?
develop a ddb and 150% depreciation schedule for a commercial coffee roster machine that is purchased...
develop a ddb and 150% depreciation schedule for a commercial
coffee roster machine that is purchased for $90,000. the machine
has a 6-year life and a salvage value of $15,000. use the
depreciation schedule to answer the following:
what are BV after 3 years and after 6 years? which of the two
methods writes off more of the first cost over the lifetime of the
machine?
Tom has bought a yellow automobile for $10K. Using MACRS GDS and DDB depreciation, construct the...
Tom has bought a yellow automobile for $10K. Using MACRS GDS and
DDB depreciation, construct the annual depreciation allowance
table. For automobiles: IRS asset class = 0.22, years = 3, MACRS
(GDS, ADS) = 5. MACRS assumes $0 salvage value.
Tom has bought a yellow automobile for $10K. Using MACRS GDS and DDB depreciation, construct the...
Tom has bought a yellow automobile for $10K. Using MACRS GDS and
DDB depreciation, construct the annual depreciation allowance
table. please explain all steps and show all steps and work thank
you
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...
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....
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.
E7-37B. (Learning Objectives 2, 3: Analyzing the effect of a sale of a PPE; DDB depreciation)...
E7-37B. (Learning Objectives 2, 3: Analyzing the effect of a
sale of a PPE; DDB depreciation) Assume that on January 2, 20X6,
LaSalle of Lyon purchased fixtures for €8,400 cash, expecting the
fixtures to remain in service for five years. LaSalle has
depreciated the fixtures on a double-declining-balance basis, with
€1,800 estimated residual value. On September 30, 20X7, LaSalle
sold the fixtures for €2,200 cash. Record both the depreciation
expense on the fixtures for 20X7 and then the sale of...
Directions: Calculate Depreciation Expense for each of 3 years using 3 different methods using the following...
Directions: Calculate Depreciation Expense for each of 3 years
using 3 different methods using the following information. Report
your final answers, use formulas and/or show all work for each
calculation. Round to the whole number.
Multi-use printer acquired on
the first day of the Year One for $10,000
The estimated useful life is 3
years or 10,000 hours
The residual salvage value is
estimated at $1500
During Year One, the copy
machine was used for 3300 hours
During Year Two,...
there are various methods of auditing around the computer, through the computer, and with the computer....
there are various methods of auditing around the computer,
through the computer, and with the computer. Which of these methods
would you recommend for the audit of accounts receivable
and why? Be sure to include the impact of professional standards
related to the method you recommended and give an example
of how the method you recommended would be used specifically to
audit accounts receivable.
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Why is important for organizations to have a disaster recovery plan?
- A point charge of -1C is placed in the center of a spherical shell of radius...
- Your team will make a modification of the program #1 above, that will read in the...
- Mary spots Bill approaching the dorm at a constant rate of 2 m/s on the walkway...
- There has been concern among some folks that social media--a broad umbrella, I know--is changing our...
- 1. Jerome, Sheila, Gary, and Ella agreed to purchase a tract of land and make it...
- What is the difference between system clocks and bus clocks? Which one is used for assembly...
ADVERTISEMENT