I cant seem to figure out the formulas for these answers. Formula: Subtract, Divide; Cell ReferencingUsing Excel to Compute Revised DepreciationStudent Work AreaPROBLEMRequired: Provide input into cells shaded in yellow in thistemplate. Use mathematical formulas with cell references to theOn January 1, 2022, the Hermann Company general ledger showsthe following information concerning its equipment.Problem and work areas as indicated.EquipmentAccumulated Depreciation$ 36,00013,600Book value at date of changeThe depreciation resulted from using the straight-line method withthe following additional information.Depreciable costRevised annual depreciation10 years$ 2,000Useful lifeSalvage valueOn January 1, 2022, the company concludes that the remaininguseful life changes to the following with the same salvage value.Remaining useful life2 yearsCompute the revised annual depreciation.

Book Value at date of change = Equipment value - Accumulated depreciation Book Value at date of…

Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem and work areas as indicated. Book value at date of change Depreciable cost Revised annual depreciation

Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem and work areas as indicated. Book value at date of change Depreciable cost Revised annual depreciation

Century 21 Accounting General Journal

11th Edition

ISBN:9781337680059

Author:Gilbertson

Publisher:Gilbertson

Chapter19: Accounting For Plant Assets, Depreciation, And Intangible Assets

Section19.5: Declining-balance Method Of Depreciation

Problem 1WT

See similar textbooks

Related questions

Q: Required information Use the following information for the Exercises below. [The following…

A: Depreciation is the loss in the value of the asset caused due to its usage, wear, and tear. There…

Q: Required information [The following information applies to the questions displayed below.] Ramirez…

A: Depreciation: Depreciation means the reduction in the value of an asset over the life of the assets…

Q: Airport Parking incurred the following costs to acquire land, make land improvements, and construct…

A: As per IAS 16 Property Plant and Equipment , Capitalization of costs incurred to Land , Land…

Q: Indicate which of the following costs should be expensed when incurred. a. $13,000 paid to…

Q: State whether each of the below is Capital Expenditure or Revenue Expenditure. Purchase of new…

A: Capital expenditure: It is the amount of funds invested in the business to get long-term benefits to…

Q: The initial cost of a paint sand mill, including its installation is P 800,000. The depreciable…

A: Formula: Straight line method deprecation = ( Asset cost - Salvage value ) / Useful life

Q: Use full-year depreciation for the adjusting entries

A: Journal refers to the process of recording all the monetary transactions which shows all the credit…

Q: Complete a depreciation schedule to enter fixed-asset data in an Excel table, calculate depreciation…

A: Straight line method ( SLM ) of depreciation is a method of depreciation under which there is equal…

Q: Consider the following accounting information for a computer system:Cost basis of the asset (I) =…

A: Working note:

Q: Compute depreciation under units-of-activity method. structions a. Compute the depreciable cost per…

A: Depreciation means fall in the value of tangible fixed assets because of its usage or with efflux of…

Q: Required information Use the following information for the Exercises below. (Algo) Skip to…

A: Depreciation Expense - Depreciation is charged on the assets for the purpose of use, wear and tear,…

Q: Create a single line depreciation schedule using the following information:

A: Depreciation: Depreciation refers to the reduction in the monetary value of a fixed asset due to…

Q: A copy machine acquired on May 1 with a cost of $2,545 has an estimated useful life of 3 years.…

A: Depreciation: Depreciation means the reduction in the value of an asset over the life of the assets…

Q: 1. State whether each of the below is Capital Expenditure or Revenue Expenditure. a. Purchase of new…

A: Capital expenditure: It is the amount of funds invested in the business to get long-term benefits to…

Q: ) Prepare appropriate journal entries for each relevant event. nearest dollar). Show your working. )…

Q: Discuss the potential for abuse and fraud in this system. Describe the controls that should be…

A: Procurement and safeguarding of Assets are very important factor or process of an organisation.…

Q: Certain activities are listed below. Indicate which of the activities would be considered in…

A: Research and Development (R&D) refers to the department in an organization which all the…

Q: Develop a table showing the depreciation and book value for each year using both the Excel® DDB…

A: Depreciation is the diminishing in value of the asset over the period of time due to usage in…

