Onion Production, Packing, and Storage Feasibility on the Navajo Indian Irrigation Project


RR-769
Nate Lee, Constance L. Falk and William Gorman
College of Agricultural, Consumer and Environmental Sciences, New Mexico State University


Authors: Respectively, Analyst, MetLife Agricultural Investments, Overland Park, KS; Professor, Department of Agricultural Economics and Agricultural Business, New Mexico State University (MSC 3169, Box 30003, Las Cruces, NM 88003, 575-646-4731, cfalk@nmsu.edu); and College Professor, Department of Agricultural Economics and Agricultural Business, New Mexico State University. (Print Friendly PDF)

Abstract

The purpose of this study was to assess the feasibility of a 1,200-acre onion production, packing, and storage enterprise on the Navajo Indian Irrigation Project (NIIP) in Northern New Mexico. Three approaches were used to assess the project: a deterministic financial feasibility model, discounted cash flow and ratio analyses, and a risk analysis involving stochastic prices and yields. The project appears to be financially feasible for the NIIP. Profitability ratios exceeded industry standards, the project net present value (NPV) was $3,173,286, and the internal rate of return (IRR) was 25.9% over a 25-year project life. A medium level of risk was found in the stochastic simulation model, but adequate returns to investors can be expected in the long run.

Introduction

The Navajo Indian Irrigation Project (NIIP) consists of 110,630 acres, encompassing approximately 70,000 acres of irrigated farmland located in northwestern New Mexico. In 2004, the NIIP was composed of eight blocks, each ranging in size from 7,000 to 9,000 acres of irrigated farmland. Historically, there has been interest in diversifying into onions at NIIP.

Ogaz (1971) identified fresh dry onions as an “enterprise shown to be economically feasible” for production in northwestern New Mexico. Further studies (Gorman et al., 1972; Gorman et al., 1973; Sweetser et al., 1976; Gorman et al., 1985) identified fresh dry onions as one crop with the agronomic and economic potential to be successfully grown and marketed on the NIIP. Recent studies (U.S. Department of Interior, Bureau of Indian Affairs [USDI-BIA], 2000; USDI-BIA, 2002) focused on identifying high value crops with the potential to be profitable. Onions were cited as a crop with the potential to be profitable.

The purpose of this study was to assess the feasibility of onion production, packing, and storage on the NIIP in northwestern New Mexico. This paper focuses on the results of both deterministic and stochastic financial analyses. Detailed explanations of onion price movements, supply and demand conditions, competing onion-producing regions, farming procedures and farm production costs, storage requirements, and packing house steps are discussed in Lee (2006).

The general assumptions of the project were:

  • Potential markets for NIIP were east of New Mexico, and trucks were used for shipping.
  • Principal competitor production regions were in California, Colorado, Idaho, Oregon, and Washington.
  • Historical North and Northeast Colorado prices could be used for NIIP onions.
  • NIIP would employ management capable of growing onions of commercial quality.
  • The increased production would not adversely affect prices of red, white, and yellow onions over the marketing period.
  • An outside broker for onion sales would be used, the marketing period would be from August to December, and both fresh and storage onions would be sold.
  • Adequate packing and storage facilities would be built and would be made available in all years of commercial production.
  • The onion planting would be 1,200 acres, to include 400 acres of red, 100 acres of white, and 700 acres of yellow onions.
  • Grade number one onions in medium, jumbo, and colossal sizes would be sold. Medium are 2 1/4 to 3 1/4 in., jumbo are 3 in. and up, and colossal are 3 3/4 in. and up.
  • Onions would be rotated with crops such as potatoes, small grains, alfalfa, corn, and beans in several of the many fields on the NIIP.
  • The onion packing facility would be 40,000 square feet and located along a state highway midway between the two major NIIP production regions.

Methodology

Field Production and Packing Shed Models

Onion production costs were estimated using a revised version of the Microcomputer Crop Cost and Return Generator developed at New Mexico State University (NMSU) (Sullivan et al., 1986). Farm machinery and equipment were included in the farming cost estimates for tillage, planting, crop maintenance, and harvesting equipment (Lee, 2006).

The procedures used to prepare an onion packing facility and storage budget were (1) determining the post-harvest handling flow procedures involved; (2) determining storage provisions, capital requirements, and operating cost; (3) applying relevant cost assumptions to express per 50-lb sack inputs and yields in monetary values; (4) applying the assumed physical quantities and factors per 50-lb sack; (5) summing fixed and variable costs to obtain total costs of storage and packing per 50-lb sack; and (6) applying relevant price assumptions per 50-lb sack.

Packing and storage machinery and equipment included in the analysis were a bin piler, receiving bins, finish toppers, and onion-sorting line with boxing and bagging. Also included were design costs and transport and setup. The onion-sorting line was assumed to handle (1) all pack sizes from pre-packs to super colossal; (2) packing in 25-lb and 50-lb bags and 25-lb, 40-lb, and 50-lb cardboard boxes; and (3) a throughput of 2,500 fifty-pound bags per hour. A subset of these capacities was modeled in this analysis.

