Upland Calculator Program
The Cotton Loan Calculator is designed to assist in the evaluation of variety trials. It derives loan values by applying USDA premiums and discounts to HVI classing data. In addition, the program can calculate net returns over harvest costs on a per-acre basis. The program is updated each year with the USDA’s revisions to premium and discount values.
To calculate loan values, the program requires the user to input HVI classing data. This includes color and leaf grades, micronaire, length, strength, uniformity index, and extraneous matter.
The Loan Calculator can import HVI data directly from source files, eliminating the need to cut and paste. This service is available for HVI sources with known formatting (USDA, Texas Tech FBRI, and Cotton Incorporated’s Fiber Lab). Manual data entry, through cut and paste of HVI output into the columns of the calculator, is also supported.
Two short instructional videos and a pdf covering the operating instructions are located below on this webpage.
The program is distributed as a macro-enabled Excel workbook. For the program to perform properly, the user must enable Macros. It should be possible to enable macros by simply clicking allow content when you open the file. If that does not work, reset your macro security by clicking on File (top left corner of Excel), then select Trust Center, then click on Trust Center Settings. In the Trust Center menu, click on Enable all macros, then click Ok. The Enable Macros Before You Do Anything video will guide you through this process.
Questions, comments, and suggestions are welcome. Please email Jon Devine; we are happy to help.
Disclaimer:
The information contained herein is derived from public and private sources believed to be reliable; however, Cotton Incorporated cannot guarantee its accuracy or completeness. No responsibility is assumed for the use of this information and no express or implied warranties or guarantees are made. The software is provided “As Is”, without warranty of any kind, express or implied, including but not limited to the warranties of merchantability, fitness for a particular purpose and noninfringement. In no event shall the authors or copyright holders be liable for any claim, damages or other liability, whether in an action of contract, tort or otherwise, arising from, out of or in connection with the software or the use or other dealings in the software.
© 2025 Cotton Incorporated. All rights reserved; America’s Cotton Producers and Importers
2025 Upland Loan Calculator program revised July 15, 2025.
Cotton Loan Calculator Instructions
Ensure that macros are enabled