Need another way of calculation I am using this formula to calculate depreciatio

Question

Need another way of calculation

I am using this formula to calculate depreciation on asset.

=ROUND(((D4+E4-G4)*C4)+(F4*(C4/2)),0)

is there any another way to calculate?

Thanks and regards

S.No. Particulars Dep.
Rate Opening Addition Addition
After
01.10.2013 Sold During the Year Depreciation Closing Balance Office Equipments 1 Air Conditioner 0.15 0.00 37500.00 0.00 0.00 5625.00 31875.00 2 Coffee Machine 0.15 6655.00 0.00 0.00 0.00 998.00 5657.00 3 Computer & Peripherals 0.60 38667.00 6250.00 250.00 0.00 27025.00 18142.00

Explanation / Answer

^Your formula calculates the depreciation correctly assuming financial year is from 1-Apr to 31-Mar..<

Your closing balance is also coming out correctly..

I don't think an alternative formula is needed. Your formula is simple and does its job perfectly.<?

The same formula can be written as below but it is your formula only represented in a different way.

=ROUND(((D4+E4-G4)*2+F4)*C4/2,0)

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.