3.3 Percentage, Ratio, Rate of Growth & Budget Calculations

3.3 Percentage, Ratio, Rate of Growth & Budget Calculations

Public sector financial leadership demands exact mathematical fluency. Career executive officers are responsible for managing multi-billion peso program budgets, evaluating public spending efficiency, and defending budget execution performance before oversight bodies like the Department of Budget and Management (DBM) and the Commission on Audit (COA). The CES-WE rigorously tests quantitative facility in percentage calculations, ratio analysis, multi-year rate of growth estimations, and public financial management indicators like agency absorptive capacity.

---

Mathematical Foundations for Executive Public Management

1. Percentage Change vs. Percentage Point Change

A frequent error in public policy reporting is confusing relative percentage change with absolute percentage point change.

• Percentage Change Formula: Measures relative growth or contraction relative to the initial baseline: $\text{Percentage Change} = \left( \frac{\text{New Value} - \text{Old Value}}{\text{Old Value}} \right) \times 100\%$

• Percentage Point Change Formula: Measures the simple arithmetic difference between two percentage figures: $\text{Percentage Point Change} = \text{Rate}_{\text{Final}} - \text{Rate}_{\text{Initial}}$

Policy Application Example: Suppose a province's poverty incidence decreases from 20% in 2020 to 15% in 2024.

• The percentage point reduction is $15% - 20% = \mathbf{-5 \text{ percentage points}}$.
• The relative percentage change is $\frac{15 - 20}{20} \times 100% = \frac{-5}{20} \times 100% = \mathbf{-25%}$.
• Stating that poverty fell by "5%" is mathematically inaccurate; it fell by 5 percentage points, which represents a 25% relative reduction in poverty.

---

Ratios, Proportions & Public Sector Benchmarking

Ratios compare two quantitative values, expressed as $A : B$, $\frac{A}{B}$, or "A per B". In public administration, ratios normalize comparisons across jurisdictions of varying sizes.

Core Public Administration Ratios

1. Service Delivery Ratios: $\text{Doctor-to-Population Ratio} = \frac{\text{Total Licensed Public Doctors}}{\text{Total Population}}$ (Target benchmark: 1 doctor per 1,000 population, or 1:1,000)

2. Fiscal Dependency & Autonomy Ratios: $\text{LGU Local Revenue Autonomy Ratio} = \left( \frac{\text{Locally Sourced Revenue}}{\text{Total LGU Operating Income}} \right) \times 100\%$

3. Personnel-to-Capital Expenditure Ratios: Evaluates institutional balance between Personal Services (PS) and Capital Outlay (CO).

---

Rate of Growth Analysis: AAGR & CAGR Shortcuts

Tracking multi-year public expenditure or demographic growth requires understanding annual growth rates.

1. Average Annual Growth Rate (AAGR)

AAGR computes the simple arithmetic mean of annual percentage growth rates across $n$ consecutive periods: $\text{AAGR} = \frac{g_1 + g_2 + \dots + g_n}{n}$

2. Compound Annual Growth Rate (CAGR)

CAGR calculates the geometric annualized rate of growth over a multi-year period, smoothing out year-to-year volatility: $\text{CAGR} = \left( \frac{V_{\text{final}}}{V_{\text{initial}}} \right)^{\frac{1}{n}} - 1$

where $n$ is the number of growth periods (years).

Timed Exam Shortcut for CAGR Estimation

Without scientific calculators in exam environments, candidates can approximate CAGR using the arithmetic estimation formula: $\text{Approximate CAGR} \approx \frac{\text{Total Percentage Growth}}{n}$

Adjustment Rule: Because compounding adds interest-on-interest, true CAGR is always slightly lower than the simple arithmetic average (AAGR) for positive growth rates.

---

Public Sector Budget Mechanics & Absorptive Capacity

