Calculation guide
Deduct only unpermitted leakage from closing consideration.
Inputs
Locked-box equity price
Example entry 1000 (in the selected currency).
Annual ticking fee
Example entry 5 %. Allowed range 0 to 100.
Days from locked-box date
Example entry 73. Use whole numbers.
Total leakage
Example entry 20 (in the selected currency).
Permitted leakage included above
Example entry 5 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Locked-box equity price | 1,000 |
| Annual ticking fee | 5% |
| Days from locked-box date | 73 |
| Total leakage | 20 |
| Permitted leakage included above | 5 |
| Result | Value |
|---|---|
| Closing consideration | 995 |
| Ticking fee | 10 |
Calculation steps
Closing consideration = (((Locked-box equity price + ((((Locked-box equity price × Annual ticking fee) ÷ 100) × Days from locked-box date) ÷ 365)) − Total leakage) + Permitted leakage included above)
(((1,000 + ((((1,000 × 5) ÷ 100) × 73) ÷ 365)) − 20) + 5) = 995
Ticking fee = ((((Locked-box equity price × Annual ticking fee) ÷ 100) × Days from locked-box date) ÷ 365)
((((1,000 × 5) ÷ 100) × 73) ÷ 365) = 10
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Locked-box equity price | 1,000 | 1,100 | Closing consideration | 995 | 1,096 |
| Annual ticking fee | 5% | 6% | Closing consideration | 995 | 997 |
| Days from locked-box date | 73 | 80 | Closing consideration | 995 | 995.958904 |
| Total leakage | 20 | 22 | Closing consideration | 995 | 993 |
| Permitted leakage included above | 5 | 6 | Closing consideration | 995 | 996 |
