ISC (Commerce) इयत्ता १२ - CISCE Question Bank Solutions for Accounts

What is the use of UPDATE command in SQL?

Name the DBMS language component which can be embedded in a programme.

Stem Ltd. came up with an IPO inviting the public to subscribe to its Equity shares of ₹ 10 each. The issue was over-subscribed. The company allotted 80,000 shares to all the applicants making a pro-rata allotment in the ratio of 3 : 2. The face value of the share was payable in three instalments.

Based on the information given above and the following extract of ledger accounts and Cash Book (Bank Column), answer the questions that follow:

1. What are the number of shares applied for by the public?
2. What is the amount payable per share with application?
3. What is the amount payable per share with first and final call?
4. Stem Ltd. did not receive the allotment money and call money due from the shareholder Rehan, who had applied for 3,000 shares. What is the amount received by Stem Ltd. with allotment?
5. Stem Ltd. forfeited Rehan’s shares after the final call. It reissued 1,500 forfeited shares fully called up @ ₹ 13 per share
   Give the journal entries passed by the company for:
   1. Forfeiture of these shares
   2. Reissue of the forfeited shares

Jubilant Food Works Ltd., the company that operates Domino’s restaurants in India, reported a net profit of ₹ 65.7 crore for the three months ending, 31st December, 2023, against ₹ 80 crore for the three months ending, 31st December, 2022.

You are required to give, for the three months ending, 31st December, 2023, as compared to the same period ending, 31st December, 2022:

1. The formula to calculate the percentage change in net profit of the company.
2. The percentage change in the net profit of Jubilant Food Works Ltd. of the three months ending 31st December, 2023 vis-a-vis the three months ending, 31st December, 2022, mentioning the increase/decrease.

Calculate the Operating Ratio of Zen Ltd. (up-to two decimal places) from the following information:

The fill function can be ______ to complete formulas in a range.

Give any two reasons to show that a blank space or zero is not the same as NULL value in SQL.

What are the SQL statements used in Database testing to manipulate the test table?

Answer briefly of the following question :

Give the adjusting entry and closing entry for interest on loan taken by a partner from the firm, when the firm
follows the Fluctuating Capital Method.

Answer briefly of the following question :

Give the formula for valuation of goodwill by the Capitalisation of Average Profit Method.

On 1st April, 2013, Rayon Ltd. issued 2,000, 9% Debentures of 100 each at a discount of 10%, redeemable
at par on 31st March, 2017. The issue was fully subscribed. To meet the provisions of the Companies Act,
2013, the Board of Directors decided to transfer  30,000 to Debenture Redemption Reserve on 31st March,
2014, and the balance on 31st March, 2015. On 1st April, 2016, the company made the required investment in
government securities.

The investments were encashed and the debentures were redeemed on the due date.
It is the policy of the company to write off capital losses in the year in which they occur.
You are required to pass journal entries for issue and redemption of debentures (ignore interest on
debentures).

On 1^st April, 2016, Krayon Ltd. issued 8,000. 12% Debentures of Rs. 100 each, redeemable at par after 5 years.
The issue was fully subscribed.
According to the terms of issue, interest on debentures is payable annually on 31st March. Tax deducted at
source is 20%.
You are required to pass journal entries for the year 2016-17, regarding issue of debentures and interest on
debentures.

The Quick Ratio of a company is 0.8:1. State whether the Quick Ratio will improve, decline or will not change in the
following cases:
(i) Cash collected from Debtors Rs. 50,000.
(ii) Creditors of Rs. 20,000 paid off.

From the following extracts of a company’s Balance Sheets, and the additional information, you are required to calculate Cash from Operating Activities for the year ending 31st March, 2021.

Anjan Ltd. reported a profit of ₹ 80,000 for the year ended 31st March, 2021, after considering the following:

How is index hunting helpful?

Give any two measures to achieve index hunting.

Give the difference between data and information along with an example.

Which one of the following terms is NOT related to computerised databases?

Which formula will capture the correct number of numerical values from the following range?

A2 : A5 & C2 : C5

Give the meaning of the MODE Junction in Excel with an example.