FP Academy · INSIGHTS

Percentages and percentage points in financial reporting

Use simple calculations to distinguish a relative change from the difference between two percentages.

Mohammad Amar · Founder & Owner · 08.10.2026

Name the change precisely

A percentage expresses a share or relative change. Percentage points measure the difference between two percentages. The distinction matters for margins, cost shares and budget variances.

An expense rises by 10%

An expense budgeted at DKK 80,000 comes in at DKK 88,000. The difference is 88,000 − 80,000 = DKK 8,000. Relative to budget, 8,000 / 80,000 = 0.10, or 10%.

With budget in B2 and actual cost in C2, enter =(C2-B2)/B2. Format the result as a percentage. Percentage formatting already converts the decimal for display.

A margin rises from 20% to 25%

The difference is 25% − 20% = 5 percentage points. Relative to its original level, the margin grew by (25% − 20%) / 20% = 25%. Saying the margin “rose by 5%” would misdescribe this change.

Enter 20% in B3 and 25% in C3. With percentage formatting, =C3-B3 displays 5%. Describe that result as five percentage points. To display the number 5, use =(C3-B3)*100 in a number-formatted cell labelled “Change in percentage points”.

Check the starting point

An increase from DKK 10,000 to DKK 15,000 is 50%. The reverse movement is a fall of approximately 33.33%. The amount is the same but the denominator changes. When the baseline is zero, show the change in DKK and explain why there is no percentage. Negative baselines also require care.

Before sending the report

Check what is being compared, which denominator you used and whether you are describing an amount or two shares. FP Academy’s Excel course connects calculation, formatting and explanation.