The Depreciation Schedule for a School Bus Is Created in Excel

question 43

Essay

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?

---

Definitions:

Eating Disorder

Mental disorders characterized by abnormal or disturbed eating habits that negatively affect a person’s health or psychology.

Anorexia Nervosa

An eating disorder characterized by an obsessive fear of gaining weight, leading to severe restriction of food intake and often starvation.

Individual Therapy

A form of psychotherapy where a therapist works one-on-one with a client to address issues affecting their mental health and well-being.

Thin

Having little body fat or flesh, often used to describe a slender physical appearance.