2017 Upland Cotton Loan Calculator

The Upland Cotton Loan Calculator facilitates calculation of Commodity Credit Corporation (CCC) upland 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 upland cotton crop.

2017 Upland Cotton Loan Calculator Application

The Upland Cotton Loan Calculator was designed for the evaluation of variety trials, but can be used for any application involving the calculation of cotton loan values. The program calculates net returns over experimental treatment and harvest costs on a per acre basis. Results can be presented in both report and graphical formats.

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 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, set 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.

Questions, comments, and suggestions are welcome.  Please send an email to John Devine, we are happy to help.