UNIT 5 Business Accounting P3

Column1 Column2 Column3 Column4
Cash flow forecast
Business: Alan Hull
Period Jan - Dec

Jan Feb Mar
Balcance B/F 1,050.00 1565.00 1000.00
Income
Owner's capital 0 0 5000
Bank loan 0 0 3000
Cash Sales 37,800 34,020 31,500
Credit Sales 0 0 0
Rent Received 250 250 250
VAT on Sales 7,560 6,804 6,300
Total Receipts 45,610 41,074 46,050
Total cash available 46,660.00 42,639.00 47,050.00

Expenses
Vehicle 0 0 9000
Mortgage 950 950 950
Business rated 0 0 360
Wages extra 0 0 0
Wages 7600 7600 7600
Drawings 1,700.00 1,700.00 1,700.00
Advertising 175 175 175
Insurance 110 110 110
Loan repayment -interest 0 0 0
Loan repayment -capital 0 0 0
Purchases 27,000.00 24,300.00 22,500.00
VAT on purchases 5,400.00 4,860.00 4,500.00
VAT paid to C & E 2,160.00 1,944.00 1,800.00
Overdraft interest 0 0 0
Total Payments 45,095.00 41,639.00 48,695.00



Balance C/F 1,565.00 1,000.00 -1,645.00
Total