Chapter 10 Balance Sheet Analysis

Highlights

• Balance sheet analysis is the most important tool for fundamentals-based price forecasting.
• This chapter covers the format all balance sheets take, and introduces the USDA WASDE balance sheet.
• This chapter shows what affects each row of the balance sheet.
• This chapter provides a timeline of when the rows of a balance sheet can be updated.

• Do you know which cells in the balance sheet must be estimated by the USDA and which can be calculated from other cells in the table?

Fundamental analysis is an assessment of price based on underlying supply and demand factors. Focusing on changes in the relationship between supply and demand allows one to calibrate an informed opinion of the value of the commodity. The main role of the market is to find the value at which supply equals demand - or in other words, the value that ‘clears the market.’ The estimated ‘fundamental value’ is simply a forecast, or expectation of, the market clearing price. The goal of any forecasting exercise is to compare the forecast (estimated fundamental value) to the current market price and make decisions accordingly.

If your forecast is above the current market price, that is bullish because your forecast implies the market is undervaluing the commodity - an opportunity to buy low and sell high! If your forecast is below the current market price, that is bearish because your forecast implies the market is overvaluing the commodity - an opportunity to sell high and buy low! This, of course, only works if your forecast is correct, that is, the market eventually agrees and moves into line with your forecast.

10.1 Supply and Demand

Conducting fundamental analyses involves taking into account all the factors that determine supply, demand, and ultimately, prices. For grain markets there are basically two supply models to keep in mind: preplanting and post planting. Below we display both.

The intuition here is simply that before planting, the final supply for the crop can be affected by farmers changing their intentions about how many acres to plant. Once the crop has been planted, supply is essentially fixed, except for the uncertainty that remains due to realized yields. To summarize, things that affect the supply of a commodity are outlined below.

Supply is Affected by:

• Acreage

• Prices of crops competing for acreage
• Pre-Plant Weather
• Yield

• Post-Plant Weather
• Government Policies

Acreage

Before planting, farmers plan how much acreage to devote to each commodity, thus determining the baseline expected production level. Before summer weather is revealed, expected production is simply Acreage X Trend Yield. In the Corn Belt, where planting decisions amount to deciding how to divide acres between corn and soybeans, their relative prices play a large role in the farmer’s decision. If futures prices indicate planting soybeans will be more profitable than planting corn, farmers will plan to devote more acres than usual to soybeans, for example. Weather can be an important determinant of acreage decisions as well. The most ardent planting intentions of a farmer can be derailed by persistent wet weather. An unusually rainy planting season can reduce planted acres from intentions. Before the crop is actually in the ground, the supply of grain is relatively elastic.

Yield

After the crop is planted supply is quite inelastic, but there is still considerable uncertainty related to how much the crop will yield; this is largely determined by weather during the growing season.

Government Policies

The government has been heavily involved in Agriculture in the United States since the great depression of the 1930’s. There have been programs that guarantee a minimum price, programs that guarantee minimum revenue, and various incarnations of crop insurance programs. Occasionally these favor the production of one type of crop over another. When this happens, farmers predictably respond by planting more of the crop treated more favorably by the program.

Demand is Affected by:

• Consumer Income
• Exchange Rates
Consumer Income

This one is straight from economics 101. When people have more money, they will spend it on goods. This means increased demand for commodities and their derived products. This includes foreign income, since exports are a big component of demand for commodities in the United States. Rising incomes usually means rising consumption of meat, which increases the demand for commodities like corn, soybeans, and even wheat that are used as animal feed.

Exchange Rates

Exchange rates also affect demand through their influence on exports. For example, if the U.S. dollar is weak, then consumers in other countries can buy dollars cheaply - giving them more purchasing power for goods denominated in dollars.

10.2 Balance Sheet

Most fundamental analyses rely on maintaining balance sheets of a commodity for a country, region, or the world. The approach is to maintain a careful accounting of how much supply exists and how much of the commodity has been used. Then through various means we will explore later, one arrives at a price that is expected to ration remaining supplies across competing uses.

10.2.1 The Marketing Year and Balance Sheet Forecasting Schedule

Balance sheet analysis is often organized by marketing year. Since production happens once per year, the marketing year is defined to begin in the first month the commodity is harvested and ends with the following year’s harvest. The table below makes note the month on which marketing years begin for several crops.

Table 1. Beginning of Marketing Year by Crop. (Source NASS Timetables)
Crop Beginning of Marketing Year - First Month of Harvest
Corn September
Soybeans September
Spring Wheat (Chicago) August
Winter Wheat (KC) July

Forecasting supply and demand for any given marketing year begins well before harvest - nearly a year in advance, in fact. Table 2 below follows the typical forecasting schedule with the 2017/2018 marketing year. Note that is for the marketing year that begins with harvest in September of 2016.

