All Exams Test series for 1 year @ ₹349 only
Question

Direction: Consider the following table that shows percentage profit earned by company ABC and company XYZ during the year 2011-2016. Answer the question based on the data contained in the table

Year

Percent profit earned by company ABC

Percent profit earned by company XYZ

2011

50

55

2012

70

60

2013

50

45

2014

40

50

2015

60

50

2016

80

75

If the amount of profit earned by company XYZ in 2012 was Rs. 9 Lakh, what was the total investment?

The correct answer is

15,00,000

Solving Data Interpretation Profit and Investment Question

This question requires us to use the provided data from the table on company profits to calculate the total investment of company XYZ in a specific year, given its profit amount and the corresponding percentage profit.

First, let's look at the relevant data from the table for company XYZ in the year 2012:

Year Percent profit earned by company ABC Percent profit earned by company XYZ
2011 50 55
2012 70 60
2013 50 45
2014 40 50
2015 60 50
2016 80 75

From the table, we can see that the percentage profit earned by company XYZ in the year 2012 was 60%.

We are also given that the amount of profit earned by company XYZ in 2012 was Rs. 9 Lakh. Rs. 9 Lakh is equal to Rs. 9,00,000.

The formula for percentage profit is:

$$ \text{Percentage Profit} = \left( \frac{\text{Profit}}{\text{Investment}} \right) \times 100 $$

We need to find the total investment. We can rearrange the formula to solve for Investment:

$$ \text{Investment} = \left( \frac{\text{Profit}}{\text{Percentage Profit}} \right) \times 100 $$

Now, let's substitute the given values into the formula:

  • Profit = Rs. 9,00,000
  • Percentage Profit = 60%

$$ \text{Investment} = \left( \frac{9,00,000}{60} \right) \times 100 $$

Let's perform the calculation step-by-step:

First, divide the Profit by the Percentage Profit (as a decimal or keep it as percentage and multiply by 100 later):

$$ \text{Investment} = \frac{9,00,000}{60} \times 100 $$

$$ \text{Investment} = 15,000 \times 100 $$

Now, multiply by 100:

$$ \text{Investment} = 15,00,000 $$

So, the total investment made by company XYZ in 2012 was Rs. 15,00,000.

Summary of Calculation for Investment

Here is a quick summary of how the investment was calculated:

  1. Identify the profit amount for company XYZ in 2012: Rs. 9,00,000.
  2. Find the percentage profit for company XYZ in 2012 from the table: 60%.
  3. Use the formula: Investment = (Profit / Percentage Profit) × 100.
  4. Substitute values: Investment = (9,00,000 / 60) × 100.
  5. Calculate the result: Investment = Rs. 15,00,000.

This result matches one of the given options.

Revision Table: Key Concepts

Concept Definition/Formula Relevance to Question
Profit Revenue - Expenses Given as Rs. 9 Lakh for XYZ in 2012.
Percentage Profit ((Profit / Investment) * 100)% Given as 60% for XYZ in 2012 in the table.
Investment The initial capital or amount spent to generate revenue/profit. The value we need to calculate. Formula is derived from Percentage Profit formula.
Data Interpretation Analyzing and drawing conclusions from given data, often in tables or charts. Requires extracting correct percentage profit from the provided table.

Additional Information on Profit and Investment

Understanding the relationship between profit, investment, and percentage profit is fundamental in business analysis and data interpretation questions. Profit represents the gain from an investment or business activity after deducting expenses. Investment is the capital put into the business or project.

Percentage profit provides a standardized way to compare the profitability of different investments or business activities, regardless of their absolute scale. A higher percentage profit generally indicates a more efficient or lucrative use of investment capital.

In these types of data interpretation problems, you often need to:

  • Read and understand the data presented in tables or charts accurately.
  • Identify the specific data points required for the question (e.g., profit percentage for a specific year and company).
  • Recall or derive the correct formula relating the given quantities (Profit, Investment, Percentage Profit).
  • Perform the necessary calculations carefully.

Remember that Profit can also be expressed as a percentage of Cost Price (Profit Margin) or Revenue. However, in the context of 'percentage profit earned' alongside investment, it usually refers to Profit as a percentage of Investment, or sometimes as a percentage of Revenue. The formula used in this solution, based on Investment, is the most common interpretation in such data interpretation questions unless specified otherwise.

Was this answer helpful?

Important Questions from Tabulation

  1. The table shows District-wise data of a number of primary school teachers posted in schools of a city.

    Study the table and answer the question:

    District

    Male teachers

    Female teachers

    East

    1650

    2375

    North

    1075

    2651

    West

    1280

    1520

    South

    1170

    1085

    Central

    690

    859


    What is the difference between the total number of male teachers in the districts East, North, West taken together and the total number of female teachers in the districts East and South?
  2. Table shows income (in Rs. ) received by 4 employees of a company during the month of December 2020 and all their income sources.

    Source

    Amit

    Suresh

    Nitin

    Varun

    Salary

    35000

    38500

    29000

    42000

    Arrears

    6000

    6300

    5000

    7500

    Bonus

    1000

    1100

    1000

    1240

    Overtime

    1800

    1950

    1400

    1500


    What is the ratio of salary of Varun to his income other than salary?
  3. Study the table and answer the question:

    Income (Rs.)

    No. of persons

    Less than 200

    12

    Less than 250

    26

    Less than 300

    34

    Less than 350

    40

    Less than 400

    50


    What is the percentage of persons earning Rs. 250 or more?
  4. The following table shows the annual profit of a company (in Rs. lakh).

    2014-2015

    2015-2016

    2016-0217

    2017-2018

    2018-2019

    625

    690

    725

    775

    815

    The period which has the maximum percentage increase in profit over the previous year is:

  5. The table given below shows the number of persons participating in a survey from 6 different states.

    States Persons 
    S1100
    S2200 
    S3400 
    S4500 
    S5600 
    S6800

    What is the ratio of number of person participating in a survey from state S3 to the number of person participating in a survey from state S4?

Need Expert Advice?

Start Your Preparation with Prepp Mobile App

Download the app from Google Play & App Store
Download the app from Google Play & App Store
Prepp Mobile App