please answer all

1. A company bought a machine for BD300,000 which has a useful life of 7 years and can be sold for BD 30,000 at the end of its useful life. Determine the a. Depreciation schedules, dn b. Accumulated depreciation, Dn c. Book value, Cn using straight line method. Generate the plots using Microsoft excel. 2. Repeat problem #1 if there is an installation cost of BD20,000. 3. Repeat problem #1 if there is a dismantling cost of BD5,000