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 3 years 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,...
Compute the depreciation schedule using Sum-of-years'-digits method for a copy machine that costs $50,000 and has...
Compute the depreciation schedule using Sum-of-years'-digits
method for a copy machine that costs $50,000 and has SV of zero at
the end of a 10-year depreciable life.
SHOW DETAIL in the Dropbox for this
problem
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- What 2 things happen to the melting point of a solid when an impurity is present?
- How Can Hominin Evolution be characterized as " mosaic evolution" Use examples of species from the...
- Absorption and Variable Costing Income Statements for Two Months and Analysis During the first month of...
- Mobile and wireless devices are being increasingly used in the Business Administration and Management Industry. write...
- What are the options that might be considered in relation to introducing flexible work practices? What...
- Question 2 : Aggregate Scores: Write a program that opens 2 files, quiz.txt, and hw.txt. The...
- Define the term symbiosis specifically as it applies in a biological context. Compare and contrast parasitism,...
ADVERTISEMENT