Loading Solved Paper…
Preparing the paper for your device
320
NIOS Senior Secondary 100% Curricular Audit Verified

Accountancy (लेखांकन 320)

Official Examination Solutions • Verified Scheme

Accountancy (320)
Complete Solved Question Paper

Exhaustively solved examination solutions adhering strictly to the NIOS Senior Secondary Accountancy curriculum. Features full journal entries, ledger accounts, cash flow statements, and comprehensive dual-solutions for all internal choice (OR) questions across both Section A and both Optional Modules in Section B.

Time: 3 Hours Max Marks: 100 Total: 47 Questions Includes Both Modules I & II
100/100 Scoring Target 47 Questions
14 MCQs (Sec A)
10 Objectives
9 Short & VSA
3 Long (5M)

General Examination Instructions & Paper Scheme

Click to expand/collapse candidate guidelines and marking pattern

Instructions for Candidates:

  1. Candidate must write his/her Roll Number on the first page of the Question Paper.
  2. Please check the Question Paper to verify that the total pages (12 printed pages) and total number of questions (47 questions) contained in the Question Paper are the same as those printed on the top of the first page.
  3. Making any identification mark in the Answer-Book or writing Roll Number anywhere other than the specified places will lead to disqualification.
  4. Write your Question Paper Code No. 71/SS/320, Set A1 on the Answer-Book.
  5. The question paper consists of two sections: Section A (Q. 1 to 36, Compulsory) and Section B (Q. 37 to 47, consisting of Optional Module I: Analysis of Financial Statements OR Optional Module II: Application of Computers in Financial Accounting). Both modules are solved in full here.
Section-wise Mark Distribution
  • • Section A (Q. 1 to 14): MCQs (1 Mark each = 14 Marks)
  • • Section A (Q. 15 to 20): Objectives (2 Marks each = 12 Marks)
  • • Section A (Q. 21 to 24): Multi-part Short (4 Marks each = 16 Marks)
  • • Section A (Q. 25 to 28): Short VSA (2 Marks each = 8 Marks)
  • • Section A (Q. 29 to 33): Short Questions (3 Marks each = 15 Marks)
  • • Section A (Q. 34 to 36): Long Questions (5 Marks each = 15 Marks)
  • • Section B (Q. 37 to 47): Optional Module (20 Marks total)
  • • Total Marks: 100 Marks (47 Questions)
Examination Timing

Reading Period: 15 minutes allotted (2:15 p.m. to 2:30 p.m.) for reading only.
Writing Duration: 3 Hours (2:30 p.m. to 5:30 p.m.). All answers must be written sequentially in the provided Answer-Book.

SECTION A

Multiple Choice Questions (1 to 14)

[14 × 1 = 14 Marks]
Q. 01 Accounting Basics • Source Documents
[1 Mark]

______ is a documentary evidence in support of a transaction.

(A) Accounting Equation
(B) Ledger
(C) Journal
(D) Voucher
Verified Answer • Option (D)

Ans. (D) Voucher
Curricular Justification: A voucher is a written documentary evidence prepared by the accountant and verified by authorized signatories confirming the authenticity and business justification of an economic transaction.

Q. 02 Accounting Equation
[1 Mark]

Which equation is correct out of the following?

(A) Liabilities = Assets + Capital
(B) Assets = Capital - Liabilities
(C) Assets = Capital + Liabilities
(D) Capital = Assets + Liabilities
Verified Answer • Option (C)

Ans. (C) Assets = Capital + Liabilities
Curricular Justification: The fundamental accounting equation is based on the dual aspect principle: all resources owned by the business (Assets) are financed either by owners (Capital) or external creditors (Liabilities).

Q. 03 Trial Balance • Suspense Account
[1 Mark]

If a trial balance doesn't agree, then which account is opened in order to reconcile the trial balance?

(A) Profit and loss account
(B) Suspense account
(C) Goodwill account
(D) Capital reserve account
Verified Answer • Option (B)

Ans. (B) Suspense account
Curricular Justification: When a Trial Balance fails to balance due to one-sided errors, the difference is temporarily transferred to a newly opened Suspense Account to facilitate finalization of accounts pending error location.

Q. 04 Rectification of Errors
[1 Mark]

Sales Book has been undercast by ₹1,000. This error will be rectified by:

(A) Crediting Suspense A/c by ₹1,000 and debiting sales A/c by ₹1,000
(B) Debiting Suspense A/c by ₹1,000 and Crediting sales A/c by ₹1,000
(C) Crediting Suspense A/c by ₹2,000 and debiting sales A/c by ₹2,000
(D) Debiting Suspense A/c by ₹2,000 and Crediting sales A/c by ₹2,000
Verified Answer • Option (B)

Ans. (B) Debiting Suspense A/c by ₹1,000 and Crediting sales A/c by ₹1,000
Curricular Justification: The Sales Book has a normal credit balance. An undercasting means the credit side of Sales Account is short by ₹1,000. To rectify, we credit Sales Account by ₹1,000 and debit Suspense Account by ₹1,000.

Q. 05 NPO • Income and Expenditure Account
[1 Mark]

Which of the following is correct about 'Income and Expenditure Account' of a Not-for-Profit Organisation?

(A) The excess of the income over expenditure is called net profit.
(B) Specific donation is an item of revenue nature.
(C) Entrance fees is an item of income.
(D) All items of receipts are recorded on income side of Income and Expenditure Account...
Verified Answer • Option (C)

Ans. (C) Entrance fees is an item of income
Curricular Justification: In standard accounting practice for NPOs, entrance fees are treated as recurring revenue receipts and credited to the Income and Expenditure Account as income (unless specific instructions state it must be capitalized).

Q. 06 Financial Statements • Trading Account
[1 Mark]

Which of the following items is not shown in Trading Account?

(A) Wages
(B) Fuel and Power
(C) Carriage inwards
(D) Bad debts
Verified Answer • Option (D)

Ans. (D) Bad debts
Curricular Justification: Wages, Fuel and Power, and Carriage Inwards are direct operating expenses related to production and purchase of goods shown in the Trading Account. Bad debts are an indirect selling/financial loss debited to Profit & Loss Account.

Q. 07 NPO • Receipts & Payments Account
[1 Mark]

Which of the following is an item of 'Payments' while preparing Receipts and Payments Account of a Not-for-Profit Organisation?

(A) Stationery
(B) Donation
(C) Entrance fees
(D) Life membership fees
Verified Answer • Option (A)

Ans. (A) Stationery
Curricular Justification: Donations, entrance fees, and life membership fees represent cash receipts (inflows). Payment for purchasing stationery is a cash outflow recorded on the credit (payment) side of Receipts and Payments Account.

Q. 08 Dissolution of Partnership Firm
[1 Mark]

On dissolution of the firm, amount received from sale of unrecorded asset is credited to:

(A) Partners Capital Accounts
(B) Profit and Loss Account
(C) Realisation Account
(D) Cash Account
Verified Answer • Option (C)

Ans. (C) Realisation Account
Curricular Justification: When any asset (recorded or unrecorded) is realized in cash upon dissolution, the accounting entry is: Cash/Bank A/c Dr. to Realisation A/c. Realisation Account is credited with the proceeds.

