Docstoc

vidal grape farm enterprise budget calculator - Excel - Excel

Document Sample
vidal grape farm enterprise budget calculator - Excel - Excel Powered By Docstoc
					Vidal 1

VIDAL GRAPE ENTERPRISE BUDGET Number of Acres = 50

Revised: Dec '05 Return Per Acre: 1 tonne = ($1,795) 1.10231 tons

Yield - tonnes Price - $/tonne Production - tonnes Crop Insurance C.I. Premium/ac: Level of Coverage Guaranteed Yield/ac. Probability of a payout Expected Payout/ac Participate in CI? (y/n)

Optimistic 7.0 580.00 350

Expected 6.0 555.00 300

Pessimistic 5.0 525.00 250

149.00 85% 5.10 18.41% $55.74 Yes Unit/Ac ------Number -----Cost/Unit 1417 21 30.4 81 94 0 0 0 Number -----1 0 0 1 0 1 0 0 0 10.90 14.20 0.365 0.309 0.000 0.000 0.000 Cost/Unit 274.00 0.00 0.00 54.00 0.00 282.00 0.00 0.00 0.00 $/Acre -----1417 229 432 30 29 0 0 0 $/Acre -----274 0 0 54 0 282 0 0 0 $/Year -----70850 11445 21584 1478 1452 0 0 0 $/Year -----13700 0 0 2700 0 14100 0 0 0

Expenses ANNUAL PRODUCTION COSTS: Annual cost to recover Establishment costs
(establishment costs amortized over 21 years)

Seasonal Labour Operator Labour Fertilizers: 1. Am.Nitrate 2. Potash 3. 4. 5.

hr. hr. kg kg kg kg or l kg or l Unit/Ac ------kg or l kg or l kg or l kg or l kg or l kg or l kg or l kg or l kg or l

Insecticides: 1. All Insecticides 2. _______________ 3. _______________ Herbicides: 1. All Herbicides 2. _______________ Fungicides: 1. All Fungicides 2. _______________ Other Sprays 1. All Other Sprays 2. _______________

Page -1

Other Expenses: Manure Cover Crop Seed Marketing Bd. Fees Crop Insurance Tying Material

Unit/Ac ------tons kg $ Insurance $ Unit/Ac ------$ $ $ $ $ $ $ Typical $/Acre 267 116 0 42 0 %int 5.5 %year 60

Number -----0 2 6 1 1 Number -----1 19 1 1 6 968 968

Cost/Unit 0.00 5.00 15.00 149.00 20.00 Cost/Unit 15.00 3.79 0.00 129.00 78.00 0.35 0.20

$/Acre -----0 10 90 149 20 $/Acre -----15 72 0 129 468 339 194

$/Year -----0 500 4500 7450 1000 $/Year -----750 3601 0 6450 23400 16940 9680

Other Expenses: Trellis Maintenance Replacement Vines Bird Control Irrigation Custom Work 1. Harvest and Delivery 2. Pruning 3. Tying

Fuel Mach. Repair & Maint. Bldg. Repair & Maint. Consulting General Variable Costs Interest on Operating Capital Total Variable Costs

$/Acre 267 116 0 42 0

$/Year 13350 5800 0 2100 0

104 -----4761

5197 -----238027

Fixed Costs: Depreciation Interest on Term Loans Land Costs Long-term Leases General Fixed Costs Total Fixed Costs

Typical $/Acre 176 58 0 0 186

$/Acre 176 58 0 0 186 -----420

$/Year 8800 2900 0 0 9300 -----21000

Page -2

Revenues: Total Expected Revenues add: Expected Insurance Revenues less: Variable Costs Expected Operating Margin less: Fixed Costs Expected Net Revenue

$/Acre 3330 56 4761 ------1375 420 ------1795

$/Year 166500 2787 238027 ------68740 21000 ------89740

Break-even $/pt to cover:

Variable Costs Fixed Costs Total Costs

793 70 ------------------863

Chance of at least breaking even ==> Chance of at least 0 $/acre return ==> Coefficient of variation ==> Returns $/acre Chances of at least this return per acre -884 -1391 -1795 -2198 -2705 17 % 33 % 50 % 67 % 83 %

3% 3% 0.28

The user of this worksheet assumes all responsibility.
For more information: OMAFRA Agricultural Information Centre

ag.info@omafra.gov.on.ca
1-877-424-1300

Page -3


				
DOCUMENT INFO
Shared By:
Stats:
views:206
posted:1/28/2008
language:English
pages:3
ocak ocak
About