Livestock Budget 2019-2020
FORECAST CASHFLOW 1ST APRIL 2019 – 1ST MARCH 2020
12Mth Total 52,800 64,400 9,800
Opening Debtors
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Jan
Feb
Mar
Closing Adj12Mth Debtors Total
INCOME
Livestock BeefSucklerHerd
26,400 7,083
26,400 7,083
52,800 64,400 9,800
Sheep
7,733 2,400
7,083 2,400
7,083 2,500
7,083 2,500
7,083
7,083
7,083
CullSales
OtherIncome Misc
12,000 33,399
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000 32,449
1,000
1,000
1,000
12,000 33,399
SingleFarmPayment
950
TOTALFARMINGINCOME
172,399
1,000
1,000
1,000
11,133
10,483
10,583
10,583
8,083
40,533
8,083
34,483
35,433
172,399
EXPENDITURE
Opening Creditors
Closing Creditors
VariableCosts
Fertilisers
7,699
7,699
7,699
Sprays
500
500
500
Purchases
18,450
4,800
4,800
4,050
4,800
18,450
Feeds
13,511 7,500 9,750 2,500
2,535
3,147
1,272
1,272
660 625 813 208
660 625 813 208
660 625 813 208
660 625 813 208
660 625 813 208
660 625 813 208
660 625 813 208
660 625 813 208
13,511 7,500 9,750 2,500
Vet&Medical
625 813 208
625 813 208
625 813 208
625 813 208
Sundry Straights
FixedCosts Water&Drainage GeneralRepairs CasualLabour MachineryCosts
2,000 2,500
167 208 417 417 217
167 208 417 417 417
167 208 417 417
167 208 417 417 217 300 265 354 500 317
167 208 417 417 417
167 208 417 417
167 208 417 417 217
167 208 417 417 417
167 208 417 417
167 208 417 417 217
167 208 417 417 417
167 208 417 417
2,000 2,500
5,000 5,000 7,600 24,405
5,000 5,000 7,600 24,405
Fuel&Oil
1,267
1,267 3,952
1,267
1,267
Contract&Hire
8,202
10,402
1,850
TotalElectricity
1,200 1,980 4,250 2,500 1,400 8,400 1,051 4,794 75
300 265 354
300 265 354
300 265 354
1,200 1,980 4,250 2,500 1,400 8,400 1,051 4,794 75
Office
115 354
115 354
115 354
115 354
115 354
115 354
115 354
115 354
General Insurance ProfessionalFees Miscellaneous
2,000
317
17
17
17
17
317
17
17
317
17
17
Rent
4,200
4,200
BankCharges Bank Interest
19
19
19
19
56
214 399
390 399
391 399
Loan&HP Interest
399
399
399
399
399
399
399
399
399
TOTALOPERATINGCOSTS Cap&PivRecipts Cap&PrivExpenditure MachineryBought MachineryLease/HP
132,065
12,098
14,122
13,978
15,394
19,437
13,668
12,406
4,835
5,667
5,758
9,035
5,667
132,065
2,000 3,324 5,000 1,200
2,000
2,000 3,324 5,000 1,200
277 417 100
277 417 100
277 417 100
277 417 100
277 417 100
277 417 100
277 417 100
277 417 100
277 417 100
277 417 100
277 417 100
277 417 100
LoansRepaid
Pensions
LifeAssurance Class IVN.I.C. CouncilTax CashDrawn
240 240
20 20
20 20
20 20
20 20
20 20
20 20
20 20
20 20
20 20
20 20
20 20
20 20
240 240
1,500 12,000
125
125
125
125
125
125
125
125
125
125
125
125
1,500 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
ScheduleD/CorporationTax
2,000
1,000
1,000
2,000
NetCapital&PrivateMovements
-27,504
-1,959
-1,959
-1,959
-2,959
-1,959
-1,959
-1,959
-3,959
-1,959
-2,959
-1,959
-1,959
MONTHLYCASHFLOW OpeningBalances
12,830
-13,056 -15,081 -14,936 -7,220
-10,912 -5,044
-3,781
-711
32,907
-633
23,489
27,808
CurrentAccBalance DepositAccBalance
-10,000
BankBalance
-10,000
-23,056 -38,137 -53,074 -60,294 -71,206 -76,249 -80,031 -80,741 -47,834 -48,467 -24,978 2,830
BalanceAtYearEnd
2,830
2,830
Made with FlippingBook - professional solution for displaying marketing and sales documents online