At the beginning of the year, Orbit Airways purchased a used Boeing aircraft at a cost of $45 million. Orbit expects the plane to remain useful for five years (3 million miles) and to have a residual value of $5 million. Orbit expects the plane to be flown 750,000 miles the first year.

At the beginning of the year, Orbit Airways purchased a used Boeing aircraft at a cost of $45 million. Orbit expects the plane to remain useful for five years (3 million miles) and to have a residual value of $5 million. Orbit expects the plane to be flown 750,000 miles the first year.

Using Excel:

1. Compute Orbit’s first-year depreciation on the plane using the following methods:

a. Straight-line

b. Units-of-production

c. Double-declining-balance

2. Show the airplane’s book value at the end of the first year under the straight-line method.

At the beginning of the year, Orbit Airways purchased a used Boeing aircraft at a cost of $45 million. Orbit expects the plane to remain useful for five years (3 million miles) and to have a residual value of $5 million. Orbit expects the plane to be flown 750,000 miles the first year.