CFAES Give Today
Farm Office

Ohio State University Extension

CFAES

FARMS Spreadsheet

Farm and Resource Management Spreadsheet (FARMS)

Farm Transition Planning is challenging, in part, because of the need to collect and organize asset information.  Without knowing what assets are owned, the value of the assets and how the assets are titled, farm transition planning becomes more of a guessing game rather than a specific plan.  FARMS (developed by Robert Moore and David Marrison) provides a template to assist with the identification, valuation and titling status of your assets in an organized manner using Microsoft Excel.  FARMS also allows you to collect other information critical to the farm transition process such as identifcation of executors and trustees, funeral instructions and advisor information.  Lastly, and perhaps most importantly, FARMS allows you to use the asset information to run different scenarios for your assets to determine the best distribution plan for your farm transition plan.

Accessing FARMS

Thank you for your interest in downloading the Farm and Resource Management Spreadsheet (FARMS). To receive access to the spreadsheet, we ask you to

1) Watch the short (40 minutes) training video available here: Initial FARMS Training Video or attend one of the Zoom sessions listed below

and

2) Complete a short survey to help us report back to the North Central Risk Management Education Center for the grant we received to help educate farmers and professionals, available here: Training Evaluation. When you have completed the evaluation, you will receive information from our team on how to download the spreadsheet.

If you have any questions, please contact David Marrison (marrison.2@osu.edu) or Robert Moore (moore.301@osu.edu).

Upcoming Online Training Courses

Click on registration link to register for the course.

April 7 @ 10:00 am:   https://osu.zoom.us/meeting/register/oJmnwm-VQx6XjqvBh7J0aA

April 16 @ 10:00 am:  https://osu.zoom.us/meeting/register/iY9cLoJeQwS0rUHkHr3DpA

April 23 @ 1:00 pm:  https://osu.zoom.us/meeting/register/vT_-X56FQQqBT63fKUQW4g

May 2 @ 3:00 pm:     https://osu.zoom.us/meeting/register/KmbdTjq2SryLkYNOaevp3Q

May 28 @ 1:00 pm:    https://osu.zoom.us/meeting/register/FMMlmLZyShSowG_B1X_v8Q

June 10 @10:00 am: https://osu.zoom.us/meeting/register/Wdt7ZoRaSouCfgmtdZ157g

Additional Training Videos 

A series of in-depth videos on each of the tabs of the spreadsheet and each of these can be accessed below:

Video 1: Introduction to FARMS

Video 2: Gather Your Supplies and Info

Video 3: Contact Information and Estate Planning

Video 4: Real Estate

Video 5: Business Entities

Video 6: Personal Property and Debt

Video 7: Statement of Intent and Review

Video 8: Tech and Pink Tabs

Video 9: Green Tabs-Financial and Life Insurance

Video 10: GreenTabs-Real Estate, Business Entities, Personal Property, Farm Assets and Debt

Video 11: Summary Tab

Video 12: Yellow Tabs-Agents


 

Grant Slide

Thank you to the North Central Risk Management Education Center and USDA-NIFA for their support of this outreach program  (USDA/NIFA Award Number 2023-70027-40444).