Get documents about "Economist Budget
Document Sample
CONFIDENTIAL CONFIDENTIAL CONFIDENTIAL CONFIDENTIAL CONFIDENTIAL
Head office use only
(indicate yes once used)
APPENDIX A ANNUAL BUDGET Bookkeepers
Beginning Month: Apr-06 Budget Survey
NAME: A Grower REAMS use only
MILL: AK (please indicate yes if an update)
Number: 123456 UPDATE
DATE
Assumptions: Normal Season
BUDGET SUMMARY # 30-Aug-10 All Enterprises Crop Only
R Total R/t
TOTAL FARM INCOME (A) 1,224,929 213
LESS: TOTAL FARM EXPENSES (D) 1,015,363 176
NET FARM PROFIT (A-D) 209,566 36
LESS: CAPITAL OUTFLOW (B) 152,946 27
NET MARGIN (A-D-B) 56,620 10
LESS: NON-FARM EXPENSES (C) 28,980 5
ESTIMATED CASH (A-D-B-C) 27,640 5
SURPLUS
CROP PRODUCTION INFORMATION 1 2 3 Total Yields/ha
Tons mill crop tons 5,755 - - 5,755
Tons seed crop tons - - - -
Area under crop ha 97.8 - - 98 59 t crop/AUC
Harvest area ha 100% 97.8 - - 98 59 t crop/Ha harvest
Replant/Plant area ha 10% 10.0 - - 10
% RV tons 12.70% - -
Tons RV 731 - - 731 7.5 t suc./ha cut
Page 1 - 8/30/2010
Name: A Grower
A INCOME:
INCOME: R
CROP: Total sales 731 t RV R1,660.00 /t _______________ __________ ________ _________ ________ 1,213,269
Retention Interest 10% ___________ _____________ _______________ __________ ________ _________ ________ 2,912
RV Cost Compensation R 1.52 ___________ _____________ _______________ __________ ________ _________ ________ 8,748
Seed cane R0 per ton _____________ _______________ __________ ________ _________ ________ -
OTHER: Other 1 _ _________ ___________ _____________ _______________ __________ ________ _________ ________ -
Other 2 _ _________ ___________ _____________ _______________ __________ ________ _________ ________ -
Other 3 _ _________ ___________ _____________ _______________ __________ ________ _________ ________ -
Other 4 _ _________ ___________ _____________ _______________ __________ ________ _________ ________ -
-
CAPITAL: Seasonal loan - crop _ _________ ____________ April 2001 Month Rec __________ ________ _________ ________ -
Other _ _________ ____________ Month Rec __________ ________ _________ ________ -
Interest Subsidy _ _________ _________________________ Month Rec __________ ________ _________ ________ -
(A) TOTAL 1,224,929
B CAPITAL OUTFLOW
CAPITAL OUTFLOW: R
REDEMPTION'S: Bonds Bank J-D _R 1,639,000 __________ 9.50% _________ ________ 64,348
Specify _______________ __________ 12.00% _________ ________ -
Loans Specify S,O,N,D _______________ __________ 11.50% _________ ________ -
Specify _______________ __________ 11.50% _________ ________ -
Specify S,O,N,D _______________ __________ ________ _________ ________ -
H.P's Bakkie R 5,027 per month for 12 Mnths _________ ________ 60,324
Case Tractor R 2,356 per month for 12 Mnths _________ ________ 28,274
Specify per month for __________ Mnths _________ ________ -
Specify per month for __________ Mnths _________ ________ -
Specify per month for __________ Mnths _________ ________ -
Specify per month for __________ Mnths _________ ________ -
Seasonal Loan Dec Month Due __________ ________ _________ ________ -
__________ ________ _________ ________ -
CAPEX Motor bike Apr Month Paid __________ ________ _________ ________ -
New Equipment Jul Month Paid __________ ________ _________ ________ -
Fixed Improvements Month Paid __________ ________ _________ ________ -
OTHER _______________ __________ ________ _________ ________ -
(B) TOTAL 152,946
Page 2 - 8/30/2010
Name: A Grower
D FARM EXPENSES
FARM EXPENSES: CROP Other 1 Other 2 Other 3 Other 4 TOTAL
1. TRANSPORT Da Neil Hilo R 24.31 /ton _____________ 139,904 - - - - 139,904
Infield & Load R 0.00 /ton _____________ - - - - - -
2. FERTILISER Plant ___________ _____________ 14,500 - - - - 14,500
Ratoon ___________ _____________ 109,750 - - - - 109,750
Other ___________ _____________ - - - - - -
Lime ___________ _____________ 13,000 - - - - 13,000
3. CHEMICALS Weedicides ___________ _____________ 48,900 - - - - 48,900
Ripener ___________ _____________ 4,600 - - - - 4,600
Other ___________ _____________ - - - - - -
Other ___________ _____________ - - - - - -
4. CONTRACTING Other ___________ _____________ - - - - - -
Other ___________ _____________ - - - - - -
Other ___________ _____________ - - - - - -
5. PLANT MATERIALS Seed ___________ _____________ 22,000 - - - - 22,000
6. CROP LEVIES SASRI, CTS R 1.44 /ton crop _____________ 8,287 - - - - 8,287
P&D, Mill Grp R 0.70 /ton Crop _____________ 4,010 - - - - 4,010
7. CROP INSURANCE R 0.50 /ton crop _____________ 2,878 - - - - 2,878
8. MARKETING COSTS Commission - - - - - -
Packaging - - - - - -
Other - - - - - -
9. WAGES Cut & Stack R0.00 /ton - - - - - -
Bonuses ___________ _____________ - - - - - -
Permanent ___________ _____________ 148,000 - - - - 148,000
Planting ___________ _____________ - - - - - -
Leave ___________ _____________ 2,479 - - - - 2,479
Seasonal Labour ___________ _____________ 87,500 - - - - 87,500
10. OTHER LABOUR Rations ___________ _____________ 12,000 - - - - 12,000
Provident Fund ___________ _____________ - -
WCA ___________ _____________ 2,107 - - - - 2,107
UIF ___________ _____________ 1,480 - - - - 1,480
Skills development ___________ _____________ - - - - - -
Training ___________ _____________ - - -
Medical ___________ _____________ - - - - - -
Protective Clothing ___________ _____________ 8,000 - - - - 8,000
11.SALARIES Salaries R0 /ton _____________ 36,000 - - - 36,000
Medical Aid ___________ _____________ 1,500 - - - - 1,500
Other ___________ _____________ - - - - - -
12. MECH MAINTENANCE Tractor & vehicles ___________ _____________ 33,000 - - - - 33,000
Implements/equipment ___________ _____________ 10,000 - - - - 10,000
General (w/shop, tyres) ___________ _____________ 8,000 - - - - 8,000
Vehicles ___________ _____________ 5,000 - - - - 5,000
Irrigation equipment ___________ _____________ - - - - - -
Other ___________ _____________ - - - - - -
Trailers ___________ _____________ 6,000 - - - - 6,000
13. PLANT HIRE ___________ _____________ - - - - - -
14. FUEL AND LUBE Petrol ___________ _____________ 13,000 - - - 13,000
Diesel ___________ _____________ 52,000 - - - - 52,000
Lubes ___________ _____________ 5,000 - - - - 5,000
15. TRANSPORT IN ___________ _____________ - - - - - -
16. FIXTURE MAINT Buildings ___________ _____________ 10,000 - - - - 10,000
Roads ___________ _____________ - - - - - -
Bridges ___________ _____________ - - - - - -
(D) FARM EXPENSES SUB TOTAL 808,894 - - - - 808,894
Page 3 - 8/30/2010
Name: A Grower
D. FARM EXPENSES CONTINUED:
FARM EXPENSES CONTINUED: CROP Other 1 Other 2 Other 3 Other 4 TOTAL
17. INSURANCE Vehicle & short-term ___________ _____________ 12,000 - - - - 12,000
General insurance ___________ _____________ - - - - - -
18. LICENSES All ___________ _____________ 870 - - - - 870
19. ADMINISTRATION Accounting/Canefarms ___________ _____________ 6,000 - - - - 6,000
Legal/Consulting ___________ _____________ 5,000 - - - - 5,000
Telephone ___________ _____________ 8,400 - - - 8,400
Bank charges ___________ _____________ 3,000 - - - - 3,000
Cell Phone ___________ _____________ - - - - - -
Stationery ___________ _____________ 500 - - - 500
Other ___________ _____________ - - - - - -
Other ___________ _____________ - - - - - -
Other ___________ _____________ - - - - - -
20. SERVICES Electricity ___________ _____________ 18,000 - - - - 18,000
Electrcity irrigation ___________ _____________ - - - - - -
21. SECURITY Chubb ___________ _____________ 3,600 - - - - 3,600
Radios 1,000 - - - - 1,000
22 OTHER LEVIES JSB ___________ _____________ 500 - - - - 500
Other ___________ _____________ - - - - - -
23. CONSUMABLES ___________ _____________ 500 - - - 500
24. LIVESTOCK Comm - Vets and medicines___________ _____________ - - - - - -
Comm - Feed ___________ _____________ 1,800 - - - - 1,800
Comm - Purchases ___________ _____________ - - - - - -
25. FARM ANIMALS Draught animals / other ___________ _____________ - - - - - -
26. FARM LEASE Farm Lease R 0.00 per ton _____________ - - - - - -
Lease 0% of Gross income - -
27. INTEREST Bonds FNB ___________ _____________ 145,024 - - - - 145,024
Specify ___________ _____________ - - - - - -
Specify ___________ _____________ - - - - - -
Loans Lbank Feb _____________ - - - - - -
LBank Feb _____________ - - - - - -
Specify ___________ _____________ - - - - - -
Specify ___________ _____________ - - - - - -
Production loan 20.25% _____________ - - - - - -
20.25% _____________ - - - - - -
O/Bal R 50,000 Bank overdraft ___________ _____________ 275 - (0) - - 275
Interest 14.00%
28. OTHER Legal ___________ _____________ - - - - - -
House lease ___________ _____________ - - - - - -
(D) TOTAL FARM EXPENDITURE 1,015,363 - (0) - - 1,015,363
C. NON-FARM:
NON-FARM: R
Drawings __________ _ _________ ___________ _____________ _______________ __________ ________ _________ ________ 12,000
Life assurance __________ _ _________ ___________ _____________ _______________ __________ ________ _________ ________ 16,980
Other __________ _ _________ ___________ _____________ _______________ __________ ________ _________ ________ -
Other __________ _ _________ ___________ _____________ _______________ __________ ________ _________ ________ -
Other __________ _ _________ ___________ _____________ _______________ __________ ________ _________ ________ -
(C) TOTAL 28,980
ADDITIONAL COMMENTS
Please fill enter any additional comments re. New developments, CAPEX etc that may be of interest to the budget survey here
Page 4 - 8/30/2010
CANEFARMS CASHFLOW PROJECTION - WHOLE BUSINESS Apr-06 to Mar-11 APPENDIX F
CLIENT: A Grower DATE: Aug-10
A.CASH OUT TOTAL Apr-06 May-10 Jun-10 Jul-10 Aug-10 Sep-10 Oct-10 Nov-10 Dec-10 Jan-11 Feb-11 Mar-11
FARM EXPENSES
Transport out 139,904.05 - 6,995 17,488 17,488 17,488 17,488 17,488 17,488 17,488 10,493 - -
Fertiliser - Cane 137,250 - - - - 34,313 34,313 34,313 34,313 - - - -
Fertiliser - Other - - - - - - - - - - - - -
Chemicals - Cane 53,500 - - - 10,700 10,700 10,700 10,700 10,700 - - - -
Chemicals - other - - - - - - - - - - - - -
Contracting - - - - - - - - - - - - -
Plant materials (seed) 22,000 - - - - - - 22,000 - - - - -
Cane levies 12,297 - 615 1,537 1,537 1,537 1,537 1,537 1,537 1,537 922 - -
Crop insurance 2,878 - - - - - - - - - - - 2,878
Marketing Costs - - - - - - - - - - - - -
Wages: Cutters - - - - - - - - - - - - -
Seasonal 87,500 - - 10,000 15,000 15,625 15,625 15,625 15,625 - - - -
Permanent 148,000 12,333 12,333 12,333 12,333 12,333 12,333 12,333 12,333 12,333 12,333 12,333 12,333
Planting - - - - - - - - - - - - -
Leave pay 2,479 207 207 207 207 207 207 207 207 207 207 207 207
Other Labour: Rations 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
Other (WCA, UIF..) 11,587 966 966 966 966 966 966 966 966 966 966 966 966
Salaries 37,500 3,125 3,125 3,125 3,125 3,125 3,125 3,125 3,125 3,125 3,125 3,125 3,125
Mech Maint: Tractor & vehicles 33,000 1,722 1,722 1,722 1,722 1,722 1,722 1,722 1,722 1,722 7,500 5,000 5,000
Implements/equipment 10,000 833 833 833 833 833 833 833 833 833 833 833 833
General (w/shop, tyres) 8,000 667 667 667 667 667 667 667 667 667 667 667 667
Vehicles 5,000 417 417 417 417 417 417 417 417 417 417 417 417
Irrigation equipment - - - - - - - - - - - - -
Trailers 6,000 500 500 500 500 500 500 500 500 500 500 500 500
Plant Hire - - - - - - - - - - - - -
Fuel & Lube: Petrol 13,000 1,083 1,083 1,083 1,083 1,083 1,083 1,083 1,083 1,083 1,083 1,083 1,083
Diesel 52,000 6,333 4,583 4,583 4,583 4,583 4,583 4,583 4,583 4,583 3,000 3,000 3,000
Lube 5,000 1,667 - - 1,667 - - 1,667 - - - - -
Transport in - - - - - - - - - - - - -
Fixture Maint: Buildings 10,000 833 833 833 833 833 833 833 833 833 833 833 833
Sheds - - - - - - - - - - - - -
Fencing/Misc - - - - - - - - - - - - -
Insurance & License 12,870 1,073 1,073 1,073 1,073 1,073 1,073 1,073 1,073 1,073 1,073 1,073 1,073
Administration: Accounting/consulting 11,000 - - 5,000 - - - - 6,000 - - - -
Telephone/Admin, etc 11,900 992 992 992 992 992 992 992 992 992 992 992 992
Services: Electricity 18,000 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500
Water - - - - - - - - - - - - -
Security 4,600 383 383 383 383 383 383 383 383 383 383 383 383
Other levies (JSB, etc) 500 42 42 42 42 42 42 42 42 42 42 42 42
Consumables 500 42 42 42 42 42 42 42 42 42 42 42 42
Farm animals 1,800 150 150 150 150 150 150 150 150 150 150 150 150
Farm lease - - - - - - - - - - - - -
Interest Bonds 145,024 12,085 12,085 12,085 12,085 12,085 12,085 12,085 12,085 12,085 12,085 12,085 12,085
Loans - LB - - - - - - - - - - - - -
Seasonal loan - - - - - - - - - - - - -
Other - - - - - - - - - - - - -
CAPT OUTFLOW Month
Redemption's - Bonds J-D 64,348 5,362 5,362 5,362 5,362 5,362 5,362 5,362 5,362 5,362 5,362 5,362 5,362
Redemption's - Loans (LB) S,O,N,D - - - - - - - - - - - - -
Redemption's - Loans (LB) - - - - - - - - - - - - -
Redemption's - Seasonal loan Dec - - - - - - - - - - - - -
HP Instalments 5027 88,598 7,383 7,383 7,383 7,383 7,383 7,383 7,383 7,383 7,383 7,383 7,383 7,383
CAPEX Investments Apr - - - - - - - - - - - - -
New Equip Jul - - - - - - - - - - - - -
Fixed Imp 0 - - - - - - - - - - - - -
NON - FARM
Drawings 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
Life assurance 16,980 1,415 1,415 1,415 1,415 1,415 1,415 1,415 1,415 1,415 1,415 1,415 1,415
Other - - - - - - - - - - - - -
Other - - - - - - - - - - - - -
VAT - INPUT 14.00% 43,657 1,557 2,622 4,920 4,220 4,220 4,220 4,220 5,060 4,220 3,964 2,015 2,418
TOTAL OUTFLOW 1,240,671 64,669 69,928 98,641 110,308 143,579 143,579 167,245 150,419 82,941 79,269 63,406 66,686
Page 5 - 8/30/2010
CLIENT: A Grower
GROSS CASH IN: TOTAL Apr-06 May-10 Jun-10 Jul-10 Aug-10 Sep-10 Oct-10 Nov-10 Dec-10 Jan-11 Feb-11 Mar-11
Tons cane 5,755 288 719 719 719 719 719 719 719 432
Cane Sales 97.5% 1,182,937 - 59,147 147,867 147,867 147,867 147,867 147,867 147,867 147,867 88,720 - -
Cane Sales Retention 2.5% 30,332 - - - - - - - - - 30,332
Ret Int 2,912 - - - - - - - - - - - 2,912
RV Cost Compensation 8,748 - 437 1,094 1,094 1,094 1,094 1,094 1,094 1,094 656 - -
Seed cane - - - - - - - - - - - - -
Other 1 - - - - - - - - - - - - -
Other 2 - - - - - - - - - - - - -
Other 3 - - - - - - - - - - - - -
Other 4 - - - - - - - - - - - - -
Capital Seasonal loan April 2001 - - - - - - - - - - - - -
Other - - - - - - - - - - - - -
Interest Subsidy 0 - - - - - - - - - - - - -
Vat - Output 14.00% 165,611 - 8,281 20,701 20,701 20,701 20,701 20,701 20,701 20,701 12,421 - -
TOTAL GROSS INFLOW 1,390,540 - 67,865 169,662 169,662 169,662 169,662 169,662 169,662 169,662 101,797 - 33,244
NET INFLOW 1,390,540 - 67,865 169,662 169,662 169,662 169,662 169,662 169,662 169,662 101,797 - 33,244
VAT - PAY/RECEIVE (121,954) 3,975 (21,440) (32,963) (32,963) (32,123) (6,442)
OPENING BALANCE 50,000 50,000 (10,819) (13,032) 36,549 95,903 89,023 115,107 84,561 103,804 158,402 180,930 111,082
CASH OUTFLOW (1,362,625) (60,694) (69,928) (120,081) (110,308) (176,541) (143,579) (200,208) (150,419) (115,064) (79,269) (69,848) (66,686)
CASH INFLOW 1,390,540 - 67,865 169,662 169,662 169,662 169,662 169,662 169,662 169,662 101,797 - 33,244
BALANCE C/F (10,694) (12,882) 36,549 95,903 89,023 115,107 84,561 103,804 158,402 180,930 111,082 77,640
INTEREST 14.00% (125) (150) - - - - - - - - - -
Total short term Interest = (275)
MONTHLY CLOSING BALANCE (10,819) (13,032) 36,549 95,903 89,023 115,107 84,561 103,804 158,402 180,930 111,082 77,640
Apr-06 May-10 Jun-10 Jul-10 Aug-10 Sep-10 Oct-10 Nov-10 Dec-10 Jan-11 Feb-11 Mar-11
2006/7Bank Balance
200,000
150,000
100,000
Rands
50,000
-
Apr-06
Oct-10
Feb-11
Jun-10
Sep-10
Nov-10
Aug-10
Dec-10
Jan-11
May-10
Jul-10
Mar-11
(50,000)
Month
Page 6 - 8/30/2010
CASHFLOW PROJECTION - CROP ONLY Apr-06 to Mar-07 APPENDIX F
CLIENT: A Grower DATE: Aug-10
A.CASH OUT TOTAL Apr-06 May-06 Jun-06 Jul-06 Aug-06 Sep-06 Oct-06 Nov-06 Dec-06 Jan-07 Feb-07 Mar-07
FARM EXPENSES
Transport out 139,904 - 6,995 17,488 17,488 17,488 17,488 17,488 17,488 17,488 10,493 - -
Fertiliser - Crop 137,250 - - - - 34,313 34,313 34,313 34,313 - - - -
Fertiliser - Other -
Chemicals - Crop 53,500 - - - 10,700 10,700 10,700 10,700 10,700 - - - -
Chemicals - Other -
Contracting - - - - - - - - - - - - -
Plant materials (seed) 22,000 - - - - - - 22,000 - - - - -
Crop levies 12,297 - 615 1,537 1,537 1,537 1,537 1,537 1,537 1,537 922 - -
Crop insurance 2,878 - - - - - - - - - - - 2,878
Marketing Costs - - - - - - - - - - - - -
Wages: Bonuses - - - - - - - - - - - - -
Leave pay 2,479 207 207 207 207 207 207 207 207 207 207 207 207
Permanent 148,000 12,333 12,333 12,333 12,333 12,333 12,333 12,333 12,333 12,333 12,333 12,333 12,333
Seasonal 87,500 - - 10,000 15,000 15,625 15,625 15,625 15,625 - - - -
Other Labour: Rations 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
Other (WCA, UIF..) 11,587 966 966 966 966 966 966 966 966 966 966 966 966
Salaries 37,500 3,125 3,125 3,125 3,125 3,125 3,125 3,125 3,125 3,125 3,125 3,125 3,125
Mech Maint: Tractor/trailer 33,000 1,722 1,722 1,722 1,722 1,722 1,722 1,722 1,722 1,722 7,500 5,000 5,000
Implements/equip 10,000 833 833 833 833 833 833 833 833 833 833 833 833
General (Wshop/tyres) 8,000 667 667 667 667 667 667 667 667 667 667 667 667
Motot vehicles 5,000 417 417 417 417 417 417 417 417 417 417 417 417
Irrigation equip - - - - - - - - - - - - -
Trailers 6,000 500 500 500 500 500 500 500 500 500 500 500 500
Plant Hire - - - - - - - - - - - - -
Fuel & Lube: Petrol 13,000 1,083 1,083 1,083 1,083 1,083 1,083 1,083 1,083 1,083 1,083 1,083 1,083
Deisel 52,000 6,333 4,583 4,583 4,583 4,583 4,583 4,583 4,583 4,583 3,000 3,000 3,000
Lube 5,000 1,667 - - 1,667 - - 1,667 - - - - -
Transport in - - - - - - - - - - - - -
Fixture Maint: Buildings 10,000 833 833 833 833 833 833 833 833 833 833 833 833
Sheds - - - - - - - - - - - - -
Fencing/Misc - - - - - - - - - - - - -
Insurance & Licence 12,870 1,073 1,073 1,073 1,073 1,073 1,073 1,073 1,073 1,073 1,073 1,073 1,073
Administration: Accounting/consulting 11,000 - - 5,000 - - - - 6,000 - - - -
Telephone/office, etc 11,900 992 992 992 992 992 992 992 992 992 992 992 992
Services: Electricity 18,000 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500
Water - - - - - - - - - - - - -
Security 4,600 383 383 383 383 383 383 383 383 383 383 383 383
Other levies (JSB, etc) 500 42 42 42 42 42 42 42 42 42 42 42 42
Consumables 500 42 42 42 42 42 42 42 42 42 42 42 42
Farm animals 1,800 150 150 150 150 150 150 150 150 150 150 150 150
Farm lease - - - - - - - - - - - - -
Interest Bonds 145,024 12,085 12,085 12,085 12,085 12,085 12,085 12,085 12,085 12,085 12,085 12,085 12,085
Loans - - - - - - - - - - - - -
Seasonal loan - - - - - - - - - - - - -
Other - - - - - - - - - - - - -
CAPT OUTFLOW
Redemptions - Bonds 64,348 5,362 5,362 5,362 5,362 5,362 5,362 5,362 5,362 5,362 5,362 5,362 5,362
Specify - - - - - - - - - - - - -
Specify - - - - - - - - - - - - -
Redemptions - Seasonal loan Dec - - - - - - - - - - - - -
HP Instalments 88,598 7,383 7,383 7,383 7,383 7,383 7,383 7,383 7,383 7,383 7,383 7,383 7,383
CAPEX Investments Apr - - - - - - - - - - - - -
New Equip Jul - - - - - - - - - - - - -
Fixed Imp 0 - - - - - - - - - - - - -
NON - FARM
Drawings 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
Life assurance 16,980 1,415 1,415 1,415 1,415 1,415 1,415 1,415 1,415 1,415 1,415 1,415 1,415
Other - - - - - - - - - - - - -
Other - - - - - - - - - - - - -
Other - - - - - - - - - - - - -
VAT - INPUT 14.00% 43,657 1,557 2,622 4,920 4,220 4,220 4,220 4,220 5,060 4,220 3,964 2,015 2,418
TOTAL OUTFLOW 1,240,671 64,669 69,928 98,641 110,308 143,579 143,579 167,245 150,419 82,941 79,269 63,406 66,686
CLIENT: A Grower
GROSS CASH IN: TOTAL Apr-06 May-06 Jun-06 Jul-06 Aug-06 Sep-06 Oct-06 Nov-06 Dec-06 Jan-07 Feb-07 Mar-07
Tons cane 5,755 288 719 719 719 719 719 719 719 432 - - -
Crop Sales 97.5% 1,182,937 - 59,147 147,867 147,867 147,867 147,867 147,867 147,867 147,867 88,720 - -
Cane Sales Retention 2.5% 30,332 - - - - - - - - - - - 30,332
Ret Int 2,912 - - - - - - - - - - - 2,912
RV Cost Compensation 8,748 - 437 1,094 1,094 1,094 1,094 1,094 1,094 1,094 656 - -
Seed - - - - - - - - - - - - -
Other 1 - - - - - - - - - - - - -
Capital Seasonal loan April 2001 - - - - - - - - - - - - -
Other - - - - - - - - - - - - -
Interest Subsidy 0 - - - - - - - - - - - - -
Vat - Output 14.00% 165,611 - 8,281 20,701 20,701 20,701 20,701 20,701 20,701 20,701 12,421 - -
TOTAL GROSS INFLOW 1,390,540 - 67,865 169,662 169,662 169,662 169,662 169,662 169,662 169,662 101,797 - 33,244
NET INFLOW 1,390,540 - 67,865 169,662 169,662 169,662 169,662 169,662 169,662 169,662 101,797 - 33,244
VAT - PAY/RECEIVE (121,954) 3,975 (21,440) (32,963) (32,963) (32,123) (6,442)
OPENING BALANCE 50,000 50,000 (10,819) (13,032) 36,549 95,903 89,023 115,107 84,561 103,804 158,402 180,930 111,082
CASH OUTFLOW (1,362,625) (60,694) (69,928) (120,081) (110,308) (176,541) (143,579) (200,208) (150,419) (115,064) (79,269) (69,848) (66,686)
CASH INFLOW 1,390,540 - 67,865 169,662 169,662 169,662 169,662 169,662 169,662 169,662 101,797 - 33,244
BALANCE C/F (10,694) (12,882) 36,549 95,903 89,023 115,107 84,561 103,804 158,402 180,930 111,082 77,640
INTEREST 14.00% (125) (150) - - - - - - - - - -
Total short term Interest = (275)
MONTHLY CLOSING BALANCE (10,819) (13,032) 36,549 95,903 89,023 115,107 84,561 103,804 158,402 180,930 111,082 77,640
Apr-06 May-06 Jun-06 Jul-06 Aug-06 Sep-06 Oct-06 Nov-06 Dec-06 Jan-07 Feb-07 Mar-07
Related docs
