|
Plan Grain Sales, Estimate Expected Net Price
You can estimate expected net prices for wheat, corn, soybeans and canola for any given months in the future, thus helping to plan sales and estimate the profitability of storing grain, using the tables on page 15 as
a guide.
Created by NDSU extension crops economist George Flaskerud, here’s how the charts work: In the first column, Calendar Month, pick months into the next year that are likely times in which you would sell grain,
and hence, would like to estimate the net price you’d receive.
The Nearby Futures Month and the Nearby Futures price for each corresponding calendar month are entered in the next two columns. In the Nearby Futures column, the settle price is entered using
the closest futures month (Nearby Futures Month) to the Calendar Month
in the first column. For August in the wheat example, that would be the Minneapolis September futures price on the day this chart was created, which was $3.36. Most daily newspapers publish the grain futures prices you would need to do your own sales planning charts.
In the fourth column is the Nearby Basis, which is the difference between the futures and your local cash price. Here, enter your local average basis for each calendar month listed in the first column. In the
wheat example, the basis in August at Hunter, ND is 27 under. Your local elevator would know these numbers. You can use last year’s basis numbers, or averages from the last three or five years. (See more basis
information, including links to online basis charts, on pages 12-13).
In the next column, add the Nearby Futures numbers with the Nearby Basis numbers to calculate an Expected Price. Thus, for August in the wheat example, the Nearby Futures
price of $3.36 plus the Nearby Basis of -27 equals an Expected Price of $3.09.
Next, subtract Storage Costs for each Calendar Month
in the chart. There would be no storage cost if you sell off the combine. Use the Storage Cost estimates Flaskerud provides in these charts, your own storage cost estimates, or estimates from your local elevator, lender, or farm business management or extension educator.
The final calculations give the results in the final column of the chart, Expected Net Price.
The tables do not include an estimate for loan deficiency payments. After you’ve calculated the Expected Price for the Calendar Month
in each row of the chart, an LDP amount could be added, if you indeed take the LDP on that grain.
Here’s one final example from start to finish, estimating net price for soybeans selling off the combine, using the soybean sales planning chart: To figure the Expected Net Price
for soybeans in the Hunter, ND area for the Calendar Month October, add the Nearby CBT Futures price – which on July 11 was $5.28. Subtracting the nearby Basis of -50, and with no
Storage Costs, the Expected Net Price is $4.78.
Note that these are only estimates to help with sales planning. Other factors such as quality premiums/discounts and government support income are not included.
Returns to Short-Term Wheat Storage at Hunter, ND Futures & Basis as of 7/11/03 • Complete sales in Nov-Jan for 14% pro, Sep-Nov for 15% pro
|
Calendar Month
|
Nearby Futures Month
|
Nearby MGE Futures
|
Hunter Nearby Basis
|
Hunter Expected Price
|
Storage Costs
|
Expected Net Price
|
|
|
|
+
|
+
|
=
|
-
|
=
|
|
Aug
|
Sep
|
336
|
-27
|
309
|
-
|
309
|
|
Sep
|
Dec
|
342
|
-26
|
316
|
10.7
|
305
|
|
Oct
|
Dec
|
342
|
-24
|
318
|
12.4
|
306
|
|
Nov
|
Dec
|
342
|
-19
|
323
|
14.2
|
309
|
|
Dec
|
Mar
|
348
|
-14
|
334
|
16.0
|
318
|
|
Jan
|
Mar
|
348
|
-14
|
334
|
17.8
|
316
|
|
Feb
|
Mar
|
348
|
-20
|
328
|
19.6
|
308
|
|
Mar
|
May
|
352
|
-20
|
332
|
21.4
|
311
|
|
Apr
|
May
|
352
|
-20
|
332
|
23.3
|
309
|
Returns to Longer-Term Corn Storage at Hunter, ND Futures & Basis as of 7/11/03 • On 10-15 cent rally, hedge in July for June delivery
|
Calendar Month
|
Nearby Futures Month
|
Nearby CBT Futures
|
Hunter Nearby Basis
|
Hunter Expected Price
|
Storage Costs
|
Expected Net Price
|
|
|
|
+
|
+
|
=
|
-
|
=
|
|
Oct
|
Dec
|
215
|
-46
|
169
|
-
|
169
|
|
Nov
|
Dec
|
215
|
-44
|
171
|
10.0
|
161
|
|
Dec
|
Mar
|
223
|
-43
|
180
|
11.0
|
169
|
|
Jan
|
Mar
|
223
|
-44
|
179
|
12.1
|
167
|
|
Feb
|
Mar
|
223
|
-41
|
182
|
13.2
|
169
|
|
Mar
|
May
|
229
|
-40
|
189
|
14.3
|
175
|
|
Apr
|
May
|
229
|
-40
|
189
|
15.4
|
174
|
|
May
|
Jul
|
233
|
-40
|
193
|
16.6
|
176
|
|
Jun
|
Jul
|
233
|
-40
|
193
|
17.7
|
175
|
Soybean Storage Not Profitable at Hunter, ND Futures & Basis as of 7/11/03 • Sell rallies and complete sales at harvest
|
Calendar Month
|
Nearby Futures Month
|
Nearby CBT Futures
|
Hunter Nearby Basis
|
Hunter Expected Price
|
Storage Costs
|
Expected Net Price
|
|
|
|
+
|
+
|
=
|
-
|
=
|
|
Oct
|
Nov
|
528
|
-50
|
478
|
-
|
478
|
|
Nov
|
Jan
|
531
|
-48
|
483
|
14.6
|
468
|
|
Dec
|
Jan
|
531
|
-46
|
485
|
17.3
|
468
|
|
Jan
|
Mar
|
534
|
-50
|
484
|
20.0
|
464
|
|
Feb
|
Mar
|
534
|
-50
|
484
|
22.6
|
461
|
|
Mar
|
May
|
534
|
-53
|
481
|
25.3
|
456
|
|
Apr
|
May
|
534
|
-52
|
482
|
27.9
|
454
|
|
May
|
Jul
|
535
|
-50
|
485
|
30.6
|
454
|
|
Jun
|
Jul
|
535
|
-50
|
485
|
33.2
|
452
|
Planning Canola Sales at Velva, ND (US$/Cwt = WCE Futures • Exchange Rate / 22.046) Futures 7/14/03 and Basis 1999/00-2001/02 Ave
Sell rallies & complete sales by mid-March
|
Calendar Month
|
Nearby Futures Month
|
Nearby WCE Futures
|
Velva Nearby Basis
|
Velva Expected Price
|
Storage Costs
|
Expected Net Price
|
|
|
|
+
|
+
|
=
|
-
|
=
|
|
Sep
|
Nov
|
1093
|
-111
|
983
|
-
|
983
|
|
Oct
|
Nov
|
1093
|
-124
|
970
|
25
|
944
|
|
Nov
|
Jan
|
1111
|
-90
|
1022
|
31
|
991
|
|
Dec
|
Jan
|
1111
|
-76
|
1035
|
36
|
998
|
|
Jan
|
Mar
|
1126
|
-62
|
1064
|
42
|
1022
|
|
Feb
|
Mar
|
1126
|
-55
|
1070
|
48
|
1022
|
|
Mar
|
May
|
1135
|
-40
|
1096
|
54
|
1042
|
|
Apr
|
May
|
1135
|
-41
|
1094
|
60
|
1034
|
|