Calculation guide
Production and payments occur at year end.
tariff = (pmt(capital,12*rate,years)+cost)/units
Inputs
Upfront capital
Example entry 1000000.0 (in the selected currency).
Annual operating cost
Example entry 50000.0 (in the selected currency).
Annual billable units
Example entry 10000.0. Minimum 1e-12.
Project life (years)
Example entry 10.0. Minimum 1. Use whole numbers.
Target annual return (%)
Example entry 0.0 %. Allowed range 0 to 100.
Worked example
| Input | Value |
|---|---|
| Upfront capital | 1,000,000 |
| Annual operating cost | 50,000 |
| Annual billable units | 10,000 |
| Project life (years) | 10 |
| Target annual return (%) | 0% |
| Result | Value |
|---|---|
| Minimum tariff per unit | 15 |
Calculation steps
Minimum tariff per unit = ((payment(Upfront capital, (12 × Target annual return (%)), Project life (years)) + Annual operating cost) ÷ Annual billable units)
((payment(1,000,000, (12 × 0), 10) + 50,000) ÷ 10,000) = 15
Interpreting the result
A lower tariff leaves revenue below the amount needed to service capital at the target return.
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 |
|---|---|---|---|---|---|
| Upfront capital | 1,000,000 | 1,100,000 | Minimum tariff per unit | 15 | 16 |
| Annual operating cost | 50,000 | 55,000 | Minimum tariff per unit | 15 | 15.5 |
| Annual billable units | 10,000 | 11,000 | Minimum tariff per unit | 15 | 13.636364 |
| Project life (years) | 10 | 11 | Minimum tariff per unit | 15 | 14.090909 |
| Target annual return (%) | 0% | 1% | Minimum tariff per unit | 15 | 15.558208 |
