4.4 Reverse Percentages, VAT & Financial Calculations

4.4 Reverse Percentages, VAT & Financial Calculations

Civil servants manage significant public expenditure. Commercial procurement, supplier contract management, grant administration, and Treasury Green Book business case appraisals require robust financial numeracy. Among financial numeracy topics on the Civil Service Numerical Test, reverse percentages and Value Added Tax (VAT) calculations represent the most common stumbling blocks for candidates.

In standard forward percentage problems, you know the starting baseline and must determine the final figure. In reverse percentage problems, the scenario is inverted: you are given the final figure after a tax, discount, or inflationary increase has been applied, and you must work backwards to deduce the original baseline.

---

The Reverse Percentage Problem

Consider an operational statement: "Following an $8%$ cost-of-living pay award, an Executive Officer's salary is £32,400. What was the salary before the award?"

Most untrained candidates perform the following calculation: $\text{Incorrect Thought Process:} \quad 8\% \text{ of } £32,400 = 0.08 \times 32,400 = £2,592$ $\text{Erroneous Baseline:} \quad £32,400 - £2,592 = £29,808 \quad \text{(WRONG!)}$

Why is this calculation completely wrong? Because the $8%$ increase was awarded on the original salary, not on the higher, post-award salary of £32,400. By calculating $8%$ of £32,400, you are subtracting an inflated cash amount.

The Fundamental Algebraic Relationship

To find the true original amount, set up the basic relationship using the forward multiplier:

$\text{Original Value} \times (1 + r_{\text{dec}}) = \text{Final Value}$

To isolate the Original Value, divide both sides by the multiplier:

$\mathbf{\text{Original Value} = \frac{\text{Final Value}}{1 + r_{\text{dec}}}} \quad \text{(For Percentage Increases)}$ $\mathbf{\text{Original Value} = \frac{\text{Final Value}}{1 - r_{\text{dec}}}} \quad \text{(For Percentage Decreases)}$

Correct Execution: Executive Officer Salary

$\text{Original Salary} = \frac{£32,400}{1 + 0.08} = \frac{£32,400}{1.08} = £30,000$

Verification: $8%$ of £30,000 is $0.08 \times 30,000 = £2,400$. Adding £2,400 to £30,000 gives exactly £32,400.

---

The Asymmetry of Percentages

Understanding reverse percentages requires appreciating the inherent asymmetry between upward and downward percentage changes between two numbers:

£100 \xrightarrow{+25\%} & £125 \\[0.5em] £125 \xrightarrow{-20\%} & £100 \quad \text{(NOT } -25\%!\text{)} \end{aligned}$$ To reverse a **$25\%$ increase**, you must apply a **$20\%$ decrease** because the base has grown from 100 to 125 ($25 / 125 = 1/5 = 20\%$). Similarly, to reverse a **$20\%$ discount**, you must apply a **$25\%$ increase** to return to the original price ($20 / 80 = 1/4 = 25\%$). The table below outlines these mathematical counterparts: | Forward Change | Forward Multiplier | Reverse Operation | Reverse Multiplier Equivalent | Equivalent Counter-Change | | :--- | :--- | :--- | :--- | :--- | | **$+10\%$** | $\times 1.10$ | $\div 1.10$ | $\times 0.9091$ | $-9.09\%$ | | **$+20\%$** | $\times 1.20$ | $\div 1.20$ | $\times 0.8333$ | $-16.67\%$ | | **$+25\%$** | $\times 1.25$ | $\div 1.25$ | $\times 0.8000$ | $-20.00\%$ | | **$+50\%$** | $\times 1.50$ | $\div 1.50$ | $\times 0.6667$ | $-33.33\%$ | | **$-10\%$** | $\times 0.90$ | $\div 0.90$ | $\times 1.1111$ | $+11.11\%$ | | **$-20\%$** | $\times 0.80$ | $\div 0.80$ | $\times 1.2500$ | $+25.00\%$ | | **$-25\%$** | $\times 0.75$ | $\div 0.75$ | $\times 1.3333$ | $+33.33\%$ | | **$-50\%$** | $\times 0.50$ | $\div 0.50$ | $\times 2.0000$ | $+100.00\%$ | --- ## Value Added Tax (VAT) in UK Public Procurement Value Added Tax (VAT) is a consumption tax charged on most goods and services supplied by businesses in the UK. In public procurement, central government departments and agencies encounter standard rate invoices continuously. * **Standard Rate:** $20.0\%$ * **Reduced Rate:** $5.0\%$ (applied to domestic energy and certain welfare goods) * **Zero Rate:** $0.0\%$ (books, public transport, basic food) ### Deconstructing a Standard VAT Invoice For goods subject to the standard $20\%$ rate, the financial relationship between **Net** (exclusive of tax), **VAT**, and **Gross** (inclusive of tax) is structured as follows: $$\text{Net Price} = 100\%$$ $$\text{VAT Amount} = 20\% \text{ of Net} = 0.20 \times \text{Net}$$ $$\text{Gross Price} = \text{Net} + \text{VAT} = 120\% \text{ of Net} = 1.20 \times \text{Net}$$ From these identities, we derive the two primary procurement formulas: 1. **Finding the Net Price from a Gross Invoice:** $$\text{Net Price} = \frac{\text{Gross Price}}{1.20} = \text{Gross Price} \times \frac{5}{6}$$ 2. **Extracting the VAT Component Directly (The "Rule of Six"):** $$\text{VAT Amount} = \text{Gross Price} - \text{Net Price} = \text{Gross} - \frac{\text{Gross}}{1.20} = \text{Gross} \times \left(1 - \frac{5}{6}\right) = \frac{\text{Gross Price}}{6}$$ > [!TIP] > **The Rule of Six:** Under the UK standard $20\%$ VAT rate, the VAT component is **always exactly one-sixth (1/6) of the gross total**. > If an MoD contractor submits a VAT-inclusive bill of £180,000: > * $\text{VAT Amount} = £180,000 \div 6 = £30,000$ > * $\text{Net Cost} = £180,000 - £30,000 = £150,000$ > Never multiply the gross total by $0.20$ ($£180,000 \times 0.20 = £36,000$ is incorrect!).

