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.
2022 Upland Loan Calculator program revised June 2, 2022.
Cotton Loan Calculator Instructions
Ensure that macros are enabled