ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
Average Crop Value Calculator
4
5
Overview: Use this calculator to determine the average value per unit for crop enterprise analysis use. Consider crop units sold prior to year end, units
contracted for sale in the new year, unpriced inventory values, and those crops already fed to livestock. See the Closeout Manual for
further details. An example is provided below for your use.
6
7
Directions: Enter relevant information into the gray shaded cells. The average value per unit to be used in the crop enterprise analysis for crop being evaluated
will display below in green.
8
9
Farm:
10
11
Crop: CornCrop: Soybeans
12
DescriptionUnits (Bu/t.)PriceTotalDescriptionUnits (Bu/t.)PriceTotal
13
Unpriced inventory (YE Value)
 10,000 $ 6.00 $ 60,000 Unpriced inventory (YE Value) 20,000 $ 15.00 $ 300,000
14
Sold out of field 10,000 $ 5.25 $ 52,500 Sold out of field $ -
15
Priced for _________ 10,000 $ 5.95 $ 59,500 Priced for _________ 5,000 $ 16.00 $ 80,000
16
Priced for _________ 10,000 $ 6.30 $ 63,000 Priced for _________ 5,000 $ 13.00 $ 65,000
17
 $ - $ -
18
 $ - $ -
19
 $ - $ -
20
 $ - $ -
21
 $ - $ -
22
 $ - $ -
23
 $ - $ -
24
 $ - $ -
25
 $ - $ -
26
 $ - $ -
27
 $ - $ -
28
 Totals: 40,000 $ 235,000 Totals: 30,000 $ 445,000
29
Average Crop Value $ 5.88 Average Crop Value $ 14.83
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