Market Data, Inc. - A Farm Profit Enhancement Service PO Box 90 Oberlin, Kansas 67749
Phone: (800) 867 - 8289
www.marketdatainc.com
Email: gloho@marketdatainc.com		 Not Logged In    Not Logged In?
Logon to Market Data, Inc. - A Farm Profit Enhancement Service     
Log On
User Name:
Password:
Select Start Page:
Remember Me (Check this ONLY if this is the computer normally used to access the MDI website). By checking this, you will be able to automatically access your MDI services without having to enter your username and password each time you visit the site from this computer.
    If you are a registered user, to view current information, please enter your user name and password to Log On. If you have not subscribed to this service, you may purchase this service and view current information by selecting the "Services" link above and purchasing this service. If you are not already a registered user, please select the "Registration" button above, go through the registration process and then Log On to purchase services. AN EXAMPLE OF THIS SERVICE IS SHOWN BELOW.
Marketing Plan Steps
Planning Steps Crop Enterprises Crop Variable Expenses Breeding Livestock Enterprises Feeder Livestock Enterprises Livestock Expenses Fixed Expenses Fixed Income Excess Margin/Profit Review Plan
Marketing Analysis Planning Steps
 
Market Plan
Setup 		Step A: Marketing Plan Initialization MDI Home
Enter the time period of the Market Plan, starting cash balance, operating debt, default interest rates.
 
Crop
Enterprises 		Step 1: Select Your Crop Enterprises  
Here you will select the crops, how much you will plant and estimate your yield.
 
Crop Variable
Expenses		 Step 2: Determine Your Crop Variable Expenses  
Here you will determine your expected expenses for each crop you have selected in Step 1.
 
Breeding Livestock Enterprises Step 3a: Select Your Breeding Livestock Enterprises  
Here you will select your breeding livestock, enter sale weights, etc..
 
Feeder Livestock Enterprises Step 3b: Select Your Feeder Livestock Enterprises  
Here you will select your feeder livestock, enter sale weights, etc..
 
Livestock
Expenses 		Step 4: Determine Your Livestock Expenses  
Here you will enter livestock costs and expenses.
 
Fixed Expenses Step 5: Determine Your Fixed Expenses  
Here you will enter your fixed expenses independent of the crop and livestock expenses related to your farm.
 
Fixed Income Step 6: Determine Your Fixed Income  
Here you will enter your fixed income which will offset your Fixed Expenses.
 
Excess
Margin/Profit		 Step 7: Determine Your Desired Excess Margin / Profit  
Here you will determine your desired excess margin or profit based upon percentage of gross variable income.
 
Review Plan Step 8: Review Your Plan  
Here you will review your plan and determine if you should adjust crop types and acreage for each area based on probabilities of price goals, and look at a cash flow with enterprise analysis.

P.O. Box 90    Oberlin, Kansas 67749
Phone: (800) 867- 8289 Fax: (785) 475 - 3864   
  Marketing Plan Summary Report
Exit   Print
  Prepared for:  Market Data, Inc. Marketing Plan  January 1, 2007    to    December 31, 2007 
A PROJECTED INCOMES   Cash Flow
1 Feeder Livestock Incomes ......................................................................................................... $0
2 Breeding Livestock Incomes ......................................................................................................... $55,110
3 Grain and Hay Crop Incomes ......................................................................................................... $327,328
4 Cooperative Incomes ......................................................................................................... $0
5 USDA Incomes Expires 2010 $20,852
6 CCC Loan Incomes ......................................................................................................... $0
7 Crop Insurance Incomes ......................................................................................................... $0
8 Custom Machine Income ......................................................................................................... $5,000
9 Other Machine Incomes ......................................................................................................... $0
10 Rental Incomes ......................................................................................................... $0
11 Other Farm Income Coop Dividends $1,000
12 Royalty Income ......................................................................................................... $0
  TOTAL FARM INCOMES ......................................................................................................... $409,290
