Question

What is the difference between SLN and DB method of Depreciation? How are they implemented in MS Excel?

08 Oct 2024
Answer :
Word Count : 234

The Straight-Line (SLN) and Declining Balance (DB) methods of depreciation are two common approaches for allocating the cost of an asset over its useful life, impacting financial statements and tax calculations differently.

Straight-Line Method (SLN): This method spreads the asset's cost evenly over its useful life. It is calculated using the formula:

\[
\text{Depreciation Expense} = \frac{\text{Cost of Asset} - \text{Salvage Value}}{\text{Useful Life}}
\]

In Microsoft Excel, the SLN function is used as follows:

```
________ _______ ________ _____ __________ _____ ___ ____ __________ _____ ________ ______.
___ _________ __________ ___ ________.
_________ __________ _____ ___ ______ ___ _________ ________ ____ _______ ______ _____.
________ __________ ___ ___ ________ ________ ____ ____ _____ _______.
_________ ____ ______ ___ ______ ________ ______ __________ _________ ______ __________ ______.
____ ___ __________ _______ ______ ______ ________ ________ ______ _______.
______ ____ ______ __________ ________ ___ ______ _____ __________.
___ _________ ____ ___ __________ ____ _________ ___ _____.
___ ______ __________ ___ ___ ______ ________ ________.
______ _______ ___ __________ ____.
________ ___ ____ ___ ___ _____.
__________ ______ ____ ___ _____ _________ __________ ________ ___.
______ __________ ______ _________ ____ _______ _________ _________ ________ ___ ___ _______.
____ _________ _________ _____ ______ _______ __________ __________ _________ ________.
__________ ___ _____ _____ ____ ______ __________ ____ _________ ______ ___ ________.
_______ _______ ______ ___ ____ ________ _______ _______ _________.
________ ____ __________ __________ _______ ________ ______.

IGNOU ACADEMY
Your IGNOU journey, made easier.
  • Solved Assignments
  • Study Notes
  • Guess Papers
  • Question Papers
Skip in 10
Top