Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Use the information on the Given Data worksheet to prepare three depreciation schedules using the following methods: straight-line, double-declining balance, and activity-based. Auburn Car Wash
| Use the information on the Given Data worksheet to prepare three depreciation schedules using the following methods: straight-line, double-declining balance, and activity-based. | |||||||||||||||
| Auburn Car Wash | |||||||||||||||
| Straight Line | |||||||||||||||
| Calculation | End of Year Amounts | ||||||||||||||
| Depreciable | X | Depreciation | = | Depreciation | Accumulated | Book | |||||||||
| Year | Cost | Rate | Expense | Depreciation | Value | ||||||||||
| 1 | Class hour: | If you hover your mouse over a cell with a red flag you will see the comment | |||||||||||||
| 2 | |||||||||||||||
| 3 | |||||||||||||||
| 4 | |||||||||||||||
| 5 | |||||||||||||||
| Total | |||||||||||||||
| Auburn Car Wash | |||||||||||||||
| Double-Declining-Balance | |||||||||||||||
| Calculation | End of Year Amounts | ||||||||||||||
| Beginning | X | Depreciation | = | Depreciation | Accumulated | Book | |||||||||
| Year | Book Value | Rate | Expense | Depreciation | Value | ||||||||||
| 1 | If you hover your mouse over a cell with a red flag you will see the comment | ||||||||||||||
| 2 | |||||||||||||||
| 3 | |||||||||||||||
| 4 | |||||||||||||||
| 5 | Note: for year 5 you must make the year end book value equal to the Residual Value | ||||||||||||||
| Total | Therefore you will need to take the beginning book value less the Residual Value | ||||||||||||||
| Auburn Car Wash | |||||||||||||||
| Activity-Based | When you have completed all three schedules answer the following question. | ||||||||||||||
| What do you observe about the Book Value at the end of the 5th year for all three methods? | |||||||||||||||
| Calculation | End of Year Amounts | ||||||||||||||
| Hours | X | Depreciation | = | Depreciation | Accumulated | Book | Type answer here-------> | ||||||||
| Year | Used | Rate | Expense | Depreciation | Value | ||||||||||
| 1 | |||||||||||||||
| 2 | |||||||||||||||
| 3 | |||||||||||||||
| 4 | |||||||||||||||
| 5 | |||||||||||||||
| Total | |||||||||||||||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Managerial Accounting An Introduction to Concepts Methods and Uses
Authors: Michael W. Maher, Clyde P. Stickney, Roman L. Weil
10th Edition
1111822239, 324639767, 9781111822231, 978-0324639766
