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

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).