Skip to Main Content

The University of Tennessee | Institute of Agriculture

Department of Agricultural and Resource Economics

Frequently Used Tools:




Fertilizer Cost Calculator

The Fertilizer Cost Calculator is an Excel based calculator which will help you evaluate the cost of applying varying levels of fertilizer and using various products. The Calculator should be used as a tool (along with a soil test) to evaluate estimated costs per acre for fertilizer.

The only fields in the spreadsheet which can be changed are:

  1. Price per ton for Urea, Ammonium Nitrate, DAP and Muriate of Potash
  2. Application rate per acre of (N,P2O5, and K2O) - example (60-30-30 or 60-0-30)
  3. Application costs per acre ($/acre) - this may be a charge/acre to be truck spread, or a buggy rental fee prorated on a per acre basis.

For traditional standard blends of fertilizer (6-12-12 or 19-19-19) application rate would be adjusted by the number of pounds planned to apply per acre. Example: 200 pounds of 19-19-19 per acre would have the application rate of 38-38-38 and 300 pounds per acre would be an application rate of 57-57-57. A current soil test will assist you in evaluating the feasibility of applying a standard blend of fertilizer.

Note on Security Settings

The file contains macros (buttons for printing and moving from the intro page to the calculator). Security settings for Microsoft Office or Excel may give you warnings for when you open the file. This will especially be true if your security settings are set to high or very high. The following should correct the issue.

For Excel 2010

  • When you open the file a "Security Warning" Message may appear just above the spreadsheet.
  • The message will read "This file originated from an Internet location and might be unsafe."
  • Click on the "Enable Editing" Button beside the message.
  • A second message may then appear just above the spreadsheet which reads “Some active content has been disabled."
  • Click on the "Enable Content" Button beside the message.

For Excel 2007

  • When you open the file a "Security Warning" Message may appear just above the spreadsheet.
  • The message will read "Some active content has been disabled."
  • Click on the "Options" Button beside the message.
  • A Microsoft Office security window appears. Select "Enable the content" then "OK".

For Excel 2003

If your security settings are set to High or Very High a message will be displayed and you may need to change your security settings to enable the macros.

  • Open Excel
  • Select the "Tools" menu option
  • From the Tools menu select "Macro" and then select "Security"...
  • A window will be displayed which will include a tab labeled Security Level
  • Select "Medium" and then "OK"
  • Now open the Fertilizer Cost Calculator file
  • When you open the file, a security warning window will appear
  • Select the "Enable Macros" button to continue opening the file

For additional information contact Tammy McKinley