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
Made with FlippingBook Learn more on our blog