Question

1 Approved Answer

Posted on Sep 15, 2024

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

image text in transcribed

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% Numbers to be used in calculating the weighted cost of capital 83% Marginal Cost of Debt Afer Tax Cost of Equity Werted amount of deblog Weighted amount of equity long 80.0% ed Average Cool Capital Disc Rate Total Cash Expense PV Foto $882.700 $12.129 $3168 821.781 1254 SORO 199304 $1.016783 $1.042.202 $1,100.60 $1,134.347 Total investment - $1.700.000 Tones ready account for depreciation expense P 10 Capital Recovery Factor Anu EU NPV MR TANA Crop assessment cash to Total Cash Total Cash Expense Salvage Value Net Cash Flow PV Factor Net Cash Flow 1000 1.000 $20 301 $20 910 $21.242 $21.583 $21.932 54199 4413 1000 Taxes already account for depreciation expense Capital Recovery Factor Annuity EQUIN NPV Financial Fosby for Dairy Net Cash Flow Total Loan Payment Principal Portion ayment Surplus or Deficit 00 521 $1.002.739 31. 51. 15 O for Crop Nel Cash Flow Total Loon Payment Surplus ore (1251) 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% Numbers to be used in calculating the weighted cost of capital 83% Marginal Cost of Debt Afer Tax Cost of Equity Werted amount of deblog Weighted amount of equity long 80.0% ed Average Cool Capital Disc Rate Total Cash Expense PV Foto $882.700 $12.129 $3168 821.781 1254 SORO 199304 $1.016783 $1.042.202 $1,100.60 $1,134.347 Total investment - $1.700.000 Tones ready account for depreciation expense P 10 Capital Recovery Factor Anu EU NPV MR TANA Crop assessment cash to Total Cash Total Cash Expense Salvage Value Net Cash Flow PV Factor Net Cash Flow 1000 1.000 $20 301 $20 910 $21.242 $21.583 $21.932 54199 4413 1000 Taxes already account for depreciation expense Capital Recovery Factor Annuity EQUIN NPV Financial Fosby for Dairy Net Cash Flow Total Loan Payment Principal Portion ayment Surplus or Deficit 00 521 $1.002.739 31. 51. 15 O for Crop Nel Cash Flow Total Loon Payment Surplus ore (1251)