Commercial Calculations: Discounts & Payroll

Crown Commercial Service (CCS) Framework Discounts

Government procurement frequently leverages bulk framework agreements where suppliers apply negotiated discounts against standard list prices.

• Single Trade Discount: A contractor quotes £45,000 with a $15%$ framework discount: $\text{Net Cost} = £45,000 \times (1 - 0.15) = £45,000 \times 0.85 = £38,250$
• Chain / Successive Discounts: In commercial contracts, a supplier may offer a $12%$ framework discount plus a $2%$ prompt payment discount if the invoice is settled within 10 calendar days. Multiply successive factors: $\text{Final Payable} = \text{List Price} \times 0.88 \times 0.98$

---

Simple vs. Compound Interest in Public Capital Schemes

Civil service analysts evaluating long-term infrastructure funds, student loan repayment models, or municipal capital borrowing must differentiate between simple and compound interest.

Simple Interest

Simple interest is calculated solely on the original principal sum for the entire duration of the loan. The interest earned or paid each year remains fixed:

$I = P \times r \times t$ $A = P + I = P(1 + rt)$

Where:

• $P$ = Principal amount invested or borrowed
• $r$ = Annual interest rate (in decimal format)
• $t$ = Time period in years
• $I$ = Total interest accrued
• $A$ = Total accumulated balance (Principal + Interest)

Application: Statutory prompt payment interest on overdue commercial invoices under UK public procurement regulations typically accrues as simple interest.

Compound Interest

Compound interest arises when interest is added to the principal, so that from that moment on, the interest that has been added also earns interest. The balance grows exponentially:

$A = P(1 + r)^t$

Where interest is compounded $n$ times per year (e.g. quarterly $n=4$, monthly $n=12$): $A = P\left(1 + \frac{r}{n}\right)^{nt}$

Five-Year Growth Comparison: £100,000 at 6.0% per annum

Notice how the gap widens significantly over time due to the compounding of interest on previous interest gains.

Comprehensive Worked Walkthrough: Ministry of Justice Cloud Procurement

Let us review a multi-step commercial calculation typical of questions found on the Senior Executive Officer (SEO) and Fast Stream Numerical Tests.

Procurement Scenario

The Ministry of Justice receives a final consolidated invoice for an enterprise cloud data migration project totaling £1,056,000.

The contract documentation specifies two critical financial conditions:

1. The gross invoice total of £1,056,000 includes UK standard Value Added Tax (VAT) at $20.0%$.
2. Prior to billing, the supplier applied a mandatory $12.0%$ Crown Commercial Service (CCS) negotiated framework discount to their original catalogue quotation.

---

Step-by-Step Analytical Breakdown

Step 1: Extract the Net Invoice Amount (Excluding VAT)

The gross invoice includes $20%$ VAT, meaning it equals $120%$ of the net cost: $\text{Net Invoice Amount} = \frac{\text{Gross Total}}{1 + 0.20} = \frac{£1,056,000}{1.20} = £880,000$ (Or via Rule of Six: $\text{VAT} = £1,056,000 \div 6 = £176,000$; $\text{Net} = £1,056,000 - £176,000 = £880,000$.)

Step 2: Reverse the Framework Discount to Find the Original Catalogue Quotation

The net invoice amount of £880,000 represents the price after the $12.0%$ framework discount was deducted. Therefore, £880,000 equals $(100% - 12%) = 88%$ of the original catalogue quote:

$\text{Original Catalogue Quote} = \frac{\text{Net Invoice Amount}}{1 - 0.12} = \frac{£880,000}{0.88} = £1,000,000$

Step 3: Calculate the Total Financial Savings Achieved by the Framework Agreement

The direct commercial savings achieved for the taxpayer through the CCS framework discount is: $\text{Commercial Savings} = \text{Original Catalogue Quote} - \text{Net Contract Cost}$ $\text{Commercial Savings} = £1,000,000 - £880,000 = £120,000$

[!WARNING] The Compounded Error Trap: If a candidate incorrectly attempts to reverse the problem using forward percentages:

1. Erroneously subtracting $20%$ from the gross: $£1,056,000 \times 0.80 = £844,800$
2. Erroneously adding $12%$ to that figure: $£844,800 \times 1.12 = £946,176$ They obtain an entirely fictitious original quote of £946,176. Test writers craft multiple-choice options to match these exact arithmetic errors. Always divide by the multiplier when calculating backwards!

---

Summary Reference: Reverse Calculations and Multipliers