CMA Intermediate · Financial Management and Business Data Analytics · Comparative, Common-Size Financial Statements and Trend Analysis
Sales of Mehta Foods Ltd. have trend indices (base Year 1 = 100) of 100, 120, 150 and 135 for Years 1 to 4. Year 1 sales were Rs 50 lakh. By what percentage did sales change from Year 3 to Year 4, and what are Year 4 sales?
Sales fell by 10 percent to Rs 67.5 lakh. Year 4 sales are 135 percent of Rs 50 lakh, while Year 3 was Rs 75 lakh. The 15-point index drop is measured against 150, not 100, giving 10 percent.
- ADecrease of 15%; Rs 67.5 lakh
- BDecrease of 10%; Rs 67.5 lakhCorrect
- CDecrease of 10%; Rs 75 lakh
- DDecrease of 15%; Rs 75 lakh
Explanation
Year 4 sales = 50 x 1.35 = Rs 67.5 lakh. Year 3 sales = 50 x 1.5 = Rs 75 lakh. Change = (67.5-75)/75 = -10%. The 15-point fall in the index is not a 15% fall, since the correct base is Year 3's index of 150 (15/150 = 10%).
Did you get it right without looking?
One question tells you little. A timed set on Comparative, Common-Size Financial Statements and Trend Analysis shows your real accuracy, how long you take and where you lose marks.
More Comparative, Common-Size Financial Statements and Trend Analysis questions
- Arjun Traders has the following comparative data: current assets ₹6,00,000 (2023-24) and ₹7,50,000 (2024-25); current liabilities ₹3,00,000 …
- In the common-size balance sheet of Kaveri Foods Ltd, total assets are ₹20,00,000 and current assets are 40% of total assets. Current liabil…
- Sundaram Textiles reported sales of ₹8,00,000 in 2023-24 and ₹10,00,000 in 2024-25. Net profit was ₹80,000 in 2023-24 and ₹1,20,000 in 2024-…
- For Orion Pharma Ltd, common-size figures (as % of revenue) for Year 1 and Year 2 are: gross profit 40% and 36%; other expenses 22% and 16%.…
- A comparative income statement of Sahyadri Foods shows net profit of ₹40,000 in Year 1 and ₹30,000 in Year 2 for a share capital base unchan…
- Which of the following best describes horizontal analysis of financial statements?