Source: UNIV OF MINNESOTA submitted to
ENHANCING THE VALUE OF THE NATIONAL FARM FINANCIAL BENCHMARKING DATABASE
Sponsoring Institution
National Institute of Food and Agriculture
Project Status
TERMINATED
Funding Source
Reporting Frequency
Annual
Accession No.
1016847
Grant No.
2018-38504-28733
Project No.
MIN-14-G28
Proposal No.
2018-03996
Multistate No.
(N/A)
Program Code
FBMB
Project Start Date
Sep 1, 2018
Project End Date
Aug 31, 2020
Grant Year
2018
Project Director
Craven, R.
Recipient Organization
UNIV OF MINNESOTA
(N/A)
ST PAUL,MN 55108
Performing Department
Applied Economics
Non Technical Summary
This project will enhance the national farm financial benchmarking database by improving research opportunities using the data, expanding diversity of the type of farm activities in the database, and by increasing the number of farms represented in the database.Benchmarking serves as an important tool to help producers improve profitability through better management of risk, volitatility, and financial stress. It allows them to evaluate the merits of different approaches to farm management in order to identify the practices most well aligned with their operational goals through comparisons to their peer-group farms. This project will create new partnerships and innovative approaches to obtaining data from additional operations for inclusion in the national database, as well as facilitating use and interpretation of the data by more producers. These interactions will assist in growing collaborative partnerships that allow farmers and ranchers dispersed across the nation to access farm financial analysis and benchmarking tools that are relevant to their concerns.Specific goals of this project include: expanding research opportunities using the database; increasing the diversity of the existing database; expanding collaborations with farm financial management programs; developing additional tools to improve overall database efficiency and collaborative efforts; provide training to emerging benchmarking programs in order to ensure consistency and integrity of collection processes; and create training resources to help producers, educators, and lenders interpret and apply benchmarking principals in ways that are most beneficial to operational management.
Animal Health Component
0%
Research Effort Categories
Basic
(N/A)
Applied
(N/A)
Developmental
(N/A)
Classification

