Question:

From the following information, prepare a Comparative Statement of Profit and Loss for the year ended $31^{\text {st }}$ March, 2024 :

Particulars2023-24 (₹)2022-23 (₹)
Revenue from operations8,00,0004,00,000
Cost of revenue from operations4,00,0002,00,000
Employee benefit expenses1,60,00080,000
Tax Rate50% 

(a) From the following information, calculate Opening Trade Receivables and Closing Trade Receivables :

  • Trade Receivables Turnover Ratio = 4 times
  • Closing Trade Receivables were ₹ 20,000 more than that in the beginning.
  • Cost of Revenue from operations = ₹ 6,40,000.
  • Cash Revenue from operations = $\frac{1}{3}$ of Credit Revenue from Operations
  • Gross Profit Ratio = 20%

Show Hint

Comparative Statements show absolute and percentage changes between two periods. - Absolute Change = Current Year Amount - Previous Year Amount. - Percentage Change = (Absolute Change / Previous Year Amount) * 100. Ensure correct calculation of Profit Before Tax and Tax Expense before finding the final Profit After Tax changes.
Hide Solution
collegedunia
Verified By Collegedunia

Solution and Explanation

Let's calculate the Opening and Closing Trade Receivables.

1. Calculate Revenue from Operations (Credit Revenue):

Gross Profit Ratio = 20%
Cost of Revenue from Operations = Rs 6,40,000
Revenue from Operations = Cost of Revenue from Operations / (1 - Gross Profit Ratio)
Revenue from Operations = Rs 6,40,000 / 0.80 = Rs 8,00,000
Cash Revenue = (1/3) * Credit Revenue
Total Revenue from Operations = Cash Revenue + Credit Revenue
Rs 8,00,000 = (4/3) * Credit Revenue
Credit Revenue = Rs 8,00,000 * (3/4) = Rs 6,00,000

2. Calculate Average Trade Receivables:

Trade Receivables Turnover Ratio = Credit Revenue / Average Trade Receivables
4 = Rs 6,00,000 / Average Trade Receivables
Average Trade Receivables = Rs 6,00,000 / 4 = Rs 1,50,000

3. Let's denote Opening Trade Receivables as X:

Closing Trade Receivables = X + Rs 20,000
Average Trade Receivables = (Opening + Closing Trade Receivables) / 2
Rs 1,50,000 = (2X + Rs 20,000) / 2
Rs 3,00,000 = 2X + Rs 20,000
2X = Rs 2,80,000
X = Rs 1,40,000

4. Calculate Opening and Closing Trade Receivables:

Opening Trade Receivables = Rs 1,40,000
Closing Trade Receivables = Rs 1,40,000 + Rs 20,000 = Rs 1,60,000

Answer:

Opening Trade Receivables: Rs 1,40,000
Closing Trade Receivables: Rs 1,60,000

Was this answer helpful?
0
0

Top Questions on Profit and Loss Account

View More Questions