Instructions for Downloading and Using
the Post-Buyout Tobacco Budget
These budgets use macros. The security for your Excel software should be set to medium and you should allow the software to enable macros for this file in order for it to work correctly.
Overview:
Tobacco share lease arrangements will change dramatically as a result of the tobacco buyout. Landowners and growers will have to evaluate the consequences of future share lease terms to ensure fair treatment of all parties.
To determine a fair and equitable share lease, all parties should place a value on the resources they contribute, total them, and share in the revenue in the same proportions that they share in the costs. To help growers and landowners in this process, the University of Kentukcy College of Agriculture has prepared an enterprise budget to allow users to change input costs and to assign those costs to each party in the proportion they will be shared.
These budgets reside in a Microsoft Excel file "budgets_tobacco-post-buyout.xls". The user is able to change the default information in the budgets to reflect their production practices to generate a budget that is representative of their own situation. This file uses macros. The security for your Excel software should be set to medium and you should allow the software to enable macros for this file in order for it to work correctly.
Instructions for using the budgets are included on the introduction page of the spreadsheet.
Downloading and Installing the Post-Buyout Tobacco Budget:
This file uses macros. The security for your Excel software should be set to medium and you should allow the software to enable macros for this file in order for it to work correctly.
Click on "Post-Buyout Tobacco Budget" download option either here or in the page menu to the left. With most browsers, you will get a choice of saving it to your hard drive or opening it. Save it to a location on your hard drive. Remember the location where you saved the file so you can find it later. If your browser opens the file without asking you whether to open it or to save it, right click on the link and select "Save Target As" to save the file to your hard drive.
Opening the budget file:
This file uses macros. The security for your Excel software should be set to medium and you should allow the software to enable macros for this file in order for it to work correctly.
In the Excel spreadsheet, select "Tools" on the menu bar. Under the Tools menu option, select "Macro". Under the Macro menu item you should see "Security". Click on "Security" and set this to "Medium". This will allow your computer to accept the macros. Close out of the spreadsheet and reopen it remembering to choose "Enable Macros".
Go to the folder/directory in which you saved the file and double-click on the "Post-Buyout Tobacco Budget" Excel icon. The file is named "budgets_tobacco-post-buyout.xls".
IMPORTANT: When opening the budget spreadsheet, always choose to "Enable Macros".In the Excel spreadsheet, select "Tools" on the menu bar. Under the Tools menu option, select "Macro". Under the Macro menu item you should see "Security". Click on "Security" and set this to "Medium". This will allow your computer to accept the macros. Close out of the spreadsheet and reopen it remembering to choose "Enable Macros".
To Save Budgets:
Click on "File", then "Save as..." give it a name of your choosing and click "OK". You do not have to save individual budgets. When you save a file, you save all of the budgets in that file.
To Exit the Budgets:
To exit the budget spreadsheet, always be sure to press "Save" to ensure your latest changes are saved to the file. You can press the "X" at the top right corner of the screen or go to "File", "Exit".
For More Information
For additional information about the interactive Post-Buyout Tobacco Budget, please contact Steve Isaacs.