SLN
The SLN function in Google Sheets is a powerful tool to calculate the depreciation of an asset for one period using the straight-line method.
Function Syntax and Parameters
Syntax: SLN(cost, salvage, life)
Parameters:
cost: The initial cost of the asset.salvage: The value of the asset at the end of its useful life.life: The number of periods over which the asset is depreciated.
Step-by-Step Tutorial
- Calculating depreciation using
SLN:- Example: If the initial cost is $10,000, the salvage value is $2,000, and the asset has a useful life of 5 years, the formula would be
=SLN(10000, 2000, 5). - Result: Depreciation value of $1600 per year.
- Example: If the initial cost is $10,000, the salvage value is $2,000, and the asset has a useful life of 5 years, the formula would be
Use Cases and Scenarios
- Asset Depreciation: Calculate the yearly depreciation of a vehicle, equipment, or any other valuable asset.
- Financial Planning: Determine the depreciation expense to be included in financial statements or budget projections.
Related Functions
No related functions.
Related Articles
No related articles.