Dairy Farm Annual Cash Flow Projection Template: User's Manual

Abstract

The purpose of the templates described here is to make an annual cash flow and debt repayment projection for a dairy farm for the coming year, based on the past year's figures. The projection is made both on a per cow and a per farm basis. The format is very similar to the "Yearly Cash Flow Planning and "Analysis" page included in most regional dairy farm business summary publications for a number of years (for example, see page 16 of 1984 Northern New York Dairy Farm Business Summary, A.E. Ext. 85-10). The past year's receipts and expenses are entered into the templates along with the projected changes for the coming year. The total farm cash flows are then automatically calculated and the borrowed or equity funds needed for the coming year are determined. The Lotus 1-2-3 electronic spreadsheet software package is required.