Marketing Budget 2

 

TASK. 2 J Smith Cash Budget 2011

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

 

Receipts

Opening balance

-1160

Cash sales

1400

1400

1150

1150

1150

1150

1150

1150

1150

1150

1150

1150

Debtors

900

900

650

650

650

650

650

650

650

650

650

 

Total receipts for month

240

2300

2050

1800

1800

1800

1800

1800

1800

1800

1800

1800

 

Payments

Car credit agreement

150

150

150

150

150

150

150

150

150

150

150

150

Petrol

50

50

50

50

50

50

50

50

50

50

50

50

Insurance and breakedown cover

10

10

10

10

10

10

10

10

10

10

10

10

Car tax

100

Wages

1300

1300

1300

1300

1300

1300

1300

1300

1300

1300

1300

1300

Advertising

100

100

100

100

100

100

100

100

100

100

100

100

 

Total Payments

1610

1610

1610

1710

1610

1610

1610

1610

1610

1610

1610

1610

 

Summery of bank account

Net cashflow

-1370

690

440

90

190

190

190

190

190

190

190

190

Bank balance (overdraft) at beginning

0

-1370

-680

-240

-150

40

230

420

610

800

990

1180

 

Bank balance (overdraft) at end of month

-1370

-680

-240

-150

40

230

420

610

800

990

1180

1370