Arable Budget 2018-2019

FORECAST CASHFLOW 1ST APRIL 2018 – 31ST MARCH 2019

12Mth Total 100,253 119,625 32,639 90,144 23,040 34,040 72,975

Opening Debtors

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Jan

Feb

Mar

Closing Adj12Mth Debtors Total

INCOME

Crop WinterWheat(LightLand) WinterWheat(HeavyLand)

40,600

16,240 16,820

16,008 17,400

27,405

100,253 119,625 32,639 90,144 23,040 34,040 72,975

85,405

WinterBarley WinterOSR SpringBeans

32,639 90,144

23,040

DPeas

34,040

SugarBeet

27,000

36,525

9,450

OtherIncome Rents

9,200 7,787

600

600

600

600

600

2,600 3,894

600

600

600

600

600

600

9,200 7,787

Misc

3,894

BasicPayment+ELS

101,850

3,150

9,450

89,250

101,850

TOTALFARMINGINCOME

591,553

3,750

600

41,200

600

123,383 40,534

43,110

84,048

86,005

4,494

126,375 37,455

591,553

EXPENDITURE

Opening Creditors

Closing Creditors

VariableCosts

Seed

37,053 63,468 87,873 2,699 5,500 6,000 32,025 4,512 27,300 33,955 19,530 6,000 5,504 12,600 7,000 8,000 79,072 2,410 7,288 42,954

4,914

20,193

3,510

8,436 7,172 8,424

37,053 63,468 87,873 2,699 5,500 6,000 32,025 4,512 27,300 33,955 19,530 6,000 5,504 12,600 7,000 8,000 79,072 2,410 7,288 42,954

Fertilisers

56,295 20,488

Sprays Sundry

6,121

19,535

14,719

12,816

1,754

4,016

220

336

184

879

109

323

648

FixedCosts Water&Drainage GeneralRepairs RegularLabour CasualLabour MachineryCosts Contract&Hire TotalElectricity General Insurance ProfessionalFees Miscellaneous Fuel&Oil Office

375 417

1,000

375 417

1,000

375 417

1,000

375 417

1,000

417

417

417

417

417

417

417

1,417 2,669

2,669

2,669

2,669

2,669

2,669 2,256 2,917 1,681

2,669 2,256 5,808 5,208 992

2,669

2,669

2,669

2,669

2,669

2,917 1,000

2,917 1,681

992

2,917 1,000

2,917 1,000 5,208 1,167

2,917 1,681

992

2,917 1,000

2,917 1,681

992

5,808

5,808

5,808 7,238

208

208 167 625

208 167 375

208

208 167 625 625 250

208 167 625 625 250

208 167 375

208

208 167 625 625 250

1,167

1,167

167 375

1,167

167 375

375

375

375

375

12,600

1,125

4,000

500

250

250

500

250

500

250

4,500

250

Rent

39,536

39,536

BankCharges Bank Interest

42

519

42

42

519

42

42

519

42

42

519

42

1,433

1,916

2,014

1,925

Loan&HP Interest

200

9,963

200

200

11,463

200

200

9,963

200

200

9,963

200

TOTALOPERATINGCOSTS

490,742

56,959

41,076

30,066

24,601

26,887

23,481

77,491

25,166

100,833 19,952

21,041

43,189

490,742

Cap&PivRecipts MachinerySold

1,750

1,750

1,750

Cap&PrivExpenditure MachineryBought MachineryLease/HP2

15,000 8,242 29,285 10,000 20,000

15,000 1,166

15,000 28,242 29,285 10,000 20,000

1,166

1,166

1,166

1,166 29,285

15,416

1,166

1,166

1,166

1,166

1,166

1,166

LoansRepaid Pensions SchoolFees Class IVN.I.C. CouncilTax CashDrawn

833

833

833

833

833

833

833

833

833

833

833

833

1,667

1,667

1,667

1,667

1,667

1,667

1,667

1,667

1,667

1,667

1,667

1,667

140 500

12 42

12 42

12 42

12 42

12 42

12 42

12 42

12

12

12 42

12 42

12 42

140 500

42

42

12,000

1,000

1,000

1,000

1,000

1,000

1,000

1,000

1,000

1,000

1,000

1,000

1,000

12,000

NetCapital&PrivateMovements

-113,417

-4,719

-4,719

-4,719

-34,004

-18,969

-17,969

-4,719

-4,719

-4,719

-4,719

-4,719

-4,719

MONTHLYCASHFLOW OpeningBalances

-12,606

-57,928 -45,196 6,415

-58,005 77,526

-916

-39,100 54,162

-19,547 -20,178 100,614 -10,453

CurrentAccBalance DepositAccBalance

-254,674

BankBalance

-254,674

-312,602 -357,798 -351,383 -409,388 -331,862 -332,778 -371,878 -317,716 -337,263 -357,441 -256,827 -267,280

BalanceAtYearEnd

-267,280

-267,280

Made with FlippingBook - professional solution for displaying marketing and sales documents online