In Philippine public financial management (PFM), funds flow through four distinct lifecycle stages governed by DBM rules:

                  PUBLIC FINANCIAL MANAGEMENT CYCLE
  +---------------+     +---------------+     +---------------+     +---------------+
  | APPROPRIATION | --> |   ALLOTMENT   | --> |  OBLIGATION   | --> | DISBURSEMENT  |
  | (GAA Enacted) |     | (Release/SARO)|     | (Contracts)   |     | (Actual Cash) |
  +---------------+     +---------------+     +---------------+     +---------------+

Key Performance Formulas

1. Obligation Rate (Budget Utilization Rate): Measures how effectively an agency commits its available funds to legal contracts and obligations: $\text{Obligation Rate} = \left( \frac{\text{Total Obligations Incurred}}{\text{Total Allotments Received}} \right) \times 100\%$

2. Disbursement Rate (Liquidation Efficiency): Measures how quickly an agency converts legal obligations into actual cash disbursements to contractors and vendors: $\text{Disbursement Rate} = \left( \frac{\text{Total Cash Disbursements}}{\text{Total Obligations Incurred}} \right) \times 100\%$

3. Overall Agency Absorptive Capacity: Measures comprehensive budget execution from allotment to cash outlay: $\text{Overall Absorptive Capacity} = \left( \frac{\text{Total Cash Disbursements}}{\text{Total Allotments Received}} \right) \times 100\%$ $\text{Absorptive Capacity} = \text{Obligation Rate} \times \text{Disbursement Rate}$

4. Budget Variance: Evaluates budget planning accuracy: $\text{Budget Variance} = \left( \frac{\text{Actual Expenditure} - \text{Budgeted Allocation}}{\text{Budgeted Allocation}} \right) \times 100\%$

---

Step-by-Step Worked Calculation Examples

Example 1: Agency Absorptive Capacity Audit

The Department of Transportation (DOTr) receives a total allotment of ₱25.0 Billion for a regional rail extension project. By fiscal year-end, agency financial records show:

• Total Obligations Incurred: ₱20.0 Billion
• Total Cash Disbursements Paid: ₱15.0 Billion

Problem: Calculate the agency's (a) Obligation Rate, (b) Disbursement Rate, and (c) Overall Absorptive Capacity.

Solution:

1. Obligation Rate: $\text{Obligation Rate} = \frac{\text{₱20.0B}}{\text{₱25.0B}} \times 100\% = 0.80 \times 100\% = \mathbf{80.0\%}$

2. Disbursement Rate: $\text{Disbursement Rate} = \frac{\text{₱15.0B}}{\text{₱20.0B}} \times 100\% = 0.75 \times 100\% = \mathbf{75.0\%}$

3. Overall Absorptive Capacity: $\text{Absorptive Capacity} = \frac{\text{₱15.0B}}{\text{₱25.0B}} \times 100\% = 0.60 \times 100\% = \mathbf{60.0\%}$ (Cross-check: $0.80 \times 0.75 = 0.60$, or $60.0%$)

---

Example 2: Multi-Year Revenue CAGR Estimation

A city government's local revenue collection grew from ₱400 Million in 2020 to ₱665.5 Million in 2023 ($n = 3$ years).

Problem: Estimate the CAGR of local revenue collection.

Solution:

1. Total Percentage Growth: $\text{Total Growth} = \frac{665.5 - 400}{400} \times 100\% = \frac{265.5}{400} \times 100\% = 66.375\%$

2. Arithmetic Annual Estimate: $\text{Approximate CAGR} \approx \frac{66.375\%}{3} = 22.125\%$

3. Refining via Compounding Check:

   • Year 0: ₱400.0M
   • Year 1 (+18.5%): $400 \times 1.185 = 474.0\text{M}$
   • Year 2 (+18.5%): $474 \times 1.185 = 561.7\text{M}$
   • Year 3 (+18.5%): $561.7 \times 1.185 = 665.6\text{M}$

4. Conclusion: The true Compound Annual Growth Rate is 18.5% per year (which compounds to 66.375% over 3 years).