Study guide

16.2 Analytical Reasoning, Data Interpretation, and Treasury Calculations

Basic Competency on Local Treasury Examination BCLTE

Track your progress as you read

Finished sections get a check mark.

1 Chapter 1: Introduction to BCLTE & Philippine Local Treasury Service

1.1 Examination Scope, Format, Scoring, and the SEAL Program 1.2 Structure of Philippine Local Government and Treasury Hierarchy 1.3 Navigating the BCLTE Curriculum and Study Strategy

2 Chapter 2: Principles of Local Taxation & LGU Taxing Powers

2.1 Fundamental Principles of Local Taxation under RA 7160 2.2 Common Limitations on Local Government Taxing Powers 2.3 Enactment, Public Hearings, and Effectivity of Local Tax Ordinances

3 Chapter 3: Real Property Taxation — Appraisal & Assessment

3.1 Real Property Appraisal Principles, Valuation, and Classification 3.2 Schedule of Market Values and Statutory Assessment Levels 3.3 Exemptions from Real Property Taxation under the Local Government Code

4 Chapter 4: Real Property Taxation — Levies, Collections & Remedies

4.1 Basic RPT Rates, Special Education Fund (SEF), and Idle Land Tax 4.2 Tax Billing, Installments, Prompt-Payment Discounts, and Delinquency Penalties 4.3 Administrative/Judicial Remedies and Statutory Distribution of Proceeds

5 Chapter 5: Local Business Taxes (LBT) & Other Local Taxes

5.1 Business Tax Bases, Graduated Rates, and Taxable Gross Receipts 5.2 Situs of Local Business Taxation and Multi-Branch Allocations 5.3 Specific Provincial and City Levies (Transfer, Professional, Amusement, Franchise)

6 Chapter 6: Fees, Charges, Economic Enterprises & Credit Financing

6.1 Regulatory Fees, Service Charges, and Barangay Clearance Rules 6.2 Operations and Revenue Mobilization of Local Economic Enterprises (LEEs) 6.3 LGU Credit Financing, Municipal Borrowing, and Debt Service Ceilings

7 Chapter 7: Management of Local Treasury Operations

7.1 Organization, Qualifications, Appointment, and Duties of Local Treasurers 7.2 Cash Management, Liquidity Planning, and Cash Flow Forecasting 7.3 Revenue Collection Protocols and Authorized Government Depository Banks (AGDBs)

8 Chapter 8: Disbursements, Fund Controls & Cash Advances

8.1 Disbursement Processing, Vouchers (DV), Checks, and ACIC Advice 8.2 Petty Cash Fund (PCF) Operations, Advances, and Liquidation Rules 8.3 Fund Accounting: General Fund, SEF, Trust Funds, and 20% Development Fund

9 Chapter 9: Safekeeping of Funds, Physical Security & Accountable Forms

9.1 Physical Custody, Vault Management, and Security Safeguards 9.2 Custody, Requisition, and Inventory of Accountable Forms (Form 51, Form 56) 9.3 Procedures for Lost, Stolen, or Damaged Accountable Forms and Cash

10 Chapter 10: Fidelity Bonding & Commission on Audit (COA) Oversight

10.1 Public Bonding Law, Fidelity Schedules, and Accountable Officer Coverage 10.2 COA Cash Audits, Cash Count Procedures, and Reconciliations 10.3 Handling Cash Shortages, Overages, and Relief from Accountability

11 Chapter 11: Statement of Receipts and Expenditures (SRE) & eSRE Portal

11.1 Statement of Receipts and Expenditures (SRE) Structure and Components 11.2 LIFT System Reporting, BLGF Guidelines, and Filing Timelines 11.3 Treasury Financial Indicators: Collection Efficiency, Operating Surplus, and Solvency

12 Chapter 12: Inter-Government Transfers & Public Financial Management

12.1 National Tax Allotment (NTA, Mandanas-Garcia Ruling) and Allocation Formulas 12.2 Shares in National Wealth, Tobacco Taxes, and Special Purpose Grants 12.3 Local Disaster Risk Reduction Management Fund (LDRRMF) and PFM Oversight

