Hello,

I am struggling with depreciation schedules. I am needing help with proper formulas to calculate the following:

Depreciation Schedule in Excel Name: Asset Information Purchase Date Cost Residual value Estimated useful life (years) $ $ 3/1/2021 25,000.00 4,000.00 10 Depreciation Accumulated Expense Depreciation Book Value Year 2021 2022 The green cells should be formulas referencing other cells in table and the asset information box The ONLY exceptions are the two blue cells where the time factor needs to be entered (example 7/12) The rest of the green cells should reference cells in the asset information box and be formulas. 2023 2024 2025 2026 2027 2028 2029 2030 2031