The ELS Cotton Loan Valuation Program is designed to facilitate calculation of Commodity Credit Corporation (CCC) cotton loan premium and discount values given high-volume instrument (HVI) classing information. Through support of Cotton Incorporated, this program is updated annually to reflect changes in the premium and discount schedule for each year's cotton crop.
The ELS Cotton Loan Valuation Program is primarily used for evaluation of variety trials and result demonstration studies, although it can be used without modification for other applications involving calculation of cotton loan values. If desired, this program has the capability to calculate net returns over harvest cost on a per acre basis. Results can be presented in both report and graphical formats. This program is primarily used for variety test evaluations, but it can be used without modification for other applications involving calculation of cotton loan values. This program is distributed as a MicroSoft© Excel spreadsheet. This spreadsheet is menu driven. For the program to perform properly, the user must have the Excel macro security set to medium or low level. To set macro security, select Tools from the Main Menu, Macro from the Tools menu then Security which will invoke the Security Level dialog box. You will have to exit Excel for these changes to take effect.
To calculate loan values for each sample, the Cotton Loan Valuation Program requires user input of data related to HVI classing results including: color and leaf grades, micronaire, length in inches, strength in grams per tex, uniformity index and bark grade for each sample.
The Cotton Loan Valuation Decision Aid was developed by Dr. Larry Falconer at Mississippi State University, Delta Research Station with funding from Cotton Incorporated.