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 2 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,...
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
- P5.1 Your portfolio had the values in the following table for the four-year period listed. Calculate...
- 1. Mortimer Life Insurance Company wants several lists of salesperson data. Design a flowchart and pseudocode...
- MUST USE LOOPS. Write a perl program that replicates the actions of a pez dispenser. The...
- If n = 10 Mean X = 13 One value 20 was deleted Find the new...
- Garlington Technologies Inc.'s 2016 financial statements are shown below: Balance Sheet as of December 31, 2016...
- CSCI4520Programing Project for algorithm analysis: Sorting, searching, and efficiency analysis Project introduction In the project, you...
- c++ Create a program where you can add binary while they're still in binary form and...
ADVERTISEMENT