Sullivan Ranch Corporation has purchased a new tractor. The following information is given:$150,000$10,000Cost:Estimated Residual:Estimated Life in years:Estimated Life in hours:Actual Hours:Year 1Year 2Year 3Year 441200Required:1. Prepare the following Straight-Line depreciation schedule by using the Excel SLN function to calculate DepreciationExpense and entering formulas for the remaining cells. Use absolute cell references when appropriate.(Use cells A4 to B12 from the given information to complete this question.)Year1236027035022034TotalDepreciation Schedule-Straight-Line MethodEnd of year amountsDepreciatio Depreciation ExpensenSULLIVAN RANCH CORPORATIONBook Value 2. Prepare the following Activity Based depreciation schedule by entering formulas. Use absolute cell references when appropriate.(Use cells A4 to B12 from the given information to complete this question.)SULLIVAN RANCH CORPORATIONDepreciation Schedule-Activity Based MethodEnd of year amountsDepreciatio Depreciation ExpensenYear1234Total3. Prepare the following Double-Declining-Balance depreciation schedule by using the Excel DDB function to calculateDepreciation Expense and entering formulas for the remaining cells. Use absolute cell references when appropriate.(Use cells A4 to B12 from the given information to complete this question.)Year1SULLIVAN RANCH CORPORATIONDepreciation Schedule-Double-Declining-Balance MethodEnd of year amounts234TotalBook ValueDepreciatio Depreciation ExpenseBook Value

Name: Sullivan Ranch Corporation has purchased a new tractor. The following
Uploaded: 2024-03-05T11:50:36.000Z
Channel: Bartleby
Description: Sullivan Ranch Corporation has purchased a new tractor. The following information is given:$150,000$10,000Cost:Estimated Residual:Estimated Life in years:Estimated Life in hours:Actual Hours:Year 1Year 2Year 3Year 441200Required:1. Prepare the follo

Depreciation is recorded as an expense for wear and tear of a depreciable tangible asset for eg…

Business

Accounting

Sullivan Ranch Corporation has purchased a new tractor. The following information is given: $150,000 $10,000 Cost: Estimated Residual: Estimated Life in years: Estimated Life in hours: Actual Hours: Year 1 Year 2 Year 3 Year 4 4 1200 360 270 350 220 Required: 1. Prepare the following Straight-Line depreciation schedule by using the Excel SLN function to calculate Depreciation. Expense and entering formulas for the remaining cells. Use absolute cell references when appropriate. (Use cells A4 to B12 from the given information to complete this question.) Year 1 2 3 4 Total SULLIVAN RANCH CORPORATION Depreciation Schedule-Straight-Line Method End of year amounts Depreciatio Depreciatio n Expense n Book Value

Sullivan Ranch Corporation has purchased a new tractor. The following information is given: $150,000 $10,000 Cost: Estimated Residual: Estimated Life in years: Estimated Life in hours: Actual Hours: Year 1 Year 2 Year 3 Year 4 4 1200 360 270 350 220 Required: 1. Prepare the following Straight-Line depreciation schedule by using the Excel SLN function to calculate Depreciation. Expense and entering formulas for the remaining cells. Use absolute cell references when appropriate. (Use cells A4 to B12 from the given information to complete this question.) Year 1 2 3 4 Total SULLIVAN RANCH CORPORATION Depreciation Schedule-Straight-Line Method End of year amounts Depreciatio Depreciatio n Expense n Book Value

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

A player computer has a cost of $3,850 with a residual of $800 and an estimated useful life of 5 years.Calculate the annual depreciation using the straight-line depreciation method.Make journal entries.
A draw bench for precision forming and strengthening of carbon steel tubing has a cost of $1,110,000. It will have a salvage value of $76,000 after a useful life of 10 years. Part a Using the formulas, determine the depreciation charge for year 8 and the book value at the end of year 8 if straight-line depreciation is used. Depreciation charge: Book value: $ $
sd
The pertinent information about a piece of construction equipment follows: cost $180,000 Estimated Useful Life 200,000 Miles Residual (salvage) value $20,000 Placed in service 1/2/2015 Year 1 output = 37,000 miles Year 2 output= 51000 miles Compute the first two years depreciation using the units of output method.
N1. Account A piece of equipment is purchased for $40,000 and has an estimated salvage value of $1,000 at the end of the recovery period. Prepare a depreciation schedule for the piece of equipment using the straight-line method, the sum-of-the-years method, and the 200% declining-balance method with a recovery period of five years. Compare these depreciation methods in a graph.
You are an accountant for ABC Corp. Your purchasing department has procured products invoiced for $25,000 with 2/10 Net 30 terms. If you pay the invoice within 15 days, your payment would be: $25,500. $20,000. $24,500. $25,000. Accounting depreciation systematically allocates the cost of an asset in time over its useful life while economic depreciation deals with: The estimated loss of value of an asset minus the revenue it produces. The estimated salvage value of an asset at its end-of-life. The change of an asset’s value based on fair market price. The value of an asset matched to the revenue it creates indirectly.
A truck acquired at a cost of $202,800 has an estimated residual value of $18,000, has an estimated useful life of 440,000 miles, and was driven 113,000 miles during the year. Determine the following. If required, round your answer for the depreciation rate to 2 decimal places. a. The depreciable cost $ b. The depreciation rate $ per mile c. The units-of-activity depreciation for the year $
A truck acquired at a cost of $445,000 has an estimated residual value of $26,500, has an estimated useful life of 45,000 miles, and was driven 4,100 miles during the year. Determine the following. If required, round your answer for the depreciation rate to two decimal places. (a) The depreciable cost $fill in the blank 1 (b) The depreciation rate $fill in the blank 2 per mile (c) The units-of-activity depreciation for the year $fill in the blank 3 Determining Cost of Land On-Time Delivery Company acquired an adjacent lot to construct a new warehouse, paying $32,000 in cash and giving a short-term note for $337,000. Legal fees paid were $1,620, delinquent taxes assumed were $11,900, and fees paid to remove an old building from the land were $18,900. Materials salvaged from the demolition of the building were sold for $5,500. A contractor was paid $1,121,800 to construct a new warehouse. Determine the cost of the land to be reported on the balance sheet.$fill in the…
How do I solve 2,3 and 4
Find the book value for the asset shown in the accompanying table, assuming that MACRS depresiing is being used: View the table attached: Asset Installed Cost Recovery Period (Years) Elapsed time since purchase (Years) A $902,000 5 3
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 $76,400 $1,500 $750 $ $4,500 11 $ $
Equipment acquired at a cost of $96,000 has an estimated residual value of $6,000 and an estimated useful life of 10 years. It was placed in service on May 1 of the current fiscal year, which ends on December 31. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet a. Determine the depreciation for the current fiscal year and for the following fiscal year by the straight-line method. Round your answers to the nearest dollar. Depreciation Year 1 S Year 2 $ b. Determine the depreciation for the current fiscal year and for the following fiscal year by the double-declining-balance method. Do not round the double-declining balance rate. Round your answers to the nearest dollar. Depreciation Year 1 S Year 2 S