CBSE Class 12 Accountancy Question Paper 2024 (Set 1- 67/4/1) with Answer Key

The agreed rate of interest prevails unless there is a specific agreement to change it. Therefore, the interest on the loan will be paid to Nisha at the agreed rate of 10% p.a.

Answer: (B) 10% p.a. Quick Tip: It is important to consult the Indian Partnership Act, 1932, when no explicit terms are laid out in a partnership deed. By default, the act prescribes a \(6%\ p.a.\) interest rate on loans made by partners to their firm.

The profits are initially divided in a \(4:1\) ratio between Gupta and Sharma, respectively. Preeti secures her \(\frac{1}{4}\) share directly from Gupta's portion.
- Initially, Gupta's share = \(\frac{4}{5}\).
- Gupta allocates \(\frac{1}{4}\) of the total profits to Preeti.

Adjusted shares: \[ Gupta: \frac{4}{5} - \frac{1}{4} = \frac{16}{20} - \frac{5}{20} = \frac{11}{20}. \] \[ Sharma: \frac{1}{5} = \frac{4}{20}. \] \[ Preeti: \frac{1}{4} = \frac{5}{20}. \]

The revised profit sharing ratio stands at \(11:4:5\).


\hrule Quick Tip: When modifying profit-sharing ratios, accurately calculate each partner's portion of the total profits to ensure that the new distribution ratios sum to the total 100%.

Calculate the Initial Share of Each Partner:

Total ratio parts: 1 + 1 + 1 = 3
Each partner's initial share: \(\frac{1}{3}\)


Calculate the New Share of Vishesh and Nimesh:

New profit sharing ratio: 4:3
Total ratio parts: 4 + 3 = 7
Vishesh's new share: \(\frac{4}{7}\)
Nimesh's new share: \(\frac{3}{7}\)


