Open calculator ↗

Percentage rent with a natural breakpoint · Calculation guide

Calculate total annual rent.

Calculation guide

The tenant pays base rent plus the stated percentage of eligible sales above base rent divided by that percentage.

total = base+max(0,sales-base*100/rate)*rate/100; threshold = base*100/rate; overage = total-base

Inputs

Annual base rent

Example entry 60000 (in the selected currency).

Percentage rent rate

Example entry 5 %. Allowed range 0.0001 to 100.0.

Eligible annual sales

Example entry 1500000 (in the selected currency).

Worked example

InputValue
Annual base rent60,000
Percentage rent rate5%
Eligible annual sales1,500,000
ResultValue
Total annual rent75,000
Natural sales breakpoint1,200,000
Percentage rent above base15,000

Calculation steps

Total annual rent = (Annual base rent + ((max(0, (Eligible annual sales − ((Annual base rent × 100) ÷ Percentage rent rate))) × Percentage rent rate) ÷ 100))

(60,000 + ((max(0, (1,500,000 − ((60,000 × 100) ÷ 5))) × 5) ÷ 100)) = 75,000

Natural sales breakpoint = ((Annual base rent × 100) ÷ Percentage rent rate)

((60,000 × 100) ÷ 5) = 1,200,000

Percentage rent above base = (Total annual rent − Annual base rent)

(75,000 − 60,000) = 15,000

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Annual base rent60,00066,000Natural sales breakpoint1,200,0001,320,000
Percentage rent rate5%6%Total annual rent75,00090,000
Eligible annual sales1,500,0001,650,000Total annual rent75,00082,500
Percentage rent with a natural breakpoint →