Concept explainers
Concept Introduction:
Depreciation can be defined as the cost of use or the cost of wear and tear of the assets used during the operations of the business.
There are many methods available for calculating depreciation of an asset. Some of them are –
• Straight-line method
• Double-declining method
• Units-of-production
These methods are discussed as under –
1. Straight-line method – In straight-line method, the depreciable cost of the asset is divided by the number of years of the life of the asset.
2. Double-declining method – In double-declining method, the assets are depreciated at twice the straight-line method rate, and the rate is applied on the beginning balance of the asset of the year.
3. Units-of-production method – In Units-of-production method, the depreciable cost of the assets is divided by the total Units-of-production during the life of the asset and multiplied by the number of units produced during the year.
Requirement 1
To prepare:
Depreciation Schedules for –
• Straight-line method
• Double-declining method
• Units-of-production method
Using the excel and excel formulas
Requirement 2:
To prepare:
A second depreciation schedule for double-declining method using EXCEL function DDB.
Requirement 3:
Minimum selling price for the asset to be sold at a profit of $ 6,000 using the three methods –
• Straight-line method
• Double-declining method
• Units-of-production method
Want to see the full answer?
Check out a sample textbook solutionChapter 10 Solutions
Horngren's Accounting: The Managerial Chapters, Student Value Edition (12th Edition)
- Compute the net income or net loss for the month ended on March 31, 2008, from the following data: Assets on March 1, 2008 $ 40,000 Liabilities on March 1, 2008, 30,000 Capital on March 31, 2008, 15,000 Additional investments by the owner during the year 2008 2,000 Withdrawals during the year 2008 1,000 A. $3,000 B. $4,000 C. $5,000 D. $6,000arrow_forwardMountain Bikes purchased 100 units at $200 each on January 1. On January 15, they purchased 150 units at $220 each. If they sold 180 units during January, calculate the ending inventory value using FIFO method.arrow_forwardPlease given correct answer general accountingarrow_forward
- What is the project expected free cash flow for the year? General accountingarrow_forwardNO WARONG ANSWERarrow_forwardA company sold office furniture costing $12,700 with accumulated depreciation of $10,150 for $2,200 cash. The entry to record the sale would include a gain or loss of what amount?arrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education