Cash Flow

Cash In 1 2 3 4 5 6
Sales 450 450 450 450 450 450
Revenue
Loan 400 / / / / /
Sales Revenue Total Cash 850 450 450 450 450 450
+ Loan In
Cash Out
Van Rental 100 100 100 100 100 100
Stock 150 150 150 150 150 150
Cash In – Other Costs 100 100 100 100 100 100
Cash Out Total Cash 350 350 350 350 350 350
Out
Net Cash 500 100 100 100 100 100
Flow
Opening 50 550 650 750 850 950
Opening Balance
Balance + Closing 550 650 750 850 950 1050
Net Cash Balance
Flow




Cash In January February March April May June July August September

Sales Revenue / / / / / 120,000 / / 120,000

Loan 130,000 / / / / / / / /
Total Cash In 130,000 0 0 0 0 120,000 0 0 120,000

Cash Out
Land 100,000 / / / / / / / /
Materials 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000

Wages 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000
Interest 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000
Other Costs 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000

Total Cash Out 116,000 16,000 16,000 16,000 16,000 16,000 16,000 16,000 16,000

Net Cash Flow 14,000 (16,000) (16,000) (16,000) (16,000) 104,000 (16,000) (16,000) 104,000

Opening 5000 19,000 3000 (13,000) (29,000) (45,000) 59,000 43,000 27,000
Balance
Closing 19,000 3,000 (13,000) (29,000) (45,000) 59,000 43,000 27,000 131,000
Balance