Issue 55
Prairie Grains

Library

Home

E-Mail

Back

Prairie Grains is the official publication of the Minnesota Association of Wheat Growers, North Dakota Grain Growers Association, Montana Grain Growers Association and South Dakota Wheat, Inc.

Copyright Prairie Grains Magazine
Marketing Guide 2003

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