Dairy Budget 2019-2020

FORECAST CASHFLOW 1ST APRIL 2019 – 31ST MARCH 2020

Adj

12Mth

Opening Debtors

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Jan

Feb

Mar

Closing 12Mth Debtors Total

INCOME

Total

Livestock

DairyHerd CullSales

326,012 13,750

27,168 1,146

27,168 1,146

27,168 1,146

27,168 1,146

27,168 1,146

27,168 1,146

27,168 1,146

27,168 1,146

27,168 1,146

27,168 1,146

27,168 1,146

27,168 1,146

326,012 13,750

OtherIncome

BasicPaymentScheme 18,000

18,000

18,000

TOTALFARMINGINCOME

357,762

28,314

28,314

28,314

28,314

28,314

28,314

28,314

28,314

46,314

28,314

28,314

28,314

357,762

EXPENDITURE

Opening Creditors

Closing Creditors

VariableCosts

Fertilisers

16,500 79,590 7,470 11,850 33,750 3,750 6,300 3,750 8,000 4,000 28,000 10,150 5,500 25,100 16,800 1,910 8,000 4,800 2,640 28,000

16,500 6,633

16,500 79,590 7,470 11,850 33,750 3,750 6,300 3,750 8,000 4,000 28,000 10,150 5,500 25,100 16,800 1,910 8,000 4,800 2,640 28,000

Feeds

6,633

6,633

6,633

6,633

6,633

6,633

6,633

6,633

6,633

6,633

6,633

Vet&Medical

623 988 313 525 313

623 988 313 525 313

623 988 313 525 313

623 988 313 525 313

623 988 313 525 313

623 988 313 525 313

623 988 313 525 313

623 988 313 525 313

623 988 313 525 313

623 988 313 525 313

623 988 313 525 313

623 988 313 525 313

Sundry Straights Minerals A.I.Fees

2,813

2,813

2,813

2,813

2,813

2,813

2,813

2,813

2,813

2,813

2,813

2,813

N.M.RRecording

FixedCosts

Water&Drainage GeneralRepairs RegularLabour

667 333

667 333

667 333

667 333

667 333

667 333

667 333

667 333

667 333

667 333

667 333

667 333

2,333

2,333

2,333

2,333

2,333

2,333

2,333

2,333

2,333

2,333

2,333

2,333

MachineryCosts

1,817

417 458 667

417 458

1,667

417 458

417 458

1,667

417 458

417 458 667

1,667

417 458 667

417 458 667

Fuel&Oil

458 667

458

458

458 667

Contract&Hire

5,267

3,167

3,167

3,167

3,167

3,167

TotalElectricity

1,400

1,400

1,400

1,400

1,400

1,400

1,400

1,400

1,400

1,400

1,400

1,400

Office

97

97

97

97

97

97

847 667 900 220

97

97

97

97

97

General Insurance ProfessionalFees Miscellaneous

667 900 220

667 150 220

667 150 220

667 900 220

667 150 220

667 150 220

667 150 220

667 150 220

667 900 220

667 150 220

667 150 220

Rent

2,333

2,333

2,333

2,333

2,333

2,333

2,333

2,333

2,333

2,333

2,333

2,333

BankCharges Bank Interest

75

19 17

19 21

19 55

19 22

75

301

17

13

17

22

22

56

22

18

301

Loan&HP Interest

6,440

537

537

537

537

537

537

537

537

537

537

537

537

6,440

TOTALOPERATINGCOSTS

312,676

24,650

22,519

27,096

27,000

25,023

25,005

44,256

25,057

22,539

24,505

22,524

22,502

312,676

Cap&PrivExpenditure

MachineryLease/HP 7,800

650 667

650 667

650 667

650 667

650 667

650 667

650 667

650 667

650 667

650 667

650 667

650 667

7,800 8,000

LoansRepaid LifeAssurance CouncilTax CashDrawn

8,000

300

25

25

25

25

25

25

25

25

25

25

25

25

300

1,800 26,000

150

150

150

150

150

150

150

150

150

150

150

150

1,800 26,000

2,167

2,167

2,167

2,167

2,167

2,167

2,167

2,167

2,167

2,167

2,167

2,167

NetCapital&PrivateMovements

-43,900

-3,658

-3,658

-3,658

-3,658

-3,658

-3,658

-3,658

-3,658

-3,658

-3,658

-3,658

-3,658

MONTHLYCASHFLOW OpeningBalances

1,186

5

2,136

-2,441

-2,345

-368

-350

-19,600 -402

20,116

150

2,131

2,154

CurrentAccBalance DepositAccBalance

-10,000

BankBalance

-10,000

-9,995

-7,858

-10,300 -12,645 -13,013 -13,363 -32,963 -33,365 -13,249 -13,099 -10,968 -8,814

BalanceAtYearEnd

-8,814

-8,814