Calculation guide
Inputs
Stored units
Example entry 1000.0.
Harvest price per unit
Example entry 5.0 (in the selected currency).
Later sale price per unit
Example entry 6.0 (in the selected currency).
Storage months
Example entry 6.0.
Monthly storage per original unit
Example entry 0.05 (in the selected currency).
Annual financing rate (%)
Example entry 8.0 %. Allowed range 0 to 100.
Quantity shrink (%)
Example entry 2.0 %. Allowed range 0 to 100.
Worked example
| Input | Value |
|---|---|
| Stored units | 1,000 |
| Harvest price per unit | 5 |
| Later sale price per unit | 6 |
| Storage months | 6 |
| Monthly storage per original unit | 0.05 |
| Annual financing rate (%) | 8% |
| Quantity shrink (%) | 2% |
| Result | Value |
|---|---|
| Gain · Storage | 380 |
Calculation steps
Net gain from storage = (Stored units × (((((1 − (Quantity shrink (%) ÷ 100)) × Later sale price per unit) − Harvest price per unit) − (Storage months × Monthly storage per original unit)) − ((((Harvest price per unit × Annual financing rate (%)) ÷ 100) × Storage months) ÷ 12)))
(1,000 × (((((1 − (2 ÷ 100)) × 6) − 5) − (6 × 0.05)) − ((((5 × 8) ÷ 100) × 6) ÷ 12))) = 380
Interpreting the result
Positive carry means the later sale covers shrink, storage, financing and the forgone harvest sale.
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 |
|---|---|---|---|---|---|
| Stored units | 1,000 | 1,100 | Gain · Storage | 380 | 418 |
| Harvest price per unit | 5 | 6 | Net result · Storage | 380 | -660 |
| Later sale price per unit | 6 | 7 | Gain · Storage | 380 | 1,360 |
| Storage months | 6 | 7 | Gain · Storage | 380 | 296.666667 |
| Monthly storage per original unit | 0.05 | 1.05 | Net result · Storage | 380 | -5,620 |
| Annual financing rate (%) | 8% | 9% | Gain · Storage | 380 | 355 |
| Quantity shrink (%) | 2% | 3% | Gain · Storage | 380 | 320 |
