Question

M/s Excel Computers has a debit balance of Rs 50,000 (original cost Rs 1,20,000) in Computers account on April 1, 2000. On July 1, 2000, it purchased another computer costing Rs 2,50,000. One more computer was purchased on January 1, 2001, for Rs 30,000. On April 1, 2004, the computer which has purchased on July 1, 2000, became obsolete and was sold for Rs 20,000. A new version of the IBM computer was purchased on August 1, 2004, for Rs 80,000. Show Computers account in the books of Excel Computers for the years ended on March 31, 2001, 2002, 2003, 2004 and 2005. The computer is depreciated @ $10\%$ per annum on straight-line method basis.

Answer 1

Dr Computer Account Cr
$\begin{array}{cccccccc}\text{Date}& \text{Particulars}& \text{JF}& \text{Amt.(Rs)}& \text{Date}& \text{Particulars}& \text{JF}& \text{Amt.(Rs)}\\ 2000& & & & 2001& & & \\ \text{Apr 1}& \text{Balance b/d (C1)}& & 50,000& \text{Mar 31}& \text{Depreciation}& & \\ \text{Jul 1}& \text{Bank A/c (C2)}& & 2,50,000& & \text{A/c}& & \\ & & & & & C1=12,000& & \\ & & & & & C2=18,750& & \\ & & & & & C3=\underset{–}{750}& & 31,500\\ \text{Jan 1}& \text{Bank A/c (C3)}& & 30,000& \text{Mar 31}& \text{Balance c/d}& & \\ & & & & & C1=38,000& & \\ & & & & & C2=2,31,250& & \\ & & & & & C3=\underset{–}{29,250}& & 2,98,500\\ & & & \underset{–}{\overline{3,30,000}}& & & & \underset{–}{\overline{3,30,000}}\\ 2001& & & & 2002& & & \\ \text{Apr 1}& \text{Balance b/d}& & & \text{Mar 31}& \text{Depreciation}& & \\ & & & & & \text{A/c}& & \\ & C1=38,000& & & & C1=12,000& & \\ & C2=2,31,250& & & & C2=25,000& & \\ & C3=\underset{–}{29,250}& & 2,98,500& & C3=\underset{–}{3,000}& & 40,000\\ & & & & \text{Mar 31}& \text{Balance c/d}& & \\ & & & & & C1=26,000& & \\ & & & & & C2=2,06,250& & \\ & & & & & C3=\underset{–}{26,250}& & 2,58,500\\ & & & \underset{–}{\overline{2,98,500}}& & & & \underset{–}{\overline{2,98,500}}\\ 2002& & & & 2003& & & \\ \text{Apr 1}& \text{Balance b/d}& & & \text{Mar 31}& \text{Depreciation}& & \\ & & & & & \text{A/c}& & \\ & C1=26,000& & & & C1=12,000& & \\ & C2=2,06,250& & & & C2=25,000& & \\ & C3=\underset{–}{26,250}& & 2,58,500& & C3=\underset{–}{3,000}& & 40,000\\ & & & & \text{Mar 31}& \text{Balance c/d}& & \\ & & & & & C1=14,000& & \\ & & & & & C2=1,81,250& & \\ & & & & & C3=\underset{–}{23,250}& & 2,18,500\\ & & & \underset{–}{\overline{2,58,500}}& & & & \underset{–}{\overline{2,58,500}}\\ 2003& & & & 2004& & & \\ \text{Apr 1}& \text{Balance b/d}& & & \text{Mar 31}& \text{Deprecition}& & \\ & & & & & \text{A/c}& & \\ & C1=14,000& & & & C1=12,000& & \\ & C2=1,81,250& & & & C2=25,000& & \\ & C3=\underset{–}{23,250}& & 2,18,500& & C3=\underset{–}{3,000}& & 40,000\\ & & & & \text{Mar 31}& \text{Balance c/d}& & \\ & & & & & C1=2,000& & \\ & & & & & C2=1,56,250& & \\ & & & & & C3=\underset{–}{20,250}& & 1,78,500\\ & & & \underset{–}{\overline{2,18,500}}& & & & \underset{–}{\overline{2,18,500}}\\ 2004& & & & 2004& & & \\ \text{Apr 1}& \text{Balance b/d}& & & \text{Apr 1}& \text{Bank A/c (C2)}& & 20,000\\ & C1=2,000& & & \text{Apr 1}& \text{Profit}\&\text{Loss}& & 1,36,250\\ & & & & & \text{A/c}& & \\ & C2=1,56,250& & & & & & \\ & C3=\underset{–}{20,250}& & 1,78,500& 2005& & & \\ \text{Aug 1}& \text{Bank A/c (C4)}& & 80,000& \text{Mar 31}& \text{Depreciation}& & \\ & & & & & \text{A/c}& & \\ & & & & & C1=2,000& & \\ & & & & & C3=3,000& & \\ & & & & & C4=\underset{–}{5,333}& & 10,333\\ & & & & \text{Mar 31}& \text{Balance c/d}& & \\ & & & & & C1=Nil& & \\ & & & & & C3=17,250& & \\ & & & & & C4=\underset{–}{74,667}& & 91,917\\ & & & \underset{–}{\overline{2,58,500}}& & & & \underset{–}{\overline{2,58,500}}\end{array}$