Filetype Excel XLS | Posted on 18 Aug 2022 | 4 years ago
Authentication
digital resources
293x Filetype XLS File size 0.11 MB Source: www.gov.mb.ca
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
CropShare Lease Calculator - 2019 Printed: 8/17/2022
*** Enter changes to values in BLUE only
Land Value $2,950 / ac Grain Storage Usage % Cost
Machinery Investment $682.20 / ac Non-aeration bins 25% $1.95 /bu
Machinery Depreciation Rate 10.00 % Aeration bins 75% $2.45 /bu
Operating Interest Rate 5.75 %
Investment Rate 2.75 % Cash Land Rental $75.00 / ac
Manitoba Agriculture Guidelines for Estimating Crop Production Costs
For more information on crop production costs,
Manitoba Agriculture Farm Machinery Custom and Rental Rate Guide
For more information on machinery costs,
Manitoba Agriculture Grain Bin and Farm Building Rental Cost Planner
For more information on grain storage costs,
A. Operating Costs ($/Acre) Soy- (enter Landowner
(leave costs blank if crop is not included in rotation) Canola Wheat beans crop) Share Owner Leasee Total Cost
Seed & Treatment $62.50 $24.00 $95.10 0% $0.00 $60.53 $60.53
Fertilizer $89.06 $70.89 $21.76 0% $0.00 $60.57 $60.57
Herbicide $14.41 $30.83 $10.67 0% $0.00 $18.64 $18.64
Fungicide $16.25 $16.50 $0.00 0% $0.00 $10.92 $10.92
Insecticide $0.00 $0.00 $0.00 0% $0.00 $0.00 $0.00
Fuel $24.21 $25.95 $22.65 0% $0.00 $24.27 $24.27
Machinery Operating $10.00 $10.00 $10.00 0% $0.00 $10.00 $10.00
Rental and Custom $2.88 $2.88 $2.88 0% $0.00 $2.88 $2.88
Crop Insurance $7.47 $7.70 $12.66 0% $0.00 $9.28 $9.28
Other Costs $7.75 $7.75 $7.75 0% $0.00 $7.75 $7.75
Drying Costs $0.00 $0.00 $0.00 0% $0.00 $0.00 $0.00
Land Taxes $15.00 $15.00 $15.00 100% $15.00 $0.00 $15.00
Subtotal Operating Costs $249.53 $211.50 $198.47 $0.00 $15.00 $204.83 $219.83
Operating Interest $0.43 $5.89 $6.32
Total Operating Costs $15.43 $210.72 $226.15
B. Fixed Costs ($/Acre)
Land Investment Costs 100% $68.15 $12.98 $81.13
Machinery Depreciation 0% $0.00 $68.22 $68.22
Machinery Investment 0% $0.00 $18.76 $18.76
Storage Costs 100% $6.20 $0.00 $6.20
Total Fixed Costs $74.34 $99.96 $174.30
Total Operating and Fixed Costs $89.77 $310.68 $400.46
C. Labour ($/Acre) $26.40 $26.40 $26.40 0% $0.00 $26.40 $26.40
Total Contributions $89.77 $337.08 $426.86
Contribution Share 21.0% 79.0%
Estimated Farmgate Revenue
Soy- (enter Average Gross
Estimated Farmgate Canola Wheat beans crop) Revenue Per Acre
Price ( $ per unit) $11.00 $6.75 $11.00
Yield per acre (bu or lb.) 40 55 38
Gross Revenue Per Acre $440.00 $371.25 $418.00 $0.00 $409.75
Lease Calculation #1 - Share Split Method
Owner LeaseeTotal ($/Ac)
Share Split 21.0% 79.0%
Share of Revenue $86.05 $323.70 $409.75
Marginal Return - Over Operating Costs (Gross Revenue minus cash costs) $70.62 $112.98 $183.60
Marginal Return - Over Total Costs (Gross Revenue minus all costs) ($3.73) ($13.38) ($17.11)
Return to Assets (ROA) not incl. Capital Gains 2.39%
Manitoba Agriculture
Lease Calculation #2 - Flexible Share Calculation Method
Owner LeaseeTotal ($/Ac)
Contribution Share $86.05 $323.70 $409.75
Remaining Revenue $0.00
Distribution of Surplus Revenue 50% 50%
Share of Surplus Revenue $0.00 $0.00
Total Revenue Earned $86.05 $323.70 $409.75
Percent Share of Revenue (Total) 21.0% 79.0%
Marginal Return - Over Operating Costs (Gross Revenue minus cash costs) $70.62 $112.98 $183.60
Marginal Return - Over Total Costs (Gross Revenue minus all costs) ($3.73) ($13.38) ($17.11)
Return to Assets (ROA) not incl. Capital Gains 2.39%
Lease Calculation #3 - Typical 1/3 Landowner Share Method
Owner LeaseeTotal ($/Ac)
Share Split 33% 67%
Share of Revenue $135.22 $274.53 $409.75
Share of Expenses (Owner - Fertilizer and Pesticides) $30.60
Share of Expenses (Leasee) $195.56
Marginal Return - Over Operating Costs (Gross Revenue minus cash costs) $104.62 $78.97 $183.60
Calculated % Revenue Share (With no expenses, to equal 1/3 share amount) 25.5%
Marginal Return - Over Total Costs (Gross Revenue minus all costs) $30.28 ($47.39) ($17.11)
Return to Assets (ROA) not incl. Capital Gains 3.55%
Lease Calculation #4 - Cash Rent Calculation
Owner LeaseeTotal ($/Ac)
Share of Revenue $75.00 $334.75 $409.75
Percent Share of Revenue (Total) 18.3% 81.7%
Marginal Return - Over Operating Costs (Gross Revenue minus cash costs) $59.57 $124.03 $183.60
Marginal Return - Over Total Costs (Gross Revenue minus all costs) ($14.77) ($2.33) ($17.11)
Return to Assets (ROA) not incl. Capital Gains 2.02%
Note: This budget is only a guide and is not intended as an in-depth study of the cost of production of this industry.
Interpretation and use of this information is the responsibility of the user.
Successfully managing and planning your business success starts with you. Contact your local
Manitoba Agriculture Office
for the support, advice and resources you need to make sound decisions for the
email us
continued success of your farm business. If you have questions, and a
will contact you.
farm management specialist
Created and maintained by Manitoba Agriculture Farm Management January, 2019
Roy Arnott Darren Bond
Farm Management Specialist Farm Management Specialist
Manitoba Agriculture
no reviews yet
Please Login to review.