13 Chapter 13: Local Finance Committee & Stakeholder Coordination

13.1 Composition, Mandates, and Budget Recommendations of the LFC 13.2 Coordinating with the Local Chief Executive, Sanggunian, and Barangays 13.3 Technical Interfacing with BLGF, DOF, COA, DBM, and DILG

14 Chapter 14: Republic Act No. 6713 — Ethical Standards & Conduct

14.1 The Eight Norms of Conduct for Public Officials and Employees 14.2 Prohibited Acts, Financial Conflicts, Outside Employment, and Divestment 14.3 Statement of Assets, Liabilities, and Net Worth (SALN) and Transparency Rules

15 Chapter 15: Public Accountability, Transparency & Responsive Service

15.1 15-Day Response Timelines, Public Assistance, and Ease of Doing Business 15.2 Administrative Penalties, Sanctions, and Disciplinary Procedures 15.3 Internal Controls, Ethical Safeguards, and Fraud Prevention in Local Treasury

16 Chapter 16: General Ability — Verbal, Analytical & Management Skills

16.1 Verbal Ability and Reading Comprehension in Administrative Contexts 16.2 Analytical Reasoning, Data Interpretation, and Treasury Calculations 16.3 Basic Leadership, Delegation, and Supervisory Principles in LGUs

16.2 Analytical Reasoning, Data Interpretation, and Treasury Calculations

Key Takeaways Explain This Topic AI

Use a repeatable sequence: identify the data and rule, estimate, compute, check units, and test the result against the question.

The official booklet pace is about 70 seconds per response field overall, and does not make the ten EDQ fields scored test questions.

Percentage change, collection efficiency, assessed value, discounts, and interest require a clearly stated numerator, denominator, rate, and period.

A universal statement such as “all C are A” does not by itself prove that any C exists or that all A are C.

A standalone non-graphing, non-programmable, non-scientific four- or five-function calculator is the permitted exam aid.

Last updated: September 2026

16.2 Analytical Reasoning, Data Interpretation, and Treasury Calculations

Quick Answer: The Analytical Ability section of the BCLTE evaluates quantitative problem-solving, pattern recognition, and logical deduction under a tightly timed booklet. Number series are deciphered through systematic tier-testing: evaluating constant differences (arithmetic), constant ratios (geometric), second-order differences, and alternating interleaved sub-series. In treasury data interpretation, candidates must rapidly compute percentage variances [ ( Actual − Target ) / Target × 100 % ] [(\text{Actual} - \text{Target}) / \text{Target} \times 100\%] [( Actual − Target ) / Target × 100% ] , year-on-year growth rates, and collection efficiencies [ ( Actual Collections / Total Collectibles ) × 100 % ] [(\text{Actual Collections} / \text{Total Collectibles}) \times 100\%] [( Actual Collections / Total Collectibles ) × 100% ] . Applied treasury math tests multi-step calculations integrating prompt-payment discounts (e.g., 20% advance discount), four-tranche quarterly installment schedules, and statutory delinquency penalties (2% per month up to 72%). Formal logical deduction items are resolved with error-proof accuracy using Euler circles and Venn diagrams to evaluate categorical syllogisms.

1. Anatomy of the Analytical Test in the BCLTE

The BCLTE analytical domain measures fluid intelligence, numerical acuity, and systematic deduction. In local treasury operations, financial officers do not simply compute arithmetic totals; they interpret budget-to-actual variances, forecast cash inflows from historical trends, evaluate macroeconomic indicators, and verify that statutory formulas comply with Book II of Republic Act No. 7160. Four Pillars of Analytical Assessment in the BCLTE

  • ├── 1. Number Series & Sequences (Arithmetic, Geometric, Interleaved, Polynomial)
  • ├── 2. Data Interpretation (Revenue Ledgers, Variance Tables, Multi-Axis Charts)
  • ├── 3. Applied Treasury Mathematics (Discounts, Installments, Penalties, Weighted Means)
  • └── 4. Logical Deduction & Syllogisms (Euler Circles, Venn Diagrams, Categorical Proofs)