Guenthner (1999) and Patterson (2002) employed engineering-cost methods to derive potato storage operating and ownership cost estimates. Many firms that supply, design, and manufacture potato storage also serve the onion industry. An engineering-cost method was used here, and also included labor and supervision costs, energy usage factors (Hancock & Epperson, 1990; Hanney & Bishop, 2005), and shrink losses (Boyhan et al., 2001; Patterson, 2002; Wilson & Estes, 1992).

Financial outcomes of onion packing and storage were modeled using a modified version of the spreadsheet add-in The Packing Simulation Model (PACKSIM; Schatzer et al., 1990). A stochastic financial planning model was then developed that combined the Microcomputer Crop Cost and Return Generator results and PACKSIM.

Ratio and Discounted Cash Flow Analyses

Nine key business ratios for the onion production, packing, and storage project based on the first and second years of operation were estimated. Five benchmark ratios based on Standard Industrial Classification (SIC) codes for specific industries were used to make comparisons (Dun & Bradstreet, Inc., 2004). The benchmark ratios used combined SIC0161 and SIC0723, since no benchmark exists for such an integrated operation.

The net present value (NPV) and internal rate of return (IRR) were estimated assuming 100% equity capital and a 25-year project life. The residual value was assumed to be the ending book value of the initial investment at year 25. Equipment replacements were assumed to take place at three- and six-year intervals throughout the project life and were based upon estimated trade-in values and wear-out life (Lazarus & Selley, 2005). The operating cash flows for each year were taken from the annual cash flow statements produced by the PACKSIM model.

Risk Modeling

Significant risk exists in projects such as this; price and yield in particular create uncertainty. Fixed or deterministic values, such as the mean price, can be replaced with probability distributions that describe a range of possibilities. Prices and yields were selected as the stochastic input variables for the risk model. To conduct the stochastic simulations, @Risk, a Microsoft Excel add-in, was used. Both Monte Carlo and Latin Hypercube sampling techniques are possible in @Risk, and Latin Hypercube was chosen to conduct the simulation (Palisade Corporation, 2000). Latin Hypercube is more efficient than Monte Carlo because it requires fewer iterations to converge on true distributions and accurately represents low probability outcomes in simulation outputs (Palisade Corporation, 2000).

Price and Yield Assumptions

Price estimates for the PACKSIM model were based on Colorado prices, which reflect the most likely prices that the NIIP may receive for commercial production of onions, based on proximity. North Colorado and East Colorado freight on board (F.O.B.) shipping point price data for 1998 to 2003 were evaluated (U.S. Department of Agriculture, Federal-State Market News Service [FSMNS]). Deterministic prices were based on the mean across the years for the various colors and sizes of grade number one onions (Table 1).

Table 1. Monthly U.S. No. 1 Onion Prices and Distribution by Size Categories

Month Item Red White Yellow Red Yellow
    -------- Fresh market -------- ------Storage-----
August Colossal     20%    
    $7.89    
Jumbo 70% 40% 54%    
$7.47 $10.18 $6.24    
Medium 30% 6% 26%    
$5.31 $8.74 $6.24    
September Colossal     40%    
    $7.73    
Jumbo 70% 40% 50%    
$6.88 $9.71 $6.38    
Medium 30% 60% 10%    
$4.86 $8.57 $5.23    
October Colossal         40%
        $7.55
Jumbo       70% 60%
      $6.31 $6.19
Medium       30%  
      $4.47  
November Colossal         20%
        $7.82
Jumbo       70% 60%
      $6.45 $6.84
Medium       30% 20%
      $4.60 $5.14
December Colossal         20%
        $7.31
Jumbo       70% 54%
      $7.10 $6.91
Medium       30% 26%
      $4.82 $5.58

Probability distributions of selling prices were fit for each onion type, grade, and size based on the FSMNS North Colorado and East Colorado F.O.B. prices from 1998 to 2003 (Table 2). Distributions were selected using BestFit2, which is integrated into the @Risk software. Each selection was based on three goodness of fit statistical rankings: chi-squared, Kolmogorov-Smirnov, and Anderson-Darling.

Spearman Rank Correlation Coefficients were estimated to account for price behavior similarities among onion types and sizes between months. Several distribution functions were found to be best among prices. Therefore, this method was used because it is known as a “distribution-free” approach, as any types of distributions may be correlated (Palisade Corporation, 2000).

The first year mean yield for yellow onions was determined by fitting probability distributions to historical yellow onion data and the rankings based on the three goodness-of-fit statistics. White onion yields were represented by a triangular distribution due to limited historical yield data. Historical yields for red onions were not available, so no stochastic distributions were estimated (Table 2).

Table 2. Stochastic Input Variables and Data Sources

Data
series
Size Color

Fresh or storage

