Loan 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 sets of 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 to HVI classing data including: color and leaf grades, micronaire, length, strength, uniformity index, and extraneous matter.
Since the 2019 edition, 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. This includes HVI output from the USDA, Texas Tech FBRI, and Cotton Incorporated’s Fiber Lab. Traditional data entry, through cut and paste is also supported.
Two short instructional videos and a pdf covering the operating instructions are located on the right side of this page.
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.
Upland Loan Calculator program revised September 10, 2020
ELS Loan Calculator program revised June 23, 2020