In: Statistics and Probability
3. A large profitable corporation purchased a small plane for use by its executives. The plane cost $3,500,000. It is expected to have a service life of seven years and $0 salvage value. Develop the complete depreciation schedule for the plane showing year-by-year depreciation charges and book values, and determine the present worth of all the depreciation charges assuming an interest rate of 6% per year, using: (a) DDB method with switch to SL, (b) MACRS depreciation.
Answer:-
Given That:-
A large profitable corporation purchased a small plane for use by its executives. The plane cost $3,500,000. It is expected to have a service life of seven years and $0 salvage value. Develop the complete depreciation schedule for the plane showing year-by-year depreciation charges and book values, and determine the present worth of all the depreciation charges assuming an interest rate of 6% per year, using:
(a) DDB method with switch to SL,
With SLM, annual depreciation = $3,500,000 / 7 = $500,000
SLM depreciation rate = 1 / 7
DDB Depreciation rate = 2 x 1 / 7 = 2 / 7
Each year, comparison is made between DDB depreciation and SLM depreciation of remaining book value. A switch from DDB to SLM is made in the year when SLM depreciation is higher than DDB Depreciation. From table below, the switch happens in year 5.
| Year | DDB | Remaining book value | SLM | 
| 1 | 3,500,000 x 2/7 = 1,000,000 | 25,00,000 | 3,500,000 / 7 = 500,000 | 
| 2 | 2,500,000 x 2/7 = 714,286 | 17,85,714 | 2,500,000 / 6 = 416,667 | 
| 3 | 1,785,714 x 2/7 = 510,204 | 12,75,510 | 1,785,714 / 5 = 357,143 | 
| 4 | 1,275,501 x 2/7 = 364,431 | 9,11,070 | 1,275,501 / 4 = 318,875 | 
| 5 | 911,070 x 2/7 = 260,306 | 6,50,764 | 911,070 / 3 = 303,690 | 
| 6 | 650,764 x 2/7 = 185,933 | 4,64,831 | 650,764 / 2 = 325,382 | 
| 7 | 464,831 x 2/7 = 132,809 | 3,32,022 | 464,831 / 1 = 464,831 | 
So, Total depreciation schedule & Present worth (PW):
| Year | Annual depreciation | Discount factor @6% | Discounted depreciation | 
| 1 | 10,00,000 | 0.9434 | 9,43,396 | 
| 2 | 7,14,286 | 0.8900 | 6,35,712 | 
| 3 | 5,10,204 | 0.8396 | 4,28,377 | 
| 4 | 3,64,431 | 0.7921 | 2,88,663 | 
| 5 | 3,03,690 | 0.7473 | 2,26,935 | 
| 6 | 3,25,382 | 0.7050 | 2,29,381 | 
| 7 | 4,64,831 | 0.6651 | 3,09,139 | 
| Present worth = | 30,61,604 | 
(b) MACRS depreciation.
MACRS Depreciation schedule, assuming 7-year property class & mid-year convention
| MACRS | ||||
| Year | Depreciation % | Depreciation % | Discount factor @6% | Discounted depreciation | 
| 1 | 14.29 | 5,00,150 | 0.9434 | 4,71,840 | 
| 2 | 24.49 | 8,57,150 | 0.8900 | 7,62,860 | 
| 3 | 17.49 | 6,12,150 | 0.8396 | 5,13,973 | 
| 4 | 12.49 | 4,37,150 | 0.7921 | 3,46,264 | 
| 5 | 8.93 | 3,12,550 | 0.7473 | 2,33,556 | 
| 6 | 8.92 | 3,12,200 | 0.7050 | 2,20,089 | 
| 7 | 8.93 | 3,12,550 | 0.6651 | 2,07,864 | 
| Present worth = | 27,56,445 | 
Plz like it......,