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

Appendix 4: Sample Cash Flow Spreadsheet

for the First Two Operating Years

(see for Excel ﬁle)

Year One

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

12,000

100

200

300

400

500

600

700

800

900

1,000

Contribution (Draw)

(12,000)

100

Ending Balance

100

200

300

400

500

600

700

800

900

1,000

1,100

II. Business Checking Account

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Year's

Total

3,111

288

257

119

396

425

652

719

659

426

4,743

Beginning Cash in Ckg

Operating Income

1,000

2,300

4,800

7,200

9,600

10,400

9,600

9,400

4,700

59,000

Operating Expenditures

(8,433)

(2,023)

(2,731)

(3,793)

(3,223)

(4,471)

(3,173)

(4,733)

(3,660)

(3,033)

(2,283)

(2,645)

(44,200)

Net Cash Flow From Operations

(8,433)

(2,023)

(2,731)

(2,793)

(923)

329

4,027

4,867

6,740

6,567

7,117

2,055

14,800

Cash From Borrowing

41,000

1,000

4,500

6,000

3,000

1,500

57,000

Subtotal - Available

32,568

2,088

2,057

3,464

2,196

2,225

4,452

5,519

7,459

7,226

7,543

6,798

71,800

Capital Expenditures

(40,257)

(1,545)

(41,802)

Debt Reduction

(500)

(2,500)

(3,500)

(5,500)

(1,500)

(500)

(21,500)

Draws

(1,200)

(14,400)

Contribution To (From) Savings

12,000

(100)

10,900

Ending balance

3,111

288

257

119

396

425

652

719

659

426

4,743

4,998

III. Non-Operational Sources of Cash (Borrowing)

Farm Service Agency (FSA) Loan

41,000

Other Loans

1,000

4,500

6,000

3,000

1,500

16,000

Subtotal

41,000

1,000

4,500

6,000

3,000

1,500

57,000

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

Draw

1,000

12,000

Medical Insurance

200

2,400

Total Draws

1,200

14,400

Contribution to Savings

100

1,100

FSA Loan Payment

500

5,500

Other Loan Payments

2,000

3,000

5,000

1,000

16,000

Total Debt Repayment

500

2,500

3,500

5,500

1,500

500

21,500

V. Operating Income

Ukiah Farmer's Market

800

1,200

2,400

2,800

3,200

1,500

18,300

Willits Farmer's Market

400

800

1,200

1,600

2,000

1,000

11,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

1,000

2,300

4,800

7,200

9,600

10,400

9,600

9,400

4,700

59,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

1,000

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

100

540

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

350

Total Operating Expense

8,433

2,023

2,731

3,793

3,223

4,471

3,173

4,733

3,660

3,033

2,283

2,645

43,850

Poppy Davis, CPA

USDA Risk Management Agency

Unit 2.0 | 43

Appendix 4

Small Farm Business Planning

Small Farm Business Planning Templates And Instrucitons Page 43

Related Articles

Related forms

Related Categories