sln - Depreciation Using the Straight-Line Method SLN The...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Depreciation Using the Straight-Line Method – SLN The depreciation charge or expense of an asset for any one specific period of time using the straight-line depreciation method can be calculated using Excel’s SLN function. See the table below for a detailed list of the exercises and problems in the text that can be solved using this function. Syntax =SLN(cost,salvage,life) Cost – initial cost of asset Salvage – value of the asset at the end of depreciation Life – number of periods over which the asset is being depreciated General Example The following general example shows how the SLN function can be used. Notice that the SLN function appears in the formula bar. 1
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Using the SLN Function in a Spreadsheet To calculate the depreciation charge for one period using the straight-line method, create a worksheet by following Steps 1 to 7. Or, to use the SLN function right away, open the SLN worksheet in the Excel Templates workbook. All fields have been formatted for you (currency, percentage, number of decimals displayed). Step 1
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 08/22/2009 for the course MATH 1101 taught by Professor Tonycirusolo during the Fall '05 term at Niagara College.

Page1 / 5

sln - Depreciation Using the Straight-Line Method SLN The...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online