How To Calculate Depreciation Schedule In Excel. The sln function can be used to calculate straight line depreciation in excel during a single period of an asset's useful life. In year 2, the depreciation is the sum of the first two harges in row 48 (namely, cells j48:k48).
Following the depreciation expense formula above: In year 2, the depreciation is the sum of the first two harges in row 48 (namely, cells j48:k48). Now, you can build a depreciation schedule.
