Investment Cash Requirement

What would the cash projections for the investment in isolation look like (assume VAT at 20%)?

Cash Projections: Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 Total
Sales Income
VAT on Sales
Total Income
Purchases
VAT on Purchases
Wages (net) £800 £800 £800 £800 £800 £800 £800 £800 £800 £800 £800 £800 £9,600
PAYE & NIC £0 £300 £300 £300 £300 £300 £300 £300 £300 £300 £300 £300 £3,300
Expenses £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
VAT on Expenses £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Stationery £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Telephone
VAT on Overheads
Rent
New Van
New Machine
VAT on Capital Spend
VAT Return
Total Spend
Net Income
Bank Start Balance £0
Bank End Balance

 

Download Template (.pdf)

Previous Page Next Page

Contents