Scribd
Upload
12 views1 page

Excel SLN Function for Depreciation

The SLN function in Excel calculates straight-line depreciation of an asset using its initial cost, salvage value, and useful life. It is useful for financial analysis of assets like equipment and vehicles, providing a simple method for budgeting. However, it may not accurately reflect depreciation for assets that depreciate unevenly over time.

Uploaded by

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

Excel SLN Function for Depreciation

The SLN function in Excel calculates straight-line depreciation of an asset using its initial cost, salvage value, and useful life. It is useful for financial analysis of assets like equipment and vehicles, providing a simple method for budgeting. However, it may not accurately reflect depreciation for assets that depreciate unevenly over time.

Uploaded by

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

Function: SLN is a financial function in Excel used to calculate depreciation of an asset in straight-line

method.

Syntax: SLN(cost, salvage, life)

cost: Initial cost of the asset.

salvage: Value of the asset at the end of its useful life.

life: Number of periods over which the asset is depreciated.

Straight-Line Depreciation: Assumes asset depreciates by equal amount each period until it reaches
salvage value.

Usage: Calculate depreciation for assets like equipment, vehicles, or machinery, simplifying financial
analysis tasks.

Example: =SLN(10000, 2000, 5) calculates annual depreciation for a $10,000 asset with $2,000 salvage
value over 5 years.

Accuracy: Simple method suitable for basic financial analysis and budgeting tasks.

Limitations: May not accurately represent depreciation of assets with uneven depreciation over time.

You might also like