With 170 test questions plus 10 EDQ response fields allocated across a 3.5-hour testing block , an examinee has an average of about 70 seconds per booklet response field . Success requires bypassing manual trial-and-error in favor of structured diagnostic algorithms.

2. Number Series and Pattern Recognition

Civil service number series questions test the candidate's ability to deduce the underlying operational rule connecting successive terms. Rather than guessing randomly, examinees must execute a four-step diagnostic sequence: Diagnostic Decision Tree for Number Series

  • [Inspect Sequence: a₁, a₂, a₃, a₄, a₅...]
  • │

├─► Step 1: Does the sequence grow or shrink smoothly?

  • │ └─► Calculate 1st Difference (Δ₁ = aₙ - aₙ₋₁)
  • │ ├─► Constant Δ₁: Arithmetic Series
  • │ └─► Linear or Accelerating Δ₁: Calculate 2nd Difference (Δ₂)
  • │

├─► Step 2: Does the sequence explode exponentially?

  • │ └─► Test Constant Ratio (r = aₙ / aₙ₋₁): Geometric Series
  • │

├─► Step 3: Does the sequence oscillate up and down?

  • │ └─► Split into Alternating / Interleaved Series (Odd vs Even terms)
  • │

└─► Step 4: Do differences fail standard arithmetic/geometric tests?

  • └─► Test Fibonacci (aₙ = aₙ₋₁ + aₙ₋₂) or Squares/Cubes (n² ± k, n³ ± k)
  • The Five Master Series Architectures

Arithmetic Progressions (Constant 1st Difference): a n = a 1 + ( n − 1 ) d a_n = a_1 + (n - 1)d a n ​ = a 1 ​ + ( n − 1 ) d Example: 14 , 21 , 28 , 35 , 42 , … 14, 21, 28, 35, 42, \dots 14 , 21 , 28 , 35 , 42 , … ( d = + 7 d = +7 d = + 7 ).

Two-Tier / Multi-Tier Progressions (Constant 2nd Difference): The first differences are not constant, but the differences between differences form a pattern. Sequence: 3 , 8 , 16 , 27 , 41 , 58 , … 3, 8, 16, 27, 41, 58, \dots 3 , 8 , 16 , 27 , 41 , 58 , … 1st Differences: + 5 , + 8 , + 11 , + 14 , + 17 +5, +8, +11, +14, +17 + 5 , + 8 , + 11 , + 14 , + 17 2nd Differences: + 3 , + 3 , + 3 , + 3 +3, +3, +3, +3 + 3 , + 3 , + 3 , + 3 (Constant Δ 2 = + 3 \Delta_2 = +3 Δ 2 ​ = + 3 ). Next term: 58 + ( 17 + 3 ) = 58 + 20 = 78 58 + (17 + 3) = 58 + 20 = 78 58 + ( 17 + 3 ) = 58 + 20 = 78 .

Geometric Progressions (Constant Ratio): a n = a 1 × r n − 1 a_n = a_1 \times r^{n-1} a n ​ = a 1 ​ × r n − 1 Example: 6 , 18 , 54 , 162 , 486 , … 6, 18, 54, 162, 486, \dots 6 , 18 , 54 , 162 , 486 , … ( r = 3 r = 3 r = 3 ).

Interleaved / Alternating Sequences (Dual Threads): Two completely independent sub-sequences are woven together at odd and even positions. Whenever a series alternates between increasing and decreasing, or features duplicate values, immediately separate the odd and even indices. Sequence: 5 , 12 , 9 , 16 , 13 , 20 , 17 , 24 , … 5, 12, 9, 16, 13, 20, 17, 24, \dots 5 , 12 , 9 , 16 , 13 , 20 , 17 , 24 , … Odd terms (indices 1, 3, 5, 7): 5 , 9 , 13 , 17 , … 5, 9, 13, 17, \dots 5 , 9 , 13 , 17 , … ( + 4 +4 + 4 progression). Even terms (indices 2, 4, 6, 8): 12 , 16 , 20 , 24 , … 12, 16, 20, 24, \dots 12 , 16 , 20 , 24 , … ( + 4 +4 + 4 progression). Next term (index 9, odd): 17 + 4 = 21 17 + 4 = 21 17 + 4 = 21 .

