Cash Flow Template[2]

New Farm Monthly Cash Flow Statement for the First Operating Year 1/28/2008 9:56 PM page 1 of 6 Cash Flow Template Enter in the purple cells, the green cells have formulas. Enter your equipment needs and your operational costs, based on your farm plan and your research. Now you can research sources of financing or modify your farm plan so you will not need to borrow. Once you have estimated your projected monthly income and expense based on your farm plan and your marketing plan, work on your financing plan by entering amounts you will need to borrow or contribute from savings in any month that shows a negative balance in the checking account. Enter your income projections based on your marketing plan. You may do aditional calculations of quantity and price to justify your entries. Poppy Davis, CPA USDA Risk Management Agency page 1 of 6New Farm Monthly Cash Flow Statement for the First Operating Year 1/28/2008 9:56 PM page 2 of 6 Cash Flow Template Poppy Davis, CPA USDA Risk Management Agency page 2 of 6New Farm Monthly Cash Flow Statement for the First Operating Year 1/28/2008 9:56 PM page 3 of 6 * Note: Purple cells for input Green cells have formulas I. Personal Savings or Checking Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total Opening Balance -----------Contribution (Draw) Ending Balance ------------II. Business Checking Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Beginning Cash in Ckg -----------Operating Income -------------Operating Expenditures -------------Net Cash Flow From Operations -------------Cash From Borrowing -------------Subtotal -Available -------------Capital Expenditures -------------Debt Reduction -------------Draws -------------Contribution To (From) Savings -------------Ending balance -------------III. Non-Operational Sources of Cash (Borrowing) Farm Service Agency (FSA) Loan -Other Loans -Subtotal -------------IV. Non-Operational Uses of Cash (Draws and Debt Repayment) Draw -Other Necessary personal expenses -Total Draws -------------Contribution to Savings -FSA Loan Payment -Other Loan Payments -Total Debt Repayment -------------V. Operating Income Source #1 -Source #2 -Source #3 -Source #4 -Subtotal -----------Year's Total Poppy Davis, CPA USDA Risk Management Agency page 3 of 6New Farm Monthly Cash Flow Statement for the First Operating Year 1/28/2008 9:56 PM page 4 of 6 * Note: Purple cells for input VI. Operating Expenditures Labor, on farm (hoursxrate) -Labor, at market (hoursxrate) -Worker's Compensation -Subcontracted Labor (hoursxrate) -Organic Certification -Rent (acresxrate) -Utilities -Gasoline/Diesel Fuels -Banking/Accounting -Office Expense -Auto Maintenance/repairs -Auto Insurance -Liability Insurance -Tractor Maintenance -Soil Tests Seed -Amendments Compost -Manure -Gypsum -Kelp Meal -Fish Meal -Liquid Kelp -Liquid Fish -Biological Innoculants -Veggie Mix Meal -Farmers Market Fees -Season Extension Row Cover -Plastic Mulch -Miscellaneous Plastic Shopping Bags -Total Operating Expense -------------Poppy Davis, CPA USDA Risk Management Agency page 4 of 6New Farm Monthly Cash Flow Statement for the First Operating Year 1/28/2008 9:56 PM page 5 of 6 Purple cells for input Green cells have formulas I. Personal Savingsor Checking Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total Opening Balance ------------Contribution (Draw) Ending Balance ------------II. Business Checking Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Beginning Cash in Ckg ------------Operating Income -------------Operating Expenditures -------------Net Cash Flow From Operations -------------Cash From Borrowing -------------Subtotal -Available -------------Debt Reduction -------------Draws -------------Contribution To (From) Savings -------------Ending balance -------------III. Non-Operational Sources of Cash (Borrowing) Farm Service Agency (FSA) Loan -Other Loans -Subtotal -------------IV. Non-Operational Uses of Cash (Draws and Debt Repayment) Draw -Other Necessary personal expenses -Total Draws -------------Contribution to Savings -FSA Loan Payment -Other Loan Payments -Total Debt Repayment -------------V. Operating Income Source #1 -Source #2 -Source #3 -Source #4 -Subtotal -----------Vi. Operating Expenditures Year's Total Poppy Davis, CPA USDA Risk Management Agency page 5 of 6New Farm Monthly Cash Flow Statement for the First Operating Year 1/28/2008 9:56 PM page 6 of 6 Purple cells for input Labor, on farm (hoursxrate) -Labor, at market (hoursxrate) -Worker's Compensation -Subcontracted Labor (hoursxrate) -Organic Certification -Rent (acresxrate) -Utilities -Gasoline/Diesel Fuels -Banking/Accounting -Office Expense -Auto Maintenance/repairs -Auto Insurance -Liability Insurance -Tractor Maintenance -Soil Tests Seed -Amendments Compost -Manure -Gypsum -Kelp Meal -Fish Meal -Liquid Kelp -Liquid Fish -Biological Innoculants -Veggie Mix Meal -Farmers Market Fees -Season Extension Row Cover -Plastic Mulch -Miscellaneous Plastic Shopping Bags -Total Operating Expense -------------Poppy Davis, CPA USDA Risk Management Agency page 6 of 6