13 Non-Farm Income ......................................................................................................... $0
14 Non-Farm Wages Off Farm Job $24,000
15 Business Income ......................................................................................................... $0
16 Business Expenses ......................................................................................................... $0
17 Net Non-Farm Business Incomes ......................................................................................................... $0
  TOTAL NON-FARM INCOMES ......................................................................................................... $24,000
18 Capital Sales Incomes ......................................................................................................... $0
  TOTAL INCOMES ......................................................................................................... $433,290
19 New Term Loan Incomes ......................................................................................................... $0
  TOTAL CASH INFLOWS ......................................................................................................... $433,290
page 1
Key Ratios
Total Cash Inflow $433,290  without capital sales or new term loans
$433,290
Less Total Expenses $376,196  
$376,196
Cash Flow Margin (-) $57,094  
$57,094
Cost of Earnings 63.48%  Green < 65%, and Red > 80%. Your Rating is: GREEN
Debt Coverage Ratio 280.23%  Green > 150%, and Red < 110%. Your Rating is: GREEN
Interest Expense Ratio 9.49%  Green < 10%, and Red > 20%. Your Rating is: GREEN

I/We declare this cash flow projection to be true and accurate to the best of my/our knowledge and belief

Signed by ________________________________________________________________     Date Signed__________________

P.O. Box 90    Oberlin, Kansas 67749
Phone: (800) 867- 8289 Fax: (785) 475 - 3864   
  Marketing Plan Summary Report
  Prepared for: Market Data, Inc. Marketing Plan  January 1, 2007    to    December 31, 2007 
B PROJECTED EXPENSES   Cash Flow
1 Feeder Livestock Purchases ......................................................................................................... $0
2 Breeder Livestock Purchases ......................................................................................................... $12,000
3 Feed Purchases ......................................................................................................... $5,000
4 Feed Raised ...................................................................$15,000
5 Vet and Medicine Expenses ......................................................................................................... $2,000
6 Livestock Yardage Expenses ......................................................................................................... $0
7 Livestock Marketing/Hedging ......................................................................................................... $0
8 Livestock Freight & Trucking ......................................................................................................... $1,000
9 Pasture Owned ...................................................................$0
10 Livestock Pasture/Other Rent ......................................................................................................... $2,500
11 Cropland Rental Expenses ......................................................................................................... $5,000
12 Crop Freight & Trucking ......................................................................................................... $0
13 Crop Marketing/Hedging Cost ......................................................................................................... $0
14 Crop Storage Expenses ......................................................................................................... $0
15 Seed and Plant Expenses ......................................................................................................... $25,900
16 Raised Seed ...................................................................$0
17 Fertilizer & Chemical Expense ......................................................................................................... $104,042
18 Irrigation Expenses ......................................................................................................... $0
19 Crop Insurance Expenses ......................................................................................................... $20,293
20 CCC Loans repaid or expensed ......................................................................................................... $0
21 Machine Hire Expenses ......................................................................................................... $600
22 Supplies Expense ......................................................................................................... $3,250
23 Gas Fuel & Oil Expense ......................................................................................................... $19,130
24 Utilities & Telephone Expenses ......................................................................................................... $5,000
25 Labor Hired and Benefits ......................................................................................................... $18,000
26 Repairs and Maintenance ......................................................................................................... $24,750
27 Conservation or Crop Service ......................................................................................................... $3,250
28 Property Taxes and Licenses ......................................................................................................... $4,000
29 Property Insurance ......................................................................................................... $5,000
30 Lease Expenses ......................................................................................................... $0
31 Car and Truck Expenses ......................................................................................................... $1,500
32 Professional Fees Expenses ......................................................................................................... $2,000
33 Office Dues & Publications ......................................................................................................... $600
34 Other Expenses ......................................................................................................... $0
35 Miscellaneous Expenses ......................................................................................................... $6,290
36 Depreciation Expenses ...................................................................$18,250
  TOTAL VARIABLE EXPENSES ...................................................................$33,250   $271,105