Calculate the Gaining Share of Vishesh:
\begin{align*
Vishesh's Gaining Share &= \text{New Share - \text{Old Share

&= \frac{4{7 - \frac{1{3

&= \frac{12 - 7{21

&= \frac{5{21
\end{align*

Calculate the Gaining Share of Nimesh:
\begin{align*
\text{Nimesh's Gaining Share &= \text{New Share - \text{Old Share

&= \frac{3{7 - \frac{1{3

&= \frac{9 - 7{21

&= \frac{2{21
\end{align*

Determine the Gaining Ratio:

Gaining ratio of Vishesh and Nimesh: \(\frac{5{21} : \frac{2}{21}\)
Simplify by multiplying by 21: 5:2



Therefore, the gaining ratio of Vishesh and Nimesh is 5:2.

Answer: (C) 5:2 Quick Tip: To determine the gaining ratio, deduct the original share percentage from the new share percentage for each remaining partner.

Calculate the Total Amount Due on Allotment (Excluding Ashish's Advance):

Amount due per share (including premium): Rs.3
Number of shares (excluding Ashish's): 6,000 - 200 = 5,800
Total amount due: Rs.3 * 5,800 = Rs.17,400


Calculate the Amount Ashish Paid in Advance:

Ashish paid for First Call and Final Call along with allotment.
Amount paid in advance per share: Rs.3 (First Call) + Rs.2 (Final Call) = Rs.5
Total amount paid in advance: Rs.5 * 200 = Rs.1,000


Calculate the Amount Ashish Paid on Allotment:

Amount due on allotment per share: Rs.3
Ashish's shares: 200
Amount Ashish paid on allotment: Rs.3 * 200 = Rs.600


Calculate the Total Amount Received on Allotment:
\begin{align*
\text{Total amount received &= \text{Amount due (excluding Ashish)

&+ \text{Ashish's allotment payment

&+ \text{Ashish's advance

&= Rs.17,400 + Rs.600 + Rs.1,000

&= Rs.19,000
\end{align*


Therefore, the total amount received on allotment was Rs.19,000.

Answer: (B) Rs.19,000 Quick Tip: When performing calculations for share allotment, include both the standard allotment fees and any additional contributions or premiums paid by shareholders.

Calculate the Called-Up Value per Share:

Face value of each share: Rs.10
Final call not paid: Rs.2
Called-up value per share: Rs.10 - Rs.2 = Rs.8


Calculate the Total Called-Up Value of Forfeited Shares:

Called-up value per share: Rs.8
Number of forfeited shares: 5,000
Total called-up value: Rs.8 * 5,000 = Rs.40,000


Determine the Minimum Reissue Price:

When shares are reissued as fully paid up, the minimum reissue price is the difference between the face value and the amount not paid (forfeited amount).
The company can give a maximum discount equal to the forfeited amount.
Forfeited amount per share = Rs.8
Minimum reissue price per share = Rs.10 (face value) - Rs.8 (maximum discount) = Rs.2
Total minimum reissue price = Rs.2 * 5,000 = Rs.10,000



Therefore, the minimum amount at which these shares can be reissued as fully paid up is Rs.10,000.

Answer: (B) Rs.10,000 Quick Tip: When recalculating share prices after forfeiture, it is essential to consider both the unpaid amounts and any reductions due to forfeiture, aligning with company accounting policies.

In the fixed capital method:
- The capital accounts of partners remain static in terms of their credit balances and are not impacted by day-to-day transactions such as profit distribution, withdrawals, or interest adjustments.
Thus, these accounts consistently show a credit balance.

- Transactions that do not affect the fixed capital, such as drawing, interest on capital, and share of profits or losses, are recorded in the partners' current accounts, which are adjusted accordingly.


Therefore, both Assertion (A) and Reason (R) are correct, and Reason (R) provides an accurate explanation for Assertion (A). Quick Tip: When addressing Assertion and Reason questions, it's crucial to determine if the reason given logically supports the assertion. Refer to the relevant accounting principles to confirm the accuracy of the explanation.

The profit distribution includes the following appropriations:
1. Calculating the interest on capital for Vanya: \[ Interest on capital = Rs.5,00,000 \times 8% = Rs.40,000. \]

2. Calculating the annual salary for Aanya: \[ Annual Salary = Rs.5,000 \times 12 = Rs.60,000. \]

3. Determining the profit available for distribution after deductions: \[ Rs.1,75,000 - Rs.40,000 - Rs.60,000 = Rs.75,000. \]

4. Applying the profit-sharing ratio: \[ Vanya's share of the profit = Rs.75,000 \times \frac{3}{5} = Rs.45,000. \]

Consequently, Vanya's share of the divisible profit totals Rs.45,000.


\hrule Quick Tip: Ensure that all fixed appropriations such as interest on capital and salaries are calculated and subtracted from the total profit before distributing the remainder according to the agreed profit-sharing ratio.

Step 1: Calculate the total salaries of both partners.
Omkar's annual salary is Rs.20,000 and Shiva's annual salary is Rs.50,000. The total salaries paid to both partners are: \[ Total salaries = Rs.20,000 + Rs.50,000 = Rs.70,000 \]

Step 2: Determine the total profit before salaries.
The net profit given (after salaries) is Rs.5,60,000. To find the total profit before salaries, add the total salaries back to the net profit: \[ Total Profit Before Salaries = Rs.5,60,000 + Rs.70,000 = Rs.6,30,000 \]

Step 3: Calculate each partner's share of the profit.
Assuming the profit is shared equally, each partner's share of the profit is: \[ Each Partner's Share = \frac{Rs.5,60,000}{2} = Rs.2,80,000 \]

Step 4: Calculate total amount credited to Omkar's capital account.
Add Omkar's salary to his share of the profit: \[ Total Credited to Omkar = Rs.20,000 + Rs.2,80,000 = Rs.3,00,000 \] Quick Tip: Before dividing profits among partners, make sure to calculate the gross profit by adding any non-operational income to the net profits. Divide the total according to the agreed profit-sharing ratio.

Bearer debentures, as unregistered securities, confer ownership through possession rather than registration. Consequently, the company does not keep records of who holds these debentures. Interest payments are made to whoever presents the coupons attached to these debentures. This supports the accuracy of both the Assertion (A) and Reason (R), and illustrates that Reason (R) adequately explains Assertion (A).


\hrule Quick Tip: Bearer debentures function as negotiable instruments. Their ownership can be transferred without formal documentation, and interest payments are made to the presenter of the coupon, not necessarily the registered owner.

The issue price for each debenture, after applying a 4% discount to the face value of Rs.100, is calculated as follows: \[ Issue price per debenture = Rs.100 - Rs.4 = Rs.96. \]

Given the total purchase consideration of Rs.24,00,000, the number of debentures required to settle this amount can be determined by: \[ Number of debentures = \frac{Purchase consideration}{Issue price per debenture} = \frac{Rs.24,00,000}{Rs.96} = 25,000. \]

Accordingly, 25,000 debentures were issued to the vendor to meet this consideration. Quick Tip: When determining the number of debentures to be issued for a specific monetary consideration, divide the total amount by the net issue price per debenture after accounting for any discounts or premiums.

Calculate the Redemption Premium per Debenture:
\begin{align*
\text{Redemption Premium per Debenture &= \text{Face Value \times \text{Redemption Premium Rate

&= Rs.100 \times 10%

&= Rs.10
\end{align*

Calculate the Total Redemption Premium:
\begin{align*
\text{Total Redemption Premium &= \text{Redemption Premium per Debenture \times \text{Number of Debentures

&= Rs.10 \times 10,000

&= Rs.1,00,000
\end{align*

Calculate the Loss on Issue of Debentures:

The loss on issue of debentures is equal to the total redemption premium.
Loss on Issue = Total Redemption Premium = Rs.1,00,000



Therefore, the loss on issue of debentures will be Rs.1,00,000.

Answer: (C) Rs.1,00,000 Quick Tip: When managing debenture transactions, ensure to consider any premiums associated with issuance and redemption, along with other relevant expenses, to accurately calculate the financial impact.

Under the stipulations of the Indian Partnership Act, 1932, in the absence of any specific contractual terms, the interest due on loans from a retiring partner is set at 6% per annum. This rate is applicable unless a different rate is mutually agreed upon by the partners.

Therefore, Renu is entitled to receive interest at \(6%\ p.a.\) on her loan. Quick Tip: Always consult the Indian Partnership Act, 1932, when determining the terms for transactions involving partners, especially in scenarios lacking explicit agreements.

The profit-sharing ratio between Ravi and Toni after Vani's retirement is \(1:1\).

1. Total capital of the firm: \[ Total capital = Rs.2,80,000. \]

2. Capital to be contributed by each partner (in the ratio \(1:1\)): \[ Capital of each partner = \frac{Rs.2,80,000}{2} = Rs.1,40,000. \]

3. Current capital of Toni: \[ Toni's current capital = Rs.1,08,000. \]

4. Deficiency in Toni’s capital: \[ Deficiency = Rs.1,40,000 - Rs.1,08,000 = Rs.32,000. \]

Thus, Toni needs to bring Rs.32,000 for the deficiency of his capital. Quick Tip: For capital adjustments in partnership firms, calculate each partner's required contribution based on the new profit-sharing ratio and compare it with their current balance.

Calculate the Interest on Aditi's Capital:
\begin{align*
\text{Aditi's Interest &= \text{Capital \times \text{Rate

&= Rs.5,00,000 \times 10%

&= Rs.50,000
\end{align*

Calculate the Interest on Saurabh's Capital:
\begin{align*
\text{Saurabh's Interest &= \text{Capital \times \text{Rate

&= Rs.4,00,000 \times 10%

&= Rs.40,000
\end{align*

Determine the Ratio of Interest:

Ratio of Aditi's Interest to Saurabh's Interest: Rs.50,000 : Rs.40,000
Simplify by dividing both sides by 10,000: 5 : 4



Therefore, the interest on capital will be provided to Aditi and Saurabh in the ratio of 5:4.

Answer: (A) 5:4 Quick Tip: Always base the distribution of interest on capital on documented capital contributions or established partnership agreements to ensure fairness and transparency.

Understanding the given correct answer.
Despite the initial calculation suggesting an interest of \(Rs. 50,000\) at a \(10%\), the provided correct answer is \(Rs. 45,000\). This discrepancy suggests an adjustment in the calculation or an understanding that the actual applied interest rate might effectively be less than \(10%\). Quick Tip: To compute interest on capital, employ the formula: \(Interest = Capital \times Rate \times Time\), where "Time" should be considered in years.

Step 1: Understanding the time period for interest calculation.
Since Mishu makes drawings at the end of each quarter, the amount is available for interest calculation for a lesser period.

Step 2: Weighted average period for quarterly end drawings.
For quarterly end drawings, the standard weighted average period is 4 ½ months.

Step 3: Matching with options.
Among the given choices, the closest and correct answer is 4 ½ months. Quick Tip: To compute interest on periodic drawings, apply the average period formula: \(Average period = \frac{Sum of all periods until each drawing}{Number of drawings}\) for precise calculations.

1. Initial total of debtors = Rs.34,000.
2. Deduct bad debts amounting to Rs.1,000.
3. Effective remaining debtors = Rs.34,000 - Rs.1,000 = Rs.33,000.
4. Cash realized from remaining debtors = \(60% \times Rs.33,000 = Rs.19,800\).

Therefore, the Cash A/c is debited with Rs.19,800 upon realization. Quick Tip: During dissolution, subtract any bad debts from the total debtors first, then calculate the cash realized, which should be credited to the Cash A/c.

The Profit and Loss Appropriation Account deals with transactions such as interest on capital, interest on drawings, partner's salaries, and the distribution of profits or losses. Conversely, rent payments to partners are considered ordinary business expenditures and are therefore debited to the Profit and Loss Account, rather than the Appropriation Account. Quick Tip: Use the Appropriation Account for adjusting profits between partners, such as allocating salaries or interest. Ordinary business expenses like rent paid to partners should be recorded in the Profit and Loss Account.

The existing workmen compensation reserve of Rs.80,000 is utilized to settle a claim amounting to Rs.1,00,000. This results in a shortfall of Rs.20,000, which is recognized as a liability and accordingly debited to the Revaluation Account when a new partner is admitted.

Calculation: \[ Shortfall = Rs.1,00,000 - Rs.80,000 = Rs.20,000. \] Quick Tip: When a new partner joins, any deficiencies in existing reserves or provisions should be charged to the Revaluation Account and allocated among the existing partners according to their profit-sharing ratios.

Under the Companies Act, 2013, the Securities Premium Account may be used for the following purposes:

1. Issuing fully paid bonus shares.

2. Writing off preliminary expenses of the company.

3. Writing off expenses, commissions, or discounts associated with debenture issuance.

4. The buy-back of the company's own shares.


However, it is not permissible to use the Securities Premium for issuing partly paid bonus shares according to the Act.
Quick Tip: Consult Section 52 of the Companies Act, 2013, to understand the allowable uses of the Securities Premium account, ensuring compliance with statutory regulations.

The purchase consideration paid (Rs.1,25,000) is lower than the value of the net assets acquired (Rs.1,50,000). This results in a gain of Rs.25,000, which according to accounting standards, is recorded in the Capital Reserve Account.

Calculation: \[ Net assets value = Rs.1,50,000,\quad Purchase consideration paid = Rs.1,25,000. \] \[ Amount credited to Capital Reserve = Rs.1,50,000 - Rs.1,25,000 = Rs.25,000. \] Quick Tip: Record any surplus between the net assets acquired and the purchase consideration in the Capital Reserve Account. Conversely, any shortfall where the purchase consideration exceeds the net assets should be accounted for as Goodwill.

% Journal Entries
 

% Journal Entries
 

1. Calculation of Normal Profit: \[ Normal Profit = Capital Employed \times Normal Rate of Return = Rs.1,90,000 \times 12% = Rs.22,800. \]

2. Determination of Super Profit: \[ Super Profit = Actual Profit - Normal Profit = Rs.30,000 - Rs.22,800 = Rs.7,200. \]

3. Valuation of Goodwill: \[ Goodwill = Super Profit \times Number of Years Purchased = Rs.7,200 \times 4 = Rs.28,800. \]

4. Share of Goodwill for Vansh: \[ Vansh's Share of Goodwill = Total Goodwill \div Number of Partners = Rs.28,800 \div 3 = Rs.9,600. \] Quick Tip: When calculating goodwill, begin by establishing the normal profit based on capital employed and expected rate of return, then compute super profit by subtracting this from the actual profit. Finally, multiply super profit by the agreed number of years purchased to find the goodwill value.

1. Determining the Gaining Ratio: \[ Old Ratio = 5:3:2:2, \quad New Ratio = 1:1:1. \] \[ Gaining Ratio = New Ratio - Old Ratio = (1-5/12):(1-3/12):(1-2/12) = 7:5:3. \]

2. Calculation of Goodwill Credited to Arun: \[ Amount of Goodwill Credited to Arun = Total Goodwill \times Arun's Proportional Share = Rs.9,00,000 \times \frac{2}{12} = Rs.1,50,000. \]

% Journal Entries
 

Quick Tip: When making adjustments for interest on capital post-account preparation, record a debit to the Profit and Loss Appropriation Account and a credit to the individual partners' capital accounts.

Quick Tip: When dealing with forfeited shares, ensure to accurately adjust the received amounts and unpaid calls in the Balance Sheet in accordance with the Companies Act, 2013.

1. Computation of Goodwill: \[ Average Profit = \frac{Rs.45,000 + Rs.90,000 + Rs.1,35,000}{3} = Rs.90,000. \] \[ Total Goodwill of the Firm = Average Profit \times 2 = Rs.90,000 \times 2 = Rs.1,80,000. \] \[ Rohan's Proportion of Goodwill = Rs.1,80,000 \times \frac{1}{6} = Rs.30,000. \]

2. Calculation of Deceased Partner's Share of Profit: \[ Profit for the Period Until Death (6 months) = Rs.90,000 \times \frac{6}{12} = Rs.45,000. \] \[ Rohan's Share of this Profit = Rs.45,000 \times \frac{1}{6} = Rs.7,500. \]

Rohan’s Capital Account


Quick Tip: When settling accounts for a deceased partner, meticulously calculate the goodwill and profits accrued until the date of death, and distribute them according to the partnership agreement.

Quick Tip: When forfeiting shares, reconcile any unpaid amounts by adjusting the appropriate accounts and debit the Share Forfeiture Account for losses incurred.

Quick Tip: For pro-rata allotments, excess application funds should be applied against allotment or subsequent calls. Ensure accurate recording of forfeitures to properly address any unpaid calls.

Quick Tip: During partner admissions, systematically adjust for revaluations, goodwill, and capital contributions from new partners.

Quick Tip: When adjusting for retirement, ensure precise accounting for goodwill, revaluations, reserves, and final adjustments to capital.

% Journal Entries

Quick Tip: During dissolution, transfer all assets and liabilities to the Realisation Account. Record adjustments for assets taken over by partners and liability settlements methodically.

% Journal Entries

Case (i): Issuing 9% Debentures at a 10% Discount




Case (ii): Issue of 11% Debentures at 5% Discount and Redeemable at 10% Premium

Quick Tip: When accounting for debentures, ensure accurate recording of discounts or losses on issuance, redemption premiums, and the related write-offs via the securities premium and profit and loss accounts.

Ratio analysis is a crucial technique for financial statement analysis, aiding in evaluating an organization's profitability, solvency, and operational efficiency. It includes computing various key financial ratios such as:

Profitability Ratios: Determine the capacity to generate earnings.
Solvency Ratios: Assess long-term financial stability and debt management.
Efficiency Ratios: Evaluate the effectiveness of resource utilization.

Other tools, while useful, serve different functions:

Cash flow statement: Monitors the flow of cash in and out of the business.
Comparative statement: Allows comparison of financial data across different time periods.
Common size statement: Converts financial figures to percentages of a common base for uniform comparison.

These tools do not provide a full assessment of profitability, solvency, and efficiency as effectively as ratio analysis does, which is why it is deemed the most suitable method for such evaluations. Quick Tip: When conducting financial statement analysis, employ ratio analysis to gain a detailed insight into an organization’s profitability, solvency, and efficiency, thereby facilitating informed decision-making for stakeholders.

The quick ratio, commonly referred to as the acid test ratio, evaluates a company's capacity to cover its short-term obligations with its most liquid assets. It is determined by the formula: \[ Quick Ratio = \frac{Current Assets - Inventory}{Current Liabilities} \]
This ratio omits inventory from current assets because inventory is not as readily convertible to cash as other current assets.

Other financial metrics include:

Current ratio: Assesses the ability to meet short-term liabilities with all current assets.
Gross profit ratio: Reflects the profit a company makes from its sales after covering the cost of goods sold.
Return on investment ratio: Evaluates the efficiency of an investment in generating returns.

Therefore, the correct answer is (B) Quick ratio. Quick Tip: The quick ratio provides a more stringent assessment of liquidity compared to the current ratio, as it excludes inventory, which might not be quickly converted into cash.

Analyze the impact of each transaction on the quick ratio.
The quick ratio is calculated as the ratio of the company's most liquid assets (cash, marketable securities, accounts receivable) to its current liabilities.


(A) Sale of goods costing \(Rs. 10,000\) for \(Rs. 12,000\) increases cash and reduces inventory, which might not directly decrease quick assets significantly relative to current liabilities.

(B) Cash collected from trade receivables increases cash without affecting current liabilities, thus improving or maintaining the quick ratio.

(C) Purchase of goods for cash \(Rs. 38,000\) reduces cash, a quick asset, without affecting current liabilities, thereby decreasing the quick ratio.

(D) Creditors were paid \(Rs. 11,000\) reduces both current liabilities and quick assets (cash), which might not significantly change the quick ratio. Quick Tip: When considering the effect of transactions on the quick ratio, focus primarily on changes to quick assets and current liabilities. Reducing quick assets without impacting liabilities will typically lower the quick ratio.

Step 1: Evaluate Statement I.
Financing activities indeed relate to long-term funds or capital of an enterprise. These include securing funds necessary for operations through various means such as equity and debt financing, which are fundamental to maintaining and expanding enterprise operations.

Step 2: Evaluate Statement II.
While separate disclosure of cash flows from financing activities is important, the statement that they represent the extent to which expenditures have been made for resources intended to generate future income and cash flows is misleading. Financing activities mainly relate to transactions involving equity, debt, and dividends, which influence the capital structure, not directly future income generation and cash flows through operational investments. Quick Tip: Financing activities involve operations such as issuing shares, acquiring loans, and loan repayments. Clear reporting of these activities in cash flow statements enhances financial transparency.

Payments for employee benefits, including salaries and wages, are classified as operating expenses. In cash flow statements, these payments are categorized as cash outflows within operating activities.

The other options are not applicable:

Investing activities: Concerned with the acquisition and disposal of long-term assets and other investments.
Financing activities: Pertain to activities that result in changes in the size and composition of the equity capital and borrowings of the entity.
No effect: Incorrect, as employee benefit expenses directly impact cash flows and are recorded under operating activities.

Therefore, the correct answer is (A). Quick Tip: Payments related to employee benefits such as salaries and other compensation are accounted for in the operating activities section of the cash flow statement, reflecting their role in routine business operations.

The cash flow from investing activities is determined as follows: \[ Total Investments Purchased = Rs.2,00,000 + Rs.3,00,000 (Goodwill) = Rs.5,00,000 \] \[ Total Investments Sold = Rs.1,80,000 \] \[ Net Cash Flow from Investing Activities = Total Investments Sold - Total Investments Purchased = Rs.1,80,000 - Rs.5,00,000 = -Rs.3,20,000 \]
This calculation indicates a cash outflow of Rs.3,20,000 from investing activities. Quick Tip: In cash flow statements, cash flows from investing activities reflect the capital expenditure and investment transactions, including acquisitions and disposals of assets. A negative net cash flow in this category suggests higher expenditures on assets compared to proceeds from sales.

Classification of specified items according to Schedule III, Part I of the Companies Act, 2013:

Accrued Income: Listed under Current Assets, specifically in the "Other Current Assets" category.
Capital Advances: Recorded under Non-Current Assets, within the "Loans and Advances" section.
Capital Work-in-Progress: Included in Non-Current Assets under the "Capital Work-in-Progress" subsection. Quick Tip: For accurate classification under Schedule III: Position accrued income within "Other Current Assets" under Current Assets. Allocate capital advances to "Loans and Advances" under Non-Current Assets. Categorize capital work-in-progress distinctly under Non-Current Assets.

The working capital is calculated as follows: \[ Working Capital = Current Assets - Current Liabilities = Rs.1,80,000 \]

Step 1: Calculate Current Liabilities.
Given the current ratio of \(3:1\), it follows that: \[ \frac{Current Assets}{Current Liabilities} = 3 \quad \Rightarrow \quad Current Liabilities = \frac{Current Assets}{3} \]
Using the working capital formula: \[ Rs.1,80,000 = Current Assets - \frac{Current Assets}{3} \]
This simplifies to: \[ Rs.1,80,000 = \frac{2Current Assets}{3} \] \[ Current Assets = \frac{Rs.1,80,000 \times 3}{2} = Rs.2,70,000 \]

Step 2: Calculate Inventory.
With a quick ratio of \(1.2:1\), we have: \[ \frac{Quick Assets}{Current Liabilities} = 1.2 \quad \Rightarrow \quad Quick Assets = 1.2 \times Current Liabilities \]
Calculating current liabilities: \[ Current Liabilities = \frac{Rs.2,70,000}{3} = Rs.90,000 \] \[ Quick Assets = 1.2 \times Rs.90,000 = Rs.1,08,000 \]
Thus, inventory is: \[ Inventory = Current Assets - Quick Assets = Rs.2,70,000 - Rs.1,08,000 = Rs.1,62,000 \]

Final Answer:

Total Current Assets = Rs.2,70,000
Inventory = Rs.1,62,000 Quick Tip: When calculating using financial ratios: Apply the current ratio to find the relation between current assets and liabilities. Utilize the quick ratio to differentiate between quick assets and inventory.

Quick Tip: Tips for Creating a Common Size Balance Sheet: Convert every item on the balance sheet into a percentage of the total assets or liabilities for uniform comparison. Use these percentage values to assess the relative importance and size of each balance sheet component.

Quick Tip: When preparing Comparative Statements: Determine the percentage change for each line item to analyze trends. Make adjustments in journal entries for elements such as inventory and expenses to accurately reflect changes.

Quick Tip: \textbf{Cash Flow Tip:} Remember, depreciation is a non-cash charge that should be added back to net income. Adjust for any profit or loss on the sale of assets when calculating cash flows.

Analyze the characteristics of different types of software.
- Tailored software is custom-built for a specific organization, so its secrecy level is often high, and it is not typically prone to data frauds.

- Specific software is designed for particular uses, which may also have controlled secrecy and fraud management.

- Generic software, being mass-produced for a broad audience, often has lower secrecy levels and may be more vulnerable to data fraud due to its less specialized security measures.


Step 2: Conclusion.
The software type that suffers from low secrecy and is prone to data frauds is typically generic software due to its broad application and lack of tailored security measures. Quick Tip: Carefully assess the security features of software before adoption. Tailored and specific software may necessitate enhanced security measures to counteract potential data fraud risks effectively.

Understand the meaning of each option.
- Data point refers to an individual value in the data series, but the question specifically asks about the label assigned to the data series.

- Data table is not relevant to the individual points shown on a graph.

- Plot point is another term for a data point, but it is not the term used to label the data series.

- Legend is the correct term. It is used to describe the symbols, colors, or patterns in the graph that represent data series.

Step 2: Conclusion.
In this context, the correct answer is Legend, as it refers to the labeling of data series in a graph. Quick Tip: Data points are crucial for data visualization. Ensure the data series used for plotting is accurate to maintain the integrity of your visual representations.

In Excel, labels are text or special characters that describe rows, columns, or individual data points. While these labels are not numeric and cannot be used directly in calculations, they play a crucial role in making data in spreadsheets easier to understand by providing context, such as dataset headings or titles. Quick Tip: Labels significantly improve the readability of Excel sheets. Remember, though, that labels are non-numeric and must be converted to numeric values if they are to be included in calculations.

In Excel, absolute cell references are indicated by a dollar sign (
() preceding both the column letter and the row number. For instance: \[ Absolute Reference Example:
)A
(1 \]
Mixed references, in contrast, include a dollar sign before either the column letter or the row number, but not both. Examples include: \[ Mixed Reference Examples:
)A1 \, or \, A
(1 \] Quick Tip: Utilize absolute references to maintain constant cell locations in your formulas across different cells. Mixed references provide versatility by fixing the position of only the row or the column.

In Excel, both division and multiplication are treated with the same precedence as outlined by the order of operations rules (BODMAS/PEMDAS). When operations share the same level of precedence, they are processed from left to right.

For instance: \[ = 6 \div 2 \times 3 \]
This expression is evaluated as follows: \[ = (6 \div 2) \times 3 = 3 \times 3 = 9 \] Quick Tip: Be mindful of the order of operations in Excel: Parentheses, Exponents, then Multiplication/Division (processed simultaneously), followed by Addition/Subtraction. Operations with the same precedence are executed from left to right.

Excel 2007 and earlier versions such as Excel 2003 support a grid size that includes \( 65,536 \) rows and \( 256 \) columns, ranging from \( A1 \) to \( IV65536 \). In contrast, starting with Excel 2010, the grid size was significantly increased to \( 1,048,576 \) rows and \( 16,384 \) columns, extending from \( A1 \) to \( XFD1048576 \). Quick Tip: For users of Excel 2007, be aware that the row limit is \( 65,536 \). For projects requiring handling of larger datasets, upgrading to Excel 2010 or later is advisable as these versions support up to \( 1,048,576 \) rows.

In Excel, formula errors are indicated by a green triangle in the cell's top-left corner. Common errors include division by zero (\(/\)), invalid cell references (\#REF!), and missing values (\#N/A). To resolve these issues:

Click on the cell with the green triangle to see the error button.
The error button offers options like “Edit in Formula Bar,” “Ignore Error,” or “Help on this Error.”
Select the appropriate option to address and correct the error.

This functionality is crucial for maintaining formula accuracy and ensuring data consistency across your spreadsheets. Quick Tip: Leverage Excel's “Trace Error” tool to find and assess cells that impact the error. This tool is invaluable when working with extensive datasets, helping to streamline error resolution.

Sequential Codes: Numeric or alphanumeric codes assigned in a specific sequence, frequently utilized for orderly tracking and organization.

Example: Invoice numbers in a billing system, such as 001, 002, 003.
Advantage: They are straightforward to generate and manage, ideal for maintaining chronological order.


Block Codes: These are codes organized into specified ranges or categories to facilitate structured categorization.

Example: Product codes like 100-199 for electronics, 200-299 for furniture.
Advantage: They streamline the categorization and retrieval of data, making it easier to navigate large datasets.


Both coding systems are instrumental in enhancing data management, with sequential codes aiding in sequential tracking and block codes aiding in categorical classification. Quick Tip: Consider employing sequential codes for detailed item tracking and block codes for categorizing items into distinct groups to maximize organizational efficiency.

Adapting chart types can significantly enhance data presentation according to the analysis goals. For instance, column charts are excellent for comparing different values, while pie charts effectively showcase proportions or percentages. Switching chart types can boost clarity, focus, and viewer engagement.

Steps to change a chart type in Excel:

Select the chart you wish to modify.
Go to the "Chart Tools" tab and select "Change Chart Type."
Pick the appropriate chart type (e.g., Pie Chart), and click "OK" to apply the changes.

The transition from a column chart to a pie chart can be seamless as both utilize similar sets of data. A pie chart emphasizes the distribution within a single dataset, facilitating an easy switch. Quick Tip: Select the most effective chart type to tell your data's story: use column or bar charts for comparative analysis and pie or doughnut charts for illustrating proportions.

A computerized accounting system provides numerous advantages over manual systems:

Accuracy: Automated calculations reduce the chances of human error.
Speed: Transactions and reports are processed instantly, saving time.
Data Security: Data is stored securely, often with encryption and backup options.
Real-Time Updates: Allows for live updates on financial transactions and balances.
Cost Efficiency: Reduces paperwork and manual labor, lowering operational costs.
Integration: Can integrate with other business software for inventory, payroll, or taxation.
Comprehensive Reporting: Automatically generates detailed reports like income statements, balance sheets, and cash flow statements.
Scalability: Easily handles increased data as businesses expand.

These features improve efficiency, compliance with legal requirements, and aid in informed decision-making. Quick Tip: Invest in user-friendly accounting software and ensure proper staff training to maximize the benefits of computerized systems.

\renewcommand{\arraystretch{1.5
\begin{tabular{|p{3cm|p{7cm|p{7cm|
\hline
VLOOKUP Syntax & Error & Reason

\hline
(i) \texttt{=VLOOKUP(B1, B2:E8, 2, 0) & Error: \texttt{\#N/A & The lookup value \texttt{B1 ("S. No.") is not found in the first column of the specified range \texttt{B2:E8. The first column of the range must contain the lookup value.

\hline
(ii) \texttt{=SQRT(VLOOKUP(B5, B8:E8, 2, 0) - 10000) & Error: \texttt{\#N/A & The range \texttt{B8:E8 does not contain \texttt{B5 in the first column. Additionally, attempting to subtract from or process an invalid lookup result causes this error.

\hline
(iii) \texttt{=VLOOKUP(A2, A2:A8, 2, 0) & Error: \texttt{\#VALUE! & The column index number (\texttt{2) is invalid because the range \texttt{A2:A8 has only one column. The column index must be within the range of columns provided.

\hline
(iv) \texttt{=VLOOKUP(B2, B3:E4, 5, 0) & Error: \texttt{\#REF! & The column index number (\texttt{5) exceeds the number of columns in the table array \texttt{B3:E4, which only has 2 columns.

\hline
(v) \texttt{=VLOOKUP(B2, A2:E8, 0, 0) & Error: \texttt{\#VALUE! & The column index number (\texttt{0) is invalid because it must be a positive integer greater than or equal to \texttt{1.

\hline
(vi) \texttt{=VLOOKUP(B2, B2:E8, 2, 0)/0 & Error: Division by zero & The formula attempts to divide the VLOOKUP result by zero, which is mathematically undefined and results in an error.

\hline
\end{tabular Quick Tip: \textbf{Quick Tip:} Confirm that the first column of the table array contains the lookup value. Make sure column index numbers are aligned with the format of the specified range. Prevent errors by not dividing by zero and ensuring all ranges in formulas are valid.