The depreciation schedule for a school bus is created in Excel. The cost of the asset is in Cell C4, the salvage value is in Cell C5, the length of service is in Cell C6, and the annual double-declining-balance rate is in Cell C7. Column A contains the year, Column B contains the depreciable amount, Column C contains the double-declining-balance rate, Column D contains the annual depreciation, Column E contains the accumulated depreciation, and Column F contains the end-of-year book value. Using the double-declining-balance method of depreciation, what formula should be keyed into Cell C10 to calculate the first-year end-of-year book value?
Correct Answer:
Verified
Q38: Dawn bought a van at the beginning
Q39: The life of a Jeep is 12
Q40: The original cost of a dirt bike
Q41: Miguel bought a boat at the beginning
Q42: The life of an SUV is 7
Q44: The depreciation schedule for a piece of
Q45: Use the information to match the answer
Q46: Lani bought a car at the beginning
Q47: The original cost of a van was
Q48: The original cost of a bus was
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents