., lllllWillllllllllllllllllIlllllllIlllllllllllllllllllllllllll“I 3 1293 10424 4193 This is to certify that the thesis entitled A STATISTICAL MODEL FOR CHARACTERIZING PRICE VARIABILITY WITH APPLICATION TO DAIRY INVESTMENT ANALYSIS presented by TERRY ROS S SMITH has been accepted towards fulfillment of the requirements for Ph.D. degree in Dairy Science 7 Date %[ 21A: flag, AS7630 0-7639 LIBRARY Michigan State University OVtRDUt Pint): 25¢ per day per item RETURNING LIBRARY MATERIALS: ._____.____.________..____. Place in book return to remove charge from circulation records A STATISTICAL MODEL FOR CHARACTERIZING PRICE VARIABILITY WITH APPLICATION TO DAIRY INVESTMENT ANALYSIS BY Terry Ross Smith A DISSERTATION Submitted to Michigan State University in partial fulfillment of the requirements for the degree of DOCTOR OF PHILOSOPHY Department of Dairy Science 1980 ABSTRACT A STATISTICAL MODEL FOR CHARACTERIZING PRICE VARIABILITY WITH APPLICATION TO DAIRY INVESTMENT ANALYSIS BY Terry Ross Smith A statistical linear model was developed to estimate variability for price time series data. The quarterly or yearly estimates result- ing from the statistical model were used to generate simulated proba- bility distributions for each of the variables considered. A set of five interactive Fortran computer programs was developed to perform the statistical and simulation procedures. A linear one-way classification model with fixed effects was used to compute quarterly and yearly solutions. The model (Yij = A1 + Eij) is full ranked and unique solutions were computed under the constraint that the overall mean (u) was zero. The estimable function was u + Ai, which becomes A1 with u set equal to zero. Although small sample sizes (one observation per month) did not permit a statistical test for nonhomogeneity of variance between quarters or years, the variances across time periods for the price series were assumed to be different. Covariances between time periods were considered to be non-zero, since the objective was to develop "best estimates" for time series data, error terms were assumed to be correlated across observations. As a result, autocovariances were used to develop the variance-covariance Terry R. Smith matrix used in the linear model to calculate quarterly estimates. A simulation procedure was used to generate probability distributions based on the statistical estimates. A triangular matrix derived from the historical variance-covariance matrix and a random normal deviate generator were used to simulate the price series. The simulation pro- cedure generated a random series of normally distributed and appropriately correlated probability distributions for each variable considered. The procedure assumed that each variable reacts to the changes in the other variable in a way that could be described by the variance-covariance matrix. The input time series were tested for normally distributed residuals. The results of the Shapiro-Wilk test for normality indicated that for the eleven time series selected, the normality assumption was not always met. The price series were deflated by U.S.D.A. price indices in attempting to normalize these data. While there was some improvement in the normality of the time series when deflated, selection of the appropriate deflator and the interpretation of deflated series were considered major problems. Statistical tests were also performed to validate the output from the statistical and simulation computer programs. Based on comparisons made between original and simulated sample variances and means the technique appears to generate reasonable probability distributions based on the input time series. By incorporating probability distributions, such as those generated using the above described procedures for price, income or cost variables into a capital budgeting model, the information generated by the analysis represents a substantial improvement over conventional methods of Terry R. Smith incorporating risk into investment decision models. The technique was illustrated with an example. The statistical estimates and simulated probability distributions for two price series were applied to the capital budgeting model. The example compared the profitability of leasing 100 bred dairy heifers with purchasing the same over a four year period. Michigan cull cow and calf price probability distributions were used in the model. The analysis demonstrated the difference between the net present value that resulted using the expected values for each variable compared to the distribution of net present values using probability analysis. Probaility statements were made based on these results. A users guide to the computer programs and source program listings were included. ACKNOWLEDGMENTS I wish to express my gratitude to those who provided advice and assistance throughout this study and over the course of my graduate education. Special thanks are extended to my major professor, Dr. John A. Speicher, for his continuous encouragement, support and sharing of his knowledge, throughout my graduate experience. I would also like to thank Dr. Ivan L. Mao for his valuable assistance and suggestions during the preparation of this dissertation. I would like to extend my thanks to Drs. John R. Brake and William G. Bickert for serving on my guidance committee and for their time spent on my behalf, in and out of the classroom. An appreciative thank you is offered to Dr. Harold D. Hafs for his encouragement and the financial support provided by the Department of Dairy Science during my graduate study. My deepest appreciation goes to my wife, Cynthia, for her constant support and understanding throughout the course of my graduate education. An a special thanks must go to our son, Ryan, for the added happiness and joy he has brought into our family. ii TABLE OF CONTENTS INTRODUCTION . LITERATURE REVIEW. MATERIALS AND METHODS General Linear Model . Development of the Variance— Covariance Matrix . Simulation Model Test for Normality Application of the Statistical and Simulation Procedures RESULTS AND DISCUSSION . Evaluating the Normality Assumption . . Statistical Comparison between Original and Simulated Data . Application of Simulation Technique to Capital Budgeting . . Leasing versus Purchasing Dairy Cattle - an Example . A Guide to the Use of the Statistical and Simulation Progran . SUMMARY AND CONCLUSIONS APPENDIX A . REFERENCES . 21 22 24 27 29 30 32 32 35 39 4O 48 53 59 81 LIST OF TABLES A Comparison between Original and Deflated Time Series with respect to Normality. A Comparison between Input Sample Variance and Simulated Sample Variance for Selected Deflated and Undeflated Time Series Results of Wilcoxon's Rank Sum Test to Compare Means. Animal Numbers from 100 Bred Dairy Heifers Over Four Years . . . . . . . . . . . . . . . . . . . . . . . . A Comparison of Approaches to Net Present Value (NPV) Analysis of Costs and Returns for Leasing versus Purchasing 100 Bred Dairy Heifers . 33 37 38 43 44 LIST OF FIGURES l. Generalized Variance-Covariance Matrix (lower triangle). . . 26 Table APPENDIX A: LIST OF TABLES IMSL Routines . Computer program variable list. Source listings of interactive Program One Source listings of interactive Program Two Source listings of interactive Program Three Source listings of interactive Program Four . Source listings of interactive Program Five . Sample Output from Interactive computer programs computer programs computer programs computer programs computer programs Computer Programs. 59 60 63 67 71 72 75 77 INTRODUCTION Price and income instability has been characteristic of American agriculutre. Since the 1930's, price and income variability in agri- culture have indirectly been met by various government price, income, trade, resource and inventory programs. However, the price-supporting features of many of these programs has focused more strongly on in- creasing the level of farm income rather than reducing its variability. As a result, these programs have often stimulated growth in production capacity, thereby compounding problems of supply management and income instability (Barry and Fraser, 1976). The combined effects of invest- ment in larger, more efficient technologies and the expanded production capacity requires high rates of financial growth in order to preserve the economic viability of the farm business. Producers have little capacity for influencing resource and product prices. The prices paid, prices received and level of pro- ductive capacity of a farmer is affected by internal as well as external forces. Comodity price support programs, environmental regulations, trade restrictions, wars, changes in demand and changes in government monetary and fiscal policies, are externalities which have an impact on the farm firm. Adverse weather, pests and disease outbreaks can be disastrous to crop and livestock production. Family health and manage- ment ability and continuity are examples of internal sources of uncertainty. Since farm growth objectives and investment alternatives imply long- term planning horizons for proper economic analysis of all flows, costs, returns and cash, a manager's inability or reluctance to plan over periods of sufficient length can lead to inadequate economic decisions. Current methods designed to aid in the decision making process can be improved upon and new ones need to be developed. The principal objective of this study was to develop a statistically-sound procedure for incor- porating yield, price and income variability into a capital budgeting model. Most dainrfarmers had quite favorable returns during the five- year period, 1968 to 1972. Increasing feed costs caused a profit squeeze in 1973, although milk prices were also rising (Knoblauch, 1976; U.S.D.A., 1978). Many dairy farmers experienced negative returns to their labor and management during the period, 1974 to 1977 (Kelsey and Johnson, 1979; U.S.D.A., 1978). The Food and Agriculture Act of 1977 required a milk price support level of not less than 80 percent of parity through March 1979 (then the minimum support level reverted to not less than 75 percent of parity). The act also required that the support level be adjusted semi-annually through March 31, 1981 to reflect changes in the parity index. If Congress does not act again before September 30, 1981, the support level will revert to 75 percent of parity. The difference between 75 and 80 percent parity represents a difference of approximately 75 cents per hundredweight (cwt) of milk. Partially as a result of the higher support prices, the financial conditions of dairy farmers have improved and returns to labor and management were sharply higher in 1978 and 1979 (Kelsey and Johnson, 1979; U.S.D.A., 1978). While empirical variability estimates are not necessarily identical with the traditional concept of risk or uncertainty, they are objective measures of past variability in income, prices and yields (Carter and Dean, 1960). Knoublauch (1976) showed that the economic environment in which Michigan dairy producers operate has become more variable in terms of product prices and input costs. As yield and price were combined into gross income per acre, more variation existed for all crops during the 1970 through 1974 period than for the previous 10 year period. Base milk prices increased slightly in variability during the 1970 to 1974 period but were the most stable of all farm product prices. Farm input costs also increased in variability with the exception of farm wage rate which remained about the same, while 6-24-24 mixed fertilizer cost variability was less in the 1970 to 1974 period. Barry and Brake (1) noted that multiperiod planning horizons intro- duce risk not found, or at least well beyond that feund' in single period production models. Future coefficient values may be specified as point estimates of expectations or as probability distributions of future values with mean and variance estimates or probability functions which describe the kind of relationships which are not deterministic but more obscure. In the latter case, variables may vary jointly but not in an exact manner, resulting in relationships which are necessarily probabilistic and subject to equation errors. Revenue and cost infbrmation relevant to evaluating capital invest- ment proposals should be expressed in terms of cash flows into and out of the business during its expected economic lifetime. Cash flow analysis aids in evaluating the impact of both alternative investment and financing strategies used in acquiring resources, on liquidity position, income expectations and the present worth of the firm (Barry and Brake, 1971). To collect and assemble realistic estimates for the key factors which might be expected to impact an investment proposal, means to find S1 , and £0.025,59,99 g 1.39 for cases in which S1 > 52 . The values for the sample population standard deviations are shown in Table 2, along with the results of the statistical test used to compare sample variances. Since this test should be applied to normally dis- tributed variables.the results of the non-deflated data were compared with the deflated data, since the non-deflated data were shown to be more normally distributed. While deflating the data obviously removed a large portion of the variation associated with movements in the general price level, the simulated sample variances were statistically different for the input sample in six of the 54 cases tested, compared with two incidences of dissimilar variances for the non-deflated data. The simu- lated sample variance appeared to be consistently larger, though not necessarily statistically different than the input sample variance for most cases tested. No explanation was made for this trend in the data. The simulated and input data were also compared with respect to their respective sample means. The test of difference between the two means was made using the Wilcoxon's rank sum test. This test is used fer comparing the means of two populations having the same but unspecified distributions. The IMSL Library (1979) subroutine NRWRST was used to perform the test. The results showed that the hypothesis of equal means (simulated vs actual) would be rejected only in those few cases indicated in Table 3, for the selected time series. These analyses were performed as an attempt at verifying the validity of the statistical and simulations procedures carried out by the computer programs. Based on these analyses one should have some confidence in concluding that the sample variances and sample means for the original qmcwe N. > noapmewmos menace: maven mmsvpo .HmN .coo .oeu .Naa .uNH .ecu m .emc .Hmu .uua .uou .uoc .coN seam" “A\acv > .Hmm .uso .amm .sout .mmmt .Nmo m .Hos .~u_ .umc .usu .ucm .Nmm omam A«\ece w .cuo .oma .uuo .Huu .uua .Hua m .cos .cos .uuo .HNC .Nou .cmu mowemm=m Aa\ccv > .Nomt .Heu H.so~ .aom H.omu .me_1 m .Nmo .Nco ~.umm .VAN ~.u_u .uau i. :me RA\ao=v > N.Hu~ H.3mm u.oue s.umu u.~om ~.cus m ~.um~ e.eoc u.ooo s.um~ u.-u ~.suo anew ne\n=av > .Nuo .Hms. _.uma .~m~ ~.~m~ ._mu m .uao .Ndc c.sum ._mo ~.m~u .Hmu zacx no: Aa\:ae > mo.oc No.50 su.o~ sa.~¢ Nua.mm um.au m uo.~m No.uu su.mo mu.mm NNN.o_ Co.u~ i. one_ no: AA\oznv > ~.ou_ H.33H a.ccu s.m~o _H.cmo u.um~ m ~.~ou ~._~N o.cam m.emo Ho.uH~ ~.oos nmam A“\=av > m.Huu u.u~u _w.mo -.sa ~N.~m 3.83; m s.mau m.uea us.co -.cu No.mm u.muu >..mnn:m~ wzucn amen m..mwacuonma mono z..c:mmm_mnma U..aom~mnma s unrwm museum .10) data are quite similar to those generated by the simulation procedure. The major shortcoming of the computer programs developed to perform the statistical analysis are with respect to the design of their data handling capabilities. Each data point is in effect handled only as a monthly observation. In other words, variables which generally call fer annual observations would be treated as if the observations were monthly. As a result, three annual crop yields would be treated as a "quarter" (i.e. three months). The output data must be used and inter- preted assuming the input data represents monthly observations. The statistical programs and simulation procedure are designed to handle the computations for from two to ten variables. However, each variable must necessarily have the same number of observations as all other variables considered during one pass through the program sequence. 39 Thus, for example, annual crop yield and monthly crop price data are not compatible in the same model. It would however, be possible to run the program with the monthly data initially and then use the yearly data. Application of Simulation Technique to Capital Budgeting The statistical and simulation procedures can be used to incorporate the variability of a wide variety of events into an investment analysis. In addition to the leasing versus purchasing example described below, ones imagination is the only limit to the application potential of this technique. Events such as seasonal and year-to-year variations in milk production levels, and yearly crop yields would be expected to have a major impact on various managerial decisions. The variability in the level of milk production and milk price, for example, over the course of expanding the size of a dairy enterprise should certainly be incor- porated into a complete farm budget analysis. Analysis of variations in estimated gross income per acre or per animal unit are examples of variables which include the variability owing to both physical produc- tion and prices. A relatively simple example was developed to illustrate the use ” of the statistical and simulation procedures within a capital budgeting framework. The example used compares the relative profitability of leasing 100 bred dairy heifers versus purchasing the same. The example is designed to demonstrate the kinds of infermation the capital budgeting output provides the decision maker with when the simulation technique is incorporated 40 into the analysis. The results of the "point estimate" approach are compared with those generated when the statistical solutions and sim- ulation technique is used. Leasing versus_purchasing dairy cattle - an example In general, a lease is a contract by which the lessee acquires sole use of an asset in return for lease payments. The lease payments reflect the value of the leased asset and the lessor's (owner of the asset) carrying costs and his profits. Thus, a lease is similar to a conventionally financed installment loan. A dairyman entering into a dairy cattle leasing agreement generally agrees to maintain a specified number of cows for the duration of the agreement (usually for 3 to 7 years). Leasing agreements differ greatly with respect to culling leased cows, replacing culled cows, disposition of calves born to leased cows and disposition of leased cows at the time the lease expires. The dairyman typically receives the milk income from the leased cows. Therefore, when comparing leasing with purchasing one may assume that milk receipts will be the same, if the dairyman is comparing purchasing a group of cows with leasing the same group of cows. Thus, a comparative analysis need only include differences in costs and returns due to leasing or purchasing. Determining whether a change in the farm business will be profitable or not does not require a complete budget. A partial budget is a plan that lists only the receipts and expenses which are expected to change with the proposed change. In order to evaluate and compare the costs and returns over time, for any method of acquiring control of an asset, 41 one must recognize the time value of money. Net present value (NPV) analysis or capital budgeting is a technique used to evaluate the pro- jected cash flows for an investment or to compare investment alternatives. This technique dismants the projected cash flows (outflows or costs and inflows or returns) to their present values (their equivalent worth today). There are seven basic types of information required for an NPV analysis. Namely, l) the initial investment of equity (owned) capital; 2) the annual cash flows (cost and returns) attributed to the investment; 3) the length of time over which the analysis is being made; 4) the salvage value (if any) of the investment; 5) the interest or discount rate or required rate of return; 6) the applicable marginal income tax rate for generating results on an after-tax basis; and 7) the depreciation method used for old or new assets. In the example chosen, the only costs associated with leasing are the monthly lease fees since only those costs and returns that differ with respect to leasing versus purchasing need to be considered. In this particular example the leasing company would receive all cull leased cows and pay the dairyman a fixed rate ($30/head) for all bull“ calves born from leased cows. The cost side of the comparison for the purchasing example includes only the purchase price. The returns associated with the purchase alternative include, the market value of culled cows and the actual market value for the sale of bull calves. In addition to these costs and returns there are important tax considera- tions that need to be included in the analysis. In the case of the leased animals, the lease fees are the only deductible expenses associated with leasing. The example assumes that 42 the lessor chooses to pass the investment tax credit to the lessee, although it does not enter the analysis since it is assumed that the same tax credit would be available under the purchase alternative. In the case of the purchased animals, depreciation, and the interest paid on borrowed capital are included because of the effect they have as tax shields on cash flows. The acceptability and ranking of investments based on discounted cash flows depends on the sign (positive or negative) and the relative magnitude of the resulting NPV figures. In this example, since it was assumed that actual cash receipts from milk sales would be the same whether the animals were purchased or leased, the resulting NPV figures would be expected to be negative as the costs (negative NPV) outweigh the tax credits and income from the sale of calves (leasing and purchas- ing) and the sale of cull cows (purchasing). Therefore, the smallest negative NPV would be the favored investment. The dairy herd growth model (TELPLAN 52) was run for 100 purchased bred heifers to project the number of culls and bull calves to be expected over a four year planning horizon. Average death losses and cull rates were used to generate the results. Death losses for purchased bred heifers were assumed to be 2, 4,3 and 2 percent for years one through four, respectively. The average assumed cull rates for purchased bred heifers were assumed to be 35, 33, 28 and 26 percent for years one through four, respectively. Death losses for bull calves from birth to sale as newborn calves was assumed to be five percent. The average age at which heifers freshened was set at 24 months and an average calving interval of 13 months was used. The heifer raising strategy used to generate the desired results was one in which no heifers were raised as 43 replacements. The results from the animal inventory analysis are presented in Table 4. Table 4. Animal Numbers from 100 Bred Heifer Over Four Years Year 1 2 3 4 Cull cows 34 21 10 1 Bull calves 47 31 21 15 Table 5 presents a net present value analysis of the costs and returns associated with leasing versus purchasing 100 bred heifers using the conventional "point estimate" approach and the simulation technique developed in this thesis. Since —$29,702 (NPV purchase) is less negative than -$3l,l89 (NPV lease) based on expected values, one would conclude that purchas- ing is the preferred alternative. However, the range and distribution of NPV's around the expected value resulting from the simulation pro- cedure indicate there are times when the leasing option should be the preferred option in this example. According to Gill (1978), for any normally distributed random variable Y, the transformation, 2 = (Y - uy/o, always leads to a normal distribution with mean 0 and variance 1, where "y is the population mean and o is its' standard deviation. The probability density function for the standard normal form is: 44 Table 5. A Comparison of Approaches to Net Present Value (NPV) Analysis of Costs and Returns for Leasing versus Purchasing 100 Bred Heifers1 LEASE Present Value Costs: Lease fees ($10.50/head/mo) $41,400 Total costs $41,400 Returns: 2 Lease fees (tax credit) $ 7,988 Sale of bull calves ($30/head/ml) $ 2,223 Total returns: $10,211 Net Present Value = (-$41,400 + $10,211) = $~31,189 PURCHASE Costs: Purchase price ($600/head) $60,000 Total costs: $60,000 Returns: 2 3 Interest (tax credit) ’ 2 4 $ 1,744 Depreciatgon (tax credit) ’ $ 4,064 Cull cows : Expected P.V. $20,115 Range $16,513 - $24,083 Standard deviation $ 1,708 Bull calves: Expected value $ 4,375 Range $ 3,686 - $ 4,963 Standard deviation Total Returns: Expected value $30,298 Range $26,817 - $34,024 Standard deviation $ 1,742 Net Present Value: Expected value -$29,702 Range -$33,183 - $-25,976 Standard deviation $ 1,742 110% discount rate over 48 months 22095 marginal tax rate 31095 annual rate of interest 4straight-line depreciation: salvage value of $200/head Sassumes average of 12.5 cwt/head 45 FZ(z) = (1//§F) exp (22/2) and the cumulative density function is: z. p(z < z) = F2 (2) = _£ 1 f(z) dz Initially, one must establish with some degree of confidence that the distribution approximates a normal distribution, prior to making standard normal transformations and probability statements. The third and fourth moments for the 1000 simulated net present values were 0.080 and -0.643, respectively. The moments of a sample can indicate a great deal about the shape of the parent population's distribution. The third moment is used to determine whether a distri- bution is symmetric or skewed about the mean. Skewness is estimated by calculating the ratio of the third central moment to the standard deviation cubed. The third moment is equal to zero when the distribution is symmetric about the mean. A distribution is said to be skewed to the right or positively skewed when the third moment is positive and left or negatively skewed when the third moment is negative. It is generally accepted that a distribution is symmetric about the mean when the value of the third moment lies between -0.5 and 0.5. The fourth moment (kurtosis) is used to interpret the flatness or peakedness of a distri- bution. Kurtosis is estimated by dividing the fourth central sample moment by the standard deviation raised to the fourth power and then subtracting three. The fourth central moment is also zero for a random variable distributed exactly normal (Gill, 1978). This would indicate that this sample population has a distribution which is skewed slightly 46 to the right and is somewhat peaked. However, the sample appears to approach normality. A normal distribution would be expected since the simulation procedure assumed normality in that random normal deviates were used to generate the simulated values. The Shapiro-Wilk test for normality was not uSed because the sample sizes were greater than 50 which is theelimit for this procedure. Once the values of the random variable have been transformed to units of 2 (standard deviations of Y) probabilities can be evaluated. In order for the leasing option to be equivalent or preferred over the purchase option, the NPV of the purchase option must be -$3l,l89 or less. The NPV for the lease (-$31,189) can be transformed to standard normal form in order to evaluate the probability of leasing being the more profitable alternative. The transformation procedure for this example is shown below. A = (Y - u)/o 21 = ((-31,189) - (-29,702))/1742 z. = -0.8536 1 Probability (Y < ~31,189) Probability (Z < -0,8536) Probability (z < -0.8536) = 0.1967 This result indicates that although the "point estimate" approach using expected values would result in a decision maker accepting the purchase option as the most favorable option the results of the simula- tion procedure indicates there would be times in which the leasing option would be preferred. For this specific example, the calculated probability 47 would indicate that leasing would have been the more profitable alter— native 20 percent of the time. However, Gill (1978) warns that probabilities cannot be evaluated without knowing the values of ”y and o for the defined population of interest. In cases where large amounts of empirical evidence about the values of my and a have been accumulated, one may assume the values of the parameters and proceed directly with questions of probability. It can be shown that with information from 1000 subjects from the relevant p0pu1ation, one may be approximately 95 percent confident that the population variance lies in the interval 0.95 Sy to 1.05 Sy i.e., with 1000 observations the sample variance still is subject to an error of 5 percent (or more). However, somewhat fewer observations are required for equivalent reliability of estimates of the oppulation mean, unless the coefficient of variation is relatively large. Therefore, even with 1000 observations (simulations) on Y, in the example, in which Sy = 1742., one can be 95 percent confident that the population variance lies within 0.95 and 1.05 times the sample variance. Thus Sy would lie (with 95 percent confidence) between 1698 and 1785. Therefore, the probability that leasing would have been the preferred option would lie between 19.1 and 20.2 percent, as shown below. Zj = ((-3l,189) - (-29,702)/1968 = -0.8757 Probability (Z < -O.87S7) = .1906 Zk = ((-3l,189) - (-29,702))/1785 = -O.833l Probability (Z < -0.8331) = 0.2024 48 Agguide to the use of the statistical and simulation programs The techniques developed in this study were designed to provide an objective measurement of the uncertainty or variability associated with prices, cost and income, based on historical price series. If the desire for income stability is strong, farm managers may consider com- bining enterprises that could be expected (based on historical data) to reduce the variability of annual incomes even at the cost of some re- duction in average income over a period of time. The resulting variance of income from a combination of more than one enterprise is dependent upon the variability (variance) of the individual enterprises to be considered, and the degree of association or correlation (covariance) of the returns of these enterprises. If for example, farm resources were divided equally among two or more enterprises, total variance for the farm business would be reduced provided the variances (measure of variability) of the individual enterprises were approximately equal and there was less than a perfect correlation (price movements in the same direction for inputs and outputs) between enterprises. Decisions made with respect to capital expenditures are among the most difficult managerial problems. Most investments occur over a considerable time in the future, and therefore considerable effort is needed to predict probable costs and returns of each alternative. Secondly, often times most, if not all, of the capital must be laid out immediately, while benefits or returns occur over time. Thus, a decision-maker must balance added returns that will occur in future years against an expenditure that will be made immediately. Under- standing that the value of money is influenced by time is important in evaluating the profitability of investment opportunities. A dollar 49 received or spent some time in the future is not worth a dollar today. Discounting is the process used to find the present value of a given amount of money to be received or paid in the future. Net present value is simply the difference between the present value of benefits and the present value of costs. Because there are few cases in which prices, costs and income levels are known precisely beforehand, an analysis of alternative outcomes is essential to making a good decision based on the infor- mation available. One common way in which risk or uncertainty is incorporated into an investment analysis, is to estimate different levels of costs and benefits and compute the net present value for each combination. These estimates are typically considered: 1) the best or most reasonable; 2) pessimistic; 3) optimistic. Such estimates provide a basis for taking into account the consequences of unexpected or unforseen situations associated with the investment. Calculating the net present value for each estimate represents only a few points on a continuous distribution of possible combinations of future events. Since every factor that enters into the evaluation of a specific decision is subject to some uncertainty, the decision maker needs a portrayal of the effects that the uncertainty surrounding each of the significant factors has on the returns he is likely to achieve. The overall objective of this study was to develop a procedure which combines the variabilities inherent in the factors considered. Historical price data is used to compute quarterly or yearly estimates for each variable entered into the procedure. These estimates are then used as input to the simulation model. The purpose of the simulation model is to generate a distribution (1000 generated values) for each input price series. This 50 goes beyond representing the distribution of prices with only a few points. The simulation procedure also recognizes that prices fer different variables are interrelated or correlated. The simulation technique generates distributions for each variable, that are correlated with the other variables as dictated by the historical input price series. A probability distribution represents the odds of achieving a particular value or range of values based on the input time series. The following discussion describes, for the user's benefit, the set of five interactive computer programs developed in this study. The first four programs perform the statistical procedures described in detail in the materials and methods section of this thesis. Monthly data can either be read from a computer disk file or input directly by the user typing it into the computer terminal. The programs will accept monthly observations for from two to ten variables over a time period of up to five years for each variable. The statistical programs (PRGl thru PRG4) compute both quarterly and yearly best, linear, unbiased estimates (B.L.U.E.) from the input series. A variance-covariance matrix (which is a representation of the variability associated with each variable over time, the "co-variability" between variables and across time periods) is used to generate another matrix (unique trian- gular matrix) which is used in the fifth program to generate the simu- lated data. If the user is interested, he can elect to have the variance-covariance matrix, correlation matrix and unique triangular matrix printed out. After the statistical computations are completed by the first four programs the simulation program (PRGS) uses the statistical solutions to generate the simulated data. These simulated data are 51 normally distributed about the statistical estimates and appropriately correlated across variables and across time periods. These simulated data represent a "best estimate" of a sample probability distribution for each variable, thereby providing an estimate of the distribution of values for each variable. By incorporating these distributions into a capital budgeting model, a computer program can be used to carry out the discounted cash flow calculations a large number of times to generate an output to which probabilities can be attached. In other words, instead of outputting a single value as a measure of an investment's worth (as is most commonly done), a decision maker would be presented with a distri- bution of net present values or rates of return. Sensitivity analysis could then be used to determine how sensitive the results are to a change in the tax rate or discount rate, by rerunning the program for each change. This thesis contains an example in which the generated distributions for dairy calf and cull cow prices were incorporated into a capital budgeting model to illustrate this technique. Listings of the source programs (PRGl thru PRGS) are included in Appendix A, Tables 3 through 7. A sample output is also presented- in Appendix A, Table 8. Procedure for running_the prpgram 1) Sign onto the computer (See CDC Interactive Terminal User's Manual). 2) Type: ATTACH,EX,TRSEXEC. (Hit RETURN after each input line.) 3) Type: EX. 4) The program will ask the user if he would like a brief description of the programs. ALL yes/no questions should be answered with: l=YES; 0=NO. 5) 6) 7) 8) 9) 52 The programs now begin executing in sequence. Each program will ask the user several questions relative to the data input during execution of program 1 (PRGl). When the correct response has been entered the program will continue to execute. Program 1 will ask whether the data is written on a disk file or whether it will be entered by the user. If the data resides on a disk file (data for one variable followed by data for the next) the program will not execute properly until the data file has been attached as TAPEl (i.e., ATTACH,TAPE1, user's data file). The user can receive a copy of the full matrix output should he desire it, by indicating this in response to a question asked in the beginning of program 1. (Certain statistical results will always be printed during execution). After having completed the series of five programs, TAPEll will contain the simulated data, with one variable followed by another in the order in which they were input. This file may be saved and cataloged for future use by typing: CATALOG,TAPEll,your data file name. If at any time the user wants to stop execution of the programs he can do so by pressing the ESC key. This will immediately terminate the program sequence. To rerun the program follow the instructions outlined previously. For those interested in altering the programs in any way, the following steps should be followed: ATTACH,P*,TRSPRG*. (where, * is the program number) SYSTEM,FORTRAN. OLD,PE,FR,1,BY,1. If you want a program listing, type: LIST. SAVE,XX,NS. RETURN,P*. CATALOG,P*,your file name. The user's copy of the program can now be altered without affecting the existing program. SUMMARY AND CONCLUSIONS Conclusions The statistical procedure used in this study to compute unique solutions for price time series data represents a major improvement with respect to the input to a simulation model designed to generate probability functions for each variable considered. These quarterly or yearly solutions (best linear unbiased estimates) were incorporated into a simulation procedure designed to generate correlated time series. Although, the simulated sample variances appeared consistently larger than the original series, a statistical test used to compare the variances indicated they were not significantly different. It was demonstrated that the deflated time series were more normally distri- buted than the non-deflated series. It was concluded that there is a need for further study in the area of characterizing the distributional characteristics of time series data. An example was provided illustrat- ing how the simulated distributions could be incorporated into an investment analysis. The output from the capital budgeting analysis provides a decision-maker with both the expected return based on the probabilities of all possible returns and more importantly, the expected variability in returns. Decision-makers can take the various levels of possible cash flows, and get estimates of the odds for each potential outcome from a net present value analysis. Such a procedure could also be used to produce valuable information about the sensitivity of possible outcomes to the variability of input factors and to the likelihood of 53 54 achieving various net present values or rates of return. To have calculations of the odds on all possible outcomes (based on statistical estimates) lends some assurance to the decision-maker that the available information has been used with maximum efficiency. The model, Yij = A1 + E.., is a one-way classification model with 11 fixed effects. Unique solutions are obtained from what would typically be a non-full ranked model by constraining the overall mean (u 0). Only in this way is the model a full-ranked model with a unique inverse (X' V" X)", and therefore unique solutions. The interactive computer programs compute the quarterly estimates for monthly time series data for up to ten variables over a time period of up to five years. Recognizing that the error terms for time series data are typically correlated across observations, the autocorrelations were used in the development of the variance-covariance matrix. This procedure gives greater weight to those error terms with smaller variances. Autoco- variances were used as estimates of covariances across months within quarters, between quarters within years and between quarters across years. In this way, the variance-covariance matrix V used in the normal equation to compute unique solutions incorporated trend into the linear model. If one assumes that the future variability associated with a particular set of conditions is closely related to past variability, empirical estimates do provide a reasonable basis for making short and long run decisions. Therefore, the problem becomes one of selecting a length and time period most representative of expected variability in the future. Five years were selected as the maximum period over which the statistical analysis can be performed. This decision was based 55 principally on computer memory limitations and computing costs. The approximate cost of inverting a variance—covariance matrix for each input time series represents the major cost associated with executing these programs. The approximate cost of inverting a variance-covariance matrix representing five years of monthly observations (60 x 60) is $1.00 per variable. As the size of the matrix increase the rate of increase in the cost of computing the inverse also increases. Thus, it was felt that a five year time period was a reasonable period of time in terms of characterizing price variability and at the same time holding down the compuuurmemory and computational requirements. The simulation model used to generate the probability distributions is based on the assumption that the input variables are normally dis- tributed. Statistical tests were conducted on 11 price series (milk, milk cow, cull cow, calf, corn, wheat, oats, soybeans, hay, soybean oil meal, 16 percent concentrate) for three year time periods from 1967 through 1979. The results from the Shapiro-Wilk test for normality indicated that removing the effects of changes in the general price level by deflating, improved the distributional characteristics of the input time series. The index of prices received by farmers fer dairy" products seemed to be an appropriate deflator for milk, milk cow, cull cow and calf prices across those time periods used. The index of prices received for feed grains and hay was effective as a deflator in terms of normalization, for soybean oil meal, 16 percent dairy concen- trate, alfalfa hay and oat price series. Although these results were not consistent across time periods. The basic problem associated with deflating time series is the bias introduced as a result of the series itself being a part of the index. The choice of an appropriate index 56 and the interpretation of the output from a deflated model are difficult. Further research needs to be done in the area of describing the distri- butional characteristics of price series. All too often, researchers assume normal distributions without making any attempt at veryifying their assumption. The tests used to compare the original input price series with the simulated series proved to be encouraging. The variancesand means did not appear to be greatly different for those time series tested, thus, validating the performance of the statistical and simulation procedures. Although the simulated sample variance appeared consistently larger, this difference was not shown to be significant. The value of computer programs in developing clear portrayals of the risk or uncertainty associated with alternative investments has been demonstrated. An investment analysis using discounted cash flows (capital budgeting) should provide the decision maker with more infor- mation than the expected net present value or internal rate of return. By incorporating probability distributions for price, income or cost variables into a capital budgeting model, the infbrmation generated by the analysis represents a substantial improvement over conventional methods of incorporating uncertainty into an investment decision model. An illustration of the risk analysis technique using capital budgeting was presented using the correlated price series for two variables. Michigan cull cow and bull calf price data for the four-year period 1976-1979 were used to compare leasing dairy heifers with purchasing the same. The procedure used the statistical estimates and resultant simulated probability distributions for the input price series, to generate a random normal series of net present values for the S7 purchasing option. Values of the random series were transformed to standard normal form and probabilities evaluated. The numerical results using expected values (point estimates) would have caused one to select the purchase option. However, the results differed when the probability distributions for the two correlated price series were incorporated into the model. These results would offer the decision maker a probability distribution of net present values to which the probability that a value will occur can be computed. In the example, the leasing option should have been the preferred option approximately 20 percent of the time. However, it should be recognized that the generated results will nec- essarily be indicative of conditions during the historical price series for the four-year period selected. If one assumes that the variability of the recent past is a relatively good indicator or predictor of future variability, then this approach to investment analysis offers some improvement over other attempts at incorporating measures of risk. The major advantage of a probability analysis of investment alternatives is that it results in a distribution of values to base decisions on. Whether the results are in terms of net present value, internal rate of return or other criteria, probability statements can“ be made. There are limitations to the techniques and procedures developed and examined in this study and a great deal of room for improvement. The key to improving decision making aids or models is using the avail- able data and information, be it historical series or predictions, to the fullest extent possible. A good decision is one in which the resource allocations are most likely, in a probabilistic sense, to produce favorable outcomes. Good decisions only improve the chance of 58 favorable outcomes, they do not guarantee them! APPENDIX A TABLES Appendix Table 1. BECORI- BECOVM- BEMMI- FTAUTO- GGMML- LINVZF- USMMMX- USWFM- VCVTFS- VCVTFS VMULFF- VMULFM¥ VMULFP- 59 International Mathematical and Statistical Laboratory (IMSL) Estimates of means, standard deviations, correlation coefficients Estimates means and variance-covariance matrix Estimates of means, standard deviations, third and fourth moments Estimates variance, autocorrelation, autocovariance Normal Matrix or Gaussian random deviate generator inversion, full storage mode, high accuracy version Determines minimum and maximum values in a vector Prints Matrix Matrix Matrix Matrix Matrix a matrix stored in full storage mode storage mode conversion-full to symmetric storage mode conversion-symmetric to full multiplication-full by full multiplication-transpose of A by B multiplication-A by transpose of B Appendix Table 2. A AMAT AMINPUT AMQRTS AP C CV D DENOM EINV F FVCVU IDGT IER INCD IVNBR NOBSSM NQOBS NQRTS 60 Computer program variable list MATRIX (NMONTHS X NMONTHS) FULL STORED VBLOWUP (TAPES) GOES INTO INVERSION PROGRAM MATRIX (NVARS X NVARS) UNIQUE TRIANGULAR FROM TRSPRGl (AMAT) MATRIX (NVARS X NVARS) UNIQUE TRIANGULAR MATRIX (UPPER TRIANGLE) OF A- GOES INTO TRSPRG4 MATRIX (NQOBS,NVARS) OF INPUT VARIABLES MATRIX (3 X NQRTS) OF MONTHLY OBSERVATIONS WITHIN QUARTERS MATRIX (NVARS X NVARS) UNIQUE TRIANGULAR MATRIX (LOWER TRIANGLE) MATRIX (NQRTS x NMONTHS) X-PRIME*V-INVERSE MATRIX PRODUCT S*A COEFFICIENT OF VARIATION MATRIX (NQRTS,1) X-PRIME*V-INVERSE*Y DENOMINATOR FOR WEIGHTED MEAN CALCULATION SUBROUTINE: WEIGHT MATRIX (NQRTS,NQRTS) X-PRIME*V-INVERSE*X MATRIX (NQRTS,NQRTS) INVERSE (X-PRIME*V-INVERSE*X) MATRIX (NQRTS,1) SOLUTIONS FULL STORAGE OF VAR-COV MATRIX (ALL VARIABLE-UNADJUSTED FOR TIME NUMBER OF SIGNIFICANT DIGITS TO BE USED IN ACCURACY TEST SUBROUTINE: LINVlF (IMSL) ERROR PARAMETER FROM IMSL SUBROUTINES VECTOR (NVARS*(NVARS+l)/2 WORKSPACE SUBROUTINE: BEMMI VECTOR (6) INPUT TO VAR-GOV SUBROUTINE NUMBER OF OBSERVATIONS PER VARIABLE IN SUBMATRIX ENTERED INTO VAR-COV SUBROUTINE NUMBER OF OBSERVATIONS PER QUARTER (NQOBS 3) NUMBER OF QUARTERS (N YEARS*4) Table 2. NSUBM NTOBS NVARS NVCVU NYEARS PROD SCORR V VAL VBLOWUP VCOVT VCVT VCVU VMEANS VTEMP WKAREA 61 (continued) NUMBER OF SUBMATRICES ENTERED INTO VAR-COV SUBROUTINE TOTAL NUMBER OF OBSERVATIONS (NYEARS*12+1) INCLUDING ONE FROM PREVIOUS YEAR FOR SERIAL CORRELATION NUMBER OF VARIABLES NUMBER OF VALUES IN SYMMETRICALLY STORED VAR-COV MATRIX (NVARS*(NVARS+1)/2 NUMBER OF YEARS CONSIDERED FOR EACH VARIABLE MATRIX (1,NQRTS) MATRIX MULTIPLICATION PRODUCT SUBROUTINE: WEIGHT MATRIX CORRELATION COEFFICIENTS SUBROUTINE: SECOR VECTOR (NVARS*IN) RAMDOM DEVIATES VECTOR CONTAINING STD. DEV. FOR VARIABLES SUBROUTINE: SECOR VECTOR CORRELATION COEFFICIENTS SUBROUTINE: SECOR MATRIX (3,NVARS) STD. DEV., 3RD, 4TH MOMENTS MATRIX LAGGED DATA BY QUARTERS SUBROUTINE: SECOR MATRIX (NMONTHS,NMONTHS) FULL STORED EXPANDED VAR-COV MATRIX WITH DERIVED COVARIANCES INSERTED COVARIANCES DERIVED FROM VARIANCES AND SERIAL CORRELATIONS SUBROUTINE SECOR VECTOR (NQRTS*(NQRTS+1)/2 SYMMETRIC STORAGE OF VAR-COV MATRIX FOR NQRTS PERIODS VECTOR (NVARS*(NVARS+1)/2 SYMMETRIC STORAGE OF VAR-COV MATRIX UNADJUSTED FOR TIME VECTOR (NVARS) OF MEANS FOR EACH VARIABLE VECTOR (NVARS) FOR WORKING STORAGE VECTOR (NQRTS**2+3*NQRTS) WORKSPACE SUBROUTINE: LINV2F (IMSL) VECTOR RAW DATA- TRSFRGZ 62 Table 2. (continued) XM VECTOR CONTAINS MEAN FOR VARIABLES- SUBROUTINE: SECOR XMAX VECTOR (NVARS) MAXIMUM VALUE FOR EACH VARIABLE XMEAN VECTOR (NVARS) MEAN FOR EACH VARIABLE XMIN VECTOR (NVARS) MINIMUM VALUE FOR EACH VARIABLE XPRIME MATRIX (NQRTS X NMONTHS) X-PRIME FOR NORMAL EQUATION Y VECTOR RAW DATA LAGGED ONE PERIOD- TRSPRG2 Y MATRIX (NMONTHS,1) Y MATRIX FOR NORMAL EQUATION ZNUM NUMERATOR FOR WEIGHTED MEAN CALCULATIONS SUBROUTINE: WEIGHT 63 Appendix Table 3. Source listing - Program 1 (PRGl) IOOQIQOD. PROGRAP TRSPRGT(INPUTQCUTPUTOTAPEToTAPEZcTAPE3) THIS PRCGRA! READS INPUT DATA (TAPET) IN FREE FORMAT AND CALCULATES A VARIANCE°COVARIANC£ MATRIX AND UNIQUE TRIANGULAR MATRIX FOR UP TO TEN VARIABLES. TAPET ' INPUT DATA READ IN FREE‘FORHAT ONE VARIABLE AFTER ANOTHER TAPEZ 3 OUTPUT UNIOUE TRIANGULAR MATRIX (AMAT) DIPENSICN APINPUTIOZ.5C),VTEPPISO),VPEANS(SO),VCVU(TZ7$), *IVNBR(6),PVCVU(SO,SO),APAT(53,30),INCD(1275), OXFOPENTI3OSG) REWIND1 REBINOZ REHIND! IBUCIC PRINT*,' ' PRINT',' ""CXECUTINC TRSPRC1tte'" PRINT‘," ' IFLAC’C PRINTF,” ENTER NUMBER CF VARIABLES TO BE READ IN“ RCAD',NVARS PRINT0,' ENTER NUMBER OF YEARS" READ-QNYEARS Nn-NVARs-WVEARS PRINT',' ENTER NUPBER CF OBSERVATIONS PER YEAR” READ',NYROBS IftNVARS.LE.1)PRINT~o' CANNOT CALCULATE VAR-COV MATRIX- PRINTF,“ ARE THE OBSERVATIONS FOR EACH VARIABLE WRITTEN " PRINT'," TC A TAPE? (181C5:SINO)' REAthflY PRINT',” ENTER NUMBER OF OBSERVATIONS TO BE READ IN FOR EACH' PRINTe,' VARIABLE INCLUDING THO OBSERVATION FRO” LAST TWO PERIODS" PRINTO,” OF PREVIOUS YEAR.” READ'ONTUIS PRINTE,” DO YOU WANT FULL OUTPUT OF MATRICES PRINTED ON TERSINAL?“ R£A60,VY IT(YY.ED.1)IFLAC'1 IFIWV.EG.1160 To 313 - DATA READING LCOP 22 00 3c I81,NVAPS DO 25 121,Wroas READO.APINPUT(J¢I) CONTINUE PRINT'," HERE ALL VALUES ENTERED CO'RECTLY?” READ',NY IFINY.EO.C)GO re 31 URITE(1,')(APINPUT(NJ,I),NJ81,NTOES) GO T0 35 Table 3. 64 (continued) ' DATA CORRECTION LOOP 31 35 310 33 S 6 13 PRINT',” COUNT DOWN FROM FIRST VALUE ENTERED TO INCORRECT VALUE?“ PRINT-s“ TYPE IN POSITION OF INCORRECT VALUE AND CORRECT VALUE' PRINT‘p” CA SAN! LINE SEPARATED BY A CONRA" READ*,INCOR,OKCOR PRINT 359INCOROOKCOR PORrArto OBSERVATION t,I3,- HAS BEEN CHANGED TO 'oFTO.S) PRI‘T'," Is THIS TNE CORRECT CHANGE?“ READ',NV IF(NV.EO.C)GO TD 31 PRINTO," ARE TNERC ANY OTHER CHANCES?“ REAO',NY IFtWV.£O.1)GO TO 31 URIIECTO'AIANINPUTINJOI)QNJITQNTOBS) CONTINUE GO TO 32 READ(1,*)((AHINPUTIJ,I),JI1,NTOBS),I!1,NVARS) PRINT 33oNVARSeNTOBS FORPAT('ODATA HAS BEEN READ IN FOR ‘,IZ,A VARIABLESo',I3, ‘9 OBSERVATIONS PER VARIABLE.) J31 DO 10 I'1eNVAR5 PRINT 5,I,APINPUT(J,I) EORFATIROFIRSI OBSERVATION VARIABLE 'pIZo' 8P,F19.Z) PRINT 6;I,APINPUT(NTOBS'I) FONFRIIP LAST OBSERVATION VARIABLE *OIZO' 8'.F1D.2) JET ‘ CONTINUE ' ESTIMATES OF PEAN, STD. DEV., 3RD, 6TH ”OPEVTS 8 CORRELATIONS dru 16 17 19 REHINDT unuroes-z DO 1 I81,NVARS READ(1,9)(VTENP(II),IIs1,2) DU 2 J'ION REAO(1,-)AIINPUT(J,I) CONTINUE CONTINUE CALL BeretIANINPUT.N.WVARS.62.VIEFP.anFENT.VCVU.INCO.IERI Pirate," ' CALL USUSFI18NCORRELATION EATRIX,TE,VCVU,NVARS,Z) IF(IBUC.EO.1)FRINT',IER,' SUBROUTINE: BENPI' DU 15 I'IOHVARS PRINT 16.I.VTEFP(I) PORFAT('OVARIABLE',IZ,' ARITN'ETIC ‘EAN 8*,T3S,F8.3) PRINT 17,annEn1(1,I) FORPAII- c.12x.oSTAWOAeo DEV. av.735.rto.$1 cvaxnonenrt1,r)IvtENPtIJA100. PRINT 15,cv FOReArtc t,1zx,oc05rr. VAR. (PCT) ..,r3s,;3.3) PRINT 19.XFOWENT(2.I1 FORPAI(A ',12x,'THIRD POPENT 8*,T35,F10.S) Table 3. 2? 15 65 (continued) PRINT ZO,XRUHENT(3,I) FURFATC* ',TZX,'PUURTN HOHENT 3',T3$,FTC.5) CONTINUE HPITEC3O')(CAPINPUT(J9I)OJ'19NIQI'1QNVARS) REHINO! REAC(3,')(CAPINPUTCJ,I),J|1,NYQOES),I31,”N) CALL BEPNI(APINPUT,NYROBSINN,6Z,VTEHP,XNOPE”T,VCVU,INCD,IER) IFCIBUE.EO.1)PRINT'oIEPo' SUBROUTINE: BEPNI' PRINT',” ” IFCIFLAG.EO.1)CALL USUSNCTEHCORPELATION PATRIX,18,VCVU,NN,Z) UVCVU‘(NNP(NN*1)/Z) IVNBRCTI3NN Ivnaa(2)s~vnoas IVNER(3)-NY!OES IVNBRCA):T IVNBRC6)'° CALL BECOVPCANINPUT,52.IVNER,VTEFP,V'EANS,VCVU,IER) IF