Table 2: Forecasting Calendar for 2017/2018 Marketing Year
Timeline Forecasting Focus
Fall 2016 The first forecasts of supply and use based on , trend forecasts, recent history, economic relationships
Spring 2017 Update supply forecasts based on USDA acreage surveys.
Summer 2017 Update supply forecasts based on weather and USDA crop and stocks reports
Fall 2017 Update supply forecasts as yield uncertainty is resolved through harvest reports and USDA production reports
- Summer 2018 Continue to update supply forecasts based on USDA production revisions, southern hemisphere production, stocks, and use reports.

10.2.2 Southern Hemisphere Production

Production of corn, soybeans, and other commodities in the southern hemisphere (most notably in Brazil and Argentina) has grown rapidly over the last ten to fifteen years, and has impacted global commodity markets tremendously. Since southern hemisphere production occurs in the middle of marketing years organized by northern hemisphere harvest, there is an uncertain additional supply that must be forecast and updated to keep an accurate global balance sheet.

10.2.3 Uncertainty

Even careful accounting of supply and demand factors that make up the balance sheet leaves a tremendous amount of uncertainty in the market. Demand can be difficult to forecast, and can sometimes change dramatically. The USDA keeps careful track of stocks, but we only get stocks estimates once a quarter. Between Grain Stocks reports there is always a great deal of speculation as to the pace of consumption and whether we are eating into stocks at a faster or slower pace than expected. Analysts talk about whether the market is on pace to achieve the forecast level of ethanol crush, soybean crush, or exports. Surprises in any of these components can lead to rapid corrections in the commodity markets.

10.2.4 Balance Sheet Format

Here we discuss the common format balance sheets for any commodity have in common. Then we talk about the components of specific balance sheets for corn and soybeans.

Table 3. Balance Sheet for a General Commodity
Stocks and Use
Beginning Stocks
+ Production
+ Imports
= Total Supply
Domestic Consumption
+ Exports
+ Residual
= Total Consumption (Use)
Ending Stocks = Total Supply - Total Consumption

Since the USDA makes regular reports on the balance sheet for commodities (the WASDE reports described in Chapter 2), most conducing private analyses with balance sheets use the USDA categories so that the USDA estimates can be taken as a benchmark. The supply side (Stocks) is relatively straightforward. Total stocks for the marketing year will be beginning stocks, the portion of last year’s stocks that were not used up during the previous marketing year, plus this year’s production, plus any imports of the commodity. Summing these three reveals the total amount of the commodity available for use during the marketing year.

• Beginning Stocks: Some production from the previous year usually remains into the next crop season. Carryover stocks function as a buffer against current year yield uncertainty. For example, if carryover stocks are high and current year yield is expected to be below trend, the market price may fall in response but modestly. However, if carryover stocks are low - resulting from several years of below trend production and strong demand - then an expected yield below trend will likely cause a volatile rise in prices.

: Table 4. Recent USDA WASDE Balance Sheet for Corn

