How it Works – The program allows you to input a number of user-defined variables (blue cells) which are specific to your farm operation and business plan. The spreadsheet-based tool will then yield a variety of valuable reports, summary tables, and analysis that can be used for your farm business and financial plan.
Major features of the Farm Production and Financial Planning Tool Include:
Reports and Analysis – Once you have inputted all of the key data points, the tool will provide the following outputs: Four Year Pro Forma Income Statement, Internal Rate of Return, Net Present Value, Two year monthly cash flow, Executive cash flow summary, Annual, monthly, weekly and seasonal production summaries by growing system, Capital and working capital summary and more.
Scenarios – Multiple revenues and net income scenarios can be easily made to show the best and worst case scenarios for your farm business.
Startup Capital Costs – Input all project capital equipment, construction, greenhouse, supplies and other costs associated with business startup. Input any loan and term information to determine monthly payments if required.
Energy and Water – Input all equipment energy information including any greenhouse HVAC components, Aquaponic System equipment, Artificial Lighting, and auxiliary equipment, utility rates, equipment run times, gas and water consumption estimates.
Plant and Fish Production – Input the scale of the growing systems (DWC, Media Beds and Microgreens), planting density by species, by growing season, culture time, loss rate and other variables to determine specific production numbers. Input daily fish feed rates, stocking densities, number of tanks and other parameters.
Revenue and Cost of Goods – Input plant seed and media costs, how the product is being sold (ie. by the head, lb, case etc.), how the product is packaged and more to determine the variable costs per unit. Input the estimated sale price per unit to determine gross revenues. Input fish feed, fingerling restocking, and fish sale prices.
Startup Curve – Create a startup curve that allows you to realistically project lower revenues in the initial months as your business is just getting started and you are attracting new customers.
Farm Expense Categories – Straight from our own farm business chart of accounts we have provided worksheets for each expense category that connect into the 2 year cash flow and 4 year Pro Forma Income Statement: Plant and IPM Supplies, Distribution Costs, Water Quality Supplies, Nutrients and Adjusters, Office Supplies, Marketing & Advertising, Utilities, Labor, Employee Training, Insurance, Lease, Charitable Contributions, Bad Debt, Professional Services, Bank Fees, Debt Service.