Amity University 2007 B.Com ACCOUNTANCY - Question Paper

Outstanding Salary 50,000
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------

6,00,000 6,00,000

On the basis of the info provided in these 2 statements, compute any 2 of the subsequent ratios:

Current Ratio,
Stock Turnover Ratio, and
Proprietary Ratio. (4)
Qs 21. Raj Ltd. had a profit of Rs. 17,50,000 for the year ended 31.3.2006 after considering the subsequent :

Depreciation on building Rs. 1,30,000
Depreciation on plant and machinery Rs. 40,000
Goodwill written off Rs. 25,000
Loss on sale of machinery Rs. 9,000

subsequent was the position of current assets and current liabilities of the company as on 31.3. 2005 and 31.3.2006.

31.3.2005 Rs.
31.3.2005 Rs.
Stock
Bills Receivable
Cash
Creditors
Outstanding Salary
Bills Payable 70,000
67,000
60,000
68,000
7,000
43,000 87,000
58,000
75,000
77,000
4,000
29,000

compute cash flow from operating activities (6)

With the help of the subsequent Profit and Loss Account for the year ended 31.3.2006 and Balance Sheets as on 31.3.2005 and 31.3.2006 of Janta Ltd., compute cash flow from operating activities;

Profit and Loss Account of Janta Ltd. for the year ended 31.3.2006

Liabilities Amt. Rs. Assets Amt. Rs.
Gross Profit 5,00,000
Depreciation 17,000
Salary 35,000
Rent
72,000
Commission 23,000
Other Expenses 43,000
Net Profit
3,10,000

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------

5,00,000 5,00,000

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------

Proposed Dividend 1,50,000 Net Profit 3,10,000
Retained Profit 1,60,000

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------

3,10,000 3,10,000

Balance Sheets of Janta Ltd. as on 31.3. 2005 and 31.3.2006

Liabilities 2005 Rs. 2006 Rs Assets. 2005 Rs. 2006 Rs.
Share Capital 2,00,000 3,50,000
Reserves 60,000 2,20,000 Plants 4,75,000 5,40,000
Loan 20,000 30,000

Patents 50,000
Proposed Dividend 20,000 1,70,000 Stock 1,05,000 1,20,000
Creditors 1,80,000 10,000 Debtors 70,000 90,000
Bills Payable
1,70,000 20,000

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------

6,50,000
8,00,000 6,50,000
8,00,000


PART - B

(Computerised Accounting)

Qs 22. What is a Tuple? (2).

Qs 23. List the need for grouping of accounts. (2)

Qs 24. With the help of a suitable example discuss the concept of D C L. (3)

Qs 25. Differentiate ranging from Data & File. (3)

26. elaborate the effects of absence of coding? (3)

Qs 27.

a) Design a bank voucher with the subsequent info of M/s Aruna Ltd.: (3)

Date V. No Code Account Amount Rs.
31/1/07
31/1/07
31/1/07 2
2
2 711001
721001
110001 Debentures
Premium on problem
Bank 5,00,000
1,00,000
6,00,000
Prepared by Sundar Authorized by Prashant

b) M/s Aruna Ltd. employs 100 persons whose salary comprises Basic Pay, Dearness Allowance, House Rent Allowance and City Compensatory Allowance. The subsequent are the rules governing the payment.

Write the queries in SQL using the subsequent data in MS Access to calculate the allowances. (3+1)

House Rent Allowance: Rs. 3,000 up to basic pay of Rs. 10,000,
Rs. 7,000 up to basic pay of Rs. 20,000
Rs. 10,000 for basic pay above Rs. 20,000.
City Compensatory Allowance: @ 10% of basic pay subject to a minimum of Rs. 1,250.

Earning:   Approval pending.