Kansas State University Agricultural Experiment Station and

Cooperative Extension Service K-State Research and Extension is an equal opportunity provider and employer. Issued in furtherance of Cooperative Extension Work, Acts of May 8 and June 30, 1914, as amended. Kansas State University, County Extension Councils, Extension Districts, and United States Department of Agriculture Cooperating, John Floros, Director.

Using Excel for: ●Estimating Machinery Costs

●Budgeting and Enterprise Analysis ●Calculating Principal and Interest Payments

●Analysis of Livestock Economics

As well as: ● Tips and Tricks for Using Excel

● Other Decision Tools on AgManager.info

Using Excel Spreadsheets

Effectively

Kansas State University WORKSHOP SCHEDULE 9:00 a.m. Registration 9:30 a.m. Intro To Excel

10:00 a.m. Spreadsheet 1: Estimating Machinery Costs 10:45 a.m. Break

11:00 a.m. Spreadsheet 2: Crop Budgets 12:00 p.m. Lunch

12:45 p.m. Spreadsheet 3: Principal/Interest Payments 1:30 p.m. Spreadsheet 4: Livestock Economics 2:15 p.m. AgManager Excel Tools 2:45 p.m. Summary and Questions

3:00 p.m. Adjourn

Kansas State University Department of Agricultural Economics

Registration 2012-2013 K-State

“Using Excel Spreadsheets” Workshop

February 21, 2013 Troy, Kansas

Name: _____________________________

Address: ___________________________

City: _____________ State/Zip: _________

Phone: _____________________________

Email: ______________________________

Cost: $15.00 Registration deadline:

February 15, 2013

To Register: Mindy Young

Doniphan County Extension 105 S. Liberty

Troy, KS 66087 Phone:785-985-3623

Fax:785-985-2858 Email: myoung5@ksu.edu

SPEAKERS February 21, 2013 Troy, Kansas

“Using Excel Spreadsheets Effectively”

Doniphan County 4-H Building 211 N. Boder St Troy, KS

SPONSORS:SPONSORS:SPONSORS:

KKK---State Research and ExtensionState Research and ExtensionState Research and Extension

Doniphan County Extension Doniphan County Extension Doniphan County Extension

Kansas State University Kansas State University Kansas State University

Dept. of Agricultural EconomicsDept. of Agricultural EconomicsDept. of Agricultural Economics

Using Excel for: ● Estimating Machinery Costs ● Budgeting and Enterprise

Analysis ● Calculating Principal and

Interest Payments ● Analysis of Livestock Economics

As well as: ● Tips and Tricks for Using Excel

● Other Decision Tools on AgManager.info

Rich Llewelyn Rich Llewelyn is an Extension Assistant in the De-partment of Agricultural Economics at K-State. Raised on a farm near Riley, KS, he is a three-time graduate of K-State with a B.S. degree in Agronomy, and a Masters and PhD in Agricultural Economics. He then spent 13 years teaching economics and working with urban community development in East Java, Indonesia before returning to Kansas in 2006 to work with the AgManager.info website and depart-mental conferences, including the Risk and Profit conference and the state-wide Ag Profitability confer-ences. He has also taught the “Price Analysis and Forecasting” course for undergraduate students and uses Excel in class as well as for a multitude of uses.

“Knowledge for Life” 

Skills to be learned: ● Mathematical calculations ● "Sum" & "Sumproduct" functions ● Link information from other sheets ● Calculate breakeven prices & yields ● Use what-if analysis ● Utilize financial functions ● Use “"If" functions ● Create and use look-up tables ● Excel tools on AgManager.info

Mykel Taylor Mykel Taylor joined the Department of Agricultural Economics as an Assistant Professor in 2011. Her research and extension programs are focused in the areas of crop marketing and farm management. She grew up on a cattle ranch in Montana and attended Montana State University majoring in Agribusiness Management. Her PhD in Economics is from North Carolina State University. Mykel has worked in exten-sion positions at both Kansas State University and Washington State University. Some of her current re-search areas include measuring basis risk for com-modity grains, understanding the implications of food safety and country of origin labeling on meat demand, and evaluating direct marketing strategies for diversi-fied crop and livestock farmers.