Q. 09 Dissolution • Transfer of Accounts
[1 Mark]

Which of the following is transferred to Realisation Account?

(A) Balance of Cash Account
(B) Balances of Reserves
(C) Balance of Profit & Loss Account
(D) Balances of Assets Accounts other than Cash and Cash at Bank.
Verified Answer • Option (D)

Ans. (D) Balances of Assets Accounts other than Cash and Cash at Bank
Curricular Justification: Cash/Bank accounts maintain their own separate closing ledger account. Reserves and P&L balances are transferred directly to Partners' Capital Accounts. All other realizable assets are transferred to the debit of Realisation Account at book values.

Q. 10 Goodwill Nature
[1 Mark]

Which of the following is true in relation to goodwill?

(A) Goodwill is a fictitious asset.
(B) Goodwill is a current asset.
(C) Goodwill is a wasting asset.
(D) Goodwill is an intangible asset.
Verified Answer • Option (D)

Ans. (D) Goodwill is an intangible asset
Curricular Justification: Goodwill is a real asset with real earning power and realizable value, but it lacks physical substance. Hence, it is an intangible non-current asset (not a fictitious asset like preliminary expenses).

Q. 11 Admission of Partner • Premium for Goodwill
[1 Mark]

When a new partner brings his share of goodwill premium in cash, the amount is debited to:

(A) Goodwill Account
(B) Capital Account of the new partner
(C) Cash Account
(D) Capital Accounts of the old partners
Verified Answer • Option (C)

Ans. (C) Cash Account
Curricular Justification: On receipt of premium for goodwill in cash, the journal entry is: Cash/Bank A/c Dr. to Premium for Goodwill A/c. Therefore, the amount is debited to Cash/Bank Account.

Q. 12 Company Accounts • Share Capital
[1 Mark]

The first instalment which the applicants have to pay along with the application for shares is known as:

(A) Allotment money
(B) Application money
(C) Call money
(D) Calls in advance money
Verified Answer • Option (B)

Ans. (B) Application money
Curricular Justification: Application money is the statutory initial sum paid by potential investors when applying for shares offered by a company.

Q. 13 Company Accounts • Forfeiture of Shares
[1 Mark]

Shares can be forfeited:

(A) for non-payment of call money.
(B) for failure to attend meetings.
(C) for failure to repay the loan to the bank.
(D) for pledging the shares as a security.
Verified Answer • Option (A)

Ans. (A) for non-payment of call money
Curricular Justification: Under the Companies Act and Articles of Association, a company has the legal right to cancel and forfeit shares only if a shareholder defaults on paying allotment or call money after being given due statutory notice.

Q. 14 Accounting for Forfeiture Calculation
[1 Mark]

An equity share of ₹10 on which ₹8 had been called but ₹6 had been received was forfeited, the share capital account was debited by :

(A) ₹10
(B) ₹8
(C) ₹6
(D) ₹2
Verified Answer • Option (B)

Ans. (B) ₹8
Curricular Justification: At the time of forfeiture of shares, Share Capital Account is debited with the called-up value per share (here ₹8), Share Forfeiture A/c is credited with the amount already received (₹6), and Calls in Arrears A/c is credited with the unpaid amount (₹2).

SECTION A (PART II)

Objective Questions (15 to 20)

[6 × 2 = 12 Marks]
Q. 15 [2 Marks]

Fill in the blanks :
Increase in the value of an asset is ______ and decrease in the value of an asset is ______.

Complete Solved Statement

Increase in the value of an asset is debited and decrease in the value of an asset is credited.
Note: In revaluation of assets, increase is credited to Revaluation A/c and decrease is debited to Revaluation A/c. In the Asset account itself, increase is debited and decrease is credited.

Q. 16 [1 + 1 = 2 Marks]

Give one word answer for the following:
(i) Which basis of accounting is not recognized by Companies Act 2013?
(ii) It is a book of account in which all types of accounts relating to assets, liabilities, capital, expenses and revenue are maintained.

(i) Cash basis of accounting (Companies Act 2013 mandates the Accrual / Mercantile basis).
(ii) Ledger (Principal Book of Accounts).

Q. 17 [2 Marks]

Complete the following sentence:
The commonly used output devices include monitor also called ______ and ______.

The commonly used output devices include monitor also called VDU (Visual Display Unit) and Printer (or Speakers / Plotter).

Q. 18 [1 + 1 = 2 Marks]

Give one word answer of the following:
(i) The software available off the shelf is modified to suit the requirements of the user.
(ii) The errors which are rectified through suspense account are ______ .

(i) Customised software (अनुकूलित सॉफ्टवेयर).
(ii) One-sided errors (एकपक्षीय अशुद्धियाँ / Errors affecting the Trial Balance).

Q. 19 [1 + 1 = 2 Marks]

Give one word answer for the following:
(i) Revaluation account is credited for recording the value of an unrecorded :
(ii) Name the asset that is not transferred to the debit side of realization Account, but brings certain amount of cash against its disposal at the time of dissolution of the firm.

(i) Asset (Unrecorded Asset).
(ii) Unrecorded Asset.

Q. 20 [1 + 1 = 2 Marks]

Fill in the blanks:
(i) The remaining partners acquire the retiring partner's share in ______ ratio.
(ii) On dissolution, if a partner undertakes to make payment of a liability of the firm ______ account is debited.

