4.4 Reverse Percentages, VAT & Financial Calculations

Q: A government department purchases specialised digital forensic hardware under a commercial framework agreement. The contractor's invoice states a total VAT-inclusive (gross) charge of £144,000, which includes standard UK VAT at 20.0%. What was the actual VAT amount paid on this invoice?

£24,000. The correct answer is £24,000. Under the UK standard 20.0% VAT rate, the gross total is 120% of the net amount (multiplier 1.20). The net price is £144,000 / 1.20 = £120,000, and the VAT amount is £144,000 - £120,000 = £24,000. (Alternatively, apply the Rule of Six: £144,000 / 6 = £24,000). The distractor of £28,800 commits the fatal mistake of taking 20% of the gross total (£144,000 × 0.20 = £28,800), which incorrectly taxes the VAT itself. The values of £20,000 and £23,040 represent inaccurate estimations.

Q: Following a mandatory 15.0% operational expenditure reduction imposed during a mid-year spending review, an executive agency's regional travel allocation stands at £187,000. What was the agency's original travel budget prior to the reduction?

£220,000. The correct answer is £220,000. In reverse percentage calculations involving a decrease, divide the final figure by (1 - r): £187,000 / (1 - 0.15) = £187,000 / 0.85 = £220,000. The distractor of £215,050 illustrates the classic mistake of adding 15% directly to the final reduced figure (£187,000 × 1.15 = £215,050); this fails because 15% of the smaller final number is less than the 15% originally deducted from the larger starting base. The figure of £162,609 incorrectly treats the problem as an original value that had been increased, while £225,000 is an unsupported estimate.

Q: The Department for Transport allocates £250,000 into a municipal green fleet financing facility. If the facility earns compound interest at an annual rate of 4.0% per annum compounded annually over a 3-year term, what is the total value of the investment at maturity?

£281,216. The correct answer is £281,216. Using the compound interest formula A = P(1 + r)^t, the maturity value is £250,000 × (1 + 0.04)^3 = £250,000 × (1.04)^3 = £250,000 × 1.124864 = £281,216. (Year 1: £250,000 × 1.04 = £260,000; Year 2: £260,000 × 1.04 = £270,400; Year 3: £270,400 × 1.04 = £281,216). The distractor of £280,000 represents simple interest (£250,000 + (3 × £10,000)), which fails to compound interest on the accumulated balances from previous years. The figure of £270,400 reflects the fund balance after only two years rather than three, and £285,000 represents an erroneous compound calculation.

Key Takeaways

Reverse percentage problems require calculating an unknown original amount before a percentage change occurred, given only the final post-change figure and the percentage rate.
The universal division rule states that Original Value = Final Value / (1 + r) for increases, and Original Value = Final Value / (1 - r) for decreases.
The 'Fatal Mistake' in reverse percentages is applying the percentage directly to the final figure (e.g. deducting 20% from £120 to reverse a 20% increase yields £96, not the true £100 baseline).
Under the standard UK 20% VAT rate, net expenditure is found by dividing gross cost by 1.20, while the VAT component can be extracted directly using the 'Rule of Six' (Gross / 6).
Distinguishing between simple interest (I = P × r × t) and compound interest (A = P(1 + r)^t) is essential when assessing government loan facilities, capital infrastructure financing, and statutory prompt payment penalties.

Last updated: September 2026

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:

\begin{aligned} £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:

Finding the Net Price from a Gross Invoice:
$\text{Net Price} = \frac{\text{Gross Price}}{1.20} = \text{Gross Price} \times \frac{5}{6}$
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

Year	Simple Interest Balance (6% fixed on £100k)	Compound Interest Balance (6% compounded annually)	Annual Compound Advantage
Year 0	£100,000.00	£100,000.00	£0.00
Year 1	£106,000.00	£106,000.00	£0.00
Year 2	£112,000.00	£112,360.00	£360.00
Year 3	£118,000.00	£119,101.60	£1,101.60
Year 4	£124,000.00	£126,247.70	£2,247.70
Year 5	£130,000.00	£133,822.56	£3,822.56

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:

The gross invoice total of £1,056,000 includes UK standard Value Added Tax (VAT) at $20.0\%$ .
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:

Erroneously subtracting $20\%$ from the gross: $£1,056,000 \times 0.80 = £844,800$
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

Operational Problem	Given Parameters	Correct Formula	Never Do This (Distractor Trap)
Find net cost from gross (20% VAT)	Gross total ( $G$ )	$\text{Net} = G \div 1.20$	Multiplying gross by $0.80$
Extract 20% VAT from gross	Gross total ( $G$ )	$\text{VAT} = G \div 6$	Multiplying gross by $0.20$
Find original price before discount (d%)	Discounted price ( $P_d$ )	$\text{Original} = P_d \div (1 - d)$	Multiplying $P_d$ by $(1 + d)$
Find original budget before cut (c%)	Reduced budget ( $B_r$ )	$\text{Original} = B_r \div (1 - c)$	Adding $c\%$ of $B_r$ to $B_r$
Find pre-inflation cost (i%)	Current cost ( $C$ )	$\text{Original} = C \div (1 + i)$	Subtracting $i\%$ of $C$ from $C$

Test Your Knowledge

A government department purchases specialised digital forensic hardware under a commercial framework agreement. The contractor's invoice states a total VAT-inclusive (gross) charge of £144,000, which includes standard UK VAT at 20.0%. What was the actual VAT amount paid on this invoice?

£28,800

£20,000

£24,000

£23,040

Test Your Knowledge

Following a mandatory 15.0% operational expenditure reduction imposed during a mid-year spending review, an executive agency's regional travel allocation stands at £187,000. What was the agency's original travel budget prior to the reduction?

£215,050

£162,609

£225,000

£220,000

Test Your Knowledge

The Department for Transport allocates £250,000 into a municipal green fleet financing facility. If the facility earns compound interest at an annual rate of 4.0% per annum compounded annually over a 3-year term, what is the total value of the investment at maturity?

£280,000

£281,216

£270,400

£285,000

Sections you finish are checked off in the contents.

Up Next

5.1 Ratio Simplification & Equivalent Ratios

Chapter 5: Ratios, Proportions & Scaling

Civil Service Numerical Test (CSNT)

4.4 Reverse Percentages, VAT & Financial Calculations

Key Takeaways

4.4 Reverse Percentages, VAT & Financial Calculations

The Reverse Percentage Problem

The Fundamental Algebraic Relationship

Correct Execution: Executive Officer Salary

The Asymmetry of Percentages

Value Added Tax (VAT) in UK Public Procurement

Deconstructing a Standard VAT Invoice

Commercial Calculations: Discounts & Payroll

Crown Commercial Service (CCS) Framework Discounts

Simple vs. Compound Interest in Public Capital Schemes

Simple Interest

Compound Interest

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

Comprehensive Worked Walkthrough: Ministry of Justice Cloud Procurement

Procurement Scenario

Step-by-Step Analytical Breakdown

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

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

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

Summary Reference: Reverse Calculations and Multipliers