Ranking Using Risk Premiums Risk Premium RP calculate

Ranking Using Risk Premiums • Risk Premium (RP) - calculate the risk premium between each of the scenarios and a Base scenario. • Risk Premiums equal the difference between the CE’s for the risky scenarios RPG to F = CEG – CEF • Rank the risky scenarios based on the RPs • Advantage is that the full distribution (F(x) and G(x)) of values for the KOV is compared pair wise to each other distribution, based on decision maker’s RAC • A wide range of RACs can be tested to allow for a wider range of decision makers given an assumed utility function • Base scenario should be the current situation or the scenario picked best by stochastic efficiency (SERF)

Ranking Using Risk Premiums Table • The RP Table is calculated like the SERF Table using the same range of 25 RACs • The user specifies the base scenario; Option 1 was selected for this example • Select the scenario that has highest risk premium for the RAC which best defines the decision maker

Ranking Using Risk Premiums Risk Premium decision maker must be paid to accept an inferior scenario Based on the Risk Premium, decision maker would pay to move from Base to Alt 4 • Risk premiums are presented relative to the base scenario, Alt 1. • Alt 4 is preferred for all risk averse decision makers. • Distance between Red line and Base line, $18, 347, is how much a risk averse decision maker would pay to move from Alt 2 to Alt 1. • Risk averse decision makers prefer Alt 4 to Alt 1 and would pay about $8, 000 to gain Alt 4 over Alt 1.

Roy’s Safety First Rule • Roy (Econometrica, 1952) • Select the strategy which minimizes the chance of falling below a critical level of net cash income • Rank risky alternatives based on the scenario with the smallest probability of low net cash incomes • This is essentially a one light “Stop Light chart”

Roy’s Safety First Rule • A Roy’s Safety First Rule presented as the probability of NCIi < target each year i • With Roy’s Rule, can calculate the probability of a “low” net cash income for two or more consecutive years, as: =IF(AND(NCI 1<0, =IF(AND(NCI 2<0, =IF(AND(NCI 3<0, =IF(AND(NCI 4<0, NCI 2<0), 1, 0) NCI 3<0), 1, 0) NCI 4<0), 1, 0) NCI 5<0), 1, 0) • Repeat the =IF(AND()) statement for all years 2 -T and summarize the counter variables for all iterations • Roy’s probability is sum for all of the =IF(AND()) values divided by (No. Years – 1) * No. Iterations – If 10 years and 500 iterations the denominator is 4, 500 representing all possible sample observations that could be 1

Roy’s Safety First Rule • The scenario was simulated 100 iterations • Net cash income is for 10 years • Roy’s values are for 2 consecutive years with negative NCI • Roy’s Probability is the sum of the =IF(AND()) counter variables divided by 900, which is = 9 * no. iterations

Roy’s Safety First Rule • The Stop Light displays the probabilities of having two years of negative NCI in a row, years 1 & 2 or Years 3 & 4, etc. • Chart developed from the data in the previous overhead, over all 100 iterations • The counter variables can be 0 or 1 so not marginal probabilities and thus no yellow in the Stop Light

Roy’s Safety First Rule • Compare risky scenarios using the scenario with the lowest Roy’s Probability as the preferred scenario • Scenario 1 has Roy’s Probability 0. 33 • Scenario 2 has Roy’s Probability 0. 53 • Scenario 3 has Roy’s Probability 0. 23 • Scenario 4 has Roy’s Probability 0. 35 • Pick Scenario 3 as it has the lowest chance of having two yeas of negative NCI, if that is the rule.

Materials for Lecture 15 Financial Models • • • Read Chapters 13 and 14 Lecture 15 Pro Forma. xls Lecture 15 Fin Risk Manager. xls Lecture 15 Farm Simulator. xls Lecture 15 Income Taxes. xls

Multi-Year Financial Models • Business decisions often are made based on simple rules – Mean net return (IRR, NPV, etc. ) – Worst case and best case – Number of years to payoff debt – Give the business control of its supply chain, etc. • These business decisions are inherently multi-year in nature

Multi-Year Financial Models • KOVs for multi-year financial models – Annual net cash income • Probability of negative NCIt – Annual ending cash reserves • Probability of negative ending casht • Probability of having to refinance deficitst – Annual net worth (nominalt and realt) • Probability of decreasing RNW relative to BNW – Annual debt to asset ratio • Probability of insolvency – NPV summarizes returns over multiple years

Multi-Year Financial Models • Common theme or features for multi-year financial models – Input values have annual projections • Prices paid and received • Annual inflation rates or costs of production • Inflation rates for asset values • Machinery replacement plans – Management controls are expressed as annual values so, can be strategically managed • Assumptions about changing productivity • Assumptions about possible structural changes • Assumptions about competition and demand

Multi-Year Financial Models • Common set of intermediate calculations – Income Statement • Receipts from each source – Total Receipts • Cash expenses for each category (non-cash expenses such as depreciation not included here) – Total Cash Expenses • Net Cash Income – Cash Flow Statement • Net cash income and all other sources of income • All cash outflows: taxes, principal payments, owner withdrawals and dividends • Ending Cash Reserves – Balance Sheet • Assets starting with positive cash balance • Liabilities – Including cash flow deficits • Net Worth – Financial summary ratios: • Debt Asset, PVENW, NPV

