Calculation guide
Sales arrive in chronological year-end order.
PV = Σ eligible sales(t) × royalty rate / (1+i)^t
Inputs
Running royalty on sales (%)
Example entry 5 %. Allowed range 0 to 100.
Annual discount rate (%)
Example entry 0 %. Allowed range -90.0 to 100.0.
Upfront lump sum
Example entry 9000 (in the selected currency).
Annual eligible sales
Example entry 100000 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Running royalty on sales (%) | 5% |
| Annual discount rate (%) | 0% |
| Upfront lump sum | 9,000 |
Annual eligible sales
| Annual eligible sales |
|---|
| 100,000 |
| 100,000 |
| Result | Value |
|---|---|
| Running royalty value less lump sum | 1,000 |
| Running royalty present value | 10,000 |
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 |
|---|---|---|---|---|---|
| Running royalty on sales (%) | 5% | 6% | Running royalty value less lump sum | 1,000 | 3,000 |
| Annual discount rate (%) | 0% | 1% | Running royalty value less lump sum | 1,000 | 851.975297 |
| Upfront lump sum | 9,000 | 9,900 | Running royalty value less lump sum | 1,000 | 100 |
| Annual eligible sales (row 1) | 100,000 | 110,000 | Running royalty value less lump sum | 1,000 | 1,500 |