Knowledge Area (KA)Subject of Investigation (SOI)Field of Science (FOS)Percent
6016030301025%
6026030301075%
Goals / Objectives
Maintain and expand FINBIN, the national farm financial database, by working with partners to collect data from geographically and operationally diverse farms and ranches for inclusion in the database, with specific attention to making the information more accessible and applicable to a broader variety of producers nationwide.Expand research opportunities on cost of production and farm profitability using the vast amount of data aggregated in the database and experiment with linkages to the large production databases (big data) that have been developed in recent years.Expand collaboration among farm financial management programs and innovative efforts to increase the quantity and diversity of farms represented in the database in order to enhance the educational value to producers, lenders, educators, and policy makers.Develop database tools to improve the efficiencies of data collection by continuing to forge collaborative efforts with farm management education programs and associations.Provide training and software to existing farm management associations and emerging benchmarking efforts, to improve the value of farm financial analysis for producers, as well as improving data collection efficiency and integrity.Provide benchmarking assistance to help small and mid-sized producers improve profitability, and increase their ability to manage risk, volatility and financial stress.Create training resources to assist in the interpretation and meaningful application of information from FINBIN so producers can more effectively manage their operations through this era of reduced financial profitability.
Project Methods
1. Maintain and expand FINBIN, the national farm financial database, by working with partners to collect data from geographically and operationally diverse farms and ranches for inclusion in the database, with specific attention to making the information more accessible and applicable to a broader variety of producers nationwideA centralized database is the essential component to providing benchmarking capabilities to U.S. producers and to expanding collaboration among the organizations that provide farm financial analysis training and benchmarking to producers. This project will provide this essential component to all the other projects funded through this program.With the technology available today, the development of dynamic, online benchmarking greatly enhances the value of the data collected by farm management programs. Through FINBIN's dynamic features, users can query by size, type, or location of farm; commodity or commodities produced; or by production practices, such as tillage system or organic production. It allows producers seemingly endless capabilities to select the peer group with which to compare their farm or ranch.This project is working with educators in New England to develop benchmarking methodologies allowing educators to measure and benchmark alternative marketing channels. This project is also partnering with an 1890 institution to expand the specialty crop and marketing channel efforts and to work with more small scale producers.As data security concerns increase, efforts to research and verify data security are ongoing. This project will continue to work with University of Minnesota and external data security experts to ensure data security is current and at the highest standards.2. Expand research opportunities on cost of production and farm profitability using data aggregated in the databaseMore than 35,000 reports were generated from FINBIN last year using the powerful query and summary tools available in the database, and hundreds of these were incorporated into applied research and presentations. This project will expand the research opportunities available through the wealth of data in the country's largest farm financial database.After years of discussions, agreements are being developed that will allow researchers expanded access to the FINBIN database. As a result, three specific activities will be launched by this project including development of a technical data dictionary, an agreement has been reached between some associations providing dairy financial data and DHIA to link financial and production data, and a top farmer study is being conducted to identify characteristics of producers who are consistently in the top 20 percent of the database by profit.In 2017, FINBIN added the ability to specify search criteria and do research on panel data. This means a researcher can examine the same farms over extended periods of time. This development has helped open the database to the additional opportunities described above.3. Expand collaboration among farm financial management programs and initiate innovative efforts to increase the quantity and diversity of farms represented in the database in order to enhance the educational value to producers, lenders, educators, and policy makersTo continue to expand the amount of benchmarking data available in FINBIN, new and innovative approaches to farm financial analysis and data collection will be tested. Existing models will continue to serve many producers, but they are difficult and expensive to start in new geographic areas. Alternative models may prove to provide better opportunities for benchmarking to geographically dispersed producers.One of the major goals of this project is to investigate creative ways to incorporate data into the database from new and diverse sources, thus expanding benchmarking opportunities to more producers and expanding the diversity of the benchmarking database.CFFM will host a meeting for representatives from all states contributing data to FINBIN or working toward contributing data. This meeting will focus on sharing approaches that have been most effective in capturing, compiling, and analyzing data, as well as conducting farm financial analyses with individual producers.4. Develop database tools to improve the efficiencies of collaborative efforts with farm management education programs and associationsHigh quality benchmarking data originates with the farm management associations and other emerging efforts that work directly with producers to develop a year-end financial analysis for individual farms and ranches. One goal of this project is to expand collaboration among these organizations and thus create new opportunities and efficiencies that allow farm management programs to use fewer resources to assist as many producers as possible.5. Provide training and software to farm management associations and emerging benchmarking efforts to improve the value of farm financial analysis for producers, as well as improving data collection efficiency and integrityThere are several critical elements common to successful farm management associations. One of them is high-quality staff able to provide real-world farm financial analysis to producers and to generate farm financial data of a high enough quality to be contributed to the national database.Training is particularly important in states that are just starting to do farm financial analysis and benchmarking. This project will provide training, as requested, to the newer programs in South Carolina and associated states, Tennessee, North Carolina, and New England.6. Provide benchmarking assistance to help small and mid-sized producers improve profitability, and their ability to manage risk, volatility and financial stress All U.S. producers benefit from the availability of a national benchmarking database, not just farm management association participants. Any producer can use the database to compare their finances to similar farms or ranches to analyze the strengths and weaknesses of their operation. They can use the database in conjunction with lenders and educators to determine typical costs of production for particular commodities or production practices, as well as evaluate how they compare with other producers that are in their peer group. This database will be publicly available to all producers, thereby providing particular benefit to small and mid-sized farmers and ranchers.7. Create training resources to assist in the interpretation and meaningful application of information from FINBIN so that producers can more effectively manage their operations through this era of financial stressCFFM will work with educators, lenders, and producers to help producers successfully manage risk through this period of tight-to-negative profit margins by:Expand a resource website dedicated to sharing materials between collaborating state benchmarking programs.Developing and delivering presentations on the financial conditions in agriculture and potential means of reducing costs of production at lender and educator conferences.Assist educators throughout the country who use FINBIN reports develop presentations to help producers better understand their financial situation.Work with the programs collaborating on this project to help develop training for lenders, educators, and producers in their states on managing risk during financial stress.Provide additional training to partnering organizations on using the farm financial analysis and benchmark data to develop cash flow projections and what-if projections to help producers explore financial and operational options to deal with financial stress.