Distribution Property functions Historical data source
Yield   White F Trian (290, 676, 676) * NAPI historical
Yield   Yellow F Loglogistic (123.4, 166.22, 1.8708) yields NAPI historical
Yield   White S Trian (290, 676, 676) yields NAPI historical
Yield   White S Loglogistic (123.4, 166.22, 1.8708) yields NAPI historical
Price Colossal Yellow F Invgauss (2.1767, 2.8772, Shift(6.0733), Corrmat(NewMatrix,1)) FSMNS weekly prices, 1997-2003
Price Jumbo Red F Normal (7.7857, 1.3569, Corrmat(NewMatrix,2)) "
Price Jumbo White F Loglogistic (8.004, 2.0805, 2.1237, Corrmat(NewMatrix,3)) "
Price Jumbo Yellow F Normal (6.5, 0.7964, Corrmat(NewMatrix,4)) "
Price Medium Red F Extvalue (5.21292, 0.56845, Corrmat(NewMatrix,5)) "
Price Medium White F Loglogistic (6.8261, 1.771, 2.1374, Corrmat,6) "
Price Medium Yellow F Uniform (4.8889, 8.1111, Corrmat(NewMatrix,7)) "
Price Colossal Yellow F Loglogistic (5.3199, 2.4497, 3.3726, Corrmat(NewMatrix,8)) "
Price Jumbo Red F Normal (7.1731, 1.1017, Corrmat(NewMatrix,9)) "
Price Jumbo White F Expon (1.6923, Shift(8.4349), Corrmat(NewMatrix,10)) "
Price Jumbo Yellow F Invgauss (4.5223, 106.5519, Shift(2.1315), Corrmat,11) "
Price Medium Red F Extvalue (4.86062, 0.35494, Corrmat(NewMatrix,12)) "
Price Medium White F Expon (1.5, Shift(7.4423), Corrmat(NewMatrix,13)) "
Price Medium Yellow F Expon (0.73077, Shift(4.72189), Corrmat(NewMatrix,14)) "
Price Colossal Yellow S Logistic (7.87268, 0.90302, Corrmat(NewMatrix,15)) "
Price Jumbo Red S Invgauss (1.6282, 5.2045, Shift(4.9487), Corrmat(NewMatrix,16)) "
Price Jumbo Yellow S Logistic (6.46798, 0.78204, Corrmat(New Matrix,17)) "
Price Medium Red S Extvalue (4.46239, 0.33704, Corrmat(NewMatrix,18)) "
Price Colossal Yellow S Extvalue (7.1011, 2.04494, Corrmat(NewMatrix,19)) "
Price Jumbo Red S Invgauss (1.7836, 4.1858, Shift(4.9472),Corrmat(NewMatrix,20)) "
Price Jumbo Yellow S Uniform (3.48, 10.77, Corrmat(NewMatrix,21)) "
Price Medium Red S Normal (4.79808, 0.54781, Corrmat(NewMatrix,22)) "
Price Medium Yellow S Logistic (5.37134, 0.6691, Corrmat(NewMatrix,23)) "
Price Colossal Yellow S Invgauss (19.861, 1567.094, Shift(-11.537), Corrmat(NewMatrix,24)) "
Price Jumbo Red S Logistic (7.49202, 0.83074, Corrmat(NewMatrix,25)) "
Price Jumbo Yellow S Logistic (0.97298, 5.9654, 4.4892, Corrmat(NewMatrix,26)) "
Price Medium Red S Logistic (5.02328, 0.40313, Corrmat(NewMatrix,27)) "
Price Medium Yellow S Logistic (5.84232, 0.80341, Corrmat(NewMatrix,28)) "
*Navajo Agricultural Products Industry

Additional PACKSIM Model Assumptions

The assumptions that follow were adjusted for latter years of the discounted cash flow analysis. For simplicity, only the assumptions for the first year are presented here.

Product Mix

The product mix assumptions included six onion crop types: three colors of fresh-packed onions and three colors of storage onions (Table 3). Yields per acre, pounds per bag, number of acres, and the percentage of each crop sold each month were specified and used to calculate total volumes, as measured in 50-lb bags, and the percentage of each crop’s share of the total. This percentage share was used to allocate overhead costs among the six onion types.

Table 3. Product Mix for 50-lb Bags

Crop Red White Yellow Red Yellow Totals
  -------- Fresh market ----- ---- Storage -----  

Yield (bags per acre)