Recursive / Fibonacci-Type Series: Each term is the algebraic sum or function of the two preceding terms. Sequence: 2 , 3 , 5 , 8 , 13 , 21 , 34 , … 2, 3, 5, 8, 13, 21, 34, \dots 2 , 3 , 5 , 8 , 13 , 21 , 34 , … ( a n = a n − 1 + a n − 2 a_n = a_{n-1} + a_{n-2} a n ​ = a n − 1 ​ + a n − 2 ​ ). Next term: 21 + 34 = 55 21 + 34 = 55 21 + 34 = 55 .

3. Data Interpretation from Treasury Schedules and Reports

Local treasurers spend considerable time evaluating the Statement of Receipts and Expenditures (SRE) and subsidiary collection ledgers. Analytical test items present multi-column numerical tables depicting annual budgets, collection targets, and actual remittances across various revenue codes.

Core Analytical Formulas in Public Treasury

Treasury Metric Mathematical Formulation Operational Interpretation

Percentage Variance Actual − Target Target × 100 % \frac{\text{Actual} - \text{Target}}{\text{Target}} \times 100\% Target Actual − Target ​ × 100% Measures performance deviation from budget; positive variance indicates surplus/overperformance, negative indicates shortfall.

Year-on-Year (YoY) Growth Current Year − Prior Year Prior Year × 100 % \frac{\text{Current Year} - \text{Prior Year}}{\text{Prior Year}} \times 100\% Prior Year Current Year − Prior Year ​ × 100% Tracks secular expansion or contraction of specific tax bases over time.

Collection Efficiency Ratio (CER) Actual Collections Total Collectibles (Target) × 100 % \frac{\text{Actual Collections}}{\text{Total Collectibles (Target)}} \times 100\% Total Collectibles (Target) Actual Collections ​ × 100% Evaluates enforcement effectiveness; standard benchmark for local treasury rating.

Sectoral Share / Contribution Category Collections Total LGU Revenue × 100 % \frac{\text{Category Collections}}{\text{Total LGU Revenue}} \times 100\% Total LGU Revenue Category Collections ​ × 100% Determines dependence on specific tax sources (e.g., local source vs National Tax Allotment).

Strategic Table Interpretation Protocol

When faced with a complex numerical table on the examination:

Read the Title and Footnotes First: Verify reporting periods, currency units (e.g., "In Thousands of Pesos (₱'000)" ), and accounting bases (cash vs accrual).

Isolate the Specific Row/Column: Do not calculate unnecessary cells. Identify the precise row (e.g., Real Property Tax - Basic ) and relevant column (e.g., Variance % ).

Watch the Denominator: The most common trap in percentage calculations is selecting the wrong base year or target figure. For variance, the denominator is always the Target (Budget) , never the Actual.

4. Practical Applied Treasury Mathematics

Applied word problems on the BCLTE test the statutory arithmetic of Book II, RA 7160. Candidates must master compound calculations involving prompt-payment discounts, installment distributions, and delinquency interest surcharges. Real Property Tax Lifecycle & Statutory Math Rules

  • ├── Full Advance Payment (on/before Jan 1 or Jan 31): Up to 20% prompt discount (Sec. 251)
  • ├── Quarterly Installments (Sec. 250): 4 equal tranches due Mar 31, Jun 30, Sep 30, Dec 31
  • └── Delinquency Penalty (Sec. 255): 2% interest per month of delinquency, capped at 36 months (72% max)
  • The Prompt-Payment Discount (Section 251, RA 7160)

If the basic real property tax and the additional Special Education Fund (SEF) tax are paid in advance on or before the dates prescribed by local ordinance, the Sanggunian may grant a discount not exceeding twenty percent (20%) of the annual tax due.

