Return to Video

Agricultural Outlook Tools

  • 0:01 - 0:04
    RYAN: Well, thank you, Dr. Rood.
    This is a-
  • 0:04 - 0:07
    there's a lot going on
    in agriculture, as we all know, that's-
  • 0:08 - 0:10
    you know, we could
    spend quite a bit of time,
  • 0:10 - 0:14
    so with just our limited amount of time,
    Dr. Ward and I decided to
  • 0:14 - 0:19
    try and- try and take some- some
    information that we can gather,
  • 0:19 - 0:21
    and how does that translate
    to the producer level,
  • 0:21 - 0:24
    and what- what tools can we provide
  • 0:24 - 0:28
    Extension faculty with, producers with,
    that they may be able to start analyzing
  • 0:28 - 0:32
    some of these dramatic impacts
    that are- events that are happening
  • 0:32 - 0:33
    within agriculture right now.
  • 0:33 - 0:39
    So I'm going to start off with- with just
    sharing some- just some simple statistics,
  • 0:39 - 0:44
    some places that I look for information,
    some of the things that I watch.
  • 0:45 - 0:47
    When we look at- at-
  • 0:47 - 0:50
    at inflation, right,
    any time we turn on the news,
  • 0:50 - 0:54
    any time we look at anything on the-
    on the- on the Web right now,
  • 0:54 - 0:56
    I mean, inflation is- is a big thing.
  • 0:57 - 1:01
    President Biden was at a-
    was at a farm yesterday in Illinois
  • 1:01 - 1:02
    talking about inflation.
  • 1:02 - 1:05
    And this is a big deal
    for agriculture right now.
  • 1:05 - 1:08
    CPI, which is a basket
    consumer price index,
  • 1:08 - 1:11
    basket of goods that a consumer would buy,
  • 1:11 - 1:16
    right, we use that as a-
    a relative term of inflation.
  • 1:17 - 1:19
    And so you can see, right,
  • 1:20 - 1:24
    that past 2016, the 2020s,
    that dark red line,
  • 1:24 - 1:27
    2022 is that blue line, that-
    that darker blue line at top.
  • 1:27 - 1:32
    So we are- we're in a level of inflation
    we haven't seen for- for-
  • 1:32 - 1:35
    for many of our, you know,
  • 1:35 - 1:38
    for- for many years,
    30, 40 years for a lot of us.
  • 1:38 - 1:42
    And so this is- this is really
    impacting a lot of decisions
  • 1:43 - 1:45
    that- that are being made right now.
  • 1:45 - 1:49
    So this- this- this data comes from
    Livestock Marketing Information Center,
  • 1:49 - 1:50
    LMIC.
  • 1:50 - 1:57
    So for Extension fact, the LMIC is a
    great repository for all kinds of data.
  • 1:57 - 2:01
    This is one that I use all the time,
    Dr. Feuz uses all the time,
  • 2:01 - 2:04
    to- to gather data for- for a lot.
  • 2:04 - 2:07
    So this is a great,
    great resource that we use.
  • 2:07 - 2:11
    But you can see here that inflation is-
    is dramatically impacting,
  • 2:11 - 2:14
    at- at the consumer level
    and, as we'll show also,
  • 2:14 - 2:16
    at the- at the producer level.
  • 2:18 - 2:22
    This is- so let's look at this
    both from a global perspective
  • 2:22 - 2:26
    and from a- from a domestic
    U.S.-based perspective.
  • 2:26 - 2:30
    You can see here,
    natural gas, ammonia ba- main-
  • 2:30 - 2:32
    right, these are being used for
  • 2:32 - 2:35
    producing fertilizer,
    fuel, whatnot, right?
  • 2:35 - 2:39
    So you can see East Asia, Western Europe,
    we- we are complaining a lot
  • 2:39 - 2:43
    about the cost of natural gas,
    but you can see those impacts
  • 2:43 - 2:46
    that are being felt in- across-
    across the globe, right?
  • 2:46 - 2:49
    East Asia, Western Europe,
    really seeing that.
  • 2:49 - 2:51
    Now on the ammonia side, right?
  • 2:51 - 2:55
    We've- we've seen just a bigger
    run up on the ammonia side as-
  • 2:55 - 2:57
    as we have as other places in the world.
  • 2:57 - 3:02
    So this is what- a lot of the
    key drivers of fertilizer prices.
  • 3:02 - 3:07
    In the spring, we talked a lot about this
    in our crop schools, fertilizer prices and-
  • 3:07 - 3:10
    and with what was going on, that's
    still going on in Ukraine and Russia,
  • 3:10 - 3:16
    so dramatically impacting the bottom line
    for a lot of our crop producers.
  • 3:17 - 3:18
    This graph,
  • 3:19 - 3:21
    I found extremely interesting.
  • 3:21 - 3:25
    This comes from Farmdoc Daily
    out of University of Illinois,
  • 3:25 - 3:29
    another great resource,
    I would bookmark their- their website,
  • 3:29 - 3:34
    Farmdoc Daily, always providing
    interesting graphs and information.
  • 3:34 - 3:38
    So this is- this is fertilizer,
    the amount imported
  • 3:38 - 3:42
    and produced domestically,
    so you can see nitrogen,
  • 3:42 - 3:45
    12% of our U.S. nitrogen is imported.
  • 3:45 - 3:49
    You can see, you know,
    where the majority of that comes from.
  • 3:49 - 3:51
    Phosphate 9%, potash,
  • 3:51 - 3:54
    we're heavily reliant on
    foreign producers for potash,
  • 3:54 - 3:59
    as you can see, right, the-
    Belarus, Russia, then- then Canada.
  • 3:59 - 4:00
    So you can see that.
  • 4:00 - 4:04
    They compared that to Brazil,
    interestingly enough, right?
  • 4:04 - 4:08
    We compete with Brazil on a lot of sides
    when it comes to agriculture.
  • 4:08 - 4:11
    They're more heavily dependent
    on some of these other, right,
  • 4:11 - 4:16
    95% imported for nitrogen
    where we're 12%, phosphate 75%,
  • 4:16 - 4:19
    potash, much like us, they're 91%.
  • 4:19 - 4:21
    So, dramatic-
  • 4:22 - 4:24
    This is what's driving that-
  • 4:24 - 4:27
    that potash price and nitrogen
    because of those
  • 4:27 - 4:31
    other foreign factors driving that,
    but not quite as bad as Brazil.
  • 4:31 - 4:34
    But still, those fertilizer prices are-
  • 4:34 - 4:39
    and energy prices are really
    changing our bottom line.
  • 4:39 - 4:41
    So this is- this comes out of-
  • 4:41 - 4:44
    this is USDA NASS data.
  • 4:46 - 4:48
    So you can see here, this is paid indexes,
  • 4:48 - 4:50
    so almost like a producer price index
  • 4:50 - 4:54
    for chemical fertilizer
    and fuels at the farm level.
  • 4:54 - 4:55
    So you can see-
  • 4:55 - 4:56
    right?
  • 4:56 - 5:02
    So- so chemicals remain pretty steady
    and have risen as of late.
  • 5:02 - 5:04
    Fertilizer,
  • 5:04 - 5:09
    2013- we had high fertilizer prices
    in 2008, 2009, 2007,
  • 5:09 - 5:11
    and then it's dropped.
  • 5:11 - 5:15
    We had a period of relatively low
    fertilizer prices and have seen that,
  • 5:15 - 5:17
    and you can see how that
    tracks those fuel prices.
  • 5:17 - 5:20
    You know, energy,
    those two are tied together.
  • 5:20 - 5:26
    And so you can see those fuel prices
    and- and fertilizer prices as of late.
  • 5:26 - 5:29
    When we look at this,
    historically speaking, this graph here,
  • 5:30 - 5:32
    we- there's a time when
  • 5:32 - 5:34
    we didn't know if we'd see
    those prices, those global
  • 5:34 - 5:39
    for April 2012, October 2008,
    where the previous h-
  • 5:39 - 5:44
    two previous highs,
    and you can see April 2022,
  • 5:44 - 5:48
    we were well above those-
    those two previous highs.
  • 5:48 - 5:52
    So this- this is a
    period of- of input prices
  • 5:52 - 5:54
    we haven't seen or experienced
  • 5:55 - 5:57
    really impacting bottom line.
  • 5:57 - 5:59
    But I'll show you
    what's offsetting some of that.
  • 6:00 - 6:03
    So when we think about Utah,
    I just want to quickly show you just a-
  • 6:03 - 6:07
    just a snapshot of- this is-
    the blue line would be last year,
  • 6:07 - 6:10
    and the orange is,
    as of this year, average prices.
  • 6:10 - 6:14
    So you can see, right, California,
  • 6:14 - 6:18
    almost $70 above where we were last year,
  • 6:18 - 6:20
    Idaho, $50.
  • 6:20 - 6:23
    So, you know, you look across
    these western states where
  • 6:23 - 6:27
    $50 to $70 above where
    we were a year ago on sale price.
  • 6:28 - 6:32
    And I've read, you know,
    just some anecdotal conversations,
  • 6:32 - 6:35
    you know, with- with prices
    above 300, with take to-
  • 6:35 - 6:39
    take into consideration this is average
    across different quality levels.
  • 6:39 - 6:44
    So when I say 270, that's averaged across
    these different quality levels, but..
  • 6:46 - 6:49
    These hay prices are, you know,
    when we think about the revenue,
  • 6:49 - 6:53
    and Ru's going to show the
    revenue and the cost side.
  • 6:53 - 6:55
    So keep that in mind as we're
    talking about, you know,
  • 6:55 - 6:59
    capturing some of the sensitivity of-
    of bottom line to some of these-
  • 6:59 - 7:01
    these factors.
  • 7:02 - 7:03
    For our livestock producers,
  • 7:03 - 7:06
    we're watching the price of corn,
  • 7:06 - 7:08
    and, you know,
    thinking about the cost of feed
  • 7:08 - 7:11
    as it's tied to alfalfa as well.
  • 7:11 - 7:16
    Corn is into an area that- that
    we didn't know if we would ever see again.
  • 7:16 - 7:20
    So this is just the- the-
    the cash price for corn.
  • 7:20 - 7:23
    When we look at this on a futures basis,
    so this is the future.
  • 7:23 - 7:26
    This is July 2022 futures.
  • 7:26 - 7:31
    When we look at the previous July
    contracts, the previous high was right at,
  • 7:31 - 7:35
    you know, that 2012 when that drought
    came through, and we're above that.
  • 7:35 - 7:39
    So we're seeing, once again,
    we're seeing prices on the-
  • 7:39 - 7:43
    on some of these commodities
    that we have not seen before.
  • 7:43 - 7:47
    Soy- winter wheat,
    same story in winter wheat,
  • 7:47 - 7:50
    seeing prices we haven't
    seen before in winter wheat.
  • 7:50 - 7:54
    The previous was in 2007, 2008,
    we saw high prices.
  • 7:54 - 7:56
    We're above those right now,
  • 7:56 - 7:59
    so, you know, a lot of these
    commodities are driving-
  • 8:00 - 8:03
    are going to maintain some profitability
    on the- on the crop side,
  • 8:03 - 8:05
    offsetting some of those costs,
  • 8:05 - 8:09
    but soybeans- I just
    want to show that just as,
  • 8:09 - 8:11
    right, we're seeing these high prices.
  • 8:11 - 8:13
    Then we talk about cattle.
  • 8:13 - 8:15
    Unfortunately, when we look at cattle-
  • 8:15 - 8:19
    so this is our futures for feeder
    and futures for live cattle.
  • 8:19 - 8:23
    When we- earlier in the year,
    they've been, you know,
  • 8:24 - 8:25
    rising in-
  • 8:25 - 8:28
    the price had been rising
    as we saw that trend.
  • 8:29 - 8:32
    And then as of late
    with economic concerns,
  • 8:33 - 8:35
    you know, a lot of these
    different factors, you know,
  • 8:35 - 8:37
    margins at the packer level,
  • 8:37 - 8:41
    whatever, we've seen that price
    steadily decline.
  • 8:41 - 8:43
    On the live cattle,
    we've seen it on the live as well.
  • 8:43 - 8:48
    So unlike the commodity side,
    on the livestock side, we have these-
  • 8:48 - 8:50
    these prices that are-
  • 8:51 - 8:52
    are dampening the-
  • 8:52 - 8:56
    the profitability projections
    as we go forward.
  • 8:58 - 9:00
    Talking energy,
  • 9:00 - 9:03
    so this is our- our
    August futures for crude..
  • 9:04 - 9:06
    oil, just wanted to
    show that in perspective.
  • 9:06 - 9:09
    So this is- we're at 1- we're at 107.
  • 9:09 - 9:12
    Just very recently.
    When we put that into perspective,
  • 9:12 - 9:15
    the past 20 years, that's-
  • 9:16 - 9:17
    right?
  • 9:17 - 9:21
    We saw higher in 2008,
    you know, we had at this period, 2000.
  • 9:21 - 9:24
    So oil is- is- is high,
  • 9:24 - 9:27
    but we- you know, it's not an area
    that we haven't seen before
  • 9:27 - 9:30
    and like we're seeing
    with some of these other commodities.
  • 9:30 - 9:34
    We're still going to drive
    that cost of fuel though, natural gas.
  • 9:34 - 9:36
    Right? We're seeing this natural gas,
  • 9:36 - 9:40
    but when we put this into historical
    perspective, this is a one year chart.
  • 9:40 - 9:42
    This is a 20 year chart, right?
  • 9:42 - 9:46
    Once again, we saw those
    high prices, 2006, 2008.
  • 9:46 - 9:51
    And so natural gas is high,
    but we were at a period
  • 9:51 - 9:55
    of really low prices that kind of skewed
    some of our perspective.
  • 9:55 - 9:58
    But that's still going to drive up
    these input costs,
  • 9:58 - 10:01
    and we're going to show you how you can
  • 10:01 - 10:03
    implement some of those
  • 10:03 - 10:06
    as we put this into perspective, so...
  • 10:06 - 10:09
    MODERATOR: Ryan,
    as you're transitioning to Ruby here,
  • 10:09 - 10:12
    what- so this conflict
    in Ukraine- and Ukraine,
  • 10:12 - 10:16
    I've heard referred to sort of
    as the breadbasket of Europe, is-
  • 10:17 - 10:20
    what do we think that's- what impact
    do you think that's going to have?
  • 10:20 - 10:22
    Are we seeing that already in the futures?
  • 10:22 - 10:25
    And what impact
    do you think that's going to have on
  • 10:25 - 10:28
    some of these commodity prices,
    like particularly wheat?
  • 10:28 - 10:31
    >> Yeah, wheat- wheat is really the
    one market that's being impacted
  • 10:31 - 10:33
    by- by Ukraine.
  • 10:35 - 10:38
    There's still a lot of uncertainty
    whether, you know,
  • 10:38 - 10:43
    you see- you see pictures of farmers out
    trying to plant in Ukraine right now,
  • 10:43 - 10:46
    and there's a lot of uncertainty
    whether they will plant,
  • 10:46 - 10:47
    how much will get planted,
  • 10:47 - 10:52
    so I think this wheat market is going
    to be extremely volatile this year
  • 10:52 - 10:55
    and at least next year,
    depending on what happens there.
  • 10:55 - 10:58
    But that's- and that's-
    that's really going to impact that.
  • 10:58 - 11:00
    Some of the- the consequences of that
  • 11:00 - 11:03
    is we're seeing a lot of people,
    a lot of farmers
  • 11:04 - 11:07
    in the West and Midwest
    that are planting more wheat this year,
  • 11:07 - 11:09
    which we haven't done in a long time.
  • 11:09 - 11:11
    So that could impact the corn markets.
  • 11:11 - 11:13
    That's going to impact
    a lot of other markets.
  • 11:13 - 11:17
    And so I think this- this Ukraine issue
  • 11:17 - 11:21
    is sending ripples across
    all commodity markets right now.
  • 11:22 - 11:24
    [all three speakers speak at once]
  • 11:24 - 11:25
    RYAN: Yes. There we go.
  • 11:25 - 11:28
    RUBY: Alright. So the first-
  • 11:28 - 11:30
    so we wanted to kind of-
    and Ryan and I are going to
  • 11:30 - 11:34
    kind of go back and forth here,
    but we wanted to really
  • 11:34 - 11:37
    kind of show you how you aren't-
  • 11:37 - 11:40
    don't have to just be reliant
    on kind of our examples,
  • 11:41 - 11:44
    but how you can kind of
    go about really saying,
  • 11:44 - 11:46
    what does this mean
    down at the producer level?
  • 11:46 - 11:48
    And so that's what we wanted to go with.
  • 11:48 - 11:51
    So the first thing that we do
    is we pull up a budget,
  • 11:51 - 11:54
    and if you're working with a producer
    that has their information from last year,
  • 11:54 - 11:58
    they can use their own information,
    but this is..
  • 11:59 - 12:00
    an alfalfa budget
  • 12:01 - 12:06
    that Ryan put together,
    and it's based on a hundred acres.
  • 12:06 - 12:10
    And so budgets
    have the receipts here up at the top.
  • 12:10 - 12:13
    And this one is based upon about five-
  • 12:13 - 12:17
    well, it is five tons of alfalfa per acre,
  • 12:17 - 12:21
    and the price varied between 200 and 255,
  • 12:21 - 12:26
    and it's around an average
    around $225 a ton.
  • 12:26 - 12:28
    And then we've got the costs down here.
  • 12:28 - 12:33
    The variable costs are fertilizer,
    herbicide, insecticide,
  • 12:33 - 12:36
    the labor, fuel, repairs, other things.
  • 12:36 - 12:39
    And then we have the fixed
    costs down here.
  • 12:39 - 12:43
    And so in this case,
    Ryan's budget was showing
  • 12:43 - 12:50
    that we're making 4100- $41,000
    after our costs on this enterprise budget.
  • 12:50 - 12:52
    And this is an enterprise budget
  • 12:52 - 12:55
    because it's for one enterprise,
    and in this case it's for alfalfa.
  • 12:56 - 12:59
    So in order to really kind of
    look at changes and things,
  • 12:59 - 13:03
    what I like to do is really kind of
    bring it back down to just a few costs
  • 13:03 - 13:08
    rather than all of the various details
    that is in this budget.
  • 13:08 - 13:13
    So I want to take the budget and
    kind of simplify it a little bit. And..
  • 13:14 - 13:16
    my goal is, I have
  • 13:16 - 13:20
    these templates that I put together
    just a generic one
  • 13:20 - 13:23
    on sensitivity analysis,
    and sensitivity analysis is just saying
  • 13:24 - 13:27
    what happens to percentage
    changes to our bottom line.
  • 13:27 - 13:30
    And so you can- the green column,
  • 13:30 - 13:34
    you have your own information
    or the beginning bas- net situation.
  • 13:34 - 13:37
    In this case we've got 36% margins.
  • 13:37 - 13:39
    So for every dollar you sell,
  • 13:39 - 13:43
    36% of it is left over after you
    cover your out-of-pocket expenses,
  • 13:43 - 13:47
    then you've got your overhead, your taxes.
  • 13:47 - 13:51
    And this one was for a little
    raspberry jam out of-
  • 13:51 - 13:53
    you're making it out of your home.
  • 13:53 - 13:55
    And then the blue,
    you can put in percentage changes.
  • 13:55 - 14:00
    So I've got to find
    basically these numbers in green
  • 14:00 - 14:01
    from that enterprise budget,
  • 14:01 - 14:06
    and then if I put those in,
    then I can start to do the analysis.
  • 14:06 - 14:09
    So that's just kind of
    setting the stage for this.
  • 14:09 - 14:14
    So over here, energy is
    a big cost, as Ryan said,
  • 14:14 - 14:16
    that's been affected different things.
  • 14:16 - 14:21
    And so I just go through
    and I kind of look at what things
  • 14:21 - 14:24
    my- do I think are moving
    with those energy markets.
  • 14:24 - 14:28
    Fertilizer obviously is dependent upon
    what's going on now.
  • 14:28 - 14:32
    The- and so I just take a color coding,
  • 14:32 - 14:36
    and because I think for me color coding
    something really kind of lets me
  • 14:36 - 14:39
    just kind of see what's going on
    and know that I looked at everything.
  • 14:39 - 14:42
    So over here..
  • 14:43 - 14:47
    I'm just making energy green,
    and then I can sum up,
  • 14:47 - 14:49
    and then down here,
  • 14:49 - 14:52
    we'd also make fuel
    would be that same way.
  • 14:52 - 14:54
    And so I can make it green,
  • 14:55 - 14:57
    and I'm going to do that
    with the other things,
  • 14:57 - 14:58
    and I've actually already done that.
  • 14:58 - 15:02
    But I didn't want to start
    with my cluttered Excel file.
  • 15:02 - 15:06
    So here's how I start to kind of take
    that budget and start to pick it apart.
  • 15:06 - 15:10
    But basically, I want to assign
    all of these costs up to one of these
  • 15:10 - 15:12
    and then add them up.
  • 15:13 - 15:15
    And so if I go..
  • 15:16 - 15:18
    so this version..
  • 15:20 - 15:23
    make it a little bit bigger
    so we can see it.
  • 15:24 - 15:26
    There we go.
  • 15:26 - 15:28
    So I've got this in our- the budget,
  • 15:28 - 15:32
    and you can see that I have-
    now going down through these costs,
  • 15:32 - 15:37
    all of them are assigned to one of these,
    and then I've added them up.
  • 15:37 - 15:39
    And so..
  • 15:40 - 15:43
    water cost I put into other,
  • 15:43 - 15:48
    the irrigation labor, operator labor,
    and also repairs and maintenance, right,
  • 15:48 - 15:49
    and I talked about this a little bit,
  • 15:49 - 15:52
    and we felt like repairs and
    maintenance is coming from the parts,
  • 15:52 - 15:54
    but also the labor based upon that.
  • 15:54 - 15:59
    So the cost of getting repairs done,
    we felt like it was moving in some ways
  • 15:59 - 16:00
    with the labor market.
  • 16:00 - 16:03
    So we decided for this scenario,
  • 16:03 - 16:05
    and for this instance
    to really kind of look at
  • 16:05 - 16:07
    how to kind of pull these things together,
  • 16:07 - 16:10
    to put the repairs and
    maintenance in with the labor.
  • 16:10 - 16:13
    And then the purplish color,
  • 16:13 - 16:17
    pink color is all the other expenses,
    and then the fixed cost,
  • 16:17 - 16:21
    we lumped those together
    into our fixed cost.
  • 16:21 - 16:25
    And so when I did that, we ended up with
  • 16:26 - 16:31
    energy is making up 23% of our revenue.
  • 16:31 - 16:34
    Labor was 16%.
  • 16:35 - 16:40
    Other expenses that we
    lumped all together were 3%,
  • 16:40 - 16:46
    and then our fixed costs were 21%,
    leaving our profit down here at 37%.
  • 16:46 - 16:51
    So this is what Ryan had put together
    as a budget kind of before
  • 16:51 - 16:56
    some of these really big changes that
    have been happening- going on in 2022.
  • 16:56 - 16:59
    So now that we have those,
  • 17:00 - 17:05
    I can- and just to make it easy
    to see in this presentation
  • 17:05 - 17:08
    and not kind of be going back and forth,
  • 17:08 - 17:13
    what I did was just pull that sensitivity
    file over here into this spreadsheet.
  • 17:14 - 17:18
    As you can see that here,
  • 17:18 - 17:21
    I modified these numbers in green
  • 17:21 - 17:24
    to match what I was pulling in here.
  • 17:24 - 17:27
    So my revenue 111,000.
  • 17:27 - 17:32
    And if I go back over here to my budget,
    let's just pull that back on the screen-
  • 17:34 - 17:37
    [mumbles] no, it won't let me do that.
    Okay.
  • 17:37 - 17:42
    So my revenue was 111,000,
    that's what I put in here,
  • 17:42 - 17:48
    my energy, it all added up to 23,329.
  • 17:48 - 17:50
    And then my labor,
  • 17:51 - 17:54
    I put that in other,
    this one's left blank,
  • 17:54 - 17:57
    so if I wanted to split it out
    into one more area, I could.
  • 17:57 - 18:01
    And then I've got my overhead
    or my fixed cost.
  • 18:01 - 18:04
    And so everything's kind of put in here.
  • 18:04 - 18:07
    So this is the way things are looking now.
  • 18:07 - 18:10
    Here's my net income before taxes.
  • 18:10 - 18:12
    If I assume like a 35% tax rate,
  • 18:12 - 18:17
    then that's going to be
    around $27,000 after taxes.
  • 18:19 - 18:21
    But what we really want to know
  • 18:21 - 18:25
    is not just what we were projecting,
    but what- play the what if games.
  • 18:25 - 18:28
    And so here,
  • 18:31 - 18:34
    so over here in this blue column,
    I can just change-
  • 18:34 - 18:37
    I can change whatever we want.
  • 18:37 - 18:41
    And so before I- without anything, it's
    just going to look like it looked before.
  • 18:41 - 18:44
    But as we start to go in and
    add in different things,
  • 18:44 - 18:45
    and so, Ryan,
  • 18:46 - 18:49
    you can start to chime in here
    if you would like.
  • 18:49 - 18:54
    But- so based upon those graphs
    that Ryan was showing earlier,
  • 18:54 - 18:58
    energy's obviously,
    and our fertilizer costs have gone up.
  • 18:58 - 19:02
    So what percentage
    do you think we ought to put in there
  • 19:02 - 19:04
    for a change in fertilizer?
  • 19:06 - 19:10
    RYAN: At least 30 to 40%.
    I think that's very conservative.
  • 19:10 - 19:11
    >> Okay.
  • 19:11 - 19:14
    So we'll just start with the 30%
    and then we can change it.
  • 19:14 - 19:18
    So we see that just
    that change of 30% there
  • 19:18 - 19:22
    brings our fertilizer costs for the
    hundred acres up to around 33,000.
  • 19:23 - 19:28
    And that alone is going to
    lower this net income by 19%.
  • 19:30 - 19:31
    We're still making money,
  • 19:31 - 19:34
    but now it's less than it was before.
  • 19:34 - 19:38
    And then labor, everybody's
    seen all the help wanted signs,
  • 19:38 - 19:41
    heard about the higher labor costs,
  • 19:42 - 19:45
    would just say like 25% or more?
  • 19:46 - 19:47
    >> Yeah.
  • 19:49 - 19:51
    >> So we put in the 25%.
  • 19:52 - 19:55
    And then this'll show is now
    we're bringing that margin,
  • 19:55 - 19:58
    this is out of our-
    after our out-of-pocket costs.
  • 19:58 - 20:00
    It was $0.58 on every dollar.
  • 20:00 - 20:04
    With those two changes,
    it goes down to $0.47 on the dollar.
  • 20:05 - 20:09
    And our net income went
    from 27,000 down to-
  • 20:09 - 20:13
    after tax take- taking 9000,
    or before tax it went from
  • 20:13 - 20:16
    41,000 down to 29,000.
  • 20:16 - 20:20
    So this is something that you can quickly
    kind of make those changes.
  • 20:21 - 20:23
    Other expenses,
  • 20:23 - 20:27
    probably like with just
    inflation, 7 to 10%
  • 20:27 - 20:29
    if we're going a little conservative here,
  • 20:29 - 20:34
    so just do 7%, and then fixed cost,
  • 20:35 - 20:38
    we can go a little bit higher, maybe 10%.
  • 20:38 - 20:43
    And so you can see that
    all of those changes bring us down,
  • 20:43 - 20:47
    our net income goes down by a third,
    but we're still positive.
  • 20:47 - 20:49
    It was 41,000 before tax.
  • 20:49 - 20:53
    Now it's down to 26,000 before tax.
  • 20:53 - 20:57
    You'll notice that these changes
    didn't affect it as much,
  • 20:57 - 20:59
    partly because
    they're smaller percentages,
  • 20:59 - 21:01
    but also this- mainly this other one
  • 21:02 - 21:05
    is such a smaller number
    to begin with compared to the others
  • 21:05 - 21:09
    that it's not going to drive things
    as much as these two biggies.
  • 21:09 - 21:13
    But labor and energy are a huge part
    of the expenses in alfalfa,
  • 21:13 - 21:16
    and both of those have experienced
    really strong pressures.
  • 21:16 - 21:20
    So that would bring our
    net income down by 36%.
  • 21:21 - 21:24
    But there's something else
    going on in our state this year.
  • 21:24 - 21:26
    And what is that, Ryan?
  • 21:27 - 21:30
    >> Yeah, we're assuming we're going
    to get five tons to the acre.
  • 21:31 - 21:35
    We hope that we will be able to,
    but that's... so-
  • 21:35 - 21:37
    so what if- I mean,
  • 21:39 - 21:41
    it's just- we're going to assume that-
  • 21:41 - 21:45
    that we're not going to get our
    full yield this year on alfalfa.
  • 21:46 - 21:49
    >> So we were getting five tons per acre.
  • 21:49 - 21:54
    So if we went down to like 60%
    or about 30 tons per acre,
  • 21:54 - 21:58
    that would be like minus-
    we'd lose like 40% of our yield.
  • 22:01 - 22:04
    So that's really going to
    bring us negative.
  • 22:04 - 22:07
    We're still going to cover
    our out-of-pocket expenses
  • 22:07 - 22:11
    because the 12% is positive here,
  • 22:11 - 22:14
    but we went from getting around $0.58
  • 22:14 - 22:18
    on the dollar
    after out of pocket to $0.12,
  • 22:18 - 22:21
    and so that no longer is enough
    to cover those fixed costs,
  • 22:21 - 22:24
    those 26,000 in fixed costs.
  • 22:24 - 22:27
    So now we're going to be
    negative income here.
  • 22:27 - 22:30
    That's just- that's because
    our yield went down,
  • 22:30 - 22:34
    but I've also heard
    that prices of hay have been going up.
  • 22:35 - 22:38
    And so if we assume that
    the yield might be lower,
  • 22:38 - 22:41
    but maybe the price of hay
    is going to be a little bit higher,
  • 22:42 - 22:47
    maybe that nets out to
    only going down by 25%.
  • 22:48 - 22:53
    And if so, then we come down to where
    we're not too far from breaking even here,
  • 22:53 - 22:57
    we're negative by 1500.
  • 22:57 - 23:01
    But our margins, $0.29 on the dollar.
  • 23:04 - 23:06
    So this is..
  • 23:08 - 23:09
    how you can kind of just look at,
  • 23:09 - 23:12
    and why you might want
    to look at this with a producer,
  • 23:12 - 23:15
    is if I know early in the season
  • 23:15 - 23:18
    that I'm going to be
    having financial difficulty,
  • 23:18 - 23:22
    Ryan, when would you say is the best time
    to go start talking to a banker?
  • 23:24 - 23:26
    >> The sooner the better.
    [laughs]
  • 23:26 - 23:30
    As- as soon as you even get a hint
    that things are not going as planned,
  • 23:30 - 23:31
    that's..
  • 23:32 - 23:34
    that's when the
    communication should start.
  • 23:36 - 23:38
    >> So this can help you
    instead of kind of wait-
  • 23:38 - 23:40
    knowing that you have
    some of these things,
  • 23:40 - 23:44
    that prices are going up,
    but our yield might be down, and..
  • 23:45 - 23:48
    then it can just kind of let
    you start to put this together,
  • 23:48 - 23:52
    what that might look like, and
    play out some different scenarios.
  • 23:52 - 23:57
    So here, assuming that you did- we do get
    enough water that you can get your yield
  • 23:57 - 24:01
    and prices do go up a little bit,
    maybe instead of being negative,
  • 24:01 - 24:03
    an optimistic one would be
    that that's positive.
  • 24:03 - 24:07
    And so you can start
    to look at the breadth of that.
  • 24:07 - 24:13
    But we've also seen energy prices
    go up by 40% instead of 30%.
  • 24:14 - 24:16
    We've seen..
  • 24:16 - 24:18
    some of these other expenses.
  • 24:18 - 24:21
    You know, maybe they go up by 15%.
  • 24:22 - 24:24
    Whoops, wrong column.
  • 24:26 - 24:29
    And so it just starts to
    allow you to do it.
  • 24:30 - 24:35
    I'm going to go back to.. my base.
  • 24:36 - 24:38
    So I'm going to assume..
  • 24:44 - 24:50
    So this is kind of what
    we started out with, -25%,
  • 24:51 - 24:55
    30%, 25...
  • 25:01 - 25:07
    So when I look over here,
    the other thing that I just-
  • 25:07 - 25:10
    I put here together is
  • 25:11 - 25:16
    to link these into some pie graphs.
  • 25:18 - 25:21
    And so these pie graphs
    and this chart here
  • 25:21 - 25:25
    is based upon what I did with these
    numbers up in my sensitivity analysis,
  • 25:25 - 25:27
    it just summarized them.
  • 25:27 - 25:32
    Here was what I had before,
    is a- this is a percent of revenue.
  • 25:32 - 25:36
    Here's the percentage changes I did,
    and then this is what I have afterwards.
  • 25:36 - 25:40
    And so up here, it's just
    showing the expenses,
  • 25:40 - 25:43
    and I don't have the profit in it,
    but of your expenses,
  • 25:43 - 25:47
    so the dollars being paid to expenses,
    23% of that was going for energy
  • 25:48 - 25:50
    and with the change that we did now,
  • 25:50 - 25:54
    39% of those expenses become energy.
  • 25:54 - 25:58
    As a percent of net income,
  • 25:58 - 26:04
    it went from 23% up to 39%.
  • 26:04 - 26:06
    And then
  • 26:06 - 26:09
    you can see that profit here,
  • 26:09 - 26:13
    basically, this 37% of profit
    had to go somewhere,
  • 26:13 - 26:18
    and it went into these higher fixed costs,
    and it went into higher..
  • 26:19 - 26:21
    energy costs and higher labor.
  • 26:21 - 26:26
    But you can see that it just kind of
    shrunk that profit down to very little.
  • 26:26 - 26:30
    And pie charts don't do well with negative
    profit numbers or negative numbers,
  • 26:30 - 26:34
    so this is actually a negative
    and it was a positive, but..
  • 26:34 - 26:36
    it just kind of is to illustrate.
  • 26:36 - 26:39
    The other thing that we
    wanted to go over is
  • 26:41 - 26:42
    livestock.
  • 26:42 - 26:47
    Are there any questions on hay
    before we leave or anything?
  • 26:48 - 26:49
    Any comments?
  • 26:50 - 26:52
    Then I'll bring up the livestock then.
  • 26:55 - 26:57
    So here's-
  • 26:57 - 27:00
    I did the same thing for the livestock,
    or Ryan and I did.
  • 27:00 - 27:04
    We talked about it,
    and we separated out..
  • 27:05 - 27:07
    the state range and federal range,
  • 27:07 - 27:11
    we don't- those numbers
    won't change, but we-
  • 27:11 - 27:14
    they're so- a minor amount that
    we just lumped them in with the other,
  • 27:15 - 27:17
    and then- but the-
  • 27:17 - 27:20
    we put again the alfalfa straw,
    private meadows,
  • 27:20 - 27:23
    we saw that energy, those labor costs
    was really driving the alfalfa.
  • 27:23 - 27:27
    So we put that in under the feed together,
  • 27:27 - 27:27
    and then..
  • 27:29 - 27:33
    the other expenses,
    transportation we put under energy,
  • 27:34 - 27:39
    and then the non-fee grazing cost,
  • 27:39 - 27:41
    that's like the fencing
    and different things.
  • 27:41 - 27:43
    So that's really more like labor.
  • 27:43 - 27:46
    So we added that up over here.
  • 27:46 - 27:48
    The same thing, put it into..
  • 27:49 - 27:51
    the sensitivity..
  • 27:53 - 27:54
    table,
  • 27:55 - 27:58
    and I put together those pie charts again.
  • 28:01 - 28:02
    So if we-
  • 28:02 - 28:05
    keeps wanting to run away from me.
  • 28:08 - 28:11
    So up here we show that we would-
  • 28:11 - 28:14
    livestock weren't doing
    as well as the hay,
  • 28:14 - 28:17
    so we're showing that the profits
    weren't as much to begin with
  • 28:17 - 28:20
    based on the base budget.
  • 28:20 - 28:22
    Margin was $0.17 on the dollar,
  • 28:22 - 28:26
    net income before taxes around 6600.
  • 28:26 - 28:30
    And so if we did assume like a 15% drop,
  • 28:31 - 28:32
    and then the same thing,
  • 28:32 - 28:35
    feed we did the 30% with the energy,
  • 28:35 - 28:37
    labor 25%,
  • 28:38 - 28:40
    energy also 30%,
  • 28:40 - 28:44
    10% for other,
    10% for overhead.
  • 28:44 - 28:45
    It turned that-
  • 28:45 - 28:49
    so this one, with livestock,
    with these changes,
  • 28:50 - 28:53
    even if we assume that
  • 28:54 - 28:57
    the revenue is not going to change,
    it basically eliminated,
  • 28:57 - 29:01
    and you're not covering
    your out-of-pocket expenses.
  • 29:02 - 29:04
    Little of- and then you're losing-
  • 29:04 - 29:08
    you went from a positive
    6600 net income before taxes
  • 29:08 - 29:11
    to a -10,000.
  • 29:13 - 29:15
    And then if we assume that-
  • 29:15 - 29:18
    what's happening with cattle prices, Ryan?
  • 29:20 - 29:22
    >> It- it's slowly going down.
  • 29:24 - 29:24
    So...
  • 29:25 - 29:31
    >> So over here, and the reason I put this
    all on one page is so over here,
  • 29:31 - 29:38
    we were assuming 550 pound steer cows,
    500 pound heifer cows,
  • 29:39 - 29:43
    and the price of cattle was 1.- 175
  • 29:44 - 29:48
    for steers and then the 165 here.
  • 29:48 - 29:50
    And so if we
  • 29:51 - 29:55
    go down by 15%,
    that's what it's looking like for us.
  • 29:55 - 29:56
    And then
  • 29:57 - 30:00
    again, I don't know if we-
  • 30:00 - 30:04
    I think it's based partly on our
    range conditions and water and stuff,
  • 30:04 - 30:06
    but whether our calves
    are going to be lighter or not,
  • 30:06 - 30:09
    whether you'll have
    more death loss or not,
  • 30:09 - 30:12
    you know, those are additional things
    that you could kind of take into account
  • 30:12 - 30:15
    when you think about changes in revenue.
  • 30:15 - 30:18
    But when I put this in,
  • 30:19 - 30:23
    the- you can see that this net income
  • 30:23 - 30:28
    or profit was a positive 8%,
    and that goes down to a -19%.
  • 30:28 - 30:29
    So that net income-
  • 30:31 - 30:33
    but it starts to change.
  • 30:33 - 30:36
    And so we have a negative-
    again, in a pie chart,
  • 30:36 - 30:36
    it doesn't do well.
  • 30:36 - 30:40
    That's why we did these just
    percent of the expenses,
  • 30:40 - 30:43
    we can see that before,
    feed was 47% of your expenses.
  • 30:43 - 30:46
    But with this change, it becomes 67%.
  • 30:46 - 30:51
    And so it just starts to eat
    up all of that profit.. that..
  • 30:52 - 30:55
    Any comments here, Ryan, or..?
  • 30:56 - 31:00
    >> There was a comment in the chat box,
  • 31:00 - 31:03
    what factors are pushing
    cattle prices down?
  • 31:03 - 31:05
    I think the..
  • 31:05 - 31:07
    the main thing is the..
  • 31:07 - 31:11
    you know, I showed that graph earlier,
    the Consumer Price Index.
  • 31:11 - 31:15
    I think the cost of other goods
    are so high inflation that,
  • 31:15 - 31:17
    you know, consumers are really-
  • 31:18 - 31:22
    when consumers have money in their pocket,
    they buy- they buy beef.
  • 31:22 - 31:24
    And right now with the
    economy and with inflation,
  • 31:24 - 31:26
    consumers are really tightening up,
  • 31:26 - 31:31
    and I think that's pushing
    a lot of those- those prices down
  • 31:32 - 31:34
    on that B side.
  • 31:36 - 31:37
    But I think, no,
  • 31:37 - 31:40
    I think this captures that-
    that the implications of those
  • 31:40 - 31:44
    rising feed costs on cattle is just..
  • 31:46 - 31:47
    pushing that, you know,
  • 31:47 - 31:51
    eating up that profitability,
    just like you said.
  • 31:53 - 31:57
    >> So I think some other things
    to think about for me is..
  • 31:58 - 32:00
    that if you see-
  • 32:00 - 32:04
    we didn't do it for dairy,
    but if you see this negative,
  • 32:04 - 32:07
    this cost of feed really cutting into
  • 32:07 - 32:13
    the profit on the cattle beef side,
    you also know that the cost of feed
  • 32:13 - 32:18
    is going to be really affecting the dairy
    also, where some- a lot of our hay goes.
  • 32:19 - 32:21
    And so one thing that I would also
  • 32:21 - 32:25
    think about as I was
    back here looking at the hay,
  • 32:25 - 32:26
    is..
  • 32:27 - 32:33
    I think another pressure that we have here
    is not just from the lower yield,
  • 32:33 - 32:35
    maybe because of the water and stuff, but
  • 32:35 - 32:39
    are they going to get
    paid for their h- feed?
  • 32:39 - 32:43
    So I think that sometimes
    hay is something that,
  • 32:43 - 32:48
    as things start to tighten up in other areas,
    it's hard to get paid for it.
  • 32:48 - 32:50
    We sell hay on a-
  • 32:50 - 32:53
    as Ryan said,
    we sell a lot of hay on a handshake.
  • 32:53 - 32:57
    And so it's also just kind of-
  • 32:57 - 32:59
    are people going to, you know,
    be selling hay that-
  • 32:59 - 33:01
    I don't know if I'm
    going too far with that,
  • 33:01 - 33:05
    but I think hay is definitely
    one of those things to really think about.
  • 33:05 - 33:11
    Will they get all the money collected
    if there's financial pressure on their...
  • 33:11 - 33:14
    And that's a small amount that I think
    sometimes getting pa-
  • 33:14 - 33:16
    not paid- get for like
    one load for one farmer
  • 33:16 - 33:19
    can still be a significant thing
    for that purse.
  • 33:20 - 33:23
    >> Ruby, there's another
    question asking about-
  • 33:23 - 33:26
    are Texas producers
    culling yet due to the drought?
  • 33:27 - 33:30
    I haven't seen any data
    indicating that yet,
  • 33:30 - 33:32
    that those- those are-
  • 33:32 - 33:35
    anybody's starting to cull down south.
  • 33:35 - 33:37
    That's something
    we are definitely watching.
  • 33:37 - 33:41
    I think that's something that,
    you know, we've had these rains lately.
  • 33:41 - 33:45
    They haven't by no means
    fixed anything, but..
  • 33:46 - 33:47
    that's one of the big questions
  • 33:47 - 33:51
    and key things that we're going to be
    watching is- is to see what happens
  • 33:51 - 33:54
    with culling, both in Utah
    and in our neighbors.
  • 33:54 - 33:56
    And especially as we watch-
  • 33:56 - 33:57
    That's what we were watching last year,
  • 33:57 - 34:02
    is that drought kind of subsided in Texas,
    but we're watching it right now,
  • 34:02 - 34:05
    and if that drought creeps into Texas
    and if they start culling,
  • 34:05 - 34:08
    then there'll be some-
    some big market impacts.
  • 34:09 - 34:11
    We just haven't seen those quite yet.
  • 34:11 - 34:15
    You know, that drought, you know,
    it's precarious, but it's not to the-
  • 34:15 - 34:19
    I don't think- I don't think anybody's
    culling quite yet in Texas, but
  • 34:20 - 34:22
    we are definitely watching that.
  • 34:23 - 34:26
    RUBY: So- Yeah?
    MATTHEW: I had a real quick question,
  • 34:26 - 34:27
    this map,
  • 34:28 - 34:31
    so I might have missed this,
    being I logged on a little late, but
  • 34:31 - 34:35
    is there any prediction
    of what percent of actual-
  • 34:35 - 34:38
    of our hay product we'll actually
    produce this year due to drought?
  • 34:40 - 34:42
    How much are we gonna be down?
  • 34:44 - 34:46
    RYAN: In Utah?
  • 34:46 - 34:48
    >> Yeah, in Utah.
  • 34:49 - 34:50
    >> Ooooooh.
  • 34:52 - 34:54
    It's- it's still-
  • 34:55 - 34:56
    the one advantage is
  • 34:56 - 35:01
    we went into the fall with a little more
    soil moisture than we did in 2020, 2021-
  • 35:02 - 35:05
    the fall of 2020 into 2021.
  • 35:05 - 35:10
    So we came into 2022 with
    better soil moisture, right?
  • 35:10 - 35:13
    You talk to guys in Central Utah,
    in Sanpete County,
  • 35:13 - 35:15
    they feel like they're in
    a little better situation.
  • 35:15 - 35:18
    The problem is, we just
    didn't get enough snowfall to..
  • 35:18 - 35:19
    that's one of the- how-
  • 35:19 - 35:22
    how are those reservoirs
    going to be filled up, and how long?
  • 35:22 - 35:25
    So I think we're going to see..
  • 35:26 - 35:30
    at least, I think, a conservative 25% drop.
  • 35:30 - 35:33
    Very- and that's-
    I think that's very conservative.
  • 35:33 - 35:35
    I think it's probably
    going to be more than that,
  • 35:35 - 35:38
    but I think at least a 25%.
  • 35:39 - 35:42
    RUBY: So this was meant to
  • 35:42 - 35:46
    just give you a feel
    for how you can start to bring-
  • 35:46 - 35:49
    sources for some of the information
    that we're seeing as we go through,
  • 35:49 - 35:53
    and then how you can kind of
    bring it down to the producer level
  • 35:53 - 35:56
    and also modify for individual situations.
  • 35:56 - 36:02
    And so we used some of the enterprise budgets
    that we had here for the state of Utah,
  • 36:02 - 36:06
    but this can really be done
    with anybody's information
  • 36:06 - 36:11
    if they just get it back down to
    those few things, types of expenses.
  • 36:12 - 36:19
    So I will share those Excel files
    that we used with Kerry,
  • 36:19 - 36:22
    and so he can share them.
  • 36:22 - 36:24
    They're really cluttered,
    but I like having everything
  • 36:24 - 36:28
    kind of on one screen
    so you can see everything. So...
  • 36:28 - 36:30
    KERRY: Is there a- [inaudible]-
  • 36:30 - 36:34
    Is there a central place
    that these files are?
  • 36:34 - 36:36
    Maybe we can just send a URL out.
  • 36:36 - 36:37
    >> 'Kay.
  • 36:38 - 36:40
    >> If that's okay, instead of big file-
  • 36:40 - 36:43
    or instead of files,
    they're not all that big, but...
  • 36:45 - 36:52
    >> Should we- so we can put them
    on the APEC website, I think.
  • 36:52 - 36:54
    RYAN: Yeah, we can just upload them there.
  • 36:54 - 36:57
    >> And then the other thing- let's see...
  • 37:02 - 37:07
    Another good presentation that's
    not on the APEC website, but
  • 37:08 - 37:11
    it was at the Urban and
    Small Farms Conference.
  • 37:11 - 37:16
    And so I'm just going to share
    my screen again, just before we go.
  • 37:19 - 37:20
    There we go.
  • 37:20 - 37:23
    So the Urban and Small Farms Conference
  • 37:24 - 37:30
    is here at the diverseag.org website
    that many of you-
  • 37:30 - 37:33
    and many of you on here
    participated in that and helped with it.
  • 37:33 - 37:35
    But if you go down to
  • 37:36 - 37:42
    Thursday afternoon in the
    marketing/management segment,
  • 37:42 - 37:45
    Kynda Curtis went over
    what's up with inflation and prices,
  • 37:45 - 37:49
    and we've got her PowerPoint
    recording here, and then
  • 37:50 - 37:54
    I have the generic financial health
    evaluation tool,
  • 37:54 - 37:57
    and my presentation here too.
  • 37:57 - 38:01
    And that version of
    the file that's there has-
  • 38:01 - 38:05
    I did it with raspberry jam,
    flowers, and vegetables.
  • 38:05 - 38:09
    And so rather than- I didn't have
    the whole budgets here and stuff,
  • 38:09 - 38:11
    but I went through
    and did the sensitivity analysis
  • 38:11 - 38:14
    and preloaded the
    green numbers with those.
  • 38:14 - 38:17
    And so if you're interested more
    in small farms and stuff,
  • 38:17 - 38:19
    you can use these ones too.
  • 38:19 - 38:22
    That's also a source for information.
  • 38:23 - 38:26
    And that's, again, the Urban
    Small Farms Conference recordings
  • 38:26 - 38:27
    on diverseag.org.
  • 38:27 - 38:31
    And we'll put the rest of them
    on our APEC Extension website.
Title:
Agricultural Outlook Tools
Description:

more » « less
Video Language:
English
Duration:
38:33
Utah_State_University edited English subtitles for Agricultural Outlook Tools
Utah_State_University edited English subtitles for Agricultural Outlook Tools
Utah_State_University edited English subtitles for Agricultural Outlook Tools
Utah_State_University edited English subtitles for Agricultural Outlook Tools
Utah_State_University edited English subtitles for Agricultural Outlook Tools
Utah_State_University edited English subtitles for Agricultural Outlook Tools

English subtitles

Revisions Compare revisions