(i) The remaining partners acquire the retiring partner's share in Gaining ratio (लाभ-प्राप्ति अनुपात).
(ii) On dissolution, if a partner undertakes to make payment of a liability of the firm Realisation account is debited (Entry: Realisation A/c Dr. to Partner's Capital A/c).

SECTION A (PART III)

Applied Short Questions (21 to 24)

[4 × 4 = 16 Marks]
Q. 21 [4 Marks]

Write the names of the affected accounts for the following transactions while preparing accounting equation:

  • (i) Commission received ₹40,000
  • (ii) Purchased goods on credit from Atul ₹25,000
  • (iii) Sold furniture to Asha ₹4,000
  • (iv) Rent paid by cheque ₹6,000
Affected Accounts & Dual Effects:
S.No. Transaction Affected Accounts Effect on Accounting Equation
(i) Commission received ₹40,000 Cash A/c and Capital A/c Cash (Asset) increases (+40,000); Capital increases (+40,000)
(ii) Purchased goods on credit from Atul ₹25,000 Stock (Goods) A/c and Creditors (Atul) A/c Stock (Asset) increases (+25,000); Creditors (Liability) increases (+25,000)
(iii) Sold furniture to Asha ₹4,000 Debtors (Asha) A/c and Furniture A/c Debtors (Asset) increases (+4,000); Furniture (Asset) decreases (-4,000)
(iv) Rent paid by cheque ₹6,000 Bank A/c and Capital A/c Bank (Asset) decreases (-6,000); Capital decreases (-6,000)
Q. 22 [4 Marks]

Give a name of the accounting error for the following transactions:

  • (i) Vidushi has been debited by ₹600 instead of ₹60 and Yashika has been debited by ₹60 instead of ₹600.
  • (ii) Amount spent on repairs of an old machine debited to Machinery A/c.
  • (iii) Purchases book has been overcast by ₹5,000.
  • (iv) Purchases for ₹30,000 was not entered in the purchases book.
Classification of Errors:
  1. (i) Compensating Error (क्षतिपूरक अशुद्धि): The excess debit of ₹540 in Vidushi's account is counter-balanced by the short debit of ₹540 in Yashika's account.
  2. (ii) Error of Principle (सैद्धान्तिक अशुद्धि): Revenue expenditure on ordinary repairs has been wrongly capitalized as capital expenditure.
  3. (iii) Error of Commission (हिसाब की अशुद्धि / Casting Error): Arithmetical totaling mistake in a subsidiary book.
  4. (iv) Error of Complete Omission (पूर्ण भूल की अशुद्धि): The transaction was completely omitted from original entry in the books.
Q. 23 [4 Marks]

Answer the following questions in one word / brief:

  • (i) On which side of the Balance Sheet loan item appearing on the receipts side of Receipts and Payments Account will be shown?
  • (ii) Name the term used for debts which cannot be recovered.
  • (iii) Sundry debtors are ₹30,000, provision for Doubtful debts is required at 5%. Calculate the amount of Provision for Doubtful debts to be created.
  • (iv) Depreciation is shown on which side of Profit and Loss Account?

(i) Liabilities side (Loan taken is a capital receipt creating an obligation).
(ii) Bad Debts (डूबत ऋण).
(iii) ₹1,500 (\(\text{Calculation: } 30,000 \times \frac{5}{100} = ₹1,500\)).
(iv) Debit side (As an indirect operating expense).

Q. 24 [4 Marks]

Give one word answer for the following:

  • (i) After the reissue of forfeited shares balance of forfeited shares account is transferred to which account?
  • (ii) Applications for shares received less than the number of shares offered is called ?
  • (iii) How many days notice is to be given to the defaulting shareholders by Board of directors to make payment before the forfeiture of shares?

(i) Capital Reserve Account (पूंजीगत संचय खाता).
(ii) Under-subscription (अल्प-अभिदान).
(iii) 14 days (Minimum 14 days clear statutory notice).

SECTION A (PART IV)

Short Answer Questions (25 to 28)

[4 × 2 = 8 Marks]
Q. 25 [2 Marks]

What is meant by deferred revenue expenditure? Also give an example of it.

Meaning & Example:

Deferred Revenue Expenditure: It is a heavy revenue expenditure incurred during one accounting period, the economic benefit of which extends over multiple subsequent accounting years (normally 3 to 5 years). The unwritten-off balance is shown on the Assets side of the Balance Sheet.
Example: Massive advertising and promotional expenditure incurred on launching a new product line.

Q. 26 [2 Marks]

What will be the journal entries when the new partner brings his share of goodwill premium in cash and it is retained in the business?

Journal Entries in the Books of the Firm:
Date Particulars L.F. Debit (₹) Credit (₹)
1. Cash / Bank A/c ..................................... Dr.
    To Premium for Goodwill A/c
(Being premium for goodwill brought in cash by new partner)
— Amount —
Amount
2. Premium for Goodwill A/c .......................... Dr.
    To Sacrificing Partners' Capital A/cs
(Being goodwill premium credited to sacrificing partners in sacrificing ratio)
— Amount —
Amount
OR (Alternative Option Fully Solved)

How is Workmen Compensation Reserve shown in the balance sheet of a partnership firm, treated at the time of its dissolution?

Treatment of Workmen Compensation Reserve (WCR) upon Dissolution:
  1. If there is no liability against WCR: The entire amount of WCR is credited directly to Partners' Capital Accounts in their profit-sharing ratio.
  2. If there is a liability against WCR:
    • An amount equal to the workmen liability is transferred to the credit of Realisation A/c (and subsequently paid: Realisation A/c Dr. to Bank A/c).
    • Any excess surplus of WCR over the liability is credited to Partners' Capital Accounts in their profit-sharing ratio.
Q. 27 [2 Marks]

State any two factors which affect the goodwill of a partnership firm.

Two Key Factors Affecting Goodwill:
  1. Favourable Location: If the business is centrally located in a prominent commercial area easily accessible to customers, footfall and sales increase, leading to higher profits and higher goodwill.
  2. Quality of Goods and Services / Management Efficiency: Consistently delivering superior quality goods and having experienced, capable management builds customer loyalty and reputation, directly boosting goodwill.
OR (Alternative Option Fully Solved)

Give the necessary journal entry of realization expenses if it is paid by partner and borne by firm.

Journal Entry:
Particulars L.F. Debit (₹) Credit (₹)
Realisation A/c ..................................... Dr.
    To Concerned Partner's Capital A/c
(Being realisation expenses borne by the firm but paid by the partner on behalf of the firm)
— Amount —
Amount
Q. 28 [2 Marks]

State any two purposes for which securities premium can be utilized for as per the provisions of Companies Act.

Purposes Under Section 52(2) of Companies Act, 2013:
  1. In issuing fully paid bonus shares to the equity shareholders.
  2. In writing off preliminary expenses of the company (or writing off expenses/commission paid or discount allowed on issue of shares or debentures).
OR (Alternative Option Fully Solved)

What is meant by calls in arrears?

Meaning of Calls in Arrears:

Calls in arrears refers to the unpaid amount demanded by the company on allotment or calls that has not been remitted by shareholders by the prescribed due date. It is shown as a deduction from called-up capital under 'Subscribed Capital' in Notes to Accounts on Share Capital.

SECTION A (PART V)

Short Questions & Numericals (29 to 33)

[5 × 3 = 15 Marks]
Q. 29 [3 Marks]

Explain any three features of Single Entry System.

Three Key Features of Single Entry System:
  1. Incomplete and Unscientific System: It does not follow the dual aspect principle for all transactions. For some transactions, both aspects are recorded; for some, only one aspect; and for others, no record is kept.
  2. Maintenance of Personal Accounts and Cash Book Only: Only personal accounts of debtors and creditors and the Cash Book are systematically maintained. Nominal and Real accounts are generally neglected.
  3. Lack of Arithmetical Accuracy: Since nominal and real ledgers are omitted, a Trial Balance cannot be prepared to verify the arithmetical accuracy of the records.
OR (Alternative Option Fully Solved)

How Manager's commission is calculated if it is allowed on the net profit before charging such commission and after charging such commission? Also show the adjustment entry of it? Explain with the help of an example.

Calculation Formulas, Example, and Adjustment Entry:

1. Before charging such commission:
\[\text{Commission} = \text{Net Profit} \times \frac{\text{Rate of Commission}}{100}\]

2. After charging such commission:
\[\text{Commission} = \text{Net Profit} \times \frac{\text{Rate of Commission}}{100 + \text{Rate of Commission}}\]

Numerical Example: Suppose Net Profit before commission is ₹55,000 and Manager's Commission rate is 10%.
• Before charging: \(55,000 \times \frac{10}{100} = ₹5,500\).
• After charging: \(55,000 \times \frac{10}{110} = ₹5,000\).

Adjustment Journal Entry:
Profit & Loss A/c ..................................... Dr.
    To Commission Payable (or Outstanding Commission) A/c

(Being manager's commission provided on net profit)

Q. 30 (Numerical) [3 Marks]

As per Receipt and Payment Account for the year ended on March 31, 2025, the subscriptions received were ₹50,000.
Additional information:
(1) Subscriptions Outstanding on 1.4.2024: ₹5,000
(2) Subscriptions Outstanding on 31.3.2025: ₹3,000
(3) Subscriptions Received in Advance as on 1.4.2024: ₹2,500
(4) Subscriptions Received in Advance as on 31.3.2025: ₹1,000
Calculate the amount that will be posted in Income and Expenditure Account for income from subscriptions for the year 2024-25.

Statement of Subscriptions Income for 2024–25:
Particulars Details (₹) Amount (₹)
Subscriptions received during 2024–25 (as per R&P A/c) — 50,000
Less: Outstanding subscriptions at beginning (1.4.2024) (5,000) —
Add: Outstanding subscriptions at end (31.3.2025) 3,000 —
Add: Advance subscriptions at beginning (1.4.2024) 2,500 —
Less: Advance subscriptions at end (31.3.2025) (1,000) (500)
Income from Subscriptions to be credited to Income & Expenditure A/c — ₹49,500

Calculation: \(50,000 - 5,000 + 3,000 + 2,500 - 1,000 = ₹49,500\).

OR (Alternative Option Fully Solved)

Calculate Operating Profit from the following particulars:

ParticularsAmount (₹)
Net sales70,000
Sales Return10,000
Cost of Goods Sold5,000
Office and Administrative expenses15,000
Selling and Distribution Expenses6,500
Step-by-Step Calculation:

Primary Standard Interpretation (Net Sales already given as ₹70,000):

\[\text{Gross Profit} = \text{Net Sales} - \text{Cost of Goods Sold} = 70,000 - 5,000 = ₹65,000\] \[\text{Operating Expenses} = \text{Office Expenses} + \text{Selling Expenses} = 15,000 + 6,500 = ₹21,500\] \[\text{Operating Profit} = \text{Gross Profit} - \text{Operating Expenses} = 65,000 - 21,500 = \mathbf{₹43,500}\]

*Note: If "Net sales" was treated as Gross sales before return: Net Sales = \(70,000 - 10,000 = ₹60,000\), yielding \(\text{Operating Profit} = 60,000 - 5,000 - 21,500 = \mathbf{₹33,500}\).

Q. 31 [3 Marks]

Explain the payment to the retiring partner in instalments.

Mechanism of Instalment Payment:

When the firm lacks liquid cash to settle the retiring partner's dues immediately, the unpaid balance is transferred from his Capital Account to a newly opened Retiring Partner's Loan Account.
• The loan is repaid in agreed periodic instalments along with interest (at the agreed deed rate, or 6% p.a. under Sec. 37 of Partnership Act).
• Accounting Entries:
1. Transfer to Loan: Retiring Partner's Capital A/c Dr. to Retiring Partner's Loan A/c
2. Accruing Interest: Interest A/c Dr. to Retiring Partner's Loan A/c
3. Paying Instalment: Retiring Partner's Loan A/c Dr. to Bank A/c

OR (Alternative Option Fully Solved)

Explain how accumulated profits and losses are treated when a new partner is admitted in the firm? Give journal entries also.

Treatment & Journal Entries:

Accumulated profits, reserves, and accumulated losses appearing on the Balance Sheet belong exclusively to the old partners earned prior to the admission of the new partner. They are transferred to Old Partners' Capital Accounts in their Old Profit Sharing Ratio.

Situation Journal Entry
For Accumulated Profits & Reserves (General Reserve, P&L Cr.) General Reserve / P&L A/c .......................... Dr.
    To Old Partners' Capital A/cs (Old Ratio)
For Accumulated Losses (P&L Dr. balance) Old Partners' Capital A/cs (Old Ratio) .............. Dr.
    To Profit & Loss A/c
Q. 32 [3 Marks]

Explain 'Oversubscription' of shares. What are the options available in case of over subscription?

Concept and Available Allotment Options:

Oversubscription: A situation where the total number of share applications received by a company from the public exceeds the total number of shares offered for subscription.

Three Options Available to the Board of Directors:
  1. Total Rejection: Reject excess applications completely and refund the application money to unsuccessful applicants.
  2. Pro-Rata Allotment: Allot shares proportionally to all applicants and adjust surplus application money towards allotment and future calls.
  3. Combination (Hybrid Method): Allot some applicants in full, reject some applications outright with refund, and make pro-rata allotment to the remaining applicants.
Q. 33 [3 Marks]

What is meant by reissue of shares? Give journal entries for reissue of forfeited shares at premium, originally issued at par.

Meaning and Reissue Entries at Premium:

Reissue of Shares: Forfeited shares become property of the company and may be re-sold/reissued by the Board of Directors at par, at premium, or at a discount (discount cannot exceed the forfeited amount received on those shares).

Particulars L.F. Debit (₹) Credit (₹)
Bank A/c ............................................ Dr.
    To Share Capital A/c (Paid-up value)
    To Securities Premium A/c (Premium)
(Being reissue of forfeited shares at a premium)
— Total Recd —
Paid-up
Premium
Share Forfeiture A/c ............................... Dr.
    To Capital Reserve A/c
(Being net profit on forfeited reissued shares transferred to Capital Reserve)
— Entire Amt —
Entire Amt
OR (Alternative Option Fully Solved)

Explain the procedure of forfeiture of shares.

Step-by-Step Statutory Procedure:
  1. Default in Call Payment: The shareholder fails to pay allotment or call money by the due date.
  2. Service of 14 Days Notice: The company sends a formal written notice giving at least 14 clear days demanding the unpaid sum along with applicable interest.
  3. Warning in Notice: The notice explicitly states that in case of non-payment by the appointed day, the shares will be liable to be forfeited.
  4. Board Resolution: If the default continues, the Board of Directors passes a resolution forfeiting the shares.
  5. Cancellation & Entry: Name of the shareholder is removed from the Register of Members, and amount already paid is forfeited to the company.
SECTION A (PART VI)

Long Comprehensive Questions (34 to 36)

[3 × 5 = 15 Marks]
Q. 34 (Comprehensive) [5 Marks]

From the following Trial Balance of Goel & Son's, as on 31.3.2025, Prepare Trading and Profit and Loss Account for the year ended 31st March 2025 and Balance Sheet as at that date.

Particulars Debit Balance (₹) Particulars Credit Balance (₹)
Opening stock (1.4.2024)28,000Purchase Return4,300
Purchases34,300Sales1,40,000
Salaries16,000Discount received35,000
Bad debts5,400Capital68,500
Wages6,800Bills payable10,200
Insurance1,000Creditors23,300
Trading Expenses2,200
Drawings20,000
Cash at Bank92,000
Cash in hand50,000
Debtors25,600
Total2,81,300Total2,81,300

Adjustment: The Closing stock was valued at ₹7,200.

Books of Goel & Son's — Financial Statements:
Trading and Profit & Loss Account for the year ended 31st March, 2025
Dr. Particulars Amount (₹) Cr. Particulars Amount (₹)
To Opening Stock28,000 By Sales1,40,000
To Purchases (34,300 - Ret. 4,300)30,000 By Closing Stock7,200
To Wages6,800
To Gross Profit c/d82,400 Total1,47,200
To Salaries16,000 By Gross Profit b/d82,400
To Bad Debts5,400 By Discount received35,000
To Insurance1,000
To Trading Expenses2,200
To Net Profit (transferred to Capital)92,800 Total1,17,400
Balance Sheet of Goel & Son's as at 31st March, 2025
Liabilities Amount (₹) Assets Amount (₹)
Capital: 68,500
+ Net Profit: 92,800
- Drawings: (20,000)
1,41,300 Closing Stock 7,200
Bills Payable 10,200 Debtors 25,600
Creditors 23,300 Cash at Bank 92,000
Cash in hand 50,000
Total 1,74,800 Total 1,74,800

✓ Verified: Balance Sheet tallies perfectly at ₹1,74,800.

OR (Alternative Choice Fully Solved)

Prepare Income and Expenditure Account from the Receipts and Payments Account of Senior Citizen Health Club, Delhi for the year ending 31st December, 2025.

ReceiptsAmount (₹)PaymentsAmount (₹)
To Balance b/d28,000By Rent6,700
To Subscription34,000By Stationery3,600
To Entrance fees1,000By Salary5,800
To Sale of Investments12,500By Purchase of Equipments25,000
To Sale of old furniture (BV 3,500)2,300By Entertainment expenses10,400
To Donation5,800By Miscellaneous expenses8,600
By Furniture purchased4,500
By Balance c/d19,000
Total83,600Total83,600

Additional information: Subscription outstanding amounted to ₹500.

Income & Expenditure Account of Senior Citizen Health Club, Delhi:
Expenditure Amount (₹) Income Amount (₹)
To Rent6,700 By Subscriptions: 34,000
    + Outstanding: 500
34,500
To Stationery3,600 By Entrance fees1,000
To Salary5,800 By Donation (General)5,800
To Entertainment expenses10,400
To Miscellaneous expenses8,600
To Loss on Sale of Furniture (3,500 - 2,300)1,200
To Surplus (Excess of Income over Expenditure)5,000
Total41,300 Total41,300

• Capital Items Excluded: Purchase of Equipments (₹25,000) and Furniture purchased (₹4,500) are capital expenditures; Sale of investments (₹12,500) and cash balances are Balance Sheet items.

Final Answer: Surplus = ₹5,000.

Q. 35 (Partnership Reconstitution) [5 Marks]

A, B and C were partners in a firm sharing profits in the ratio of 2:2:1. Their balance sheet as at 31st March 2025 was as follows:

LiabilitiesAmount (₹)AssetsAmount (₹)
Creditors30,000Land85,000
Bills Payable20,000Building50,000
Outstanding Expenses25,000Plant1,00,000
General Reserve50,000Stock40,000
Capital:
  A: 50,000
  B: 60,000
  C: 70,000
1,80,000 Debtors
Cash
25,000
5,000
Total3,05,000Total3,05,000

With effect from April 1, 2025 the partners decided to share profits in the ratio of 1:1:3. For this purpose, it was agreed that:
(i) The goodwill of the firm should be valued at ₹60,000.
(ii) Land should be revalued at ₹1,00,000. Building should be depreciated by 6%.
(iii) Creditors amounting to ₹3,000 were not to be paid.
Prepare Revaluation Account, Partners' Capital accounts and Balance sheet after the reconstitution of the firm.

Complete Reconstitution Solution:

Step 1: Goodwill Adjustment Calculation

• Old Ratio of A, B, C = \(2:2:1\) (\(2/5, 2/5, 1/5\))

• New Ratio of A, B, C = \(1:1:3\) (\(1/5, 1/5, 3/5\))

• Sacrifice / (Gain) = \(\text{Old Share} - \text{New Share}\):
    A: \(\frac{2}{5} - \frac{1}{5} = \frac{1}{5}\) (Sacrifice) \(\rightarrow\) Share = \(60,000 \times \frac{1}{5} = ₹12,000\) (Cr.)
    B: \(\frac{2}{5} - \frac{1}{5} = \frac{1}{5}\) (Sacrifice) \(\rightarrow\) Share = \(60,000 \times \frac{1}{5} = ₹12,000\) (Cr.)
    C: \(\frac{1}{5} - \frac{3}{5} = -\frac{2}{5}\) (Gain) \(\rightarrow\) Share = \(60,000 \times \frac{2}{5} = ₹24,000\) (Dr.)

• Adjustment Entry: C's Capital A/c Dr. 24,000 | To A's Capital A/c 12,000 | To B's Capital A/c 12,000

1. Revaluation Account
ParticularsAmount (₹)ParticularsAmount (₹)
To Building (6% of 50,000)3,000 By Land (1,00,000 - 85,000)15,000
To Gain on Revaluation transferred to:
  A's Capital (2/5): 6,000
  B's Capital (2/5): 6,000
  C's Capital (1/5): 3,000
15,000 By Creditors (liability written off)3,000
Total18,000 Total18,000
2. Partners' Capital Accounts
Dr. Particulars A (₹)B (₹)C (₹) Cr. Particulars A (₹)B (₹)C (₹)
To A's Capital (Goodwill)——12,000 By Balance b/d50,00060,00070,000
To B's Capital (Goodwill)——12,000 By General Reserve (2:2:1)20,00020,00010,000
By Revaluation A/c (Gain)6,0006,0003,000
By C's Capital (Goodwill)12,00012,000—
To Balance c/d88,00098,00059,000 Total88,00098,00083,000
3. Balance Sheet of Reconstituted Firm as at 1st April, 2025
LiabilitiesAmount (₹)AssetsAmount (₹)
Creditors (30,000 − 3,000) 27,000 Land (Revalued) 1,00,000
Bills Payable 20,000 Building (50,000 − 3,000 dep.) 47,000
Outstanding Expenses 25,000 Plant 1,00,000
Capitals:
  A: 88,000
  B: 98,000
  C: 59,000
2,45,000 Stock
Debtors
Cash
40,000
25,000
5,000
Total 3,17,000 Total 3,17,000

✓ Verified: Balance Sheet tallies symmetrically at ₹3,17,000.

OR (Alternative Choice Fully Solved)

P and Q are partners sharing profits in the ratio of 3:2. On 31st March 2025, they decided to dissolve the firm. On that date, Sundry Assets (other than Cash) stood at ₹1,50,000 and Outside Liabilities stood at ₹50,000. Assets realized ₹1,35,000, liabilities were discharged at a discount of 5%, and realization expenses of ₹2,500 were paid by the firm. Capital balances of P and Q were ₹60,000 and ₹40,000 respectively, and cash balance was ₹2,500. Prepare Realisation Account and Cash Account.

Step-by-Step Dissolution Solution:
1. Realisation Account
Dr. ParticularsAmount (₹)Cr. ParticularsAmount (₹)
To Sundry Assets (Book Value) 1,50,000 By Outside Liabilities 50,000
To Cash A/c (Liabilities paid: 50,000 − 5%) 47,500 By Cash A/c (Assets Realized) 1,35,000
To Cash A/c (Realisation Expenses) 2,500 By Loss on Realisation transferred to:
  P's Capital (3/5): 9,000
  Q's Capital (2/5): 6,000
15,000
Total 2,00,000 Total 2,00,000
2. Cash Account
Dr. ParticularsAmount (₹)Cr. ParticularsAmount (₹)
To Balance b/d 2,500 By Realisation A/c (Liabilities paid) 47,500
To Realisation A/c (Assets Realized) 1,35,000 By Realisation A/c (Expenses) 2,500
By P's Capital A/c (Final Payment: 60,000 − 9,000) 51,000
By Q's Capital A/c (Final Payment: 40,000 − 6,000) 34,000
Total 1,37,500 Total 1,37,500

✓ Verified: Cash Account closes cleanly at ₹1,37,500.

Q. 36 (Company Accounts) [5 Marks]

Star Ltd. invited applications for issuing 20,000 equity shares of ₹10 each at a premium of ₹2 per share. The amount was payable as follows:
• On Application: ₹3 per share
• On Allotment: ₹5 per share (including premium ₹2)
• On First and Final Call: ₹4 per share

Applications were received for 30,000 shares. Pro-rata allotment was made to all applicants (ratio 3:2). Excess application money was adjusted towards sums due on allotment.
Rohan, to whom 400 shares were allotted, failed to pay the allotment and call money. His shares were forfeited. Later, 300 of these forfeited shares were reissued to Mohit as fully paid-up for ₹8 per share.
Pass necessary journal entries in the books of Star Ltd.

Step-by-Step Journal Entries & Working Notes:

Working Note 1: Allotment & Excess Application Money

• Total application money received = \(30,000 \times 3 = ₹90,000\)

• Application money required on 20,000 shares = \(20,000 \times 3 = ₹60,000\)

• Excess application money adjusted on allotment = \(90,000 − 60,000 = ₹30,000\)

Working Note 2: Unpaid Allotment Money by Rohan (Allotted 400 shares)

• Shares applied by Rohan = \(400 \times \frac{30,000}{20,000} = 600\text{ shares}\)

• Application money paid by Rohan = \(600 \times 3 = ₹1,800\)

• Application money adjusted on 400 shares = \(400 \times 3 = ₹1,200\)

• Excess application money paid by Rohan = \(1,800 − 1,200 = ₹600\)

• Allotment money due on 400 shares = \(400 \times 5 = ₹2,000\) (Capital ₹1,200 + Premium ₹800)

• Allotment in arrears by Rohan = \(2,000 − 600 = ₹1,400\) (Capital short ₹600, Premium short ₹800)

• First & Final Call in arrears = \(400 \times 4 = ₹1,600\)

• Total amount forfeited on Rohan's shares = Application money paid = ₹1,800

Working Note 3: Capital Reserve on Reissue of 300 Shares

• Forfeited amount proportional to 300 shares = \(\frac{1,800}{400} \times 300 = ₹1,350\)

• Discount on reissue (\(300 \times 2\)) = ₹600

• Net gain transferred to Capital Reserve = \(1,350 − 600 = \mathbf{₹750}\)

Date / No. Particulars L.F. Debit (₹) Credit (₹)
1. Bank A/c .................................................... Dr.
    To Equity Share Application A/c
(Being application money received on 30,000 shares @ ₹3 each)
— 90,000 —
90,000
2. Equity Share Application A/c ............................... Dr.
    To Equity Share Capital A/c (\(20,000 \times 3\))
    To Equity Share Allotment A/c (Surplus adjusted)
(Being application money transferred to Share Capital and excess to Allotment)
— 90,000 —
60,000
30,000
3. Equity Share Allotment A/c ................................. Dr.
    To Equity Share Capital A/c (\(20,000 \times 3\))
    To Securities Premium A/c (\(20,000 \times 2\))
(Being allotment money due on 20,000 shares @ ₹5 including premium)
— 1,00,000 —
60,000
40,000
4. Bank A/c .................................................... Dr.
    To Equity Share Allotment A/c (\(70,000 − 1,400\))
(Being allotment money received except on 400 shares of Rohan)
— 68,600 —
68,600
5. Equity Share First & Final Call A/c ...................... Dr.
    To Equity Share Capital A/c (\(20,000 \times 4\))
(Being call money due on 20,000 shares @ ₹4 each)
— 80,000 —
80,000
6. Bank A/c .................................................... Dr.
    To Equity Share First & Final Call A/c (\(80,000 − 1,600\))
(Being call money received except on 400 shares)
— 78,400 —
78,400
7. Equity Share Capital A/c (\(400 \times 10\)) ................. Dr.
Securities Premium A/c (\(400 \times 2\), unreceived) ........ Dr.
    To Equity Share Allotment A/c
    To Equity Share First & Final Call A/c
    To Share Forfeiture A/c (\(400 \times 3 + 600\))
(Being 400 shares forfeited for non-payment of allotment and call)
— 4,000
800
—
—
1,400
1,600
1,800
8. Bank A/c (\(300 \times 8\)) .................................... Dr.
Share Forfeiture A/c (\(300 \times 2\)) ........................ Dr.
    To Equity Share Capital A/c (\(300 \times 10\))
(Being 300 forfeited shares reissued @ ₹8 per share as fully paid)
— 2,400
600
—
—
3,000
9. Share Forfeiture A/c ....................................... Dr.
    To Capital Reserve A/c (\(1,350 − 600\))
(Being net profit on 300 reissued shares transferred to Capital Reserve)
— 750 —
750
OR (Alternative Choice Fully Solved)

Pass necessary journal entries for the issue of debentures in the following cases:
(a) Issued 1,000, 9% debentures of ₹100 each at par, redeemable at a premium of 5%.
(b) Issued 2,000, 10% debentures of ₹100 each at a discount of 5%, redeemable at par.
(c) Issued 500, 12% debentures of ₹100 each at a premium of 5%, redeemable at a premium of 10%.

Journal Entries in the Books of the Company:
Case Particulars L.F. Debit (₹) Credit (₹)
(a) Bank A/c .................................................... Dr.
Loss on Issue of Debentures A/c ............................ Dr.
    To 9% Debentures A/c
    To Premium on Redemption of Debentures A/c
(Being issue of 1,000 debentures of ₹100 at par redeemable at 5% premium)
— 1,00,000
5,000
—
—
1,00,000
5,000
(b) Bank A/c (\(2,000 \times 95\)) ................................. Dr.
Discount on Issue of Debentures A/c (\(2,000 \times 5\)) ..... Dr.
    To 10% Debentures A/c (\(2,000 \times 100\))
(Being issue of 2,000 debentures of ₹100 at 5% discount redeemable at par)
— 1,90,000
10,000
—
—
2,00,000
(c) Bank A/c (\(500 \times 105\)) ................................. Dr.
Loss on Issue of Debentures A/c (\(500 \times 10\)) .......... Dr.
    To 12% Debentures A/c (\(500 \times 100\))
    To Securities Premium A/c (\(500 \times 5\))
    To Premium on Redemption of Debentures A/c (\(500 \times 10\))
(Being issue of 500 debentures of ₹100 at 5% premium redeemable at 10% premium)
— 52,500
5,000
—
—
50,000
2,500
5,000
SECTION B (OPTION I)

Analysis of Financial Statements (37 to 47)

[Total: 20 Marks]
Q. 37 (Mod I) [1 Mark]

According to standard accounting conventions, an ideal Current Ratio is:

(A) 2 : 1
(B) 1 : 1
(C) 3 : 1
(D) 0.5 : 1

Ans. (A) 2 : 1
Curricular Justification: A Current Ratio of 2:1 is widely accepted as an ideal benchmark for commercial enterprises, signifying that the firm maintains ₹2 of liquid current assets for every ₹1 of short-term obligations.

Q. 38 (Mod I) [1 Mark]

Which of the following is treated as a cash inflow from Operating Activities in a Cash Flow Statement?

(A) Cash received from sale of goods and rendering of services
(B) Sale of machinery
(C) Issue of equity shares
(D) Bank loan raised

Ans. (A) Cash received from sale of goods and rendering of services
Curricular Justification: Revenue from core commercial operations generates operating cash inflows under AS-3 (Revised). Sale of machinery is an Investing Activity; share issues and bank loans are Financing Activities.

Q. 39 (Mod I) [1 Mark]

Payment of dividend by a manufacturing enterprise is classified as:

(A) Operating Activity
(B) Investing Activity
(C) Financing Activity
(D) Extraordinary Activity

Ans. (C) Financing Activity
Curricular Justification: Dividend paid represents the cost of servicing equity capital and is categorized as a financing cash outflow.

Q. 40 (Mod I) [1 Mark]

Fill in the blank:
Liquid Assets = Current Assets − (______ + Prepaid Expenses).

Liquid Assets = Current Assets − (Inventory / Stock + Prepaid Expenses).

Q. 41 (Mod I) [1 Mark]

Fill in the blank:
A financial statement showing individual asset and liability items as a percentage of Total Assets is known as ______ Balance Sheet.

A financial statement showing individual asset and liability items as a percentage of Total Assets is known as Common-Size (समान आकार) Balance Sheet.

Q. 42 (Mod I) [2 Marks]

State any two objectives of financial statement analysis.

  1. Assessing Earning Capacity & Profitability: To gauge how efficiently the resources of the business are being utilized to generate operating profits and net returns.
  2. Evaluating Solvency and Financial Strength: To verify the enterprise's ability to satisfy short-term liabilities on demand (liquidity) and service long-term debt commitments (long-term solvency).
Q. 43 (Mod I) [2 Marks]

Distinguish between horizontal analysis and vertical analysis of financial statements.

BasisHorizontal AnalysisVertical Analysis
Time Horizon Involves comparison of financial data across multiple consecutive accounting periods (Dynamic analysis). Analyzes financial data of a single specific accounting period (Static analysis).
Tool Used Comparative Financial Statements and Trend Analysis. Common-Size Statements and Accounting Ratios.
Q. 44 (Mod I Numerical) [2 Marks]

From the following information, calculate Liquid Ratio:
Current Assets: ₹80,000; Inventories: ₹25,000; Prepaid Expenses: ₹5,000; Current Liabilities: ₹50,000.

\[\text{Liquid Assets} = \text{Current Assets} − (\text{Inventories} + \text{Prepaid Expenses})\]

\[\text{Liquid Assets} = 80,000 − (25,000 + 5,000) = 80,000 − 30,000 = ₹50,000\]

\[\text{Liquid Ratio} = \frac{\text{Liquid Assets}}{\text{Current Liabilities}} = \frac{50,000}{50,000} = \mathbf{1 : 1}\]

Final Answer: Liquid Ratio is 1 : 1 (Standard benchmark met).

Q. 45 (Mod I Comparative) [3 Marks]

From the following details, prepare a Comparative Statement of Profit and Loss for the years ended 31st March 2024 and 31st March 2025:

Particulars2023–24 (₹)2024–25 (₹)
Revenue from Operations4,00,0005,00,000
Operating Expenses2,00,0002,60,000
Tax Rate30%30%
Comparative Statement of Profit and Loss:
Particulars 2023–24 (₹) 2024–25 (₹) Absolute Change (₹) % Change
I. Revenue from Operations 4,00,000 5,00,000 +1,00,000 +25.00%
II. Less: Operating Expenses 2,00,000 2,60,000 +60,000 +30.00%
III. Profit before Tax (I − II) 2,00,000 2,40,000 +40,000 +20.00%
IV. Less: Tax (30%) 60,000 72,000 +12,000 +20.00%
V. Profit after Tax (III − IV) 1,40,000 1,68,000 +28,000 +20.00%
Q. 46 (Mod I Numerical) [3 Marks]

From the following figures, calculate:
(i) Gross Profit Ratio, and
(ii) Inventory Turnover Ratio
Revenue from Operations: ₹6,00,000; Gross Profit: ₹1,50,000; Opening Inventory: ₹70,000; Closing Inventory: ₹80,000.

(i) Gross Profit Ratio:

\[\text{Gross Profit Ratio} = \frac{\text{Gross Profit}}{\text{Revenue from Operations}} \times 100 = \frac{1,50,000}{6,00,000} \times 100 = \mathbf{25\%}\]

(ii) Inventory Turnover Ratio:

• Cost of Revenue from Operations = Revenue − Gross Profit = \(6,00,000 − 1,50,000 = ₹4,50,000\)

• Average Inventory = \(\frac{\text{Opening Inventory} + \text{Closing Inventory}}{2} = \frac{70,000 + 80,000}{2} = ₹75,000\)

\[\text{Inventory Turnover Ratio} = \frac{\text{Cost of Revenue from Operations}}{\text{Average Inventory}} = \frac{4,50,000}{75,000} = \mathbf{6\text{ times}}\]
Q. 47 (Mod I Comprehensive) [4 Marks]

From the following information, calculate Cash Flow from Operating Activities:

Particulars31.03.2024 (₹)31.03.2025 (₹)
Surplus (Balance in Statement of P&L)1,20,0001,80,000
Trade Receivables (Debtors)45,00038,000
Trade Payables (Creditors)30,00042,000
Inventories60,00075,000
Depreciation on Machinery during the year—25,000
Loss on Sale of Furniture—5,000
Calculation of Cash Flow from Operating Activities (Indirect Method):
ParticularsDetails (₹)Amount (₹)
Net Profit during the year (\(1,80,000 − 1,20,000\)) — 60,000
Adjustments for Non-Cash and Non-Operating Items:
  + Depreciation on Machinery
  + Loss on Sale of Furniture

25,000
5,000

30,000
Operating Profit before Working Capital Changes — 90,000
Adjustments for Working Capital Changes:
  + Decrease in Trade Receivables (\(45,000 − 38,000\))
  + Increase in Trade Payables (\(42,000 − 30,000\))
  − Increase in Inventories (\(75,000 − 60,000\))

7,000
12,000
(15,000)


4,000
Net Cash Flow from Operating Activities — ₹94,000

Final Answer: Net Cash from Operating Activities = ₹94,000.

OR (Alternative Choice Fully Solved)

State under which major activities (Operating, Investing, or Financing) will the following transactions be classified while preparing a Cash Flow Statement:
(i) Purchase of Machinery for cash
(ii) Cash received from debtors
(iii) Redemption of Debentures
(iv) Interest received on Investments

  1. Purchase of Machinery for cash: Investing Activity (Cash outflow for acquiring long-term non-current physical productive asset).
  2. Cash received from debtors: Operating Activity (Cash inflow arising from core trading operations).
  3. Redemption of Debentures: Financing Activity (Cash outflow for settling long-term borrowed capital).
  4. Interest received on Investments: Investing Activity (Cash inflow generated as return on non-operating financial assets/securities).
SECTION B (OPTION II)

Application of Computers in Financial Accounting (37 to 47)

[Total: 20 Marks]
Q. 37 (Mod II) [1 Mark]

The intersection of a row and a column in an electronic spreadsheet is called a:

(A) Cell
(B) Block
(C) Worksheet
(D) Label

Ans. (A) Cell
Curricular Justification: In spreadsheet software (like MS Excel), the fundamental unit for data storage created by the intersecting coordinate of a vertical column and a horizontal row is termed a cell (e.g., A1, B10).

Q. 38 (Mod II) [1 Mark]

Every formula in an electronic spreadsheet must begin with which mathematical sign?

(A) = (Equal to)
(B) + (Plus)
(C) @ (At the rate)
(D) # (Hash)

Ans. (A) = (Equal to)
Curricular Justification: The equals sign (`=`) instructs the spreadsheet calculation engine to parse and evaluate the subsequent characters as a mathematical or logical expression rather than plain text.

Q. 39 (Mod II) [1 Mark]

In financial functions of Excel, the PMT function calculates:

(A) Periodic payment for a loan based on constant payments and interest rate
(B) Present value of an investment
(C) Future accumulated value of a cash stream
(D) Straight line depreciation amount

Ans. (A) Periodic payment for a loan based on constant payments and interest rate
Curricular Justification: The `PMT(rate, nper, pv, [fv], [type])` formula computes equal periodic repayments (EMIs) covering both principal amortization and accrued interest.

Q. 40 (Mod II) [1 Mark]

Fill in the blank:
DBMS stands for ______.

DBMS stands for Database Management System.

Q. 41 (Mod II) [1 Mark]

Fill in the blank:
A field in a database table that uniquely identifies each individual record is called a ______ key.

A field in a database table that uniquely identifies each individual record is called a Primary key (प्राथमिक कुंजी).

Q. 42 (Mod II) [2 Marks]

State two key advantages of a Computerised Accounting System (CAS) over manual accounting.

  1. Speed and Arithmetical Accuracy: Automated ledger posting, trial balance creation, and report generation eliminate human calculation errors and save vast operational time.
  2. Instant Real-time Reporting: Up-to-date final accounts, cash balances, and customized MIS analytical statements are available immediately upon data entry.
Q. 43 (Mod II) [2 Marks]

What is meant by a 'Chart' in spreadsheet software? Name any two types of charts.

Definition: A chart is a graphical/visual representation of worksheet data that enables quick visual interpretation of financial trends, proportions, and comparative performance.

Two Common Types: (i) Bar/Column Chart, and (ii) Pie Chart (used for proportional cost breakups).

Q. 44 (Mod II) [2 Marks]

Explain the importance of password security and access control in accounting software.

Password security and role-based access control restrict unauthorized access, tampering, or fraudulent alterations to sensitive financial records. Access permissions ensure that junior data-entry operators can only record vouchers, while ledger edits and master financial authorizations remain strictly confined to authorized accounting managers.

Q. 45 (Mod II) [3 Marks]

Explain the syntax and utility of any three financial functions available in electronic spreadsheets:

  1. `SLN(cost, salvage, life)`: Computes the straight-line depreciation of an asset for one single period.
  2. `PMT(rate, nper, pv)`: Computes the fixed periodic installment (EMI) required to repay a loan at a constant interest rate over a specified number of periods.
  3. `FV(rate, nper, pmt, [pv])`: Returns the future accumulated value of an investment based on periodic, constant payments and a fixed interest rate.
Q. 46 (Mod II) [3 Marks]

Explain the essential components of a Computerised Accounting System (CAS).

  1. Hardware: Physical electronic equipment including processors, storage servers, terminals, and printers.
  2. Software: Programs comprising system software (OS) and specialized accounting application software (e.g., Tally, ERP, customized packages).
  3. People: Trained accountants, data-entry personnel, and systems administrators who operate and maintain the environment.
  4. Procedures & Data: Standard operating steps for recording transactions and the structured database storing accounting facts.
Q. 47 (Mod II Practical) [4 Marks]

Design an Electronic Spreadsheet structure for preparing an Employee Payroll Register with the following salary rules:
• Dearness Allowance (DA) = 50% of Basic Pay
• House Rent Allowance (HRA) = 20% of Basic Pay
• Provident Fund (PF) Deduction = 12% of Basic Pay
• Gross Pay = Basic Pay + DA + HRA
• Net Salary = Gross Pay − PF
Provide the spreadsheet table layout and exact cell formulas.

Payroll Spreadsheet Architecture & Formulas:
Cell Column Header Data / Excel Formula (for Row 2)
A2Emp ID`E101`
B2Emp Name`Rajesh Sharma`
C2Basic Pay`40,000`
D2DA (50%)`= C2 * 0.50` (Yields ₹20,000)
E2HRA (20%)`= C2 * 0.20` (Yields ₹8,000)
F2Gross Pay`= C2 + D2 + E2` (Yields ₹68,000)
G2PF (12%)`= C2 * 0.12` (Yields ₹4,800)
H2Net Salary`= F2 - G2` (Yields ₹63,200)

Autofill Functionality: Formulas entered in row 2 (`D2:H2`) can be dynamically dragged or autofilled down to all subsequent employee rows (`D3:H100`), ensuring rapid, error-free monthly payroll calculations.

OR (Alternative Choice Fully Solved)

Explain the structure of a Database Table for maintaining 'Customer Accounts' in an accounting DBMS, specifying field names, data types, and primary key.

Database Schema for Customer Accounts:
Field NameData TypeDescription / Constraint
Cust_ID Text / Varchar(10) Primary Key (Unique identifier for each debtor)
Cust_NameText / Varchar(50)Full name of business or customer (NOT NULL)
Contact_NoText(15)Phone number for communication
CityText(30)Customer's operational city
Credit_LimitCurrency / Decimal(10,2)Maximum credit allowable
Balance_DueCurrency / Decimal(10,2)Current outstanding receivable amount

Relational Function: `Cust_ID` acts as a Foreign Key in the Sales Voucher table, linking invoices directly to customer balances and eliminating data redundancy.