what formula was used and how?

Requirement 1. For each depreciation method, prepare a depreciation schedule showing asset cost, depreciation expense, accumulated depreciation, and asset book value for each year of the asset's life. For the units of production method, round depreciation per unit to three decimal places. Before completing the straight-line depreciation schedule, calculate the straight-line depreciation rate. One year Useful life 5 = = (SL) Depreciation rate 1/5 Complete the Straight-Line Depreciation Schedule. Begin by filling out the schedule through 2019, and then complete the schedule by entering the amounts through 2022 Straight-Line Depreciation Schedule Depreciation Depreciable Depreciation Rate Cost Expense Accumulated Depreciation Asset Book Value Date Asset Cost January 4, 2018 300000 December 31, 2018 December 31, 2019 1/5 More Info On January 4, 2018, Ruiz Enterprises, Inc., paid $284,500 for equipment used in manufacturing automotive supplies. In addition to the basic purchase price, the company paid $200 for transportation charges, $400 for insurance for the equipment while in transit, $12,000 sales tax, and $2,900 for a special platform on which to place the equipment in the plant. Management of Ruiz Enterprises, Inc., estimates that the equipment will remain in service for five years and have a residual value of $25,000. The equipment will produce 65,000 units the first year, with annual production decreasing by 5,000 units during each of the next four years i.e., 60,000 units in year 2, 55,000 units in year 3, and so on, for a total of 275,000 units). In trying to decide which depreciation method to use, Ruiz Enterprises, Inc., requested a depreciation schedule for each of the three depreciation methods (straight-line, units of production, and double-declining balance)