Progress 09/01/18 to 08/31/20

Outputs
Target Audience:The primary goal of this project is to provide a national farm financial benchmarking database that will allow any farmer in the nation to compare their financial performance with a selected peer group of like farms. Therefore, the target audience of this project is all farmers in the U.S. The more direct audience is that group of farmers who are participants in farm business management education programs and who contribute to the National Farm Financial Management and Benchmarking Database. To date, complete financials for 3,439 participating farms from twelve partner farm management education programs are currently included in the National Farm Management and Benchmarking Database at http://www.finbin.umn.edu for the 2018 business year. Farms have been compiled and included in the database from 11 states (Michigan, Minnesota, Missouri, Nebraska, North Dakota, Ohio, Pennsylvania, South Carolina, South Dakota, Utah, and Wisconsin), with additional data still to be compiled from Colorado and New England. Participating farms are provided tools and access to make it possible to directly compare their farms with benchmark peer groups to highlight financial strengths and weaknesses. In 2018, 77% of contributing farms were small or mid-sized farms, the group that is most challenged by today's volatile agricultural economy. Twenty-five percent (25%) were beginning farmers and 32% were young farmers. A special effort was made this year to reach out to veterans. Forty-six (46) participating producers identified themselves as veterans. All farms across the country have access to the FINBIN website, the portal into the national database to generate benchmark reports. They can also use the "Compare Your Farm" feature to enter their financial data and generate peer group benchmarks. A third audience is agricultural lenders, educators and other agricultural professionals who can access FINBIN to generate reports to benchmark their clients, to generate educational material, and to monitor the performance of the ag economy. Finally, the fourth audience is agricultural researchers who can use FINBIN reports to support research in various facets for farm financial management. A more focused effort on research has taken place over the last year with the addition of Dr. Joleen Hadrich as a University of Minnesota faculty member. Dr. Hadrich has completed research of the attributes of top farmers, resilient dairy operations, and the impact of the Market Facilitation Program (MFP) government program. Future research efforts have begun related to the economics of organic production and the economics of cover crop production. Changes/Problems: Nothing Reported What opportunities for training and professional development has the project provided?CFFM provides extensive training and training resources to partner groups who contribute to the National Farm Business Management Benchmarking Database. This training contributes to the goal of assuring the National Database is accurate and conforms to uniform standards of consistency and data integrity. During this period, CFFM staff provided onsite training to contributors in Minnesota, Wisconsin, Pennsylvania, North Carolina, Colorado, and Idaho. In addition, the training will be for emerging community college programs in Montana and Nebraska. Since last spring and the start of the pandemic, CFFM staff have been hosting virtual training sessions for new benchmarking collaborators. Another training related to specifically to crop and livestock enterprise analysis is planned for December 2020. Our traditional training includes several two-day FINPACK training sessions specifically for educators that are held in St. Paul, MN. Newly hired collaborators from Minnesota, North Dakota, and Colorado attended in 2018 and 2019 to learn how to use the FINPACK financial analysis software. Additionally, an enterprise analysis focused training was held on site in 2019. Attendees were from Minnesota, Wisconsin, and North Dakota. There were several virtual attendees as well from New Hampshire, Colorado, and North Carolina to name a few. CFFM also maintains a full suite of online training resources for FINPACK users. During the reporting period, the online training modules were enhanced to include detailed videos on completing and interpreting the crop and livestock enterprise analysis. White papers providing tips and resources for all FINPACK users are found in the FINPACK Knowledge Base at https://www.cffm.umn.edu/FINPACKkb. Specific tools and resources related to benchmarking are provided to educators across the nation at https://z.umn. edu/benchmarking. Encompassed on this website are resources such as training videos on the benchmarking process (including segments on advanced balance sheet analysis, advanced whole-farm analysis, crop enterprise analysis, livestock enterprise analysis, and advance enterprise analysis) and the use of the RankEm software in compiling and reviewing benchmark data for consistency and integrity. Educational programs across the country have also provided analysis efficiency-related resources to assist other users with initiating the benchmarking process with the farmers and ranchers in their area. CFFM recently hosted a virtual National Benchmarking Project Leaders meeting in November to prepare for activities in the next year and to consult on strategic plans for the future. This is an annual event hosted by CFFM. FINPACK software revisions have also been distributed to users in November. Updates for this year focus on identifying renewable energy and conservation efforts. The RankEm software updates will be released in December. Here the error check report has been broadened this further helps with data integrity and error checking prior to submission for the National Database. Lastly, the technical data dictionary is now compiled for the balance sheet, whole-farm variables, calculations used in the whole farm area of the FINAN financial analysis, as well as defining the variables and calculations utilized in the crop and enterprise analysis areas of FINAN. How have the results been disseminated to communities of interest?The primary method used to disseminated farm financial benchmark results is through public access to FINBIN. FINBIN is open to anyone to query for summary financial information or benchmarks on financial metrics. Data queries can filter by farm sizes, type, and several other whole-farm attributes. Enterprise-level queries can filter by specific production practices for crop and livestock enterprises. CFFM staff and others make several national presentations each year using data from the National Database to publicize the results. During this period, presentations included American Bankers Association National Agricultural Bankers Conference where Dale Nordquist and Pauline Van Nurden presented; FINPACK Lender's Conference; MN Organic Conference; National Farm Viability Conference; National Farm Management Conference; MN Bank Examiners; the Iowa Ag Credit School in Ames, Iowa and the National School for Ag Lenders in Spearfish, South Dakota; and local Agricultural Lenders Conferences in Minnesota. The Farm Financial Standards Council has incorporated benchmark reports from the National Database into its Financial Guidelines for Agricultural Producers. CFFM staff regularly receives requests from national journalists to provide insights based on trends identified in reports generated through the National Database, including Farm Futures, Public Radio, Farm and Ranch Guide, the Minneapolis Star Tribune, Successful Farming, Farm Progress, AgFax, Ag Week, Farm Journal's MILK Business, The Land, The Farmer, Corn and Soybean Digest, Progressive Dairy, and Wells Fargo's Food for Thought newsletter. FINBIN data is cited in educational resources published by farmdoc Daily, Choices Magazine, and Farm Table. What do you plan to do during the next reporting period to accomplish the goals? Nothing Reported

