Dairy Farm Annual Cash Flow Projection Template User's Manual
Johnson, Dale; Lazarus, William F.
The purpose of the templates described here is to make an annual cash flow projection for a dairy farm for the coming year, based on the past year's cash flows. 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 1983 Northern New York Dairy Farm Business Summary, A.E. Ext. 84-8). The past year's cash 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. This procedure requires the use of the Lotus 1-2-3 electronic spreadsheet software package and an IBM PC, XT, or IBM compatible microcomputer with 256K bytes of random-access (RAM) memory.
Charles H. Dyson School of Applied Economics and Management, Cornell University