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 5R
A truck was recently purchased for $75,000 with a salvage value of $5,000 and an estimated useful life of eight years or 150,000 miles (24,000 miles per year for the first five years and 10,000 miles per year after that). Enter the new information in the Data Section of the worksheet. Again, make sure the totals for all three methods are in agreement. Print the worksheet. Save this new data as DEPREC5.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Solve step by step (in digital format), explain your entire procedure please, make the corresponding tables
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
A farmer buys a tractor for $505,000, it has a useful life of 7 years, it is depreciated by the method of sum of the digits of the years.
Find the annual book value and depreciation charges if the salvage value is $280,000.
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
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.
I need to solve the question in
handwriting and in clarity
please
The following are the cost of a system and the useful life is five years. The
salvage value for depreciation purpose is equal to 25% of the hardware
cost
Item
Hardware
Training
Installation
Cost
$170,000
$18,000
$18,000
a) What is the book value of the system at the end of year three if Straight line
method is used?
b) Suppose that after depreciation of the system for two years with straight
line, the company decides to switch to the decline method for the reminder of
the system life (depreciation rate 30%). What is the system Book Value at the
end of four years?
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
- 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 depreciation total 320,000 under all three methods? There are three common errors made by students completing this worksheet. Lets 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(B32D9,0,(D7D8)/D9) or =IF(B32D9, 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 assets 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 doesnt 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.arrow_forwardDunedin Drilling Company recently acquired a new machine at a cost of 350,000. The machine has an estimated useful life of four years or 100,000 hours, and a salvage value of 30,000. This machine will be used 30,000 hours during Year 1, 20,000 hours in Year 2, 40,000 hours in Year 3, and 10,000 hours in Year 4. With DEPREC5 still on the screen, click the Chart sheet tab. This chart shows the accumulated depreciation under all three depreciation methods. Identify below the depreciation method that each represents. Series 1 _____________________ Series 2 _____________________ Series 3 _____________________ When the assignment is complete, close the file without saving it again. Worksheet. The problem thus far has assumed that assets are depreciated a full year in the year acquired. Normally, depreciation begins in the month acquired. For example, an asset acquired at the beginning of April is depreciated for only nine months in the year of acquisition. Modify the DEPREC2 worksheet to include the month of acquisition as an additional item of input. To demonstrate proper handling of this factor on the depreciation schedule, modify the formulas for the first two years. Some of the formulas may not actually need to be revised. Do not modify the formulas for Years 3 through 8 and ignore the numbers shown in those years. Some will be incorrect as will be some of the totals. Preview the printout to make sure that the worksheet will print neatly on one page, and then print the worksheet. Save the completed file as DEPRECT. Hint: Insert the month in row 6 of the Data Section specifying the month by a number (e.g., April is the fourth month of the year). Redo the formulas for Years 1 and 2. For the units of production method, assume no change in the estimated hours for both years. Chart. Using the DEPREC5 file, prepare a line chart or XY chart that plots annual depreciation expense under all three depreciation methods. No Chart Data Table is needed; use the range B29 to E36 on the worksheet as a basis for preparing the chart if you prepare an XY chart. Use C29 to E36 if you prepare a line chart. Enter your name somewhere on the chart. Save the file again as DEPREC5. Print the chart.arrow_forwardConsider 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 = $0. Use the double-declining-depreciation method to compute the annual depreciation allowances and the resulting book values.arrow_forward
- You 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_forwardListen The Georgia DOT has purchased equipment for the new road construction around Kenesaw State University, costing $600,000. Estimated salvage value at the end of year 4 is $65,000. Use straight line depreciation, 125% DB, and DDB methods to calculate the depreciation in year 2. Write your formulas and identify al variables. Explain your answers and compare and contrast the concept of the various depreciation methods as it applies to your answer. SHOW ALL WORKarrow_forwardIf the total depreciation after 1 year and 2 years in an equipment are 21,255 and 35,731 respectively using DBM and the equipment has an expected life of 8 years, find the salvage value. Write your final answer in two decimal places.arrow_forward
- Given an asset which has an initial cost of $100,000, Useful life of 4 years and a salvage value of 10,000. Use the DDB method to determine the depreciation allowances and the book values for year 1 through 4. You need to see whether switching to the SL method, at any year, is a wise decision.arrow_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 dump truck was bought for P750,000 three years ago. It will have a salvage value of P100,000 two years from now. Using the following methods, determine book value at the end of 3rd year, accrued depreciation at the end of 2nd year and annual depreciation cost at the end of 4th year. Show solutions for the asked years.arrow_forward
- A pharmacy is planning to purchase a second-hand scanning microscope at a cost of BD10,500, and its estimated salvage value is BD500 and a projected useful life of four years. Determine the depreciation for 4th year using DB method and complete the depreciation schedules with depreciation values and book values.arrow_forwardA data server is purchased for Php 450,000. The salvage value in 18 years is Php 25,000. What is the total depreciation in the twelfth year using straight line method? Php 283,333.33 Php 284,333.33 Php 282,333.33 Php 285,333.33arrow_forwardCalculate the total cost, total depreciation, and annual depreciation (in $) for the following assets by using the straight-line method. (Round your answers to the nearest cent.) Estimated Shipping Charges Setup Charges Total Salvage Value Total Annual Useful Life (years) Cost Cost Depreciation Depreciation $88,700 $625 $2,500 $7,000arrow_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
Depreciation -MACRS; Author: Ronald Moy, Ph.D., CFA, CFP;https://www.youtube.com/watch?v=jsf7NCnkAmk;License: Standard Youtube License