soybean discount tables.xlsx

	A	B	D	E	F	G	H	I	J	K
1	Inputs enter here below		Discount of $.12 Per Bushel Per Point of Moisture (2% Per Point of Moisture)					Discount of $.20 Per Bushel Per Point of Moisture (3.3% Per Point of Moisture)
2	Discount	0.12	Soybean Harvest Moisture, %, Wet Basis	Weight of Water Loss (+) or Gain (-), Lbs/Bu to Convert Soybeans to 13.5% Moisture	$.12 Discount Per Bushel, $	Price Per Bushel, $	Value Per Bushel, $, Adjusted for Moisture	$.20 Discount Per Bushel, $	Price Per Bushel, $	Value Per Bushel, $, Adjusted for Moisture
3	Discount	0.2	19	6	0.72	$11.28	$11.64	$1.20	$10.80	$11.28
4	MKT Price/bu	12	18	5	0.6	$11.40	$11.75	$1.00	$11.00	$11.40
5	SHRINK values		17	4	0.48	$11.52	$11.84	$0.80	$11.20	$11.52
6	13.5	0.5	16	3	0.36	$11.64	$11.91	$0.60	$11.40	$11.64
7	14	1	15	2	0.24	$11.76	$11.95	$0.40	$11.60	$11.76
8	15	2.5	14	1	0.12	$11.88	$11.99	$0.20	$11.80	$11.88
9	16	3	13.5	0.5	0.06	$11.94	$12.00	$0.10	$11.90	$11.94
10	17	4	13	0	0	$12.00	$12.00	$0.00	$12.00	$12.00
11	18	5	12	1	0	$12.00	$ 11.92	0	$12.00	$11.92
12	19	6	11	2	0	$12.00	$ 11.83	0	$12.00	$11.83
13			10	3	0	$12.00	$ 11.75	0	$12.00	$11.75
14			9	4	0	$12.00	$ 11.66	0	$12.00	$11.66
15			8	5	0	$12.00	$ 11.58	0	$12.00	$11.58
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100