Excel Tip: Calculating Straight-Line Depreciation

Posted by AccountingWEB on Apr 30 2012 5390 printer friendly

Excel expert David Ringstrom is sharing his tips for optimizing the way you use Excel in our new Excel Tips series.

By David Ringstrom, CPA

The SLN feature in Excel enables you to compute straight-line deprecation for an asset. The function has three arguments: Cost, Salvage, and Life.

Cost is the original cost of the item, Salvage is the proceeds you expect to receive upon disposal, while Life is the useful life of the asset specified in years.

Thus, SLN would return $1,000 for a $5,000 asset with a salvage value of zero and a five-year useful life.

Voice of the Editor

What would you do if one of your clients won the lottery? We asked several accountants to weigh in with their advice for the lucky Powerball winner, and the tips we received are useful for anyone who receives a windfall, whether it's a lottery win, an inheritance, a big bonus on the job, or a killing in the stock market.

This Week on AccountingWEB

CPAs Mira Finé, Scott Hitchcock, Rob Keasal, Kathy Scorcio, and Ken Travis offer ten pieces of financial advice for the newest Powerball winner.

Hang Bower of BDO USA and Dan Black of Ernst & Young share their perspectives on why their firms made the Best Places to Work for Recent Grads 2013 list.

Herbein + Company, Inc. firm members talked with AccountingWEB about their year-round employee wellness program.

Bill Walter of Gross, Mendelsohn & Associates and Harold Gaar of TravisWolff LLP weigh in on mobile technology use while employees are at work.