Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 9, Problem 4R
To test your formulas, assume the machine purchased had an estimated useful life of three years (20,000, 30,000, and 50,000 hours, respectively). Enter the new information in the Data Section of the worksheet. Does your
There are three common errors made by students completing this worksheet. Letʼs clear up two of them. One, an asset that has a three-year life should have no depreciation claimed in Year 4. This can be corrected using an =IF statement in Year 4. For example, the correct formula in cell C32 is =IF(B32>D9,0,(D7–D8)/D9) or =IF(B32>D9, 0, SLN(D7, D8, D9)). You may wish to edit what you have already entered rather than retype it.
Two, as mentioned in requirement 2, the double-declining-balance calculation needs to be modified in the last year of the assetʼs life. Assuming you have already modified the formula for Year 4 (per instructions in step 2), alter the formula for Year 3 also.
If you corrected any formulas, test their correctness by trying different estimated useful lives (between 3 and 8) in cell E9. Then reset the Data Section to the original values, save the revised file as DEPREC2, and reprint the worksheet to show the correct formulas.
The third common error doesnʼt need to be corrected in this problem. The general form of the double-declining-balance formula needs to be modified to check the net book value of the asset each year to make sure it does not go below salvage value. =DDB does this automatically, but if you are writing your own formulas, this gets very complicated and is beyond the scope of the problem.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Answer the following questions related to depreciation expense calculation. Be sure
to read each question carefully.
NOTE: (Round Each Answer to the Nearest dollar, Do NOT use any Commas, Dollar
Signs or Periods. - Example 6000).
1. A machine with a useful life of 12 years and residual value of $10,000 was
purchased for $120,000 on January 1. What is the annual depreciation expense
using the straight line method?
2. A truck with a useful life of 7 years and a residual value of $0 was purchased for
$49,000 on January 1. What is depreciation expense in year 5 under the straight
line method?
3. A machine with a useful life of 5 years and residual value of $2,000 was
purchased for $30,000 on January 1. What is the depreciation expense in year 2
using the double declining balance method?
4. A Semi-Truck with a useful life of 7 years and residual value of $50,000 was
purchased for $225,000 on January 1. What is the depreciation expense for year
2 using the double declining balance? (NOTE:…
Warren Enterprises purchased a van for $21,510. The van has a salvage value of $3,800, and an estimated useful life of eight years. Warren plans to use the straight line method of depreciation. The accumulated depreciation at the end of year 3 would be $___
Note:-
Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism.
Answer completely.
You will get up vote for sure.
An automated assembly robot that cost $400,000 has a depreciable life of five years with a $100,000 salvage value. If the MACRS depreciation rates for years 1, 2, and 3 are 20.00, 32.00, and 19.20%, respectively, what is the book valueof the robot at the end of year three?
Chapter 9 Solutions
Excel Applications for Accounting Principles
Ch. 9 - Dunedin Drilling Company recently acquired a new...Ch. 9 - Open the file DEPREC from the website for this...Ch. 9 - In the space below, prepare the journal entry to...Ch. 9 - To test your formulas, assume the machine...Ch. 9 - A truck was recently purchased for 75,000 with a...Ch. 9 - Dunedin Drilling Company recently acquired a new...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Your company is considering the purchase of a secondhand scanning microscope at a cost of $10,500, with an estimated salvage value of $500 and a projected useful life of 4 years. Determine the straight-line (SL), and double declining balance (DDB) depreciation schedules.arrow_forwardYou have just bought a new pusher dozer for your equipment fleet. Its cost is $100,000. It has salvage value of $12,000 at the end of its service life. a) Calculate the depreciation using the straight-line method. Show the table with the book value and the depreciation for each year. b) Calculate the depreciation using the DDB method. Show the table with the book value and the depreciation for each year. c) The new pusher dozers $35,000/year for your company during its service life. Determine the tax amount owed at the end of each year if your marginal tax rate is 25% for the income made using this new equipment. Perform this tax calculation separately, once using straight-line depreciation and then using DDB depreciation. d) Based on your calculations for part (c), which depreciation method would you use to file the taxes.arrow_forwardYou purchased a molding machine at a cost of $88,000. It has an estimateduseful life of 12 years with a salvage value of $8,000. Determine the following·:(a) The amount of annual depreciation computed by the straight-line method.(b) The amount of depreciation for the third year computed by using the doubledeclining-balance method.arrow_forward
- Consider the following accounting information for a computer system:Cost basis of the asset (I) = $10,000;Useful life (N) = 5 years;Estimated salvage value (S) = $2,000. Compute the annual depreciation allowances and the resulting book values using the double-declining-balance depreciation method.arrow_forwardHansen Supermarkets purchased a radio frequency identification (RFID) system for one of its stores at a cost of $150,000. Hansen determined that the system had an expected life of seven years (or 50,000,000 items scanned) and an expected residual value of $6,600. Required: 1. Determine the amount of depreciation expense for the first and second years of the system's life using the: a. Straight-line method. Round your answer to the nearest whole dollar, and use the rounded amount for subsequent calculations. Depreciation expense: $ per year b. Double-declining-balance method: (Round your answers to the nearest whole dollar and do not round intermediate calculations.) Depreciation Expense Year 1 Year 2 2. If the number of items scanned the first and second years were 7,200,000 and 8,150,000, respectively, compute the amount of depreciation expense for the first and second years of the system's life using the units-of-production depreciation method. Round your answers to the nearest whole…arrow_forwardA new barcode reading device has an installed cost basis of $24,750 and an estimated service life of seven years. It will have a zero salvage value at that time. The 200% declining balance method is used to depreciate this asset. Solve, a. What will the depreciation charge be in year seven? b. What is the book value at the end of year six? c. What is the gain (or loss) on the disposal of the device if it is sold for $800 after six years?arrow_forward
- Assume that Brown's Salvage Company paid $30,000 for equipment with a 10-year life and zero expected residual value. After using the equipment for four years, the company determines that the asset will remain useful for only three more years. Read the requirements. Requirement 1. Record depreciation expense on the equipment for year 5 by the straight-line method. First, select the formula to calculate the company's revised depreciation expense on the equipment for year 5. Then enter the amounts and calculate the depreciation for year 5. (Enter "0" for items with a zero value.) Date Record the depreciation on the equipment for year 5. (Record debits first, then credits. Select the explanation on the last line of the journal entry table.) Accounts and Explanation Requirement 2. What is accumulated depreciation at the end of year 5? The accumulated depreciation at the end of year 5 is $ = Debit Revised depreciation Creditarrow_forwardA laboratory centrifuge costs $79,000 and has a $5530 salvage value with an 8-year recovery period. Use the double declining balance method with switch over to straight line to tabulate the depreciation schedule at the end of each year. Please use excel if not then that is finearrow_forwardA machine with a cost of $750,000 has an estimated salvage value of $100,000) and an estimated useful life of 5 years or 30,000 hours. It is to be depreciated using the units-of-activity method of depreciation. The machine was used for 7,000 hours in the first year and 9,000 hours in the second year. Calculate the depreciation expense for the second year using the units of activity method. (Please round answer to the nearest dollar, i.e. 3,078.666 would be entered as 3,079)arrow_forward
- I have the answer and question below but I just needf to know how to work it out Solve the problem. Round unit depreciation to nearest cent when making the schedule, and round final results to the nearest cent. A construction company purchased a piece of equipment for $1,710. The expected life is 7,000 hours, after which it will have a salvage value of $280. Find the amount of depreciation for the first year if the piece of equipment was used for 1,600 hours. Use the units-of-production method of depreciation. Answer: ($320)arrow_forwardA company that manufactures pulse Doppler insertion flow meters uses the straight line method for book depreciation purposes. Newly acquired equipment has a first cost of $170,000 with a 3-year life and $20,000 salvage value. Determine the depreciation charge and book value for year two.arrow_forwardA new barcode reading device has an installed cost basis of $20,670and an estimated service life of seven years. It will have a zero salvage value at that time. The 200% declining balance method is used to depreciate this asset. a. What will the depreciation charge be in year seven? b. What is the book value at the end of year six? c. What is the gain (or loss) on the disposal of the device if it is sold for $1,000 after six years? a. The depreciation charge in year seven will be ... nothing. b. The book value at the end of year six is ... nothing. c. The ... loss gain on the disposal of the device if it is sold for $1,000 after six years is .. nothing.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Accounting Changes and Error Analysis: Intermediate Accounting Chapter 22; Author: Finally Learn;https://www.youtube.com/watch?v=c2uQdN53MV4;License: Standard Youtube License