• Practice
  • About 13 min
  • 5 practice questions

Sorting a set of loans fast: the tick-box table and running totals

Classify a list of loans against stated limits using a tick-box table, then total the priority sector lending and each bucket without double counting or missing a limit.

If something looks wrong, please tell us.

A common practice question lists seven or eight loans, states a limit or two, and asks for the priority sector total, the amount in one bucket or the number of loans that qualify. The mistakes are never in the arithmetic. They come from skipping a limit, counting a weaker-section line twice or classifying by the borrower. A tick-box table prevents all three. Every limit and amount here is invented for practice; in an exam, use the limits the question gives.

The tick-box table

Draw a row for each loan and four small columns: Qualifies?, Category, Small and marginal farmer? and Weaker sections? Fill the columns in this order. First test the limit and the purpose; if the loan fails, write a cross and move on, and none of the other columns count. For a qualifying loan, write its purpose category, then tick the borrower columns. Finally add each column separately from the ticks. The total is the sum of the qualifying amounts, once each.

Cross out first: limit, purpose. Then category by purpose. Then borrower ticks. Total = qualifying amounts once. 'Of which' ticks never add to the total.

A worked set

Example 1. Suppose the rules in a question say: home loans qualify only up to ₹80 lakh each and education loans only up to ₹55 lakh each (both limits invented, and far from any real limit); a loan above its limit does not qualify at all. The loans (₹ lakh): (1) crop loan to a small farmer, 6; (2) home loan, 72; (3) home loan, 88; (4) education loan, 10; (5) education loan, 60; (6) loan to a micro manufacturing unit, 20; (7) personal loan for a wedding, 5; (8) dairy loan to a marginal farmer, 4; (9) loan to a large steel company, 500. Find the priority sector total, and the amounts in agriculture and among small and marginal farmers. Working: (1) qualifies: agriculture, small and marginal farmer, 6. (2) qualifies: housing, 72. (3) fails the limit: 88 > 80. (4) qualifies: education, 10. (5) fails: 60 > 55. (6) qualifies: micro enterprise, 20. (7) personal consumption: fails. (8) qualifies: agriculture (allied), small and marginal farmer, 4. (9) a large company: fails. Total = 6 + 72 + 10 + 20 + 4 = ₹112 lakh. Agriculture = 6 + 4 = ₹10 lakh. Small and marginal farmers = 6 + 4 = ₹10 lakh. Answer: ₹112 lakh in all, ₹10 lakh in agriculture, ₹10 lakh among small and marginal farmers.

Example 2. In the set above, find the amount that does not qualify and verify the total. Working: failures are 88 + 60 + 5 + 500 = ₹653 lakh. All the loans together = 6 + 72 + 88 + 10 + 60 + 20 + 5 + 4 + 500 = ₹765 lakh. Check: 112 + 653 = 765. Answer: ₹653 lakh does not qualify. The check that qualifying plus non-qualifying equals the whole list catches a lost or doubled loan.

Example 3. Suppose the invented housing limit in the question were raised to ₹95 lakh, with the other rules unchanged. What is the new total? Working: the ₹88 lakh home loan now passes its limit and qualifies as housing. The new total = 112 + 88 = ₹200 lakh. The ₹60 lakh education loan still fails its limit of 55. Answer: ₹200 lakh. Changing one limit changes only the loans of that kind.

The traps in this kind of question

  • A limit per loan, not per borrower: unless the question says otherwise, test each loan against the limit on its own.
  • The whole loan fails: a loan above its limit does not qualify in part, unless the question says so.
  • The borrower's description: a farmer's car loan is consumption, not agriculture.
  • Large companies and consumption: a big company's general loan and a personal loan do not count.
  • Double counting: a small farmer's crop loan appears in agriculture, in the small and marginal group and in the total, but it is one loan of the same amount.

Speed tip

Do not recompute the whole table for each sub-question. Fill the table once and read every bucket from it. If a question changes a limit, find the rows affected by that limit and adjust only those.

Key takeaways. Test the limit and the purpose first. Classify by purpose, then tick borrower groups. Add each bucket once, and never add an 'of which' tick to the total. Check that qualifying plus non-qualifying equals the whole list.

Check your understanding

  1. 1. Under a stated (invented) rule, home loans qualify only up to ₹80 lakh each. A home loan of ₹88 lakh is:

    1. Counted fully
    2. Counted up to ₹80 lakh
    3. Counted as education
    4. Not counted at all
    Show answer

    Answer: D. Unless the question says otherwise, a loan above its limit does not qualify at all.

  2. 2. A farmer takes a loan to buy a car for family use. Under priority sector classification it is:

    1. Agriculture
    2. Not agriculture
    3. Housing
    4. A micro enterprise
    Show answer

    Answer: B. Purpose decides the category. A car for family use is consumption, not farming.

  3. 3. Qualifying loans of ₹6, ₹72, ₹10, ₹20 and ₹4 lakh are found in a list. The priority sector total is:

    1. ₹112 lakh
    2. ₹102 lakh
    3. ₹122 lakh
    4. ₹142 lakh
    Show answer

    Answer: A. 6 + 72 + 10 + 20 + 4 = 112 lakh.

  4. 4. Of the qualifying loans in the previous question, agriculture is ₹6 lakh and ₹4 lakh. The agriculture bucket is:

    1. ₹24 lakh
    2. ₹112 lakh
    3. ₹10 lakh
    4. ₹6 lakh
    Show answer

    Answer: C. 6 + 4 = ₹10 lakh; the other loans are housing, education and micro enterprise.

  5. 5. Suppose an invented housing limit rises from ₹80 lakh to ₹95 lakh and a ₹88 lakh home loan is in the list, with a total of ₹112 lakh. The new total is:

    1. ₹112 lakh
    2. ₹127 lakh
    3. ₹207 lakh
    4. ₹200 lakh
    Show answer

    Answer: D. The ₹88 lakh loan now qualifies: 112 + 88 = ₹200 lakh.

Privacy · Terms · Refunds · Delivery