576 547 405 576 405  
Acres (#) 200 100 350 200 350 1,200
Total bags (#) 115,200 54,733 141,638 115,200 141,638 568,409
Total weight (million lb) 5.76 2.74 7.08 5.76 7.08 28.420
Portion of total weight (%) 20.3 9.6 24.9 20.3 24.9 100.0
  ---------- Distribution of monthly sales (%) ------------
August 75.0 50.0 50.0      
September 25.0 50.0 50.0      
October       25.0 20.0  
November       25.0 40.0  
December       50.0 40.0  

Labor Requirements

The base wage rate of $8.50/hour together with social security, workers’ compensation taxes, and unemployment insurance resulted in a total wage rate for each employee class of $9.71/hour, except forklift operators, whose hourly rate including burden was $11.42.

Total labor costs were estimated based on percent packed, hourly pack-out, percent capacity, and the number of workers at each stage of the packing process (Table 4). The percent packed is the percent of harvested onions and storage onions that are actually packed, and accounts for onions that are culled or are rejected at the packing facility. The hourly pack-out is the number of 50-lb bags per hour that the packing line is designed to handle at peak efficiency. The percent capacity determines the level of capacity achieved. When packing capacity is less than 100%, additional labor costs for idle time would be incurred. The number of workers per labor category estimates personnel needed to achieve the hourly pack-out rate specified.

Table 4. Labor Requirements

Crop Red White Yellow Red White Yellow
  --- Fresh market --- -------- Storage -------

Percent packed (%)

92 92 92 88 88 88
Hourly pack-out (in bags) 2,500 2,500 2,500 2,500 2,500 2,500
Percent capacity (%) 75 75 75 75 75 75
Actual packed per hour (bags) 1,875 1,875 1,875 1,875 1,875 1,875
Labor category
Packing facility labor ------------------- Workers (#) ---------------
Regular 43 43 43 43 43 43
Forklift 3 3 3 3 3 3
Labor charged to rejected crates only
Send to waste 2 2 2 2 2 2
Total per hour 48 48 48 48 48 48

Material Costs

Material costs included items such as bags, plastic wrap, pallets, raw product, and the cost of storage (Table 5). Although the model allowed farmer payments for the raw product to be estimated as a residual from packing, in this study, farmer payments were assumed to be a direct material cost. The cost of storage was a four-month average of the operating cost, which was only allocated to the three storage onions.

Table 5. Material Costs

Material Red White Yellow Red Yellow
  ----------- Fresh ---------- ---- Market Storage --
  --------------------- $ per bag ----------------------

Bags

0.25 0.25 0.25 0.25 0.25
Wrap 0.03 0.03 0.03 0.03 0.03
Pallets 0.14 0.14 0.14 0.14 0.14
Storage       0.11 0.11
Onions (production cost) 2.85 2.47 2.37 2.85 2.37
Total per bag 3.27 2.89 2.79 3.37 2.90

General Operating, Fixed, and Financial Expenses and Assumptions

Monthly general expenses included utilities, insurance, rentals, marketing commission, supplies, phone, tools, rodent control, professional services, fuel, and other expenses. These expenses were allocated to each of the six onion types based on the percentage of the total volume handled.

The cost of insurance, repair, and maintenance on buildings and equipment was considered fixed overhead (Table 6). Other fixed expenses included annual salaries for non-hourly employees. Financial assumptions also included minimum monthly cash balance, interest rates on operating loan and cash balance, depreciation schedules, and income tax status.

Table 6. Fixed Overhead and Miscellaneous Financial Inputs

Annual maintenance and repairs on buildings ($/year) 3,000.00

Annual maintenance and repair on mach. and equipment (% of investment)

2.00
Annual administrative salaries ($)
Salesperson (half time) 27,625.00
Fresh pack manager (processing) 67,600.00
Secretary (half time) 12,168.00
Miscellaneous financial data
Minimum monthly cash balance ($) 5,000.00
Interest rate paid on operating loan (monthly %) 0.17
Interest rate received on cash balance (monthly %) 0.08
Depreciation schedule Years
Plant equipment 10
Packing building 25
Storage building 15
Office equipment 10
Farm equipment 10
Income tax status Exempt

Initial minimum equity was assumed to be 60% of the total investment and the remainder borrowed. The equipment and building loans were assumed to have been obtained prior to the first year of operation. The initial startup period, year zero, was dedicated to the construction of facilities and purchase of equipment and would include some depreciation on assets and interest expense on borrowed funds. The working capital loan included payment of principal and interest on equipment and building loans, separate from the operating loan. An operating loan kicked in if the cash position dropped below the specified cash minimum of $5,000 during the operating year. When the cash position exceeded the specified cash minimum, the operating loan balance, starting with outstanding interest, was paid down.

Results

Farm Production Costs

The direct production cost of growing the raw product was estimated at $1,889,745 annually, producing 793,525 50-lb sacks on 1,200 acres. This resulted in a unit cost of $2.38 per 50-lb sack (Lee, 2006). The cost estimates included allowances for labor, capital, and land. Farm production costs in competing states indicate that NIIP costs could be one of the highest (Table 7), in part due to lower yields, a situation that, if addressed, could decrease NIIP costs relative to competitors.

Table 7. Comparison of Production Costs: NIIP and Four Other States

  --------------------------- Region, Irrigation system ------------------------
  NIIP, Pivot CO-N, Gravity CO-W, Gravity WA, Pivot ID, Gravity MI, Unknown
Yield (sacks) 661.27 690.00 700.00 1,400.00 890.00 600.00

Production costs (per acre unless noted)

------------------------------------------$ --------------------------------------
Pre-harvest 879.40 563.91 516.10 1,667.55 1,212.57 988.00
Harvest 230.09 289.65 397.08 180.25 103.76 432.00
Other 465.27 248.29 208.48 792.11 588.86 457.00
Total cost of production 1,574.76 1,101.85 1,121.66 2,639.91 1,905.19 1,877.00
Total cost of production (per bag) 2.38 1.60 1.60 1.89 2.14 3.13

Capital Outlays

Suberizer, Inc., an engineering, manufacturing, and construction company that specializes in raw product storage, prepared a cost estimate for the proposed storage building. At 41,556 square feet, the design could accommodate the necessary system and included ventilation features to accomplish unloading/loading and long-term bulk storage. The total investment in storage facilities with a 648,720-bushel capacity in eight bays was $3,477,242 (Table 8), amounting to approximately $41.84 per square foot or $5.36 per bushel. The equipment and facilities were expected to have a 25-year life and would take approximately 120 days to construct.

Table 8. Capital Investment in Production, Packing, and Storage

  Total ($)
Farm machinery and equipment 749,866
Packing and storage machinery and equipment 780,170
Packing and office building (40,000 ft²) 1,749,545
Storage facility (83,112 ft²) 3,477,242
Office 5,924
Vehicles, forklifts, and lift jacks 135,800
Total initial investment 6,898,547

Storage costs include operating and ownership costs and depend on the length of storage, interest rates, conditions at harvest, onion value at harvest, and shrink. Operating costs were directly incurred from storing onions and included labor to fill and empty the storage; power for heating/cooling, lights, and electric motors to unload and pile the onions; and shrink for a six-month storage period. Ownership costs included depreciation and interest on investment. Onion storage costs ranged from $0.49 per 50-lb bag to $0.91 per 50-lb bag over a six-month storage period (Table 9).

Table 9. Estimated Onion Storage Costs per 50-lb Bag

Months 1 2 3 4 5 6
  ------------------------------ $ -------------------------------
Operating costs
Labor 0.0912 0.0912 0.0912 0.0912 0.0912 0.0912
Supervision 0.0028 0.0028 0.0028 0.0028 0.0028 0.0028
Energy 0.0015 0.0029 0.0043 0.0057 0.0072 0.0086
Repair and maintenance 0.0100 0.0100 0.0100 0.0100 0.0100 0.0100
Other 0.0016 0.0016 0.0016 0.0017 0.0017 0.0017
Ownership costs
Depreciation 0.1822 0.1822 0.1822 0.1822 0.1822 0.1822
Interest 0.1195 0.1195 0.1195 0.1195 0.1195 0.1195
Other costs
Shrink 0.0827 0.1654 0.2481 0.3308 0.4134 0.4961
Total cost per bag 0.49 0.57 0.66 0.74 0.83 0.91

Direct storage and packing costs for all six onion types were estimated at $1,089,376 annually for 793,525 50-lb sacks. This resulted in a packing shed unit cost of $2.26 per 50-lb sack and $99.35 per acre (Table 10). Unit and per acre costs were also estimated for each onion type.

Thus, the capital cost of the production, packing, and storage facilities and associated equipment was estimated to be $6.9 million (Table 10). Building construction costs were estimated at $1,749,545, or $42.00 per square foot (S.L. Cooper, personal communication, 2006). The cost of a 648,720-bushel storage facility was $3,477,242, or $41.84 per square foot. The cost of office equipment, vehicles, forklifts, and lift jacks was also included as capital costs needed to operate the packing and storage facilities.

Table 10. Storage and Packing Costs for Different Onion Types on a 1,200-Acre Farm

  Red White Yellow Red Yellow
  ------------ Fresh market ------------- ------- Storage -----------
I. Variable costs
Packing facility labor 25,647.36 15,050.02 55,168.55 25,647.36 55,168.55
Labor charged to rejected bags only          
Send to waste          
Materials 44,568.01 26,152.76 95,867.65 53,531.03 115,147.47
Total variable costs 72,320.50 42,438.07 155,564.40 81,283.51 174,844.21
II. Fixed costs
Machinery 35,733.07 20,968.36 76,863.32 34,179.46 73,521.44
Building 67,197.34 39,431.77 144,544.28 64,275.72 138,259.75
Administrative
Supervisor 4,091.45 2,400.88 8,800.88 3,913.56 8,418.23
Foreman 10,012.02 5,875.11 21,536.26 9,576.71 20,599.90
Secretary 1,802.16 1,057.52 3,876.53 1,723.81 3,707.98
General expenses
Utilities 2,934.94 1,722.24 6,313.19 2,807.34 6,038.70
Insurance 4,828.28 2,833.26 10,385.83 4,618.35 9,934.27
Rental equipment 450.24 264.21 968.49 430.67 926.39
Marketing commission 26,496.00 15,548.00 56,994.00 25,344.00 54,516.00
Office, janitorial, postage supplies 365.82 214.67 786.90 349.92 752.69
Phone 562.81 330.26 1,210.62 538.34 1,157.98
Tools 177.73 104.29 382.30 170.00 365.68
Rodent control 177.73 104.29 382.30 170.00 365.68
Travel 296.21 73.82 637.17 283.33 609.46
Professional 2,665.92 1,564.38 5,734.51 2,550.01 5,485.18
Fuel 288.81 169.47 621.24 276.25 594.23
Interest on operating capital 3,263.46 1,915.02 7,019.84 3,121.57 6,714.63
Total fixed costs 161,344.00 94,677.55 347,057.66 154,329.04 331,968.20
Cost per acre 101.42 101.42 101.42 102.26 102.26
Variable cost (per bag) 0.68 0.68 0.68 0.80 0.80
Fixed cost (per bag) 1.52 1.52 1.52 1.52 1.52
Total cost (per bag) 2.20 2.20 2.20 2.32 2.32

Income Statement, Balance Sheet, and Cash Flow Statements

In year zero, the construction year, a net loss of $680,680 was estimated (Table 11). The project was estimated to yield a positive net income of $624,618 in the first year of operation, increasing to $1,478,234 in the second year, and gradually increasing to $1,839,517 by the tenth year of operation. The large increase in net income from year one to year two was the result of assumed yield increases in white and yellow onions. In year one, direct materials were the largest contributor to overall expenses, and included the cost of onion production and packing materials ($1,701,687). Depreciation expense ($404,033) and interest expense ($276,647) were the largest expense items.

In year zero, initial invested capital and carrying costs decreased owners' equity by $680,680, the loss recorded in the income statement. Because retained earnings in year one did not offset this decrease, year one ended with negative $56,062 in retained earnings. By year ten, retained earnings accumulated to $14,251,885 (Table 11).

In year zero, $7,352,773 in total cash outflows were required for purchases and initial capital costs (Table 11). These outflows were nearly offset by the sum of cash inflows from all borrowed funds and contributed capital. A working capital loan (Table 12) was used to cover the initial capital costs, but a cash shortage remained, creating the need for an operating loan of $10,730 (Table 11). Although the operating loan in year one reached a peak of $671,620 in the seventh month, the operating loan was paid off by the end of the year. Cash availability in years two through ten were sufficient to cover all cash costs, and no additional operating loans were needed. By the end of year ten, a positive cash balance of $15.4 million was estimated to accumulate.

Table 11. Key Financial Results from PACKSIM

  Year 0 Year 1 Year 10
  ----------------------- $ --------------------------
Income statement
Sales 0 3,497,869 4,945,214
Direct materials 0 1,701,687 2,225,178
Gross margin 0 1,518,420 2,388,024
Depreciation 404,033 404,033 258,105
Interest expense 276,647 277,246 22,378
Profits after taxes (680,680) 624,618 1,839,517
Balance sheet
Total assets 6,494,514 6,782,502 18,706,191
Total liabilities 3,036,066 2,699,435 315,177
Retained earnings (680,680) (56,062) 14,251,885
Total owner's equity 3,458,448 4,083,066 18,391,013
Cash flow
Beginning cash balance 4,139,128 0 13,743,283
Total inflows 7,345,716 3,036,275 18,688,496
Total outflows 7,352,473 2,789,012 3,240,242
Outstanding operating loan 10,730 0 0

Table 12. Summary of Loan Schedule

Item

Principal ($)

Annual rate(%)

Payments per year

Life in years Total periods

Interest per period (%)

Payment ($)

Farming, packing, and storage equipment 668,704 10.00 4 11 44 2.50 25,230
Packing and storage buildings 2,090,715 10.00 12 11 132 0.83 26,175
Working capital 447,169 8.00 12 1 12 0.67 38,899

Ratio and Discounted Cash Flow Analyses Results

The first year return on equity (ROE) of 15.30% was much lower than the Dun & Bradstreet benchmark of 24.80%, but in the second year, which is more representative of the projected annual ROE, it was 26.58% (Table 13). In general, an ROE above 10% is a desirable objective, capable of providing dividends to investors and funds for future growth. Therefore, first year ROE of 15.30% for this project may be adequate, despite the higher benchmark of 24.8%. Using the current ratio, it appears current assets could safely retire current liabilities at a rate of 2.81 to 1.0 in the first year and 7.83 to 1.0 in the second. The debt to equity ratio of 0.661 in year one was less than the benchmark of 0.987 and continued to decrease in year two.

Table 13. Key Financial Ratios

  Onion production, packing house, and storage *SIC 0161 Vegetable producers *SIC 0723 Crop prep services

Vegetable producers and crop prep services combined

Year 1 Year 2
Profitability ratios
Net profit margin on sales (%) 17.86 29.89 1.60 3.80 5.40
Return on total assets (%) 13.30 21.05 8.90 3.00 11.90
Return on equity (%) 15.30 26.58 18.70 6.10 24.80
Credit worthiness ratios
Current ratio (liquidity) 2.81 7.83 1.50 1.30 2.80
Debt ratio (leverage) 0.398 0.318      
Debt to equity ratio 0.661 0.466 0.594 1.38 0.987
Fixed charge coverage 3.253 7.218      
Activity ratios

Fixed assets turnover (times per year)

0.57 0.87      
*Standard Industrial Classification codes

The discounted cash flow (DCF) analysis resulted in an NPV of $3,173,286, using a discount rate of 17%. The IRR was 25.9% over a 25-year project life, taking into account the initial investment, residual value, and capital replacements (Table 14). The IRR was well above the discount rate of 17%.

Table 14. Discounted Cash Flow Analysis

Year

Investment: initial and residual

Net capital replacement Annual total cash flow
0 (6,898,547)   (6,898,547)
1     1,089,107
2     1,993,078
3   (55,631) 2,064,639
4     2,120,000
5     2,120,000
6   (966,856) 1,153,144
7     2,120,000
8     2,120,000
9   (55,631) 2,064,369
10     2,120,000
11     2,120,000
12   (966,856) 1,153,144
13     2,120,000
14     2,120,000
15   (55,631) 2,064,369
16     2,120,000
17     2,120,000
18   (966,856) 1,153,144
19     2,120,000
20     2,120,000
21   (55,631) 2,064,369
22     2,120,000
23     2,120,000
24   (966,856) 1,153,144
25 1,001,997   3,121,997
Net present value     $3,173,286
IRR     25.9%

Stochastic Model Results

In the first year of operation, there was a 52% probability that the project would not achieve sales of $2,181,109, the amount needed to break even (Table 15). There was a 22% probability that cash outflows would exceed inflows, and a 2% probability that profits before tax would fall below zero. If investors require that this project's return on investment exceed the cost of capital of 14%, there was a 64% probability that, in the first year of operation, this would not occur.

Table 15. Output Variable Statistics from @Risk Simulation

Name Breakeven sales Net sales Ending cash balance Profits before tax Return on assets
Minimum 1,836,725.00 2,492,578.00 5,000.00 (132,233.60) 0.02
Maximum 2,989,694.00 6,608,775.00 1,641,079.00 2,401,997.00 0.31
Mean 2,212,487.00 3,506,545.00 265,929.10 632,664.30 0.13
Std deviation 203,306.90 729,731.80 318,226.70 426,422.30 0.05
Skewness 0.86 1.62 1.97 1.39 0.84
Kurtosis 4.11 6.32 7.39 5.95 4.25
Mode 2,263,765.00 3,660,060.00 5,000.00 223,009.40 0.14
Target value 2,181,109.00   5,001.00   0.14
Target (%) 52%   22% 2% 64%

Profits were highly responsive to yellow onion yields (Figure 1). Additionally, profits were more sensitive to yellow and red onion prices than to white onion prices. The August yellow and red onion prices, as well as the December yellow and red onion prices, affected profit more than September and October. Lastly, 90% of the distribution of profits fell between $74,019 and $1,250,098 (Figure 1).

Fig. 1: Two graphs showing regression sensitivity and distribution of pre-tax profits.

Figure 1. Regression sensitivity and distribution of pre-tax profits

Summary and Conclusion

An onion production, packing, and storage enterprise based on 1,200 cultivated acres was evaluated, and the results indicate it should be financially feasible for the NIIP. The total investment for this project was nearly $7 million. Assuming a capital structure of 60% equity and 40% debt, credit worthiness ratios, short-term solvency, and leverage of this project exceeded industry standards. Current assets could safely retire current liabilities, and creditors can be assured their risk was equivalent to the owners'. By the second year of operation, the ROE was more than adequate to provide return to investors and funds for future growth.

As the key indicator of profitability, the return on assets (ROA) in year one of 13.3% was greater than the benchmark of 11.9%, but less than cost of capital of 17%. The second year ROA increased to 21.05%, exceeding the benchmark and the cost of capital.

The DCF analysis at 100% equity capital provided a better indication of the risk and expected return. The cash flows are projected to provide sufficient cash for operational needs, and based on a cost of capital of 17%, NPV and IRR indicated a very favorable outcome for this project. While the DCF evaluation accounted for riskiness of the project, simulation results provided some helpful insight into the uncertainty of price and yield and their effects on several outcome variables. The onion production, packing, and storage enterprise should be no more than a medium risk venture in the first year of operation. For example, in the first year the probability of cash outflows exceeding cash inflows was not very likely, and the probability of profits falling below zero was highly unlikely. While the simulation indicated a 64% probability that ROA would not exceed 14% in the first year of operation, with proper capitalization, the probability of any default becomes highly unlikely in the second year and beyond. The high probability associated with ROA may be offset by the added value to the raw commodity, meaning that if prices are low in a particular year, value added through packing and storage still compensates.

Marketing trends and consumption factors indicate increasing demand for onions; consequently, the market was assumed to be able to absorb the additional supply of onions without impacts on short-term prices. While the NIIP has a transportation advantage over West Coast competitors, the biggest challenge is to establish a reputation for providing high-quality onions on a consistent basis.

Limitations

Projections of the model were highly dependent on yield. Unfortunately limited historical data were available for yellow and white onions, and none were available for red onions. While very conservative yield estimates were used for this study, the projections should be interpreted with some caution.

The cost of production did not consider potential reduction in overhead due to mixed farming (both vegetable and non-vegetable), as most of the farm equipment used in vegetable production would also be used in production of other crops. The implications of such a proposal can have a substantial impact on the overall cost structure.

The study results relied upon the assumption of 60% equity capital. It remains to be determined whether or not there is financial capacity to build and operate the production, packing, and storage facility.

Good to superior management was assumed to be hired for onion-growing under center pivot irrigation and packing shed and storage management. The projections for this enterprise can be drastically altered if less than adequate management is implemented, which has implications for yields, labor costs, and other factors. At the time of this research, NIIP was considering adding onions to their production plans. Impacts of significant increases in petroleum costs were also not considered, but as the industrial food system reacts to peak oil and global warming challenges, such concerns would be expected to impact large-scale farming and far-flung distribution systems.

References

Boyhan, G., D. Granberry, & T. Kelley. 2001. Onion production guide, vegetable team production [Bulletin 1198]. Athens: University of Georgia Cooperative Extension Service.

Dun & Bradstreet, Inc. 2004. Industry norms & key business ratios. Short Hills, NJ: Dun & Bradstreet.

Gorman, W.D., R.R. Lansford, T.S. Clevenger, J.E. Williams, W. Trego, M. Burkett, E.J. Gregory, J.M. Jordan, R.K. Bull, H.H. Ogaz, N. Bowman, & P. Barnes. 1972. Alternative farm organizational structures for the Navajo Indian Irrigation Project: Projected cropping patterns, livestock enterprise, processing activities, capital requirements, employment, income, and training needs [Special Report 17]. Las Cruces: New Mexico State University Agricultural Experiment Station.

Gorman, W.D., T.S. Clevenger, R.R. Lansford, W.H. Trego, J.E. Williams, E.J. Gregory, J.M. Jordan, & H.H. Ogaz. 1973. Costs, returns, and capital requirements of selected crops for the Navajo Indian Irrigation Project [Research Report 256]. Las Cruces: New Mexico State University Agricultural Experiment Station.

Gorman, W.D., R.E. Grassberger, G.A. Welsh, R.R. Lansford, D.G. Kraenzel, T.S. Clevenger, & G.A. Baker. 1985. Information on marketing and expected yields, prices, costs, and returns for selected crops, Navajo Indian Irrigation Project [Special Report 63]. Las Cruces: New Mexico State University Agricultural Experiment Station.

Guenthner, J.F. 1999. Economics of storing potatoes. Paper presented at Idaho Potato School, Pocatello, ID. Available at http://www.cals.uidaho.edu/potato/Research&Extension/Topic/Marketing&Economics/EconomicsOfStoringPotatoes-99.pdf

Hancock, C.T., & J.E. Epperson. 1990. Temporal cost analysis of a new development in controlled atmosphere storage: The case of Vidalia onions. Journal of Food Distribution Research, 21, 65–67.

Hanney, S.J., & C.F.H. Bishop. 2005. Energy usage in UK onion (Allium cepa L.) storage. Acta Horticulturae, 682, 1,617–1,624.

Lazarus, W., & R. Selley. 2004. Farm machinery economic cost estimates for 2005. St. Paul: University of Minnesota Extension.

Lee, N. 2006. Feasibility of onion production, packing and storage on the Navajo Indian Irrigation Project. Unpublished master's thesis, New Mexico State University, Las Cruces.

Ogaz, H.H. 1971. Evaluation of alternative organizational structures for the Navajo Indian Irrigation Project. Unpublished master's thesis, New Mexico State University, Las Cruces.

Palisade Corporation. 2000. @Risk: Risk analysis and simulation add-in for Microsoft Excel, version 4. Newfield, NY: Author.

Patterson, P.E. 2002. Estimating cost of potato production in Idaho. Paper presented at Idaho Potato School, Pocatello, ID. Available at http://www.cals.uidaho.edu/potato/Research&Extension/Topic/Marketing&Economics/ EstimatingCostOfPotatoProductionInIdaho-02.pdf

Schatzer, R.J., C.L. Falk, & D.S. Tilley. 1990. User's manual for packing simulation model: Version two. Stillwater: Department of Agricultural Economics, Oklahoma State University.

Sullivan, R.P., M.J. Schaber, J.D. Libbin, & B.E. Mayberry. 1986. Microcomputer crop cost and return generator technical documentation [Bulletin 726]. Las Cruces: New Mexico State University Agricultural Experiment Station.

Sweetser, J.S., W.D. Gorman, R.R. Lansford, W.H. Trego, E.J. Gregory, & S. Hicks. 1976. Annual expenses, returns, and capital requirements of selected crops for the Navajo Indian Irrigation Project [Research Report 313]. Las Cruces: New Mexico State University Agricultural Experiment Station.

U.S. Department of Agriculture, Federal-State Market News Service. Marketing U.S. onions, Various issues, 1997-2003.

U.S. Department of Interior, Bureau of Indian Affairs. 2000. NAPI: Navajo agricultural assessment project 2000. Farmington, NM: Mid Kansas Agri Company.

U.S. Department of Interior, Bureau of Indian Affairs. 2002. Navajo Indian Irrigation Project financial feasibility assessment. Farmington, NM: Moon Peak Development, LLC.

Wilson, L., & W. Estes. 1992. Postharvest cooling and handling of onions [AG-413-06]. Greensboro: North Carolina State University Cooperative Extension Service.


¹This project was made possible with support from the New Mexico State University Agricultural Experiment Station.


To find more resources for your business, home, or family, visit the College of Agricultural, Consumer and Environmental Sciences on the World Wide Web at aces.nmsu.edu.

Brand names appearing in publications are for product identification purposes only. No endorsement is intended, nor is criticism implied of similar products not mentioned. Persons using such products assume responsibility for their use in accordance with current label directions of the manufacturer.

Contents of publications may be freely reproduced for educational purposes. All other rights reserved. For permission to use publications for other purposes, contact pubs@nmsu.edu or the authors listed on the publication.

New Mexico State University is an equal opportunity/affirmative action employer and educator. NMSU and the U.S. Department of Agriculture cooperating.

Printed and electronically distributed November 2009, Las Cruces, NM.