Determine ownership depreciation cost per hour for a D9N Caterpillar dozer withthe following assumptions:• Engine - 370 hp• Overall cost of Money - 6% (i)• Useful life-5 years (n)•Hours used per year - 2200Initial Cost - $400,000 (P)Cost of tires - $42,000 (for this formula you need to subtract the cost of thetires from the initial cost)• Estimated Salvage Value - $40,000 (F) or [(S) for AAI formula]●●NOTE: Use the average of the Time Value Method and the Average AnnualInvestment (AAI) Method to determine the answer.STEP 1-Time Value MethodFormulas:(USCRF) A₂ = P(USSFF)ANSWER:Ownership Depreciation =AAI:Af= F ((1+0³-1]STEP 2 - Average Annual Investment MethodCost of Money =i (1+i)n(1+i)n-1Ownership Depreciation = Straight-Line Depreciation + Cost of MoneyCost of Money is a function of the Average Annual Investment (AAI).AverageAAI =Time Value MethodAAI Method• Straight-Line Depreciation:AAI = $AAI x (i)2200• Ownership DepreciationAp-Af2200 hr/yrP(n+1)+S(n-1)2n= $.$/HR/YRInitial Cost - Cost of Tires - Salvage Value = $SL Depreciation per Year = $/YR/HRSL Depreciation per Hour = $/HRSTEP 3 - Calculate the Average of the Two MethodsCost/HR $Cost/HR = $Cost/HR $= Cost of Money + SL Depreciation= $_/HR$/HR/HR/HR__/HR

Let's say you bought a car today, after 10 years the value of the car will slowly decrease and…

Determine ownership depreciation cost per hour for a D9N Caterpillar dozer with the following assumptions: • Engine - 370 hp • Overall cost of Money -6% (i) • Useful life-5 years (n) • Hours used per year - 2200 • Initial Cost - $400,000 (P) • Cost of tires - $42,000 (for this formula you need to subtract the cost of the tires from the initial cost) Estimated Salvage Value - $40,000 (F) or [(S) for AAI formula] NOTE: Use the average of the Time Value Method and the Average Annual

Determine ownership depreciation cost per hour for a D9N Caterpillar dozer with the following assumptions: • Engine - 370 hp • Overall cost of Money -6% (i) • Useful life-5 years (n) • Hours used per year - 2200 • Initial Cost - $400,000 (P) • Cost of tires - $42,000 (for this formula you need to subtract the cost of the tires from the initial cost) Estimated Salvage Value - $40,000 (F) or [(S) for AAI formula] NOTE: Use the average of the Time Value Method and the Average Annual

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter9: Depreciation (deprec)

Section: Chapter Questions

Problem 1R: Dunedin Drilling Company recently acquired a new machine at a cost of 350,000. The machine has an...

See similar textbooks

Similar questions

Montello Inc. purchases a delivery truck for $15,000. The truck has a salvage value of $3,000 and is expected to be driven for 120,000 miles. Montello uses the units-of-production depreciation method and in year one it expects to use the truck for 23,000 miles. Calculate the annual depreciation expense.
Montello Inc. purchases a delivery truck for $25,000. The truck has a salvage value of $6,000 and is expected to be driven for 125,000 miles. Montello uses the units-of-production depreciation method, and in year one the company expects the truck to be driven for 26,000 miles; in year two, 30,000 miles; and in year three, 40,000 miles. Consider how the purchase of the truck will impact Montellos depreciation expense each year and what the trucks book value will be each year after depreciation expense is recorded.
Dunedin 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.
Use the information in Problem A-1 to solve this problem. Assume the delivery van is expected to have a useful life of 100,000 miles (Year 1, 40,000 miles; Year 2, 30,000 miles; Year 3, 20,000 miles; Year 4, 10,000 miles). Required Prepare a schedule of depreciation using the units-of-production method. Check Figure Year 3 depreciation, 3,200 PROBLEM A-1 A delivery van was bought for 18,000. The estimated life of the van is four years. The trade-in value at the end of four years is estimated to be 2,000.
Utica Machinery Company purchases an asset for 1,200,000. After the machine has been used for 25,000 hours, the company expects to sell the asset for 150,000. What is the depreciation rate per hour based on activity?
Montezuma Inc. purchases a delivery truck for $20,000. The truck has a salvage value of $8,000 and is expected to be driven for ten years. Montezuma uses the straight-line depreciation method. Calculate the annual depreciation expense. After five years of recording depreciation, Montezuma determines that the delivery truck will be useful for another five years (ten years in total, as originally expected) and that the salvage value will increase to $10,000. Determine the depreciation expense for the final five years of the assets life, and create the journal entry for years 6â€“10 (the entry will be the same for each of the five years).
Loban Company purchased four cars for 9,000 each and expects that they will be sold in 3 years for 1,500 each. The company uses group depreciation on a straight-line basis. Required: 1. Prepare journal entries to record the acquisition and the first years depreciation expense. 2. If one of the cars is sold at the beginning of the second year for 7,000, what journal entry is required?
Montello Inc. purchases a delivery truck for $25,000. The truck has a salvage value of $6,000 and is expected to be driven for ten years. Montello uses the straight-line depreciation method. Calculate the annual depreciation expense.
Referring to PA7 where Kenzie Company purchased a 3-D printer for $450,000, consider how the purchase of the printer impacts not only depreciation expense each year but also the assets book value. What amount will be recorded as depreciation expense each year, and what will the book value be at the end of each year after depreciation is recorded?
Colquhoun International purchases a warehouse for $300,000. The best estimate of the salvage value at the time of purchase was $15,000, and it is expected to be used for twenty-five years. Colquhoun uses the straight-line depreciation method for all warehouse buildings. After four years of recording depreciation, Colquhoun determines that the warehouse will be useful for only another fifteen years. Calculate annual depreciation expense for the first four years. Determine the depreciation expense for the final fifteen years of the assets life, and create the journal entry for year five.
Hathaway Company purchased a copying machine for 8,700 on October 1, 2019. The machines residual value was 500 and its expected service life was 5 years. Hathaway computes depreciation expense to the nearest whole month. Required: 1. Compute depredation expense (rounded to the nearest dollar) for 2019 and 2020 using the: a. straight-line method b. sum-of-the-years-digits method c. double-declining-balance method 2. Next Level Which method produces the highest book value at the end of 2020? 3. Next Level Which method produces the highest charge to income in 2020? 4. Next Level Over the life of the asset, which method produces the greatest amount of depreciation expense?
IMPACT OF IMPROVEMENTS AND REPLACEMENTS ON THE CALCULATION OF DEPRECIATION On January 1, 20-1, Dans Demolition purchased two jackhammers for 2,500 each with a salvage value of 100 each and estimated useful lives of four years. On January 1, 20-2, a stronger blade to improve performance was installed in Jackhammer A for 800 cash and the compressor was replaced in Jackhammer B for 200 cash. The compressor is expected to extend the life of Jackhammer B one year beyond the original estimate. REQUIRED 1. Using the straight-line method, prepare general journal entries for depreciation on December 31, 20-1, for Jackhammers A and B. 2. Enter the transactions for January 20-2 in a general journal. 3. Assuming no other additions, improvements, or replacements, calculate the depreciation expense for each jackhammer for 20-2 through 20-4.