Multi-Year Financial Models • A significant problem can occur with multiple year simulation models – Ending cash reserves can be negative, which causes problems in all three pro forma financial statements • What happens if ending cash is negative? – Cash reserves are zero – Must create a short-term liability – Must pay interest for this loan next year – Must repay the short-term loan next year

Multi-Year Financial Models • Problem of negative ending cash is much greater in agriculture and agribusiness models -- it occurs more often than in non -ag businesses • Risk on prices and production greater than for non-ag business interests • If you build financial models that do not accommodate this problem, you understate the risk involved with an investment

Multi-Year Financial Models • Modification to the pro forma financials for negative cash flows are simple • Change the Income statement – Add an expense category for interest paid on cash flow deficit loans – keep it separate from operating interest paid • Change the Cash Flow Statement – Make Beginning Cash equal to Cash Balance in the Balance Sheet (it should be this way but many students make the mistake of making it equal to ending cash t-1 -- -5 on Lab Exam!) – Add a cash outflow to repay the short-term loan borrowed in the previous year to meet a deficit (-5 on Lab Exam!) • Change the Balance Sheet – IF() statement for Beginning Cash – that it must be positive or zero – IF() statement for a Short-Term Liability to have a value if ending cash reserve is negative

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 A Income Statement Receipts Total Receipts Expenses All Non-Interest Expenses Interest for Land Loans Interest for Machinery Loans Interest for Operating Loans Interest for Carry over Loans Total Expenses B 2000 C 2001 D 2002 = B 2 = C 2 = D 2 = 0. 0 = SUM (B 5: B 9) = B 33 * i. Rate = SUM (C 5: C 9) = C 33 * i. Rate = SUM (D 5: D 9) Net Cash Income = B 3 – B 10 = C 3 – C 10 = D 3 – D 10 Cash Flow Statement Beginning Cash Jan. 1 = Initial Value = B 27 = C 27 Net Cash Income Other Inflows Total Inflows Repay cash flow deficits Other Outflows Total Outflows Ending Cash Balance Dec. 31 = B 12 = B 17 + B 18 + B 15 = 0. 0 = B 20 + B 21 = B 19 – B 22 = C 12 = C 17 + C 18 + C 15 = B 33 = C 20 + C 21 = C 19 – C 22 = D 12 = D 15 + D 17 + D 18 = C 33 = D 20 + D 21 = D 19 – D 22 = IF (B 23 > = 0, B 23, 0) = SUM (B 27: B 30) = IF (C 23 > = 0, C 23, 0) = SUM (C 27: C 30) = IF (D 23 > = 0, D 23, 0) = SUM (D 27: D 30) = IF (B 23 < 0, (-1 * B 23), 0) = SUM (B 33: B 35) = B 31 – B 37 = IF (C 23 < 0, (-1 * C 23), 0) = SUM (C 33: C 35) = C 31 – C 37 = IF (D 23 < 0, (-1 * D 23), 0) = SUM (D 33: D 35) = D 31 – D 37 Balance Sheet Assets Dec. 31 Cash Reserves Land Value Machinery Other Assets Total Assets Liabilities Dec. 31 Cash Flow Deficits Land Machinery Total Debts Net Worth

Multi-Year Financial Models – Income Taxes • Income taxes must be considered explicitly • Calculate taxable income Taxable Income = Total receipts – total cash expenses depreciation allowance - deductions • Use a tax table to compute taxes due • Enter taxes paid in the Cashflow Statement

Multi-Year Financial Models – Applications • Financial risk management – Analysis of the economic impact of changes in the business plan for a firm on • Ability to repay loans on time • Ability to remain solvent • Ability to earn a satisfactory rate of return on investment – Analysis of alternative marketing schemes that use contracts, futures and options to manage price risk • Portfolio analysis – Analysis of alternative combinations of investment instruments (stocks, bonds, land, etc. ) – A portfolio of investments is similar to a derivative in the investment world

Financial Risk Management • A farm level simulation model developed to analyze the financial risk faced by a farm • Input data for initial financial situation of a farm with 10 years of price and yield history providing measures of risk in production and marketing • Several financial instruments are available to test the effects of different financial arrangements on firm’s cash flows and ability to repay operating loan and remain current on long- and intermediate-term loans

Financial Risk Management

Financial Risk Management

Financial Risk Management

Financial Risk Management

Financial Risk Management

Financial Risk Management

Financial Risk Management • Uses of this type of model – Test ability of firm to repay operating debt under alternative assumptions about • • Other income Family/dividend withdrawal assumptions Machinery replacement plans Re-financing the initial machinery loans Insurance, pricing and marketing options for the crops Farm program provisions Costs of production including rental rates for land Purchasing land rather than leasing • Users of this type of model – Lenders concerned about loan solvency – Borrowers concerned about impacts of growth