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