Excel SLN Function

The Excel SLN function has the syntax shown below.

SLN (cost, salvage, life)
Arguments used in the Excel SLN function
Cost = The initial cost of the asset
Salvage = The salvage or residual value of the asset
Life = The useful life of the asset

Use of the Excel SLN Function

The Excel SLN function is used to calculate the periodic straight line depreciation of a long term asset.

Straight Line Depreciation SLN Function Example

If a business purchases an asset costing 10,000 which is estimated to have a useful life of 5 years and a salvage value of 600, then the annual straight line depreciation is calculated using the Excel SLN function as follows:

Cost = 10,000
Salvage = 600
Life = 5 years
Depreciation = SLN (cost, salvage, life)
Depreciation = =SLN (10000,600,5)
Depreciation = 1,880

Using the Excel SLN function the straight line depreciation for the asset is calculated as 1,880 a year.

Using the Excel SLN Function for Monthly Periods

In the above example the Excel SLN function was used to calculate the annual depreciation. The function could equally well be used to calculate the monthly depreciation by defining the life in terms of months instead of years.

Suppose for example, the business purchased an asset costing 5,000 with an estimated salvage value of 800 and a useful life of 30 months, then using the Excel SLN function the monthly straight line depreciation is calculated as follows:

Cost = 5,000
Salvage = 800
Life = 30 months
Depreciation = SLN (cost, salvage, life)
Depreciation = =SLN (5000,800,32)
Depreciation = 140

The straight line depreciation is calculated as 140 a month.

The Excel SLN function is one of many Excel finance functions used in financial calculations, discover another at the links below.

Excel SLN Function November 6th, 2016Team

You May Also Like


Related pages


ar credit memonotes receivable balance sheetput option accounting entriessupplies on hand adjusting entryrent due to landlord journal entryhow to calculate ending cash balancepastel accounting tutorialsadjusting entry for unearned revenuein a perpetual inventory systemifrs bad debt expenseapplied manufacturing overhead formulapayback period calculation formulapetty cash voucher template wordgearing ratio accountingdiscount formula for excelcogs to saleshow to calculate growing perpetuityconsumables examplestreatment of deferred tax in cash flow statementintangible items examplespetty cash reimbursement journal entryunearned revenue classificationspreadsheet for accounting in small businessblank accounting journalcalculation of cost of goods manufacturedexamples of factory overheadaccumulated depreciation asset or liabilitypetty cash float definitiondebit credit journalwip exampleadjusting entries inventorymanagerial accounting journal entriesafs securitiesjournal entry for interest expenseaccounting spreadsheetscash book with cash and bank columnscalculate days receivablebills receivable accountincome statement with retained earningsmanufacturing overhead calculatorunearned revenue is liabilityhow to compute inventory turnoverjournal entries in accounts payablegain on sale of investment journal entryperpetuity formulapercentage of completion method formulaaccount payable test freeadjusting entry for allowance for uncollectible accountscvp accounting formulabookkeeping ledger templatecontribution margin per unit calculatordifference between single entry and double entry bookkeepingaccounting entry for prepaid expensespresent value perpetuity calculatorrate variance definitionprepare a retained earnings statementhow to calculate bond premium amortizationdebtor turnover ratio formulaaccounts payable vs notes payablecash denomination sheeteffective interest rate calculation in excelcapital owners equitypresent value lump sum formulaaccounts receivable allowance methodpayout ratio definitiondouble entry accounting transactions are made up ofstraight line depdifference between margin and markup calculationhow to calculate material usage variancenonprofit chart of accountsaccrual journalrequisition form templatewhat is an annuity duenet income to sales ratiojournal entry payroll