help

LGO Comp. purchased equipment costing $280,000 on April 122023 . The equipment has an estimated life of five years and an estimated salvage value of $40,000. Instructions: 1. Use Excel to prepare a table to determinate the depreciation expense, accumulated depreciation, beginning book value and ending book value of each year by (a) straight-line method and (b) the double declining balance method. The following columnar headings are required for each schedule: Year, Beginning Book Value, Depreciation Expense, Accumulated Depreciation and Ending Book Value