37 Operating Interest Expenses ......................................................................................................... $8,090
38 Term Loan Interest Expenses ......................................................................................................... $25,000
39 Term Loan Principal Payments ......................................................................................................... $15,000
40 Income Tax Expenses ......................................................................................................... $6,000
41 Living Expenses ......................................................................................................... $36,000
42 Capital Purchases Replacement Cash Downpayment $15,000
  TOTAL OF ALL OUTFLOW ......................................................................................................... $376,196
  PROJECTED NET CASH FLOW(-) ......................................................................................................... $57,094
  BEGINNING OPERATING CASH or (DEBT) BALANCE of ...................................................................($20,000) & ENDING of $37,094
page 2

P.O. Box 90    Oberlin, Kansas 67749
Phone: (800) 867- 8289 Fax: (785) 475 - 3864   
  Marketing Plan Crop Summary
  Prpepared For: Market Data, Inc. Marketing Plan  January 1, 2007    to    December 31, 2007 
A Crop Type:
1 Farm Unit #
2 Total # of Acres
3 Your % Share of Acres
4 Estimated Yield
5 Total Units Produced
6 Less: Units for Feed or Seed
7 Equals Units for Cash Sale
8 Times Projected Price of:
9 Equals Total Cash Flow Dollars
10 Your Income per Acre
11 Target Sale Month of
12 Probabilty of Target Price
13 Based on Past Years Reviewed of
Alfalfa
30.0
100.00%
3.3
99.9
-100.0
-0.1
$80.00
($8)
($0.27)
October
0%
10
Cane
50.0
100.00%
3.0
150.0
-150.0
0.0
$60.00
$0
$0.00
October
0%
10
Corn
400.0
100.00%
80.0
32,000.0
0.0
32,000.0
$3.75
$120,000
$300.00
November
0%
10
  B   Crop Expenses - Per Acre
1 Seed - Purchased
2 Raised Seed
3 Fertilizer
4 Chemical / Insecticide
5 Irrigation
6 Gas, Fuel, Oil
7 Cropland Cash Rents
8 Repairs & Maintenance
9 Supplies
10 Crop Insurance - Hail
11 Crop Insurance - RP, YP, or Other
12 Machine Hire
13 Marketing/Hedging Cost
14 Freight/Trucking
15 Storage
16 Lease Expenses
17 Utilities/Drying
18 Labor
19 Crop Consultant
20 Miscellaneous
21 Machinery Depreciation
22 Operating Interest
$15.00 $11.00 $30.00
$0.00 $0.00 $0.00
$25.00 $25.00 $57.00
$15.00 $10.00 $43.00
$0.00 $0.00 $0.00
$11.00 $8.00 $9.00
$0.00 $0.00 $0.00
$15.00 $12.00 $12.00
$5.00 $2.00 $0.00
$0.00 $0.00 $3.00
$2.00 $2.00 $13.00
$0.00 $12.00 $0.00
$0.00 $0.00 $0.00
$0.00 $0.00 $0.00
$0.00 $0.00 $0.00
$0.00 $0.00 $0.00
$0.00 $0.00 $0.00
$0.00 $0.00 $0.00
$0.00 $0.00 $5.00
$3.00 $3.00 $3.00
$15.00 $12.00 $12.00
$3.71 $2.05 $7.10
C Total Variable Expenses
  Times Acres Planted of
D Equals Variable Costs
E Gross Profit(Loss) of
F Net Fixed Costs Assigned
G Profit After Fixed Costs
H Income Return(Loss) Per Acre
$109.71 $99.05 $194.10
30.0 50.0 400.0
$3,291 $4,953 $77,640
($3,299) ($4,953) $42,360
(3.0%)      $3,112 (3.0%)      $3,112 (31.0%)      $32,162
($6,412) ($8,065) $10,198
($213.72) ($161.30) $25.50
page 3

P.O. Box 90    Oberlin, Kansas 67749
Phone: (800) 867- 8289 Fax: (785) 475 - 3864   
  Marketing Plan Crop Summary
  Prpepared For: Market Data, Inc. Marketing Plan  January 1, 2007    to    December 31, 2007 
