Finance in Excel 4 - Calculate Straight Line Depreciation in Excel

Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials.

Learn how to calculate Straight Line Depreciation in Excel using the SLN() function. This is the first in a line of tutorials on how to calculate depreciation in Excel and therefore covers the most basic method of depreciation, which is the straight line method of depreciation. This is a good tutorial for those needing to improve their finance skills as well as to simply learn to apply them within the Excel environment.

For Excel consulting or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.

Have a great day!

Category:

Education

Tags:

• microsoft excel 2007
• excel tips
• excel tricks
• excel guides
• excel tutorials
• excel help
• excel teacher
• spreadsheets
• worksheets
• workbooks
• finance
• depreciation
• SLN
• straight line depreciation
• salvage value
• usefule life
• accounting

[laythesmack23]

What if I want to depreciate the full amount of the salvage amount of 150K per year, so I have year 1,year 2, year 3,etc?

[ExcelisHell]

Just set the salvage value number to 0.

[magnumforce1983]

Can anyone confirm what "Depreciation Rate" is?

[thurtig1]

What if I want to calculate the depreciation on a monthly basis? Can you divide the function?