Question:
Write the formula to calculate the depreciation by using SLN (Straight Line) method in MS Excel.
Write the formula to calculate the depreciation by using SLN (Straight Line) method in MS Excel.
Show Hint
SLN stands for Straight Line Method and returns equal depreciation each year.
Updated On: Feb 16, 2026
Show Solution
Verified By Collegedunia
Solution and Explanation
In MS Excel, depreciation under the Straight Line Method is calculated using the SLN function, which takes three arguments: Cost, Salvage value, and Useful life (in years).
Was this answer helpful?
0
0
Top PSEB Accountancy Questions
- Under which method of valuation of Goodwill, normal rate of return is not required?
- An increase in the value of assets is recorded on which side of the Revaluation Account?
- J, K, L, M are in partnership sharing profits and losses in ratio of 9 : 6 : 5 : 5. 'N' joins the partnership for 20% share. J, K, L and M would in future share profits among themselves as 3 : 4 : 2 : 1. The new profit sharing ratio will be:
- X, Y and Z are three partners sharing profits in the ratio 10 : 7 : 7. Z retired. X and Y decided to share profits in equal ratio. Gaining ratio will be:
- Rent paid to a partner is _________ against profit. (charge/appropriation)
View More Questions
Top PSEB Depreciation Questions
Top PSEB Questions
- Under which method of valuation of Goodwill, normal rate of return is not required?
- An increase in the value of assets is recorded on which side of the Revaluation Account?
- J, K, L, M are in partnership sharing profits and losses in ratio of 9 : 6 : 5 : 5. 'N' joins the partnership for 20% share. J, K, L and M would in future share profits among themselves as 3 : 4 : 2 : 1. The new profit sharing ratio will be:
- X, Y and Z are three partners sharing profits in the ratio 10 : 7 : 7. Z retired. X and Y decided to share profits in equal ratio. Gaining ratio will be:
- Rent paid to a partner is _________ against profit. (charge/appropriation)
View More Questions