Advertisements
Advertisements
What is the use of UPDATE command in SQL?
Concept: undefined > undefined
Name the DBMS language component which can be embedded in a programme.
Concept: undefined > undefined
Advertisements
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:
| Cash Book (Bank Column) (extract) | |||
| Particulars | Amount (₹) | Particulars | Amount (₹) |
| To Share Application A/c | 4,80,000 | By Balance c/d | ______ |
| To Share Allotment A/c | ______ | ||
| Share Capital A/c (extract) | |||
| Particulars | Amount (₹) | Particulars | Amount (₹) |
| To Share Forfeiture A/c | ______ | By Share Application A/c | ______ |
| To Call-in arrears A/c | ______ | By Share Allotment A/c | 4,00,000 |
| By Share Final Call A/c | ______ | ||
| Calls-in-Arrears A/c (extract) | |||
| Particulars | Amount (₹) | Particulars | Amount (₹) |
| To Share Allotment A/c | 6,000 | ||
- What are the number of shares applied for by the public?
- What is the amount payable per share with application?
- What is the amount payable per share with first and final call?
- 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?
- 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:- Forfeiture of these shares
- Reissue of the forfeited shares
Concept: undefined > undefined
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:
- The formula to calculate the percentage change in net profit of the company.
- 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.
Concept: undefined > undefined
Calculate the Operating Ratio of Zen Ltd. (up-to two decimal places) from the following information:
| Particulars | (₹) |
| Revenue from Operations | ₹ 9,00,000 |
| Gross Profit | 20% of cost |
| Operating Expenses | ₹ 60,000 |
Concept: undefined > undefined
The fill function can be ______ to complete formulas in a range.
Concept: undefined > undefined
Give any two reasons to show that a blank space or zero is not the same as NULL value in SQL.
Concept: undefined > undefined
What are the SQL statements used in Database testing to manipulate the test table?
Concept: undefined > undefined
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.
Concept: undefined > undefined
Answer briefly of the following question :
Give the formula for valuation of goodwill by the Capitalisation of Average Profit Method.
Concept: undefined > undefined
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).
Concept: undefined > undefined
On 1st 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.
Concept: undefined > undefined
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.
Concept: undefined > undefined
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:
| Particulars | (₹) |
| (i) Tax provided during the year | 4,000 |
| (ii) Amortization of Patents | 10,000 |
| (iii) Profit on sale of Vehicle | 3,000 |
| (iv) Writing off Preliminary expenses | 2,000 |
| During the year, machinery costing ₹ 40,000 (accumulated depreciation thereon being ₹ 18,000) was sold for ₹ 6,000. |
|
| 31.03.2021 (₹) | 31.03.2020 (₹) | |
| Trade Receivable | 20,000 | 16,000 |
| Inventory | 12,000 | 15,000 |
| Cash at Bank | 8,000 | 10,000 |
| Trade Payable | 9,000 | 11,000 |
| Marketable Securities | 5,000 | 2,000 |
| Plant & Machinery | 88,000 | 1,30,000 |
Concept: undefined > undefined
How is index hunting helpful?
Concept: undefined > undefined
Give any two measures to achieve index hunting.
Concept: undefined > undefined
Give the difference between data and information along with an example.
Concept: undefined > undefined
Which one of the following terms is NOT related to computerised databases?
Concept: undefined > undefined
Which formula will capture the correct number of numerical values from the following range?
A2 : A5 & C2 : C5
Concept: undefined > undefined
Give the meaning of the MODE Junction in Excel with an example.
Concept: undefined > undefined
