This web page contains a live and functional spreadsheet created with
SpreadsheetConverter
. Please enable JavaScript in your web browser for the live calculations to work properly.
Budget
Budget
Sensitivty
Alfalfa Enterprise Budget
Sprinkler Irrigation
Dryland
Flood Irrigation
Sprinkler Irrigation
Area:
Box Elder
This budget is designed for you to be able to easily adapt it to your specific farm conditions. You can change any of the values in the blue cells. As you change a value, the budget will automatically update to reflect that change. As market price expectations change, or as costs change, you can alslo update the budget. Clicking on the Sensitivity tab above will display a sensitivity analysis.
Basic Assumptions
Number of Acres
Initial establishment cost per acre
Number of years for the alfalfa stand
Number of cuttings per year
Returns
Unit
Units/ Acre
Number of Units
Projected Price/Unit
Total Value
Value/Acre
Value/ Ton
Premium Alfalfa
Ton
Medium-Quality Alfalfa
Ton
Low-Quality Alfalfa
Ton
Total Returns
Operating Costs
Unit
Units/ Acre
Projected Cost/Unit
Total Cost
Cost/Acre
Cost/Ton
PreHarvest
Acre
Fertilizer
Lbs
Application
Acre
Herbicide
Lbs ai
Application
Acre
Insecticide
Lbs ai
Application
Acre
Irrigation
Water Assessment
Acre
Pumping Costs
Acre
Irrigation Labor
Hrs
Crop Insurance
Annual
Fuel
Annual
This is for PreHarvest only
Repairs & Maintenance
Annual
This is for PreHarvest only
Other
Annual
Interest
Rate
Total PreHarvest
Harvest Costs
(Put down what you would charge a neighbor and this should cover labor, fuel, repairs, and interest on machinery)
Acre
Acre
Baling
Ton
Hauling & Stacking
Ton
Total Harvest Costs
Total Operating Costs
NET RETURN Over Operating Costs
Sensitivity Analysis
Net Return Over Operating Costs
$/Ton
Alfalfa Prices
10% Lower
5 % Lower
Expected
5% Higher
10% Higher
10% Lower
5 % Lower
Costs
Expected
5% Higher
10% Higher
Sensitivity Analysis
Net Return Over Operating Costs
$/Acre
Alfalfa Prices
10% Lower
5 % Lower
Expected
5% Higher
10% Higher
10% Lower
5 % Lower
Costs
Expected
5% Higher
10% Higher
Print All Information
Please host the converted page in server to use Print All.
Update
Reset
Print All
Submit