Scribd
Upload
4 views1 page

Excel Depreciation Functions Guide

The document describes the Excel SYD and SLN functions which calculate depreciation, with SYD using a sum-of-years method and SLN using straight-line, both based on initial cost, salvage value, and depreciation periods.

Uploaded by

faye cantil
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
4 views1 page

Excel Depreciation Functions Guide

The document describes the Excel SYD and SLN functions which calculate depreciation, with SYD using a sum-of-years method and SLN using straight-line, both based on initial cost, salvage value, and depreciation periods.

Uploaded by

faye cantil
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

SYD

The Excel SYD function returns the "sum-of-years" depreciation for an asset in a given
period. The calculated depreciation is based on initial asset cost, salvage value, and the
number of periods over which the asset is depreciated.
cost - Initial cost of an asset.
salvage - Asset value at the end of the depreciation.
life - Periods over which asset is depreciated.
period - Period to calculate depreciation for.
The Excel SYD function returns the "sum-of-years" depreciation for an asset in a given
period. The calculated depreciation is based on initial asset cost, salvage value, and the
number of periods over which the asset is depreciated.

SNL
The Excel SLN function returns the depreciation of an asset for one period, calculated
with a straight-line method. The calculated depreciation is based on initial asset cost,
salvage value, and the number of periods over which the asset is depreciated.
cost - Initial cost of an asset.
salvage - Asset value at the end of the depreciation.
life - Periods over which asset is depreciated.
The Excel SLN function returns the depreciation of an asset for one period, calculated
with a straight-line method. The calculated depreciation is based on initial asset cost,
salvage value, and the number of periods over which the asset is depreciated.

You might also like