A Crop Type:
1 Farm Unit #
2 Total # of Acres
3 Your % Share of Acres
4 Estimated Yield
5 Total Units Produced
6 Less: Units for Feed or Seed
7 Equals Units for Cash Sale
8 Times Projected Price of:
9 Equals Total Cash Flow Dollars
10 Your Income per Acre
11 Target Sale Month of
12 Probabilty of Target Price
13 Based on Past Years Reviewed of
Corn
100.0
66.67%
80.0
5,333.6
0.0
5,333.6
$3.75
$20,001
$200.01
November
0%
10
Grain Sorghum
100.0
100.00%
80.0
8,000.0
0.0
8,000.0
$3.50
$28,000
$280.00
November
0%
10
Grain Sorghum
50.0
66.67%
80.0
2,666.8
0.0
2,666.8
$3.50
$9,334
$186.68
November
0%
10
  B   Crop Expenses - Per Acre
1 Seed - Purchased
2 Raised Seed
3 Fertilizer
4 Chemical / Insecticide
5 Irrigation
6 Gas, Fuel, Oil
7 Cropland Cash Rents
8 Repairs & Maintenance
9 Supplies
10 Crop Insurance - Hail
11 Crop Insurance - RP, YP, or Other
12 Machine Hire
13 Marketing/Hedging Cost
14 Freight/Trucking
15 Storage
16 Lease Expenses
17 Utilities/Drying
18 Labor
19 Crop Consultant
20 Miscellaneous
21 Machinery Depreciation
22 Operating Interest
$30.00 $10.00 $10.00
$0.00 $0.00 $0.00
$38.00 $55.00 $36.67
$35.83 $45.00 $37.50
$0.00 $0.00 $0.00
$10.00 $8.00 $8.00
$0.00 $0.00 $0.00
$12.00 $12.00 $12.00
$0.00 $0.00 $0.00
$2.00 $3.00 $2.00
$8.67 $12.00 $8.00
$0.00 $0.00 $0.00
$0.00 $0.00 $0.00
$0.00 $0.00 $0.00
$0.00 $0.00 $0.00
$0.00 $0.00 $0.00
$0.00 $0.00 $0.00
$0.00 $0.00 $0.00
$5.00 $5.00 $5.00
$3.00 $3.00 $3.00
$12.00 $12.00 $12.00
$4.79 $5.17 $3.27
C Total Variable Expenses
  Times Acres Planted of
D Equals Variable Costs
E Gross Profit(Loss) of
F Net Fixed Costs Assigned
G Profit After Fixed Costs
H Income Return(Loss) Per Acre
$161.30 $170.17 $137.44
100.0 100.0 50.0
$16,130 $17,017 $6,872
$3,871 $10,983 $2,462
(3.0%)      $3,112 (5.0%)      $5,187 (1.0%)      $1,037
$759 $5,795 $1,425
$7.59 $57.95 $28.49
page 4

P.O. Box 90    Oberlin, Kansas 67749
Phone: (800) 867- 8289 Fax: (785) 475 - 3864   
  Marketing Plan Crop Summary
  Prpepared For: Market Data, Inc. Marketing Plan  January 1, 2007    to    December 31, 2007 
A Crop Type:
1 Farm Unit #
2 Total # of Acres
3 Your % Share of Acres
4 Estimated Yield
5 Total Units Produced
6 Less: Units for Feed or Seed
7 Equals Units for Cash Sale
8 Times Projected Price of:
9 Equals Total Cash Flow Dollars
10 Your Income per Acre
11 Target Sale Month of
12 Probabilty of Target Price
13 Based on Past Years Reviewed of
Wheat-KC
600.0
100.00%
50.0
30,000.0
0.0
30,000.0
$4.50
$135,000
$225.00
August
10%
10
Wheat-KC
100.0
66.67%
50.0
3,333.5
0.0
3,333.5
$4.50
$15,001
$150.01
August
10%
10
  B   Crop Expenses - Per Acre
1 Seed - Purchased
2 Raised Seed
3 Fertilizer
4 Chemical / Insecticide
5 Irrigation
6 Gas, Fuel, Oil
7 Cropland Cash Rents
8 Repairs & Maintenance
9 Supplies
10 Crop Insurance - Hail
11 Crop Insurance - RP, YP, or Other
12 Machine Hire
13 Marketing/Hedging Cost
14 Freight/Trucking
15 Storage
16 Lease Expenses
17 Utilities/Drying
18 Labor
19 Crop Consultant
20 Miscellaneous
21 Machinery Depreciation
22 Operating Interest
$12.00 $12.00
$0.00 $0.00
$48.00 $32.00
$12.00 $8.00
$0.00 $0.00
$10.00 $11.00
$0.00 $0.00
$12.00 $12.00
$0.00 $0.00
$3.00 $2.00
$13.00 $8.67
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$3.00 $3.00
$12.00 $12.00
$5.73 $3.43
C Total Variable Expenses
  Times Acres Planted of
D Equals Variable Costs
E Gross Profit(Loss) of
F Net Fixed Costs Assigned
G Profit After Fixed Costs
H Income Return(Loss) Per Acre
$130.73 $104.10
600.0 100.0
$78,437 $10,410
$56,563 $4,591
(36.8%)      $38,127 (3.0%)      $3,112
$18,435 $1,479
$30.73 $14.79
page 5

P.O. Box 90    Oberlin, Kansas 67749
Phone: (800) 867- 8289 Fax: (785) 475 - 3864   
  Marketing Plan Breeding Livestock Summary page 6  
  Prepared For: Market Data, Inc. Marketing Plan  January 1, 2007    to    December 31, 2007 
A Breeding Livestock Type:
1 Number of Head in Herd or Group
2 Avg. Production % per Head of
3 Production Cycles per Year
4 Est. Sale / Weaning Weight of
5 # of Offspring Raised per year
6 Less: # kept for Herd per year
7 Equals # of Head to sell of
8 Est. Local Cash Basis (-) of
9 Times Est. Sale Price of
10 Total Dollars of Raised Production
11 Cull % of Herd per year
12 Head Deathloss % of
13 Equals # of Culls to Sell of
14 Est. Cull Weight per Head of
15 Times Est. Sale Price per CWT
16 Equals Total Est. Cull Income of
17 Est. Sale Month of
18 Total Gross Income Of
19 # of Breeding Purchases of
20 Times Est. Cost per Head of
21 Equals Purchased Repl. Cost
22 Gross Margin On The Herd Of
Cow / Calf
100.0
93.00%
1.0
550.0
93.0
0.0
93.0
($10.00)
$100.00
$51,150
10.00%
2.00%
8.0
1,100.0
$45.00
$3,960
November
$55,110
12.0
$1,000
$12,000
$43,110
  B  Variable Operating Expenses - Per Head
1 Salt, Mineral, Protein and Supplement
2 Roughage, Grain and Other Feed
3 Value of Raised Feed
4 Pasture Rent Expense
5 Value of Owned Pasture
6 Other Rental Expense
7 Yardage Costs
8 Vet Costs
9 Gas, Fuel and Oil Expense
10 Repairs and Maintenance
11 Supplies
12 Utilities
13 Labor and Benefits
14 Marketing or Hedging Expenses
15 Freight or Trucking Expenses
16 Miscellaneous Expenses
17 Depreciation Expenses
18 Operating Interest
$40.00
$10.00
$150.00
$0.00
$0.00
$0.00
$0.00
$20.00
$5.00
$25.00
$5.00
$0.00
$0.00
$5.00
$0.00
$10.00
$10.00
$0.92
C Variable Expenses per Head
D Total Variable Expenses
E Gross Profit(Loss) per Head of
F Net Fixed Costs Assigned/Head
G Total Fixed Costs Assigned
H Projected Overall Return(Loss)
I Projected Return(Loss) per Head
$280.92
$28,092
$150.18
$147.84
(14.3%)      $14,784
$234
$2.34