Impacts
What was accomplished under these goals? The Center for Farm Financial Management (CFFM) worked closely with farm business management educators in partner states to support their educational efforts and to make the National Farm Business Management Benchmarking Database accessible to producers and to educators across the nation. To date, complete financials for 3,439 participating farms from twelve partner farm management education programs are currently included in the National Farm Management and Benchmarking Database at http://www.finbin.umn.edu for the 2018 business year. Farms have been compiled and included in the database from 11 states (Michigan, Minnesota, Missouri, Nebraska, North Dakota, Ohio, Pennsylvania, South Carolina, South Dakota, Utah, and Wisconsin), with additional data still to be compiled from Colorado and New England. In addition, staff from programs in nine additional states have received training and are in various stages in the process to recruit farms, complete analyses, and provide enough quality data to be included in the database. These states include the New England project that was part of this CFFM project including Extension educators from New Hampshire, Vermont, Connecticut, Maine and Massachusetts; an Auburn Extension effort that is also part of this project to add producers from Alabama; a New York effort with Cornell Extension; a North Carolina effort with North Carolina A & T; a Colorado effort lead by Colorado State University; and a Tennessee effort lead by Tennessee Extension. Initial talks of benchmarking collaboration have also occurred with four new states, Oklahoma, Idaho, Montana, and Iowa. Data has also been included from three private farm management consultants as part of CFFM's effort to expand the size and scope of the database. Lastly, CFFM has partnered with MN Extension, MN FSA, and SCORE to provide training specific to farm financial analysis, benchmarking, and cash flow projection development. SCORE has partnered nationally with FSA to provide financial management training to farmers and ranchers. FINPACK is the software tool being used to create financial statements for these operations. All data is carefully vetted at several levels to eliminate outliers and assure reporting integrity. The National Database is maintained at the University of Minnesota and is open to any producer to use to generate benchmarking reports on farm financial statements, Farm Financial Standards Council ratios, other whole entity reports, crop enterprise analysis reports, and livestock enterprise analysis reports. During the most recent twelve-month reporting year, 37,108 benchmarking reports were generated through FINBIN. The 2018 database, compiled during 2019, includes 64 organic farms, 22 specialty crop farms, and 13 farms in organic transition. Forty-six (46) producers identified themselves as veterans. CFFM provides ongoing training,education, and software support to partner farm business management programs. Findings from the Analysis Process Efficiency Survey have been used to drive training efforts and analysis support material creation for instructors across the programs involved in benchmarking. This survey was completed recently as a means to help programs gain efficiencies and learn the training needs of instructors and consultants. CFFM also continued to make software improvements to improve the educational value and to provide efficiencies to participating farm management programs. During this period, CFFM has continued the process of updating FINPACK's financial analysis software to include a market channel analysis component. This will be used by several programs to meet the unique needs of analyzing specialty crop and direct marketing farm businesses. In addition, the recent revisions to the FINPACK cash flow projection tools were refined to assist producers and educators with creating a simple annual projection. CFFM has also added features to FINPACK that help increase the efficiency of completing a financial analysis for the farm. Data components transfer more seamlessly from the balance sheet to the financial analysis tool. This increases efficiency in the process, but also leads to greater data integrity. CFFM has also been working the Iowa Farm Business Association to build a tighter interface between the PCMars Farm Accounting Software and FINPACK. This effort will expand the capabilities of the current interface beyond the ability to transfer cash transactions from the accounting software to FINPACK. The expansion will include the transfer of balance sheet loan and inventory items and also provide more synergies in completing the crop and livestock enterprise analysis. The FINPACK Vault continues to be used by more and more of the collaborating benchmark programs. The Vault is a secure repository site for FINPACK data, providing a web-based redundant backup of farm data and seamless extraction for compiling individual farm data into databases. The use of this technology will improve efficiency in data transfer and will also be more secure than current methods of data transfer. CFFM staff publicizes the National Database and the insights that can be gained from the data in various national venues and media outlets. Efforts continue to use the national database to support research programs. One such effort was finalized during the reporting period. This was a survey of MN producers to determine the attributes of Top Farmers. The results of the survey have been analyzed and several presentations have included the results. Publications are also planned to disseminate the results. CFFM continues to foster the virtual farm management pilot initiated between Minnesota Farm Business Management instructors and educators in the New England states. The effort has begun with analysis results hopeful for the coming year. CFFM participated in a project led by the National Center for Appropriate Technology to provide data to evaluate whole-farm crop insurance alternatives for organic producers. CFFM continues to teach the financial management component of NFO Beginning Farmers projects. The "AgProfit Strategies" project focuses on conventional grain, beef, and dairy producers in 15 states across the Midwest.CFFM staff have made 1 presentation before the project was put onhold because of COVID. Previous programs had CFFM making 36 total presentations for beginning organic producers across the Midwest. Data from the National Farm Business Management Benchmarking Database is used to provide financial insight to conventional and organic producers.