Q: Required Information Use the following information for the Exercises below. [The following…

A: Lets understand the basics. Depreciation is reduction in value of asset due to wear and tear,…

Q: A 2,400 square foot building has an remaining economic life of 55 years. Its current effective age…

A: Depreciation is the amount of expense that is incurred when the value of assets is decreasing with…

Q: Required information [The following information applies to the questions displayed below) Exact…

A: Depreciation expenses are considered as a reduction in the value of assets. It is a noncash expense…

Q: A draw bench for precision forming and strengthening of carbon steel tubing has a cost of…

Q: A cooling water pumping station at a manufacturing plant in iligan city cost 30,000,000 to contruct…

A: Depreciation Amount each year =30,000,000-3,000,000 ÷ 25=$1,080,000

Q: Required information (The following information applies to the questions displayed below) Exact…

A: SOLUTION- UNIT OF PRODUCTION METHOD- FORMULA- DEPRECIATION RATE = COST OF ASSET - SALVAGE VALUE /…

Q: se the following information for the Exercises below. (Algo) Skip to question [The following…

A: Introduction: A tangible item's cost can be spread out over the period of its useful life using the…

Q: Depreciation of an asset based on the number of hours of usage is a(n): a. Time-based method b.…

A: Depreciation is a non cash expenses which is charged for reduction in value of asset over the useful…

Q: Calculate the total cost, total depreciation, and annual depreciation (in $) for the following…

A: Straight-line method is one of a common and simple method used to calculate depreciation on fixed…

Q: Which of the following is considered capital expenditure Select one: a. Research expenses. b.…

A: Capital expenditure means those expenditure which are to be capitalized in books of accounts i.e.…

Q: Required Information Use the following information for the Exercises below. [The following…

A: Solution:- Straight line method is one of the depreciation method. It is simplest method compared to…

Q: Capital Expenditures and Revenue Expenditures Quality Move Company made the following expenditures…

A: Journal Entry: Journal entry is the act of keeping records of transactions in an accounting journal.…

Q: Prepare a schedule of depreciation expense, accumulated depreciation, and book value per year for…

A: The depreciation expense is the reduction in the value of fixed assets with the passage of time.

Q: . Give all journal entries related to the disposal of each machine in the current year. . Machine A.…

A: A journal entry is used to record the day-to-day transaction of an organization by debiting and…

Q: Requlred Information Use the following information for the Exercises below. [The following…

A: The deprecation expense is charged on fixed assets as reduction in the value of fixed assets with…

Q: Show Me How Revision of Depreciation A building with a cost of $1,200,000 has an estimated residual…

A: Introduction:- Straight line depreciation is one of the simplest method of depreciation. As per this…

Q: Depreciation of an asset based on the number of hours of usage is a(n) O accelerated method…

A: If an asset is depreciated on the basis of the number of hours used, it will be said that the…

Q: A draw bench for precision forming and strengthening of carbon steel tubing has a cost of $950,000.…

A: Solution Depreciation represents how much assets value has been reduced. It is applicable on…

Q: A draw bench for precision forming and strengthening of carbon steel tubing has a cost of $950,000.…

A: Depreciation under straight line method : under this method depreciation is equally charged on over…

Q: The cost of a purchased building includes: Select one: a. Demolishing old building costs. O b.…

A: As posted multiple questions we are answering only one question at a time. Kindly repost the…

Q: Consider the following accounting information for a computer system: Cost basis of the asset, I =…

A: Depreciation is the allocation of cost of asset over the period of asset's life. There are various…

Q: Consider the following accounting information for a computer system: Cost basis of the asset, I=…

A: Double Declining Depreciation Method - Under the Double Declining Depreciation method, the…

Q: depreciation rate per mile

A: Cost of delivery truck = $20000 Salvage value = $2000 Estimated useful life = 200000 miles

Q: Required information Use the following information for the Exercises below. [The following…

A: Under units of production method, depreciation expense per unit is calculated by dividing…

Q: MANAGERIAL ACCOUNTING (You may use excel. RATE will be given. No long explanation needed) Show in…

A: Depreciation is calculated on the cost of the asset. It is an expense charged in the profit and loss…

Q: 1. State whether each of the below is Capital Expenditure or Revenue Expenditure. Purchase of new…

A: Capital expenditure includes all those expenditure which are require high amount of cash outflow and…

Concept explainers

Market Efficiency

Market efficiency refers to the market's ability to provide investors with all available information about investment options for buying and selling securities. Market efficiency reflects the true value of securities without undervaluing or overvaluing them. When the quality and quantity of information increase, the market becomes more efficient, allowing it to reduce arbitrage and obtain higher market returns from investment. In a well-functioning market, everyone receives all information completely and immediately at no cost. It opens up a plethora of opportunities for investors to access various investment options.

Question

I cant seem to figure out the formulas for these answers.

Formula: Subtract, Divide; Cell Referencing
Using Excel to Compute Revised Depreciation
Student Work Area
PROBLEM
Required: Provide input into cells shaded in yellow in this
template. Use mathematical formulas with cell references to the
On January 1, 2022, the Hermann Company general ledger shows
the following information concerning its equipment.
Problem and work areas as indicated.
Equipment
Accumulated Depreciation
$ 36,000
13,600
Book value at date of change
The depreciation resulted from using the straight-line method with
the following additional information.
Depreciable cost
Revised annual depreciation
10 years
$ 2,000
Useful life
Salvage value
On January 1, 2022, the company concludes that the remaining
useful life changes to the following with the same salvage value.
Remaining useful life
2 years
Compute the revised annual depreciation.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step 3

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

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

Balance Sheet and Notes Listed here in random order are Wicks Construction Limiteds balance sheet accounts and related ending balances as of December 31, 2019: Additional information: 1. The company reports on the balance sheet the total amount for inventories and the net book value of property, plant, and equipment, with the related details for each account disclosed in notes. 2. The straight line method is used to depreciate buildings, machinery, and equipment, based upon their cost and estimated residual values and lives. A breakdown of property, plant, and equipment shows the following: land at a cost of 32,000, buildings at a cost of 182,400 and a net book value of 120,200, machinery at a cost of 63,900, and related accumulated depreciation of 18,600, and equipment (40% depreciated) at a cost of 53,000. 3. Patents are amortized on a straight line basis directly to the Patent account. 4. Inventories are listed at the lower of cost or market value using an average cost. The inventories include raw-materials, 22,200; work in process, 34,700; and finished goods, 41,600. 5. Common stock has a 10 par value per share, 12,000 shares are authorized, and 6,280 shares have been issued. 6. Preferred stock has a 100 par value per share, 1,000 shares are authorized, and 400 shares have been issued. 7. The investment in bonds is carried at the original cost, which is the face value, and is being held to maturity. 8. Short-term investments in marketable securities were purchased at year-end. 9. The bonds payable mature on December 31, 2024. 10. The company attaches a 1-year warranty on all the products it sells. Required: 1. Prepare Wicks Constructions December 31, 2019, balance sheet (including appropriate parenthetical notations). 2. Prepare notes to accompany the balance sheet that itemize company accounting policies; inventories; and property, plant, and equipment. 3. Next Level Compute the current ratio and the quick ratio. How do these two ratios provide different information about the companys liquidity? Why are these ratios useful?
When depreciation is recorded each period, what account is debited? a. Depreciation Expense b. Cash c. Accumulated Depreciation d. The fixed asset account involved Use the following information for Multiple-Choice Questions 7-4 through 7-6: Cox Inc. acquired a machine for on January 1, 2019. The machine has a salvage value of $20,000 and a 5-year useful life. Cox expects the machine to run for 15,000 machine hours. The machine was actually used for 4,200 hours in 2019 and 3,450 hours in 2020.
Comparative Analysis: Under Armour, Inc., versus Columbia Sportswear Refer to the 10-K reports of Under Armour, Inc., and Columbia Sportswear that are available for download from the companion website at CengageBrain.com. Required: With regard to depreciation methods: a. What depreciation method does Under Armour use? What depreciation method does Columbia use? b. What are the typical useful lives of each companys operating assets? c. What effect will the useful lives have on the companys financial statements?
Group and Composite Depreciation Chcadle Company purchased a fleet of 20 delivery trucks for 8,000 each on January 2, 2019. It decided to use composite depreciation on a straight-line basis and calculated the depreciation from the following schedule: Cheadle actually retired the trucks according to the following schedule (assume each truck was retired at the beginning of the year): Required: 1. Prepare the journal entries necessary to record the preceding events. 2. Assume that the company expected all the trucks to last 4 years and be retired for 1,600 each. Using group depreciation, prepare journal entries for all 6 years, assuming the company retired the trucks as shown by the latter schedule.