160 likes | 271 Views
Integrated Farm Financial Statements (IFFS) Software. Oklahoma State University Agricultural Economics Department. IFFS. Additional Information. Crop and Livestock Budgets. Cash flow statement. Debt worksheet. Income statement, financial ratios, stress test. Balance sheet. IFFS.
E N D
Integrated Farm Financial Statements (IFFS) Software Oklahoma State University Agricultural Economics Department
IFFS Additional Information Crop and Livestock Budgets Cash flow statement Debt worksheet Income statement, financial ratios, stress test Balance sheet OSU Ag Econ
IFFS • Planning and analysis tool • OSU • IFMAPS and vo-techs • Case study development for workshops and courses • Farm management courses and labs • Other educators • Lenders • Producers OSU Ag Econ
IFFS • New cost and return estimation software will create IFFS budgets • Quicken data can be imported into IFFS OSU Ag Econ
IFFS OSU Ag Econ
IFFS • Excel 97 • Crop and livestock budget (CLBUD) = 417 KB • Additional Information (AI) = 296 KB • MULTSTAT = 1.913 MB • 65 budgets = 1.54 MB • http://www.agecon.okstate.edu/iffs/ OSU Ag Econ
ProgramAction(s)Files Quicken Print to File Category list Monthly cash flow report(s): By class (enterprise) QLink Import Qkn. categories Import Qkn. data By class (or whole farm) Generate IFFS data By class (or whole farm) IFFS Load QLink generated files using: AI CLBUD Getting Quicken Data to IFFS OSU Ag Econ
Developing a Whole Farm/Ranch Plan • Collect farm financial and production information • Develop enterprise budgets (CLBUD) • Complete Additional Information worksheet (AI) • Record asset and liability information (MULTSTAT) • Load budgets (enterprise budgets and additional information) into MULTSTAT • Review financial statements and summary OSU Ag Econ
IFFS Data Collection • Producer completes: • Trend worksheet • Cash operating expense allocation worksheet • Worksheets summarizing production and, if possible, monthly expense allocation • Asset inventory • Debt worksheet • Other income worksheets • Family living expenses worksheet OSU Ag Econ
Alternative financial plans • Outline changes to be made • Modify budgets • Add, remove budgets • Revise balance sheet • Modify debt worksheet • Save new plan OSU Ag Econ