## Response [https://downloads.usda.library.cornell.edu/usda-esmis/files/3t945q76s/dv140m16d/jm215h19t/latest.xls]
##   Date: 2022-02-16 02:01
##   Status: 200
##   Content-Type: application/vnd.ms-excel
##   Size: 326 kB
## <ON DISK>  C:\Users\mindy\AppData\Local\Temp\RtmpaQaak6\file518c5d1b5d63.xls
CORN 2018/19 2019/20 Est. 2020/21 Proj. Prev 2020/21 Proj.
Million Acres
Area Planted 88.90 89.70 90.8 90.8
Area Harvested 81.30 81.30 82.5 82.5
Bushels
Yield per Harvested Acre 176.40 167.50 172.0 172.0
Million Bushels
Beginning Stocks 2140.00 2221.00 1919.0 1919.0
Production 14340.00 13620.00 14182.0 14182.0
Imports 28.00 42.00 25.0 25.0
Supply, Total 16509.00 15883.00 16127.0 16127.0
Feed and Residual 5429.00 5903.00 5650.0 5650.0
Food, Seed & Industrial 2/ 6793.00 6282.00 6375.0 6375.0
Ethanol & by-products 3/ 5378.00 4852.00 4950.0 4950.0
Domestic, Total 12222.00 12185.00 12025.0 12025.0
Exports 2066.00 1778.00 2550.0 2600.0
Use, Total 14288.00 13963.00 14575.0 14625.0
Ending Stocks 2221.00 1919.00 1552.0 1502.0
Avg. Farm Price ($/bu) 4/ 3.61 3.56 4.2 4.3 (source: February 2021 USDA WASDE Report) The balance sheet for corn follows the same generic patter, but we can be a bit more specific with the use categories since we know what the major use categories are for any given commodity. The use components are as follows: • Feed and Residual: A large portion of the corn crop is used as feed for livestock (cattle, pigs, poultry). • Food, Seed, and Industrial: Corn is used to make tortilla chips, high fructose corn syrup, edible oil and other food items. A portion of the crop is grown specifically as seed for the next years crop. There are some industrial uses for components of processed corn. Those are grouped in this category as well. • Ethanol production also demands a significant amount of corn, so much that it gets its own line in the balance sheet. Note, however, that it is technically part of the Food, Seed, and Industrial category. • The final use category is export. Corn grown in the United States is consumed around the globe, and strength or weakness in the export market is a carefully component of demand. : Table 5. Recent USDA WASDE Balance Sheet for Soybeans SOYBEANS 2018/19 2019/20 Est. 2020/21 Proj. Prev 2020/21 Proj. Million Acres Area Planted 89.20 76.10 83.10 83.10 Area Harvested 87.60 74.90 82.30 82.30 Bushels Yield per Harvested Acre 50.60 47.40 50.20 50.20 Million Bushels Beginning Stocks 438.00 909.00 525.00 525.00 Production 4428.00 3552.00 4135.00 4135.00 Imports 14.00 15.00 35.00 35.00 Supply, Total 4880.00 4476.00 4695.00 4695.00 Crushings 2092.00 2165.00 2200.00 2200.00 Exports 1752.00 1682.00 2230.00 2250.00 Seed 88.00 96.00 103.00 103.00 Residual 39.00 9.00 22.00 22.00 Use, Total 3971.00 3952.00 4555.00 4575.00 Ending Stocks 909.00 525.00 140.00 120.00 Avg. Farm Price ($/bu) 2/ 8.48 8.57 11.15 11.15
Total

(source: February 2021 USDA WASDE Report)

For soybeans, stocks are comprised of beginning stocks, production, and imports, just as they were for the general balance sheet and the corn balance sheet. The use side, contains items specific to soybeans:

• Crush: The amount of raw soybeans that are processed into soybean oil and soybean meal. Soybean oil is used predominately as edible oil; it also is used to make bio-diesel in modest quantities.
• Food, Seed, and Industrial: We saw this category in the corn balance sheet. The definition remains the same.
• Exports: The United States exports a large quantity of soybeans to global buyers.

10.3 Coming up with a Price

Balance sheet forecasting is definitely as much art as it is science. It involves keeping track of the rate of use of commodities to see how much a need there will be to ration late in the marketing year while waiting on harvest and new supplies. One should intuitively see that the forecasted ending stocks is a measure of scarcity of the commodity and therefore should be negatively related to price (i.e., tight ending stocks go along with high prices). One needs to pin down the exact nature of this relationship in order to form a meaningful forecast of price from a commodity balance sheet. We will discuss this process in more detail in a later chapter.

Balance Sheet Projections for the 2015-16 Corn Marketing Year

This farmdoc daily article was written in February of 2015. This is well before spring planting of corn and soybeans in the United States. However, farmers during this time are actively planning for planting season - prepping equipment, fertilizing and preparing ground, and buying seed. Good lays out the groundwork for early forecasts of the 2015/2016 marketing year balance sheet. This article is published two days before the February 2015 WASDE report, and Good provides context upon which market expectations for the WASDE report can be based upon.

Good, D. “Balance Sheet Projections for the 2015-16 Corn Marketing Year.” farmdoc daily (5):23, Department of Agricultural and Consumer Economics, University of Illinois at Urbana-Champaign, February 9, 2015.

Projecting the 2015-16 Corn Balance Sheet and Price Implications

In this reading Good and Irwin break down the USDA’s April 9th WASDE report and offer their own projections that differ slightly from the USDA’s projection that came out a week earlier. Pay close attention to why their price estimate is higher than the USDA’s.

Good, D., and S. Irwin. “Projecting the 2015-16 Corn Balance Sheet and Price Implications.” farmdoc daily (5):70, Department of Agricultural and Consumer Economics, University of Illinois at Urbana-Champaign, April 16, 2015.

10.5 Exercises

1. Copy and paste the corn and soybeans balance sheets into a spreadsheet.

• In the cell next to = Total Supply, manually add the cells needed to reproduce the ‘=Total Supply’ number.
• in the cell next to = Total Consumption, manually add the cells needed to reproduce the = Total Consumption number.
2. If you were making a forecast in July 2015 for the 2014/2015 marketing year balance sheet, which columns (if any) should remain fixed? I.e., they are already determined and do not need to be forecast.

3. If you were making a forecast in July 2015 for the 2015/2016 marketing year balance sheet, which columns (if any) should remain fixed?