Depreciation Schedule Excel Assignment Using Excel Formulas, please complete the following information in the required cells (see yellow highlighted cells): Annual Depreciation Expense Accumulated Depreciation Expense Year-End Book Value Total Depreciation Expense

St. Tammany Woods Recording Studio buys a machine costing $210,000 with a four-year life and an estimated $20,000 salvage value on January 1.

Cost Salvage Value = ($210,000 - $20,000) = $190,000 depreciable cost = $47,500 per year Years of Life 4 years 4 years

Can you provide formulas for Excel also? Thank you