GOOD FELLAS CATERING Truck Depreciation Schedule Straight-Line Method Cost of Asset: $56,500 Salvage Value: $5,500 Length
Fantastic news! We've Found the answer you've been seeking!
Question:
GOOD FELLAS’ CATERING Truck Depreciation Schedule • Straight-Line Method | |||||
Cost of Asset: | $56,500 | ||||
Salvage Value: | $5,500 | ||||
Length of Service (yrs): | 5 | ||||
Depreciable Base: | |||||
Annual Depreciation: | |||||
Straight-Line | Years | ||||
(SLN) | 1 | 2 | 3 | 4 | 5 |
Annual Depreciation | |||||
Cumulative Depreciation | |||||
End-of-Year Book Value | |||||
1. Enter a formula in Cell C7 to calculate the Depreciable Base. | |||
2. Enter a straight line depreciation formula in Cell C8 to calculate the Annual Depreciation. | |||
3. Copy the formula in C8 to B11. | |||
4. Copy the formula in Cell B11 horizontally to Cell F11. | |||
5. In Cell B12, enter the formula to display the depreciation for the first year. | |||
6. In Cell C12, enter the formula to add this yearly depreciation to the previous year's depreciation. | |||
7. Copy the formula in cell C12 across to F12 to calculate cumulative depreciation through the first five years. | |||
8. In Cell B13, enter the formula to calculate the depreciated asset's value after the first year. | |||
9. Copy the formula in B13 across to F13. The asset's value will be reduced to the Salvage value. | |||
10. Save the file as ch13ex02a.xlsx. |
Related Book For
Integrated Accounting
ISBN: 978-1285462721
8th edition
Authors: Dale A. Klooster, Warren Allen, Glenn Owen
Posted Date: