NOTE: You will need to complete the tables below. To do so, equations will need to be entered into the shaded colls below. Total Cash Revenue is just the sum of the primary source of cash revenue for the particular investment and its other cash revenue. To properly Incorporate the risk analysis, be sure to multiply the milk price and the corn yield by its associated adjustment factor Use that adjusted cell when calculating the cash revenue cell Year New Cows Milk Production per Cow per Year (cwt) 200 Milk Cash Revenue Other Cash Revenue 350 205 210 350 TE Cash Revenue Projections for Milk Expansion Milk Price (5 per cwt. Adjusted Milk Price including $1 premium) $13.60 $12.80 $13.50 $13.70 $13.80 $13.90 $14.00 $14 10 $14.30 $14.40 220 230 230 350 350 350 $141,219 $144,345 $120,416 $122 865 $126.085 $128,560 $133,652 $134,544 $130,258 $135,588 350 240 240 250 250 350 350 350 Adjustment Factor on Milk Price 100 0% Dash Revenue Projections for Food Grade Corn Expansion Year New Food-grade Corn Corn Yield (Bushel/Acre) Acres Adjusted Com Yield (Bushel/Acre) Food Grade Com Cash Revenue Other Cash Revenue 400 145 145 400 400 400 400 Food Grade Corn Premium (S/Bushel) $0.40 $0.40 $0.40 $0.40 $0.40 145 145 145 $18,832 $19,160 $18.922 $18,687 $18.454 Adjustment Factor on Com Yield 100.0%