Calculation guide
Assume all entered member contributions are collected. A positive deficit means funding is missing.
Inputs
Contributing members
Example entry 100. Allowed range 1.0 to 10000000.0. Use whole numbers.
Period contribution per member
Example entry 50 (in the selected currency).
Opening unrestricted reserve
Example entry 2000 (in the selected currency).
Expected assistance and expenses
Example entry 6000 (in the selected currency).
Target closing reserve
Example entry 2000 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Contributing members | 100 |
| Period contribution per member | 50 |
| Opening unrestricted reserve | 2,000 |
| Expected assistance and expenses | 6,000 |
| Target closing reserve | 2,000 |
| Result | Value |
|---|---|
| Funding deficit against target | 1,000 |
| Required contribution per member | 60 |
Calculation steps
Funding deficit against target = (((Target closing reserve + Expected assistance and expenses) − Opening unrestricted reserve) − (Contributing members × Period contribution per member))
(((2,000 + 6,000) − 2,000) − (100 × 50)) = 1,000
Required contribution per member = (max(0, ((Target closing reserve + Expected assistance and expenses) − Opening unrestricted reserve)) ÷ Contributing members)
(max(0, ((2,000 + 6,000) − 2,000)) ÷ 100) = 60
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 |
|---|---|---|---|---|---|
| Contributing members | 100 | 110 | Funding deficit against target | 1,000 | 500 |
| Period contribution per member | 50 | 55 | Funding deficit against target | 1,000 | 500 |
| Opening unrestricted reserve | 2,000 | 2,200 | Funding deficit against target | 1,000 | 800 |
| Expected assistance and expenses | 6,000 | 6,600 | Funding deficit against target | 1,000 | 1,600 |
| Target closing reserve | 2,000 | 2,200 | Funding deficit against target | 1,000 | 1,200 |
