Small Farm Business Planning Templates And Instrucitons (Page 45 of 50) in pdf

Appendix 4

: Sample Cash Flow

(cont’d)

Spreadsheet for the First Two Operating

Years

Year Two

New Farm Monthly Cash Flow Statement for the First Operating Year

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Total

I. Personal Savings or checking Account

Opening Balance

1,100

1,200

1,300

1,400

1,500

1,600

1,700

1,800

1,900

2,000

2,100

Contribution (Draw)

100

Ending Balance

1,100

1,200

1,300

1,400

1,500

1,600

1,700

1,800

1,900

2,000

2,100

2,200

II. Business Checking Account

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Year's

4,998

297

329

481

385

287

229

1,044

486

1,178

Total

Beginning Cash in Ckg

Operating Income

500

1,400

2,600

2,300

4,800

7,200

9,600

10,400

9,600

9,400

4,700

67,998

Operating Expenditures

(7,698)

(2,148)

(2,856)

(3,768)

(3,348)

(4,596)

(3,498)

(4,858)

(3,785)

(3,358)

(2,408)

(2,770)

(45,090)

Net Cash Flow From Operations

(7,198)

(1,648)

(1,456)

(1,168)

(1,048)

204

3,702

4,742

6,615

6,242

6,992

1,930

22,908

Cash From Borrowing

4,000

3,500

3,000

1,500

18,500

Subtotal - Available

1,801

1,853

2,097

2,129

2,281

2,185

4,087

5,029

6,844

7,286

7,478

3,108

41,408

Debt Reduction

(500)

(2,500)

(3,500)

(4,500)

(5,500)

(5,000)

(500)

(24,500)

Draws

(1,200)

(14,400)

Contribution To (From) Savings

(100)

(1,200)

Ending balance

297

329

481

385

287

229

1,044

486

1,178

1,308

III. Non-Operational Sources of Cash (Borrowing)

Farm Service Agency (FSA) Loan

Other Loans

4,000

3,500

3,000

1,500

18,500

Subtotal

4,000

3,500

3,000

1,500

18,500

IV. Non-Operational Uses of Cash (Draws and Debt Repayment)

Draw

1,000

12,000

Medical Insurance (2 people)

200

2,400

Total Draws

1,200

14,400

Contribution to Savings

100

1,200

FSA Loan Payment

500

6,000

Other Loan Payments

2,000

3,000

4,000

5,000

4,500

18,500

Total Debt Repayment

500

2,500

3,500

4,500

5,500

5,000

500

24,500

V. Operating Income

Ukiah Farmer's Market

500

1,000

800

1,200

2,400

2,800

3,200

1,500

21,300

Willits Farmer's Market

400

600

400

800

1,200

1,600

2,000

1,000

12,000

San Francisco Farmer's Market

800

2,400

3,200

4,800

4,000

2,000

26,800

Restaurant

200

300

400

200

2,900

Subtotal

500

1,400

2,600

2,300

4,800

7,200

9,600

10,400

9,600

9,400

4,700

63,000

VI. Operating Expenditures

Labor, on farm (1 person @$8/hr)

1,120

1,920

1,280

1,120

17,600

Labor, at market (1 person @$10/hr)

600

### ####

4,800

Worker's Compensation

125

### ####

1,500

Subcontracted Labor

500

1,000

Organic Certification

800

Rent (3 acres @ $350 per acre)

1,056

Utilities

1,020

Gasoline/Diesel Fuels

140

200

250

200

225

200

140

### ####

2,310

Banking/Accounting

150

100

250

Office Expense

480

Auto Maintenance/repairs

100

350

Auto Insurance

188

187

### ####

750

Liability Insurance

225

### ####

900

Tractor Maintenance

200

400

Soil Tests

350

Seed

4,000

500

4,500

Amendments

Compost

350

1,050

Manure

250

750

Gypsum

255

Kelp Meal

200

Fish Meal

150

Liquid Kelp

350

Liquid Fish

200

Biological Innoculants

100

Veggie Mix Meal

100

300

Farmers Market Fees

160

240

160

### ####

1,920

Season Extension

Row Cover

600

Plastic Mulch

350

Miscellaneous

Plastic Shopping Bags

200

800

Total Operating Expense

7,698

2,148

2,856

3,768

3,348

4,596

3,498

4,858

3,785

3,358

2,408

2,770

44,740

12. Appendix 4_CashFlo#A78C.xls Year 2

Unit 2.0 | 45

Appendix 4

Small Farm Business Planning

Small Farm Business Planning Templates And Instrucitons Page 45

Related Articles

Related forms

Related Categories