(800) 234-1111


Handling Fluctuating Values of Ag Co-op Stock

by | Oct 21, 2019

Our FINPACK support team recently received this question:

“What is the proper way to handle Ag Co-op stock in a balance sheet in which the stock, such as sugar beets, changes in value from year-to-year?”

With harvest underway and the 2019 analysis soon to follow, we feel it is a good time to clarify the proper way to handle this unique situation. The problem is that this change in market values can have an effect on the analysis in FINAN, especially the net farm income since the accrual adjustments take the value change into account. To avoid this problem, you can do one of the following two options:


  1. Add cost (or base) values to your balance sheets and keep the cost value constant from year-to-year. All accrual adjustments work from the cost values so you can change market values without impacting earnings. It is a simple process:
    • Edit + Copy Market to Cost – copies the market values to the cost column in the balance sheet.
    • Enter the original cost (or a constant base value) of the co-op stock in the Cost column and then you can change the Market value as needed every year (it is suggested that this occurs in the ‘Other Intermediate Assets’ detail).
    • Repeat this change in the other balance sheets used in your analysis.

Alternative method:

  1. If you do not want to add cost values to your balance sheets, use this alternative method to update FINAN, which will reflect the change in the value of the stock:
    • Enter the amount of the valuation change as a Capital Purchase (or Sale), which takes the change out of the Income Statement.
    • Enter the same amount as Gifts Received (or Gifts Given) to make the cash balance.

As always, feel free to contact FINPACK Tech Support at 1-800-234-1111 x11 if you have questions on this procedure.

[ This information is always available in the FINPACK Knowledge Base ]

+ posts
Latest News
New and Improved: Financial Ratios in FINPACK

New and Improved: Financial Ratios in FINPACK

This post highlights the updated financial ratios in FINPACK. The ratio updates are based on the recent updates to the Farm Financial Standards Council's Financial Guidelines for Agriculture. The 2022 release of the Farm Financial Standards Council's (FFSC) Financial...

FINPACK News – November Digest

FINPACK News – November Digest

The FINPACK Lenders Conference is around the corner, the FINPACK 2022 update is live including new monthly Commercial Cash Flow capabilities, and the FINPACK team at the ABA Ag Bankers conference in Omaha! Register Now for the FINPACK Lenders Conference...

The New Monthly Commercial Cash Flow Capability of FINPACK

The New Monthly Commercial Cash Flow Capability of FINPACK

What's New in the Commercial Cash Flow Tool in FINPACK? The 2022 Fall Release of FINPACK adds the capability to complete annual OR monthly cash flow projections for commercial clients. These projections can be for a few months or multiple years. This replaces the...

What’s New in the 2022 FINPACK Update?

What’s New in the 2022 FINPACK Update?

The 2022 FINPACK update brings changes to Tax Forms, incorporates new Financial Standards Measures, introduces a new Cash Flow Projection into our commercial tools and more! Farm Financial Standards Update The FINAN Financial Analysis and FINFLO Cash Flow Projection...

FINPACK NEWS Digest – October 2022

FINPACK NEWS Digest – October 2022

FINPACK lenders conference registration is open, the updated Farm Financial Scorecard, lender training, and looking forward to the ABA Ag Bankers Conference Register for the FINPACK Lenders Conference The FINPACK Lenders Conference is back in-person! Join us...