Calculation guide
Ranking by index assumes divisible independent projects.
Profitability index = Present value of future net inflows / Initial outlay. Fundable project share = 100 × min(1,Available budget / Initial outlay). NPV of fundable share = (Present value of future net inflows − Initial outlay) × Fundable project share / 100
Inputs
Present value of future net inflows
Example entry 1250 (in the selected currency).
Initial outlay
Example entry 1000 (in the selected currency).
Available budget
Example entry 800 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Present value of future net inflows | 1,250 |
| Initial outlay | 1,000 |
| Available budget | 800 |
| Result | Value |
|---|---|
| Profitability index | 1.25 |
| Fundable project share | 80% |
| NPV of fundable share | 200 |
Calculation steps
Profitability index = (Present value of future net inflows ÷ Initial outlay)
(1,250 ÷ 1,000) = 1.25
Fundable project share = (100 × min(1, (Available budget ÷ Initial outlay)))
(100 × min(1, (800 ÷ 1,000))) = 80%
NPV of fundable share = (((Present value of future net inflows − Initial outlay) × Fundable project share) ÷ 100)
(((1,250 − 1,000) × 80) ÷ 100) = 200
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 |
|---|---|---|---|---|---|
| Present value of future net inflows | 1,250 | 1,375 | Profitability index | 1.25 | 1.375 |
| Initial outlay | 1,000 | 1,100 | Profitability index | 1.25 | 1.136364 |
| Available budget | 800 | 880 | Fundable project share | 80% | 88% |