Publications

  • Type: Websites Status: Published Year Published: 2018 Citation: FINBIN, Center for Farm Financial Management, University of Minnesota, http://www.finbin.umn.edu
  • Type: Other Status: Published Year Published: 2019 Citation: Nordquist, Dale and Pauline Van Nurden, 2018 FINBIN Report on Minnesota Farm Finances, Center for Farm Financial Management, University of Minnesota, May 2019.
  • Type: Other Status: Published Year Published: 2019 Citation: Van Nurden, Pauline A., Donald L. Nitchie, Garen J. Paulson, Tonya L. Knorr, and Dale W. Nordquist, 2018 Annual Report of the Southwestern Minnesota Farm Business Management Association, Staff Paper


Progress 09/01/18 to 08/31/19

Outputs
Target Audience:The primary goal of this project is to provide a national farm financial benchmarking database that will allow any farmer in the nation to compare their financial performance with a selected peer group of like farms. Therefore, the target audience of this project is all farmers in the U.S. The more direct audience is that group of farmers who are participants in farm business management education programs and who contribute to the National Farm Financial Management and Benchmarking Database. To date, complete financials for 3,362 participating farms from nine partner farm management education programs are currently included in the National Farm Management and Benchmarking Database at http://www.finbin.umn.edu for the 2018 business year. Farms have been compiled and included in the database from 8 states (Michigan, Minnesota, Missouri, Nebraska, North Dakota, South Dakota, Utah, and Wisconsin), with additional data still to be compiled from Colorado, Ohio, New England, Pennsylvania, and South Carolina. Participating farms are provided tools and access to make it possible to directly compare their farms with benchmark peer groups to highlight financial strengths and weaknesses. In 2018, 78% of contributing farms were small or mid-sized farms, the group that is most challenged by today's volatile agricultural economy. Twenty-five percent (25%) were beginning farmers and 33% were young farmers. A special effort was made this year to reach out to veterans. Forty-six (46) participating producers identified themselves as veterans. All farms across the country have access to the FINBIN website, the portal into the national database to generate benchmark reports. They can also use the "Compare Your Farm" feature to enter their financial data and generate peer group benchmarks. A third audience is agricultural lenders, educators and other agricultural professionals who can access FINBIN to generate reports to benchmark their clients, to generate educational material, and to monitor the performance of the ag economy. Finally, the fourth audience is agricultural researchers who can use FINBIN reports to support research in various facets of farm financial management. A more focused effort on research has taken place over the last year with the addition of Dr. Joleen Hadrich as a University of Minnesota faculty member. Dr. Hadrich has completed research on the attributes of top farmers, resilient dairy operations, and the impact of the Market Facilitation Program (MFP) government program. Future research efforts are planned for organic production and the economics of cover crop production. Changes/Problems: Nothing Reported What opportunities for training and professional development has the project provided?CFFM provides extensive training and training resources to partner groups who contribute to the National Farm Business Management Benchmarking Database. This training contributes to the goal of assuring the National Database is accurate and conforms to uniform standards of consistency and data integrity. During this period, CFFM staff provided onsite training to contributors in Minnesota and Wisconsin. Additional training is being planned for early 2020. Training will take place in Pennsylvania, North Carolina, Iowa, and Colorado. The Colorado training will be held for new collaborators including Colorado and Idaho. In addition, the training will be for emerging community college programs in Montana and Nebraska. In addition, several two-day FINPACK training sessions specifically for educators was held in St. Paul, MN. Newly hired collaborators from Minnesota, North Dakota, and Colorado attended to learn how to use the FINPACK financial analysis software. Additionally, an enterprise analysis focused training was held for new collaborators. Attendees were from Minnesota, Wisconsin, and North Dakota. There were several virtual attendees as well from New Hampshire, Colorado, and North Carolina to name a few. CFFM also maintains a full suite of online training resources for FINPACK users. During the reporting period, the online training modules were enhanced to include detailed videos on completing and interpreting the crop and livestock enterprise analysis. White papers providing tips and resources for all FINPACK users are found in the FINPACK Knowledge Base at https://www.cffm.umn.edu/FINPACKkb. Specific tools and resources related to benchmarking are provided to educators across the nation at https://sites.google.com/a/umn. edu/finpackbenchmarking. Encompassed on this website are resources such as training videos on the benchmarking process (including segments on advanced balance sheet analysis, advanced whole-farm analysis, crop enterprise analysis, livestock enterprise analysis, and advance enterprise analysis) and the use of the RankEm software in compiling and reviewing benchmark data for consistency and integrity. Educational programs across the country have also provided analysis efficiency-related resources to assist other users with initiating the benchmarking process with the farmers and ranchers in their area. CFFM recently hosted a National Benchmarking Project Leaders meeting in November to prepare for activities in the next year and to consult on strategic plans for the future. FINPACK software revisions have also been distributed to users in November, including updates the FINAN financial analysis tool where energy corrected milk has been added to the dairy analysis to remain current with industry standards. The RankEm software updates will be released in December. Here the error check report has been broadened this further helps with data integrity and error checking prior to submission for the National Database. Lastly, the technical data dictionary is now compiled for the balance sheet and whole-farm variables and calculations used in the whole farm area of the FINAN financial analysis. Work continues to finalize defining the variables and calculations utilized in the crop and enterprise analysis areas of FINAN. How have the results been disseminated to communities of interest?The primary method used to disseminated farm financial benchmark results is through public access to FINBIN. FINBIN is open to anyone to query for summary financial information or benchmarks on financial metrics. Data queries can filter by farm sizes, type, and several other whole-farm attributes. Enterprise-level queries can filter by specific production practices for crop and livestock enterprises. CFFM staff and others make several national presentations each year using data from the National Database to publicize the results. During this period, presentations included American Bankers Association National Agricultural Bankers Conference where Dale Nordquist and Robert Craven presented; FINPACK Lender's Conference; MN Organic Conference; National Farm Viability Conference; National Farm Management Conference; MN Bank Examiners; the Iowa Ag Credit School in Ames, Iowa and the National School for Ag Lenders in Spearfish, South Dakota; and local Agricultural Lenders Conferences in Minnesota. The Farm Financial Standards Council has incorporated benchmark reports from the National Database into its Financial Guidelines for Agricultural Producers. CFFM staff regularly receives requests from national journalists to provide insights based on trends identified in reports generated through the National Database, including Farm Futures, Public Radio, Farm and Ranch Guide, the Minneapolis Star Tribune, Successful Farming, Farm Progress, AgFax, Ag Week, Farm Journal's MILK Business, The Land, The Farmer, Corn and Soybean Digest, Progressive Dairy, and Wells Fargo's Food for Thought newsletter. FINBIN data is cited in educational resources published by farmdoc Daily, Choices Magazine, and Farm Table. What do you plan to do during the next reporting period to accomplish the goals?CFFM will support partner groups as the complete financial analysis of the 2018 business year with their participants and compile the 2018 data into the national database. CFFM will provide training for all participants who request it and will continue to provide webinars and online training resources to support new and existing users. Special efforts will be aimed at working with the New England project leaders, Alabama, North Carolina, South Carolina, Tennessee, and Oklahoma to help them in their efforts to initiate and expand benchmark program efforts, as well as a new project being led by Colorado State University. These efforts include fostering a virtual farm management trial in an effort to continue the expansion of the national farm financial database.

