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
Hide 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 Questions on Depreciation
Calculate depreciation using the following data:
- PSEB XII - 2025
- Accountancy
- Depreciation
- An MRI machine is purchased by a hospital at Rs 27 lakhs with an expected life of 12 years. What will be the value of annual depreciation?
- CUET (UG) - 2024
- Economics
- Depreciation
- Chandra Ltd. purchased a second-hand machine for Rs. 80,000 on 1st July, 2020 and spent Rs. 30,000 on its overhaul and installation. Depreciation was to be provided @ 10% p.a. by written down value method. Prepare machinery account for 3 years assuming the books are closed on 31st March every year.
- Under which method of charging depreciation more amount is charged in the initial years as compared to the later years of its life? Give any two merits of this method.
- Estimated sale value of an asset after its working life is called:
View More Questions
Questions Asked in PSEB exam
- Explain the importance of E-waste management and proper disposal of electronic gadgets.
- PSEB XII - 2026
- Green Computing
- Explain the CIA Triad (Confidentiality, Integrity, and Availability) in cyber safety.
- PSEB XII - 2026
- Cyber Security
- Explain the concepts of Primary Key, Foreign Key, and Candidate Key.
- PSEB XII - 2026
- Database Management Systems
- Write the syntax and use of SQL DDL commands (CREATE, ALTER, DROP) and DML commands (INSERT, UPDATE, DELETE).
- PSEB XII - 2026
- Database Management Systems
- What are the main provisions of the Indian IT Act 2000?
- PSEB XII - 2026
- Cyber Security
View More Questions