If a commercial property has an annual Basic RPT of ₱50,000 and SEF of ₱25,000 (Total = ₱75,000), and the municipality grants a 15% advance discount : Discount Amount = PHP 75 , 000 × 0.15 = PHP 11 , 250 \text{Discount Amount} = \text{PHP } 75,000 \times 0.15 = \text{PHP } 11,250 Discount Amount = PHP 75 , 000 × 0.15 = PHP 11 , 250 Net Cash Payment Due = PHP 75 , 000 − PHP 11 , 250 = PHP 63 , 750 \text{Net Cash Payment Due} = \text{PHP } 75,000 - \text{PHP } 11,250 = \text{PHP } 63,750 Net Cash Payment Due = PHP 75 , 000 − PHP 11 , 250 = PHP 63 , 750

The Four Quarterly Installments (Section 250, RA 7160)

The owner of real property or person having legal interest therein may pay the basic real property tax and SEF without interest in four (4) equal installments :

  • 1st Installment: On or before March 31
  • 2nd Installment: On or before June 30
  • 3rd Installment: On or before September 30
  • 4th Installment: On or before December 31

Each installment represents exactly 25% of the total annual liability.

Delinquency Penalties (Section 255, RA 7160)

Failure to pay the tax upon the expiration of the quarter subjects the taxpayer to the payment of interest at the rate of two percent (2%) per month on the unpaid amount or a fraction thereof , until the delinquent tax is fully paid.

The Statutory Cap: In no case shall the total interest on the unpaid tax or portion thereof exceed thirty-six (36) months (i.e., a maximum statutory interest cap of 2 % × 36 = 72 % 2\% \times 36 = \mathbf{72\%} 2% × 36 = 72% ).

Installment-Specific Application: Penalty accrues solely on the overdue quarterly installment, not on future installments that have not yet reached maturity.

Speed Math and Calculator Optimization

Civil service rules permit standalone non-graphing, non-programmable, non-scientific four- or five-function calculators (scientific and graphing calculators are strictly prohibited). Candidates should optimize keystrokes:

Rather than subtracting discounts manually: to compute an 18% discount, multiply directly by the decimal complement ( 1.00 − 0.18 = 0.82 1.00 - 0.18 = \mathbf{0.82} 1.00 − 0.18 = 0.82 ).

To compute a 2% monthly penalty for 7 months, multiply the delinquent principal directly by ( 0.02 × 7 ) = 0.14 (0.02 \times 7) = \mathbf{0.14} ( 0.02 × 7 ) = 0.14 .

5. Formal Categorical Syllogisms and Deductive Reasoning

Logical deduction questions evaluate an examinee's ability to determine whether a conclusion follows necessarily from given administrative premises, irrespective of real-world subjective opinions. Civil service syllogisms rely on four standard categorical proposition forms : The Square of Categorical Propositions

  • ├── Form A (Universal Affirmative): "All S are P" (Every treasury officer is an accountable officer)
  • ├── Form E (Universal Negative): "No S are P" (No informal collector is an authorized signatory)
  • ├── Form I (Particular Affirmative): "Some S are P" (Some accountants are certified auditors)
  • └── Form O (Particular Negative): "Some S are not P" (Some employees are not bonded)
  • The Venn Diagram / Euler Circle Technique

The most dependable method to solve categorical syllogisms under exam pressure is mapping premise relationships using intersecting circles: Euler Circle Representation of Syllogistic Deduction

  • ┌──────────────────────────────┐
  • │ Accountable Officers (A) │
  • │ │
  • │ ┌──────────────────────┐ │
  • │ │ Cashiers (C) │ │
  • │ │ │ │
  • │ └──────────────────────┘ │
  • │ │
  • │ * Some non-permanent │
  • │ officers reside here │
  • └──────────────────────────────┘
  • Cardinal Rules of Deductive Validity

The Fallacy of the Undistributed Middle: The middle term (the term connecting the two premises) must be distributed (refer to all members of its class) in at least one premise. If Premise 1 is "All cashiers are bonded" and Premise 2 is "John is bonded" , you cannot conclude that "John is a cashier" (John could be a supply officer or disbursing agent).

Two Negative Premises Yield No Conclusion: If both premises contain negative qualifiers ( "No collectors are..." , "Some clerks are not..." ), no valid categorical deduction can be drawn.

Negative Premise Requires Negative Conclusion: If one premise is negative, the valid conclusion must be negative.

Affirmative Premises Never Yield a Negative Conclusion: Two positive statements cannot generate a negative deductive result.