AutoSaveOffACG2001 Module 10 Excel Quiz (1)Protected Viewp SearchSebastian BeltranSBFileHomeInsertPage LayoutFormulasDataReviewViewHelp2 ShareCommentsPROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View.Enable EditingH9fxAВCDEFGHKMP1820X71920X82021b) Double-decliningDepreciationAccumulatedBook Value After Year's22YearComputationExpenseDepreciationDepreciation2320X42420X52520X62620X72720X828c) Units-of-activity (Assume the truck was driven 10,000 miles, 50,000 miles, 20,000 miles, 20,000 miles, and2930,000 miles in 20X4-20X8, respectively.)DepreciationAccumulatedBook Value After Year's30YearComputationExpenseDepreciationDepreciation3120X43220X53320X63420X73520X83637Sheet1囲100%> AutoSaveOffACG2001 Module 10 Excel Quiz (1)Protected Viewp SearchSebastian BeltranSBFileHomeInsertPage LayoutFormulasDataReviewViewHelp2 ShareCommentsPROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View.Enable EditingH9fxAВCDEFGHKLMPOn January 1, 20X4, XYZ Company purchased a truck for $120,000. The truck is expected to have an estimated usefullife of 5 years or 125,000 miles, and the company estimates that it will be able to dispose of the truck at the end of itsuseful life for $20,000.91011Complete the tables below using the specified depreciation method.1213a) Straight-lineDepreciationAccumulatedBook Value After Year's14YearComputationExpenseDepreciationDepreciation1520X41620X51720X61820X71920X82021b) Double-decliningDepreciationAccumulatedBook Value After Year's22YearComputationExpenseDepreciationDepreciation2320X42420X52520X62620X72720X8Sheet1囲100%>

Name: AutoSaveOffACG2001 Module 10 Excel Quiz (1)Protected Viewp SearchSeba
Uploaded: 2024-03-05T11:50:36.000Z
Channel: Bartleby
Description: AutoSaveOffACG2001 Module 10 Excel Quiz (1)Protected Viewp SearchSebastian BeltranSBFileHomeInsertPage LayoutFormulasDataReviewViewHelp2 ShareCommentsPROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it'

Depreciable cost=Purchase price-Salvage value=$120,000-$20,000=$100,000

Business

Accounting

On January 1, 20X4, XYZ Company purchased a truck for $120,000. The truck is expected to have an estimated useful life of 5 years or 125,000 miles, and the company estimates that it will be able to dispose of the truck at the end of its useful life for $20,000. Complete the tables below using the specified depreciation method. a) Straight-line Depreciation Accumulated Book Value After Year's Year Computation Expense Depreciation Depreciation 20X4 20X5 20X6 20X7 20X8 b) Double-declining Depreciation Accumulated Book Value After Year's Year Computation Expense Depreciation Depreciation 20X4 20X5 20X6 20X7 20X8