The ELS Cotton Loan Calculator facilitates calculation of Commodity Credit Corporation (CCC) ELS loan premium and discount values given high-volume instrument (HVI) classing information. This program is updated annually to reflect changes in the premium and discount schedule for each year’s ELS cotton crop.
The ELS Cotton Loan Calculator was designed for the evaluation of variety trials, but can be used for any application involving the calculation of ELS loan values. The program calculates net returns over harvest costs on a per acre basis.
To calculate loan values for each sample, the ELS Cotton Loan Valuation Program requires manual user entry of HVI classing results. This includes: color and leaf grades, micronaire, length in inches, strength in grams per tex, uniformity index and extraneous matter for each sample.
The program is distributed as an 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, change your macro security settings 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.
Questions, comments, and suggestions are welcome. Please send an email to Jon Devine, we are happy to help.
2022 ELS Loan Calculator program revised June 2, 2022