What is the formula of straight line depreciation in excel?

thanks for the great reply Mr. Abdul Khalique

Dear Friend,

 

What is the formula of straight line depreciation in excel?

 

Here is the answer to your question if its for Excel 2010 version:

 

The SLN function performs the following calculation. Deprecation Value = (10,000 - 1,000) / 10 = 900.00. If we subtract this value 10 times, the asset depreciates from 10,000 to 1000 in 10 years (see first picture, bottom half).

 

Hope this helps u, if yes please vote up to my answer.

 

Regards

Poonam

It's very simple, you know the calculation e.g. (cost minus salvage) divide by life of an asset ( - ) /5 =.

In Excel we use SLN formula to calculate straight line depreciation. Go to function insert function then search SLN, enter cost, salvage value then enter life5, result will come.

 

 

• Investment banking
• Private equity
• Corporate development
• Equity research
• Financial Planning & Analysis (FP&A

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.

 

Deprecation Value = (, -1,) / =.

the formula is= {(cost- salvage)/useful life in units)units produced in period.

great reply by all users......

=SLN(COST,SALVAGE,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.

=Asset cost divided by the number of years

thanks for the invitation

Agrees with the answers