Open calculator ↗

Grain storage carry versus selling at harvest · Calculation guide

Compare later proceeds after shrink with harvest sale proceeds, cash storage costs and simple financing cost on the harvest value.

Calculation guide

gain = qty*((1-shrink/100)*later-spot-months*monthly-spot*rate/100*months/12)

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

InputValue
Stored units1,000
Harvest price per unit5
Later sale price per unit6
Storage months6
Monthly storage per original unit0.05
Annual financing rate (%)8%
Quantity shrink (%)2%
ResultValue
Gain · Storage380

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.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Stored units1,0001,100Gain · Storage380418
Harvest price per unit56Net result · Storage380-660
Later sale price per unit67Gain · Storage3801,360
Storage months67Gain · Storage380296.666667
Monthly storage per original unit0.051.05Net result · Storage380-5,620
Annual financing rate (%)8%9%Gain · Storage380355
Quantity shrink (%)2%3%Gain · Storage380320
Grain storage carry versus selling at harvest →

Sources