Impacts
What was accomplished under these goals? The Center for Farm Financial Management (CFFM) worked closely with farm business management educators in partner states to support their educational efforts and to make the National Farm Business Management Benchmarking Database accessible to producers and to educators across the nation. To date, complete financials for 3,362 participating farms from nine partner farm management education programs are currently included in the National Farm Management and Benchmarking Database at http://www.finbin.umn.edu for the 2018 business year. Farms have been compiled and included in the database from 8 states (Michigan, Minnesota, Missouri, Nebraska, North Dakota, South Dakota, Utah, and Wisconsin), with additional data still to be compiled from Colorado, Ohio, New England, Pennsylvania, and South Carolina. In addition, staff from programs in nine additional states have received training and are in various stages in the process to recruit farms, complete analyses, and provide enough quality data to be included in the database. These states include the New England project that was part of this CFFM project including Extension educators from New Hampshire, Vermont, Connecticut, Maine and Massachusetts; an Auburn Extension effort that is also part of this project to add producers from Alabama; a New York effort with Cornell Extension; a North Carolina effort with North Carolina A&T; a Colorado effort led by Colorado State University; and a Tennessee effort led by Tennessee Extension. Initial talks of benchmarking collaboration have also occurred with four new states, Oklahoma, Idaho, Montana, and Iowa. Data has also been included from three private farm management consultants as part of CFFM's effort to expand the size and scope of the database. Lastly, CFFM has partnered with MN Extension, MN FSA, and SCORE to provide training specific to farm financial analysis, benchmarking, and cash flow projection development. SCORE has partnered nationally with FSA to provide financial management training to farmers and ranchers. FINPACK is the software tool being used to create financial statements for these operations. All data is carefully vetted at several levels to eliminate outliers and assure reporting integrity. The National Database is maintained at the University of Minnesota and is open to any producer to use to generate benchmarking reports on farm financial statements, Farm Financial Standards Council ratios, other whole entity reports, crop enterprise analysis reports, and livestock enterprise analysis reports. During the most recent twelve-month reporting year, 45,127 benchmarking reports were generated through FINBIN. The 2018 database, compiled during 2019, includes 63 organic farms, 22 specialty crop farms, and 13 farms in organic transition. Forty-six (46) producers identified themselves as veterans. CFFM provides ongoing training,education, and software support to partner farm business management programs. Findings from the Analysis Process Efficiency Survey have been used to drive training efforts and analysis support material creation for instructors across the programs involved in benchmarking. This survey was completed recently as a means to help programs gain efficiencies and learn the training needs of instructors and consultants. CFFM also continued to make software improvements to improve the educational value and to provide efficiencies to participating farm management programs. During this period, CFFM has continued the process of updating FINPACK's financial analysis software to include a market channel analysis component. This will be used by several programs to meet the unique needs of analyzing specialty crop and direct marketing farm businesses. In addition, the recent revisions to the FINPACK cash flow projection tools were refined to assist producers and educators with creating a simple annual projection. CFFM has also added features to FINPACK that help increase the efficiency of completing a financial analysis for the farm. Data components transfer more seamlessly from the balance sheet to the financial analysis tool. This increases efficiency in the process, but also leads to greater data integrity. CFFM has also been working the Iowa Farm Business Association to build a tighter interface between the PCMars Farm Accounting Software and FINPACK. This effort will expand the capabilities of the current interface beyond the ability to transfer cash transactions from the accounting software to FINPACK. The expansion will include the transfer of balance sheet loan and inventory items and also more synergies in completing the crop and livestock enterprise analysis. The FINPACK Vault continues to be used by more and more of the collaborating benchmark programs. The Vault is a secure repository site for FINPACK data, providing a web-based redundant backup of farm data and seamless extraction for compiling individual farm data into databases. The use of this technology will improve efficiency in data transfer and will also be more secure than current methods of data transfer. CFFM staff publicizes the National Database and the insights that can be gained from the data in various national venues and media outlets. Efforts continue to use the national database to support research programs. One such effort was finalized during the reporting period. This was a survey of MN producers to determine the attributes of Top Farmers. The results of the survey have been analyzed and several presentations have included the results. Publications are also planned to disseminate the results. CFFM continues to foster the virtual farm management pilot initiated between Minnesota Farm Business Management instructors and educators in the New England states. The effort has begun with analysis results hopeful for the coming year. CFFM continues to participate in a project led by the National Center for Appropriate Technology to provide data to evaluate whole-farm crop insurance alternatives for organic producers. Results are also being disseminated as part of an NFO Beginning Farm project titled FarmStarts. CFFM staff made 36 total presentations across the Midwest using data from the National Farm Business Management Benchmarking Database to provide financial insight to organic producers and those considering organic production. A second FarmStarts program will begin during the grant period focusing on conventional grain and dairy production. CFFM will again collaborate on this project.

Publications

  • Type: Websites Status: Published Year Published: 2018 Citation: FINBIN, Center for Farm Financial Management, University of Minnesota, http://www.finbin.umn.edu
  • Type: Other Status: Published Year Published: 2018 Citation: Van Nurden, Pauline A., Donald L. Nitchie, Garen J. Paulson, Tonya L. Knorr, and Dale W. Nordquist, 2017 Annual Report of the Southwestern Minnesota Farm Business Management Association, Staff Paper
  • Type: Other Status: Published Year Published: 2018 Citation: Nordquist, Dale and Pauline Van Nurden, 2017 FINBIN Report on Minnesota Farm Finances, Center for Farm Financial Management, University of Minnesota, May 2018.