1d. An asset is purchased for $90,000. It is expected to have a useful life of six years and a salvage value of $18,000 at the end of its useful life. Find the depreciation amount in the second year using either 150% or 200% DB (but you must state your choice) with switchover to SL. (Document work thoroughly everywhere, but esp. here - do not take any shortcuts.)

1d. An asset is purchased for $90,000. It is expected to have a useful life of six years and a salvage value of $18,000 at the end of its useful life. Find the depreciation amount in the second year using either 150% or 200% DB (but you must state your choice) with switchover to SL. (Document work thoroughly everywhere, but esp. here - do not take any shortcuts.)

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter9: Depreciation (deprec)

Section: Chapter Questions

Problem 5R: A truck was recently purchased for 75,000 with a salvage value of 5,000 and an estimated useful life...

See similar textbooks

Similar questions

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.
in the following table (The annual usage for Asset III is 15,000 miles). (You can copy and paste the following table) Asset Depreciation Method End of Year Initial Cost (I) ($) Salvage Value (S) ($( Book Value ($) Depreciable Life (years or mi) Depreciable Amount ($) Accumulated Depreciation 1 SL 6 $30k $6k $12k 8 years ? ? || DDB 3 $25k $5k $5.4k 5 years ? $19,600 ||| UP 3 $41k $5k ? 90,000 miles 2. IV MACRS 4 $20k $2k $3,456 ? ? ?
Description You are to create a year-by-year depreciation schedule for an asset that has a cost basis (B) of $950,000 and estimated salvage value (SV 10) of $80,000 after 10 years. For the straight-line and declining balance methods, use a depreciable life (N) of 10 years. For MACRS, use a recovery period (N) of 7-yrs. ΕΟΥ, Κ 0 1 2 3 st 4 5 6 7 8 'a 9 10 Straight-Line BVk $950,000 Declining Balance dk BVk $950,000 dk MACRS BVk 950,000
Calculate 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.) Cost ShippingCharges SetupCharges TotalCost SalvageValue EstimatedUseful Life(years) TotalDepreciation AnnualDepreciation $800,000 0 $15,600 $ $100,000 15 $ $
Major medical complexes and their service providers continue to move toward advanced health informatics - acquiring, managing, and using information to provide better healthcare. A new analyzer for researching and evaluating patient samples, and making informed recommendations in the treatment of complex blood cancers, is purchased for $290,000. It is estimated to have a useful life of 6 years and to be sold at the end of that time for $9,500. Part a Develop a table showing the depreciation and book value for each year using both the Excel® DDB worksheet function and the Excel® SLN worksheet function such that the depreciation switches from double declining balance to straight-line at the optimum time. Year Depreciation Book Value 1 $ $ $ $ $ 4 $ $ $ $ Carry all interim calculations to 5 decimal places and then round your final answers to 2 decimal places. The tolerance is +2.00. %24 %24 %24 %24 %24 %24 %24 %24 2. 3. 6.
Consider the following data on an asset:Cost of the asset, I $38.000Useful life. N 6 yearsSalvage value. S $0Compute the annual depreciation allowances and the resulting book values by using the DOB method and then switching to the SL method.
I am using MACRS for depreciation. Purchase date: September 1st Cost: $650,000 Salvage: $30,000 Life: 7 years What percent do I use to calculate depreciation for years 1-8?
PLEASE NOTE: All whole dollar amounts using "$" with commas as needed (i.e. $12,345). [HINT - You definitely will want to use this EXCEL spreadsheet Chapter11 Depreciation Schedules.xlsx Download Chapter11 Depreciation Schedules.xlsxto assist in your calculations.] Straight-Line Depreciation Method: Office Mart purchases a photocopier for $70,000. The photocopier has a salvage value of $7,000 and has expected life of seven years. Office Mart uses the straight-line depreciation method. Calculate the annual depreciation expense. What is the year one book value? What is the year three book value? What is the year six accumulated depreciation? Units-of-Production Depreciation Method: Office Mart purchases a photocopier for $70,000. The photocopier has a salvage value of $7,000 and is expected to produce 787,500 copies over its life. Office Mart uses the units-of-production depreciation method and the expected copies per year for the eight years are: 115,000 copies. 119,250 copies.…
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.
On 1/1/2020 you have purchased an asset with for $50,000. You estimate the useful life to be 5 years and the salvage value to be $10,000. A) Using straight line depreciation, fill in the estimated depreciation schedule below. B) Now using accelerated depreciation (1.5X declining balance), fill in the estimated depreciation schedule below. C) On 12/31/2020 which method will report more net income, and by how much? Assume the tax rate is 40%. D) Assume that on 1/1/2021, you choose to sell the asset. You receive 40,000 in cash. Report the gain or loss under each depreciation method. (Circle one and Fill in the blank) Straight Line Depreciation: GAIN or LOSS Amount: 1.5X Accelerated Depreciation: GAIN or LOSS Amount:
At December 31, 2025, Blue Corporation reported the following plant assets. Land Buildings Less: Accumulated depreciation-buildings Equipment Less: Accumulated depreciation-equipment Total plant assets $26,520,000 11,934,000 60,640,000 7,580,000 During 2026, the following selected cash transactions occurred. 1 $4,548,000 14,586,000 53,060,000 $72,194,000 Apr. 1 Purchased land for $3,335,200. May Sold equipment that cost $909,600 when purchased on January 1, 2019. The equipment was sold for $257,720. June 1 Sold land for $2,425,600. The land cost $1,516,000. July 1 Purchased equipment for $1,667,600. Dec. 31 Retired equipment that cost $1,061,200 when purchased on December 31, 2016. No salvage value was received.
Book value Find the book value for the asset shown in the accompanying table, assuming that MACRS depreciation is being used E Recovery period (years) Elapsed time since purchase (years) Asset Installed cost A $987,000 2 The remaining book value is $ . (Round to the nearest dollar.) Data Table (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Rounded Depreciation Percentages by Recovery Year Using MACRS for First Four Property Classes Percentage by recovery year* 5 years Recovery year 3 years 7 years 10 years 1 33% 20% 14% 10% 45% 32% 25% 18% 15% 19% 18% 14% 7% 12% 12% 12% 12% 9% 9% 5% 9% 8% 9% 7% 4% 6% 6% 10 6% 11 4% Totals 100% 100% 100% 100% *These percentages have been rounded to the nearest whole percent to simplify calculations while retaining realism. To calculate the actual depreciation for tax purposes, be sure to apply the actual unrounded percentages or directly apply double-declining balance (200%)…