CBSE Class 12 Accountancy Solved Question Paper (Paper Code: 67/2/3, 2020)
Time Allowed : 3 Hours
Maximum Marks : 80
Paper Code : 67/2/3(CBSE 2020)
General Instructions :
Read the following instructions very carefully and strictly follow them :
(i) This question paper comprises two Parts – A and B. There are 32 questions in the question paper. All questions are compulsory.
(ii) Part A is compulsory for all candidates.
(iii) Part B has two options i.e. (1) Analysis of Financial Statements and (2) Computerized Accounting. You have to attempt only one of the given options.
(iv) Heading of the option opted must be written on the Answer-Book before attempting the questions of that particular OPTION.
(v) Question nos. 1 to 13 and 23 to 29 are very short answer type questions carrying 1 mark each.
(vi) Question nos. 14 and 30 are short answer type–I questions carrying 3 marks each.
(vii) Question nos. 15 to 18 and 31 are short answer type–II questions carrying 4 marks each.
(viii) Question nos. 19, 20, and 32 are long answer type–I questions carrying 6 marks each.
(ix) Question nos. 21 and 22 are long answer type–II questions carrying 8 marks each.
(x) Answers should be brief and to the point. The answer of each part should be written at one place.
(xi) There is no overall choice. However, an internal choice has been provided in 2 questions of three marks, 2 questions of four marks, 1 question of six marks, and 2 questions of eight marks. You have to attempt only one of the choices in such questions.
(xii) However, separate instructions are given with each part and question, wherever necessary.
(Accounting for Not-for-Profit Organizations, Partnership Firms and Companies)
1. Nominal share capital is:
(A) That part of authorised capital which is issued by the company.
(B) The amount of capital which is actually applied by prospective shareholders.
(C) The amount of capital which is paid by the shareholders.
(D) The maximum amount of share capital that a company is authorised to issue.
Answer: (D) The maximum amount of share capital that a company is authorised to issue.
2. Swati and Aman were partners in a firm. Their fixed capitals were ₹ 9,00,000 and ₹ 3,00,000, respectively. They shared profits in the ratio of their capitals. Divya was admitted as a new partner for 1/4th share in the profits of the firm. the profits of the firm. Divya brought ₹ 60,000 as her share of goodwill premium and ₹ 6,00,000 as her capital. The amount of goodwill premium credited to Swati’s account will be:
(A) ₹ 60,000
(B) ₹ 30,000
(C) ₹ 45,000
(D) ₹ 15,000
Answer: (C) ₹ 45,000
₹ 60,000 will be divided in the old profit sharing ratio i.e. 9:3 or 3:1 between Swati and Aman, respectively.
3. Distinguish between Income and Expenditure Account and Receipts and Payments Account on the basis of ‘Closing Balance’.
Answer: Closing balance of Income and Expenditure Account represents surplus/deficit while the closing balance of Receipts and Payments Account is cash in hand, cash at bank or bank overdraft.
4. Manu and Kanu were partners in a firm, sharing profits and losses in the ratio of 2 : 3. Their fixed capitals were ₹ 10,00,000 and ₹ 5,00,000, respectively. They were entitled to an interest on capital @ 10% p.a. The firm earned a profit of ₹ 60,000 during the year. The amount of interest on capital credited to Kanu will be:
(A) ₹ 20,000
(B) ₹ 40,000
(C) ₹ 36,000
(D) ₹ 24,000
Answer: (A) ₹ 20,000
Interest on Capital of Manu =
Interest on Capital of Kanu =
Total Interest on Capital of both the partners,i.e., ₹ 1,50,000 is more than the profit earned by the firm,i.e.,₹ 60,000, therefore Interest is allowed only to the extent of profit in the ratio of interest on capital of each partner, i.e., 2 : 1.
Now, Interest on Capital of Kanu =
5. At the time of admission of a new partner in the firm, the new partner compensates the old partners for their loss of share in the superprofits of the firm for which he brings in an additional amount which is known as ___________ .
Answer: Premium for Goodwill
6. V.F. Ltd. forfeited 8,000 equity shares of ₹ 100 each, issued at a premium of 10% for non-payment of first and final call of ₹ 30 per share. The maximum amount of discount at which these shares can be reissued will be:
(A) ₹ 5,60,000
(B) ₹ 8,00,000
(C) ₹ 3,20,000
(D) ₹ 2,40,000
Answer: (A) ₹ 5,60,000
Balance in the forfeiture Account =
The maximum amount of discount on re-issue can be provided up to an extend of amount in the forfeiture Account.
7. What is meant by ‘Issue of Debentures as a Collateral Security’?
Answer: ‘Issue of Debentures as a Collateral Security’ means that the company issued debentures as secondary securities against the loan taken by the company.
8. Priya Ltd. decided to redeem its 10,000, 6% debentures of ₹ 100 each, issued at a discount of 10% redeemable at a premium of 10%. The minimum amount that is to be transferred to Debenture Redemption Reserve will be:
(A) ₹ 2,75,000
(B) ₹ 2,50,000
(C) ₹ 11,00,000
(D) ₹ 10,00,000
Answer: (B) ₹ 2,50,000
As per SEBI Guidelines, a company shall create DRR equal to 25% of the amount of debentures issued before starting the redemption process.
Therefore, in this question amount transferred to Debenture Redemption Reserve = 25% of 10,00,000 = ₹ 2,50,000.
9. ‘Interest paid on debentures is a charge against the profits of the company.’ Is this statement correct? Give reason in support of your answer.
Answer: Yes, because Interest on debentures has to be paid even in the case of loss incurred by the company.
10. From the given extracts obtained from the Receipts and Payments Account of Cheema Club for the year ended 31st March, 2019 and additional information, calculate the amount of subscription in arrears as on 31st March, 2019.
Additional Information :
The Club had 130 members paying an annual subscription of ₹ 1,000 each. Subscriptions in arrears at the beginning of the year were ₹ 16,000. 10 members paid subscriptions for 2018-19 in 2017-18.
Subscription to be received in 2018-19 = 1,30,000
Less: Subscription actually received in 2018-19 = 1,20,000
Less: Subscription in Advance = 10,000
So, there is no arrear for the subscription of 2018-19
11. The directors of Neelkamal Ltd. forfeited 70,000 equity shares of ₹ 10 each, ₹ 10 called up, for non-payment of final call of ₹ 1 per share. Half of the forfeited shares were reissued at ₹ 20 per share fully paid-up. On reissue of forfeited shares, the following amount will be transferred to the Capital Reserve Account :
(A) ₹ 70,000
(B) ₹ 1,40,000
(C) ₹ 4,20,000
(D) ₹ 3,15,000
Answer: (D) ₹ 3,15,000
Total amount in forfeiture account=
No. of shares re-issued = 35,000. So, Amount to be transferred to Capital Reserve =
12. Nidhi, Kunal and Kabir were partners in a firm, sharing profits and losses in the ratio of 2 : 3 : 5. Nidhi retired, selling her share of profits to Kunal for ₹ 30,000 and to Kabir for ₹ 50,000. The new profit-sharing ratio between Kunal and Kabir will be :
(A) 2 : 3
(B) 3 : 5
(C) 2 : 5
(D) 5 : 3
Answer: (B) 3 : 5
13. Which of the following is NOT a capital receipt?
(A) Endowment Fund
(B) Government Grants
(C) Life-Membership Fees
(D) Donations for Building
Answer: (B) Government Grants
14. How will the following information of Royal Sports Club be presented in the Income and Expenditure Account for the year ended 31st March, 2019 and its Balance Sheet as on that date?
Tournament Expenses exceed the balance in the Tournament Fund by ₹ 30,000, so this amount is debited to Income and Expenditure A/c.
From the following particulars relating to Ganesh Charitable Society, prepare a Receipts and Payments Account for the year ending 31st March, 2019:
15. Amit, Daksh and Surbhi were partners sharing profits and losses in the ratio of 5 : 3 : 2. Amit died on 30 th September, 2019. The Balance Sheet of the firm as at 31 st March, 2019 was as follows :
According to the partnership deed, in addition to the deceased partner’s capital, his executor is entitled to :
(i) Share in profits on the basis of average profits of the last two years. Profit for the year 2017-18 was ₹ 2,00,000.
(ii) His share in the goodwill of the firm. Goodwill of the firm will be valued on the basis of two years’ purchase of the average profits of the last two years.
(iii) Amit withdrew ₹ 40,000 on 31 st May, 2019.
Prepare Amit’s Capital Account to be rendered to his executor.
1. Average profit of last 2 years =
Profit up to 30th September, 2019 =
Amit’s share of profit =
2. Average profit of last 2 years =
Firm’s Goodwill =
Amit’s share of Goodwill =
₹3,00,000 will be contributed by Daksh and Surbhi in the gaining ratio 3:2.
16. From the given Receipts and Payments Account and additional information of Premier Club for the year ended 31st March, 2019, prepare Income and Expenditure Account for the year ended 31st March, 2019 and Balance Sheet as on that date.
Additional Information :
(i) On 1st April, 2018, the Club had the following balance of assets and liabilities :
Furniture and Equipment ₹ 1,80,000, Subscriptions in arrears ₹ 15,000, and Outstanding Salary ₹ 13,000.
(ii) Charge depreciation on Furniture and Equipment @ 10% p.a.
(iii) The Club had 90 members, each paying an annual subscription of ₹ 1,000.
1. Balance Sheet (opening)
2. Calculation of Depreciation:
1 April’18 – 31 March’19:
1 Oct’18 – 31 March’19:
17. Yash and Karan were partners in an interior designer firm. Their fixed capitals were ₹ 6,00,000 and ₹ 4,00,000 respectively. There were credit balances in their current accounts of ₹ 4,00,000 and ₹ 5,00,000, respectively. The firm had a balance of ₹ 1,00,000 in General Reserve. The firm did not have any liability. They admitted Radhika into a partnership for th share in the profits of the firm. The average profits of the firm for the last five years were ₹ 5,00,000. Calculate the value of goodwill of the firm by a capitalization of the average profits method. The normal rate of return in the business is 10%.
Average Profit = ₹ 5,00,000.
Capitalised Value of the Average Profit =
Capital Employed = Capital and Current account balances of both the partners and General Reserve.
Capital Employed = 6,00,000 + 4,00,000 + 4,00,000 + 5,00,000 + 1,00,000 = ₹ 20,00,000
Goodwill = Capitalised Value of the Average Profit − Capital Employed (Net Assets)
Goodwill = 50,00,000 − 20,00,000 = ₹30,00,000
Samiksha, Ash, and Divya were partners in a firm sharing profits and losses in the ratio of 5 : 3 : 2. With effect from 1st April, 2019, they agreed to share future profits and losses in the ratio of 2 : 5 : 3. Their Balance Sheet showed a debit balance of ₹ 50,000 in the Profit and Loss Account and a balance of ₹ 40,000 in the Investment Fluctuation Fund. For this purpose, it was agreed that :
(i) Goodwill of the firm is valued at ₹ 3,00,000.
(ii) Investments of the book value of ₹ 5,00,000 be valued at ₹ 4,80,000.
Pass the necessary journal entries to record the above transactions in the books of the firm.
Calculation of Sacrificing/Gaining Ratio:
Goodwill to be brought in =
Ash’s share of Goodwill =
Divya’s share of Goodwill =
18. The capital accounts of Alka and Archana showed credit balances of ₹ 4,00,000 and ₹ 3,00,000 respectively, after taking into account drawings and net profit of ₹ 2,00,000. The drawings of the partners during the year 2018-19 were:
(i) Alka withdrew ₹ 10,000 at the end of each quarter.
(ii) Archana’s drawings were :
Calculate interest on partners’ capitals @ 10% p.a. and interest on partners’ drawings @ 6% p.a. for the year ended 31st March 2019.
Calculation of Opening Capital :
Interest on Capital:
Alka’s Interest on Capital:
Archana’s Interest on Capital:
Interest on Drawing:
Alka’s Total Drawing =
Alka’s Interest on Drawing =
Archana’s Interest on Drawing:
Archana’s Interest on Drawing:
19. Prateek, Neeraj and Umang were partners in a firm, sharing profits and losses in the ratio of 7 : 2 : 1. The firm was dissolved on 31 st March, 2019. After transfer of assets (other than cash) and external liabilities to the Realisation Account, the following transactions took place :
(i) Furniture of ₹ 45,000 was sold by auction for ₹ 66,000 and the auctioneer’s commission amounted to ₹ 2,000.
(ii) Office equipment of ₹ 90,000 was taken over by creditors of the book value of ₹ 82,000 in full settlement.
(iii) Umang had given a loan of ₹ 1,09,000 to the firm. He accepted ₹ 1,00,000 in full settlement of his loan.
(iv) Investments were ₹ 53,000 out of which ₹ 23,000 was taken over by Neeraj at ₹ 25,000. Balance of the investments were sold for ₹ 35,000.
(v) Expenses incurred on dissolution were ₹ 21,000 and were paid by Prateek.
(vi) Loss on dissolution amounted to ₹ 40,000.
Pass the necessary journal entries for the above transactions in the books of the firm.
20. (i) Kati Ltd. issued 8,000, 9% debentures of ₹ 100 each at a discount of 10%. The full amount was payable on application. Applications were received for 9,000 debentures and allotment was made on a pro-rata basis.
Pass the necessary journal entries for the above transactions in the books of Kati Ltd.
(ii) Pivot Ltd. issued 40,000, 11% debentures of ₹ 100 each on 1st April, 2015. Half of the debentures were due for redemption on 31st March, 2019. The company decided to transfer the minimum required amount to Debenture Redemption Reserve on 31st March, 2018 and invested the necessary amount in Debenture Redemption Investments on 30th April, 2018.
Pass the necessary journal entries for Redemption of Debentures.
(i) Rama Ltd. took over the following assets and liabilities of Krishna Ltd. on 1st April, 2019:
Land and Building : ₹50,00,000
Furniture : ₹10,00,000
Stock : ₹5,00,000
Creditors : ₹7,00,000
The purchase consideration of ₹ 60,00,000 was paid by issuing 12% debentures of ₹ 100 each at a premium of 20%.
Pass the necessary journal entries for the above in the books of Rama Ltd.
(ii) On 1st April, 2018, Sakshi Ltd. issued 1,000, 11% Debentures of ₹ 100 each at a discount of 6%, redeemable at a premium of 5% after three years. Pass the necessary journal entries for the issue of debentures in the books of Sakshi Ltd.
(iii) On 1st April, 2016, Canara Bank issued 5,000, 9% debentures of ₹ 100 each at a premium of 6%, redeemable on 31st March, 2019, at a premium of 10%. The issue was fully subscribed.
Pass the necessary journal entries for redemption of debentures in the books of Canara Bank.
21. V.D. Ltd. invited applications for issuing 2,00,000 equity shares of ₹ 10 each at a premium of ₹ 6 per share. The amount per share was payable as follows :
On application – ₹ 3 (including premium ₹ 1)
On allotment – ₹ 7 (including premium ₹ 5)
On first and final call – Balance amount
Applications were received for 2,50,000 shares. Applicants for 10,000 shares were sent letters of regret and application money returned to them. Shares were allotted to the remaining applicants on a pro-rata basis. Money overpaid on application was adjusted towards the sums due on allotment. The company received all the money due on allotment except from Agam,who was allotted 1,000 shares. Her shares were forfeited immediately after allotment. Afterwards, the first and final call was made. Seema, the holder of 2,000 shares, did not pay the first and final call on her shares. Her shares were also forfeited. 50% of the forfeited shares, each of Agam and Seema, were reissued as fully paid-up @ ₹ 16 per share.
Pass the necessary journal entries to record the above transactions in the books of V.D. Ltd.
1. Calculating Agam’s Calls-in-Arrear:
Agam from Category A failed to pay Allotment money:
No. of shares applied by him = x
No. of shares allotted to him = 1,000 shares
therefore, x = shares
Advance paid by him at the time of application =
Amount payable by him on allotment =
so, Calls-in-Arrears of Agam=7,000−600 = ₹6,400.
2. Calculating Seema’s Calls-in-Arrear:
Calls-in-Arrears of Seema =
Konark Ltd. invited applications for issuing 3,00,000 shares of ₹ 10 each. The amount per share was payable as follows: ₹ 3 on application, ₹ 3 on allotment, and ₹ 4 on the first and final call. The company received applications for 4,00,000 shares. Allotment was done as follows :
(i) Applicants of 2,40,000 shares were allotted 2,00,000 shares.
(ii) Applicants of 1,20,000 shares were allotted 80,000 shares.
(iii) Remaining applicants were allotted 20,000 shares.
Money overpaid on applications was adjusted towards sums due on allotment. Divij, a shareholder, belonging to group (ii), who had applied for 6,000 shares, failed to pay allotment and call money. Faisal, another shareholder, who was allotted 10,000 shares, paid the call money along with the allotment. Faisal belonged to group (i). Divij’s shares were forfeited after the first and final call. Half of the forfeited shares were reissued @ ₹ 10 per share fully paid.
Pass the necessary journal entries to record the above transactions in the books of the company.
1. Calculating Divij’s Calls-in-Arrear:
Divij from Category (i) failed to pay Allotment money:
No. of shares applied by him = 6,000 shares
No. of shares allotted to him = x
therefore, x =
Advance paid by him at the time of application =
The actual amount payable by him on allotment =
so, Calls-in-Arrears of Divij = 12,000−6,000 = ₹ 6,000.
2. Calls-in-Advance paid by Faisal =
22. Madhuri and Arsh were partners in a firm sharing profits and losses in the ratio of 3 : 1. Their Balance Sheet as at 31st March, 2019, was as follows :
On 1st April, 2019, they admitted Jyoti into a partnership for th share in the profits of the firm. Jyoti brought proportionate capital and ₹40,000 as her share of the goodwill premium. The following terms were agreed upon :
(i) Provision for doubtful debts was to be maintained at 10% on debtors.
(ii) Stock was undervalued by ₹ 10,000.
(iii) An old customer whose account was written off as bad, paid ₹ 15,000.
(iv) 20% of the investments were taken over by Arsh at book value.
(v) Claim on account of workmen’s compensation amounted to ₹ 70,000.
(vi) Creditors included a sum of ₹ 27,000 which was not likely to be claimed.
Prepare the Revaluation Account, Partners’ Capital Accounts, and the Balance Sheet of the reconstituted firm.
1. Calculation of Sacrificing Ratio:
Sacrificing ratio of Madhuri =
Sacrificing ratio of Arsh =
So, Sacrificing ratio of Madhuri and Arsh = 3 : 1
2. Calculation of Proportionate Capital of New Partner:
Adjusted Capital of Madhuri and Arsh = 3,60,000 + 1,98,000 = ₹5,58,000
Total Capital of the New firm =
Proportionate Capital of Joyti =
Anita, Gaurav and Sonu were partners in a firm sharing profits and losses in proportion to their capitals. Their Balance Sheet as at 31st March, 2019 was as follows :
On the above date, Anita retired from the firm and the remaining partners decided to carry on the business. It was agreed to revalue the assets and reassess the liabilities as follows:
(i) Goodwill of the firm was valued at ₹ 3,00,000 and Anita’s share of goodwill was adjusted in the capital accounts of the remaining partners, Gaurav and Sonu.
(ii) Land and Building was to be brought up to 120% of its book value.
(iii) Bad debts amounted to ₹ 20,000. A provision for doubtful debts was to be maintained at 10% on debtors.
(iv) Market value of investments was ₹ 1,10,000.
(v) ₹ 1,00,000 was paid immediately by cheque to Anita out of the amount due and the balance was to be transferred to her loan account which was to be paid in two equal annual instalments along with interest @ 10% p.a.
Prepare the Revaluation Account, Partners’ Capital Accounts and the Balance Sheet of the reconstituted firm on Anita’s retirement.
1. Calculation of New Ratio and Gaining Ratio:
New Ratio of Gaurav and Sonu = 2 : 1
Gaining Ratio of Gaurav =
Gaining Ratio of Sonu =
Gaining Ratio of Gaurav and Sonu = 2 : 1
2. Calculation of value of Debtors:
Debtors = 1,50,000 − 20,000 = ₹ 1,30,000
Creating Provision for Doubtful Debts:
Provision for Doubtful Debts =
3. Calculation of Share of Goodwill of Anita:
Anita’s Share of Goodwill =
Goodwill to be paid by Gaurav =
Goodwill to be paid by Sonu =
(a) Bad Debts worth ₹ 10,000 is adjusted against the Provision for Doubtful Debts.
(b) Decrease in value of investment is adjusted against the Investment Fluctuation Fund.
(Analysis of Financial Statements)
23. While preparing Cash Flow Statement, cash comprises __________ and __________ with bank.
Answer: While preparing Cash Flow Statement, cash comprises Cash in hand and demand deposits with bank.
24. ‘Forfeited Shares Account’ appears in the Balance Sheet of the company under the subhead:
(A) Reserves and Surplus
(B) Long-term Provisions
(C) Share Capital
(D) Other Current Liabilities
Answer: (C) Share Capital
25. Which of the following is NOT presented under ‘Current Liabilities’ in the Balance Sheet of a company?
(A) Short-term Borrowings
(B) Deferred Tax Liabilities
(C) Short-term Provisions
(D) Trade Payables
Answer: (B) Deferred Tax Liabilities
26. ‘Sale of goods on credit for ₹ 67,000 will increase the Gross Profit Ratio.’ Is this statement correct ? Give reason in support of your answer.
Answer: No Change because Sale of goods on credit will not affect the Gross profit ratio, as the sales and gross profit will increase by the same percentage.
27. ‘An investment normally qualifies as a cash equivalent only when it has a maturity of three months or more from the date of acquisition.’ Is this statement correct? Give reason in support of your answer.
Answer: False, because an investment qualifies as a cash equivalent only when it has a maturity of three months or less from the date of acquisition.
28. Z Ltd. purchased a building for ₹ 50,00,000 from J Ltd., paying 40% by the issue of 9% debentures and the balance by cheque. The above transaction will result in:
(A) Cash used in investing activities ₹ 20,00,000.
(B) Cash generated from financing activities ₹ 20,00,000.
(C) Decrease in cash and cash equivalents ₹ 20,00,000.
(D) Cash used in investing activities ₹ 30,00,000.
Answer: (D) Cash used in investing activities ₹ 30,00,000.
29. Which of the following is NOT a limitation of ‘Financial Statements Analysis’?
(A) It is affected by personal bias.
(B) Inter-firm comparative study possible.
(C) Lack of qualitative analysis.
(D) Ignores price level changes.
Answer: (B) Inter-firm comparative study possible.
30. From the following information obtained from the books of P. Ltd., calculate, (i) Return on Investment, and (ii) Debt Equity Ratio:
Information: Net Profit after interest and tax ₹ 6,00,000; 6% Debentures ₹ 10,00,000;
Capital employed ₹ 20,00,000, and Tax rate 40%.
Net Profit before Tax =
Tax Payable =
Net Profit before Tax and interest = 6,00,000 + 4,00,000 + 60,000 = ₹10,60,000
Return on Investment =
2. Debt-Equity Ratio =
Equity = Capital Employed – Debt
= 20,00,000 – 10,00,000
Equity = ₹10,00,000
Debt-Equity Ratio =
(i) Current Liabilities ₹ 1,50,000, Current Assets ₹ 2,80,000, Inventories ₹ 40,000, Advance Tax ₹ 30,000, and Prepaid Rent ₹ 10,000. Calculate Quick Ratio.
Quick Ratio =
Liquid Asset = Current Assets − Inventory − Prepaid Expenses
Liquid Assets = 2,80,000 − 40,000 − 40,000 = ₹ 2,00,000
Quick Ratio = = 4:3 or 1.33:1
(ii) Average Inventory ₹ 60,000, Revenue from Operations ₹ 6,00,000, the rate of Gross Loss on Sales is 10%. Calculate the Inventory Turnover Ratio.
Inventory Turnover Ratio =
Cost of Revenue from Operation = Sales + Gross Loss
Cost of Revenue from Operation =
Inventory Turnover Ratio =
31. From the following particulars obtained from the books of Mark Ltd., prepare a Comparative Statement of Profit and Loss:
From the following Balance Sheet of Swaraj Ltd., as at 31st March, 2019, prepare a common-size Balance Sheet:
32. Cash flow from the operating activities of Pinnacle Ltd. for the year ended 31st March, 2019 was ₹ 28,000. The Balance Sheet along with notes to accounts of Pinnacle Ltd. as at 31st March, 2019 is given below:
You are given the following additional information :
(i) A machinery of a book value of ₹ 90,000 (depreciation provided thereon was ₹ 23,000), was sold at a profit of ₹ 12,000.
(ii) 9% debentures were issued on 1st April, 2018.
Prepare the Cash Flow Statement.
23. A ___________ voucher is used for adjustment of non-cash transaction in the ledger.
Answer: A Journal voucher is used for adjustment of non-cash transactions in the ledger.
24. A code which consists of alphabet or abbreviation as symbol to codify a piece of information is known as ___________ code.
Answer: A code which consists of alphabet or abbreviation as a symbol to codify a piece of information is known as Mnemonic code.
25. The ___________ provides real power to database in terms of its capacities to answer complex requests involving data to be taken from ___________tables.
Answer: The Query provides real power to database in terms of its capacity to answer complex requests involving data to be taken from Multiple tables.
26. Hardware refers to:
(A) System software and application software.
(B) Computer-associated peripherals and their network.
(C) A logical sequence of actions to perform a task.
(D) All of the above.
Answer: (B) Computer-associated peripherals and their network.
27. To safeguard assets and optimise the use of resources, a business:
(A) Keeps internal controls.
(B) Only tries to achieve maximum revenue.
(C) Only ensures accurate accounting records.
(D) Only safeguards assets.
Answer: (A) Keeps internal controls.
28. The existence of data in a ‘primary key’ field is:
(A) Not necessarily required.
(B) Required but need not be unique.
(C) Required and must be unique.
(D) All of the above.
Answer: (C) Required and must be unique.
29. A ##### error appears when:
(A) A negative data is used.
(B) Column is not wide enough.
(C) Negative time is used.
(D) All of the above.
Answer: (D) All of the above.
30. What information is provided by a salary bill?
Answer: A Salary Bill provides the following information:
1. Information related to Employee like Employee’s Name, Number, Attendance, Designation and other details.
2. Dates of Pay Period for which salary bill has been generated.
3. Detailed information about Gross Salary and Net Salary (Showing all the deductions applicable).
4. Employer’s information like Name and contact details, taxes details, if any.
5. Details about the Medical Benefits provided to employees on monthly basis.
6. Detailed information about the incentives or bonuses provided to employees as appreciation for a worker’s efforts.
List the various attributes of a ‘payroll’ database.
Answer: The various attributes of a ‘payroll’ database includes:
1. Employee details: Name, Payroll Number, Designation, Location.
2. Working Hours: Payroll gives details of hours that the employees have worked to accurately calculate the salary.
3. Salary and wages: Payroll shows the salary and wages of the employees along with other benefits like incentives, medical benefits, and so on.
4. Time-Off: Payroll keeps a track of leaves and vacations of employees.
5. Payroll Taxes: Taxes deducted from the salary and wages.
6. Gross and Net Salary: Payroll shows the gross salary and Take-Home salary of the employees.
31. Explain ‘closing entry’ and ‘adjustment entry’ with the help of examples.
Answer: The closing Entry is a journal entry passed for transferring the data of Trial Balance to the Trading and Profit and Loss Account.
Example: Purchase Return Account is closed by transferring the balance to the Purchase Account.
An adjustment Entry is a journal entry passed at the end of the accounting period to have accurate balances of the accounts.
Example: Depreciation on Plant to be charged @ 10% per annum. The adjustment entry at end of the accounting period shall be:
Explain any four advantages expected by the user for paying high price for a chosen server database.
Four Advantages of a chosen server database:
1. Scalability: Server database can store a large amount of data and is, therefore, suitable for large-scale applications.
2. Performance: Server database is highly efficient to handle complex queries and large-scale data.
3. Security: Server database ensures various security measures like user authentication and encryption protection. etc.
4. Flexibility: Server database provide access to data from anywhere and anytime, providing flexibility to access.
32. Deepshikha Ltd. has its offices in Jaipur and Satara. HRA for Jaipur is ₹ 8,000 and for Satara is ₹ 6,000. DA is calculated on Basic Pay (BP) as 8% for BP ≤ ₹ 10,000 and 6% for BP ≤ ₹ 18,000. Standard number of days are taken as 30 days per month.
Give the formulae and calculate the amount of Gross Salary using Excel for the following employees :
(i) Jagat is working in Jaipur office. His Basic Pay is ₹ 25,000. Out of the sick leave allowed by the company, he has availed sick leave for five days.
(ii) Reeta is working in Satara office. Her Basic Pay is ₹ 9,500. She has availed sick leave for two days.
Employee Name = A1
HRA = B1
Basic Pay = C1
DA = D1
1. Calculation of DA:
DA = If (C1 ≥ ₹25,000, 6%, 8% ) * C1
= If (C1 ≤ ₹30,000, 8%, 6% ) * C1
Jagat DA = ₹1,500
Gross Salary = ₹15,000 + ₹8,000 + ₹25,000
(No salary will be deducted as leave without pay is not mentioned)
Reeta DA = ₹700
Gross salary = ₹16,260/-
(No salary will be deducted as leave without pay is not mentioned)
Please Login to comment...