Accounting Business Reporting for Decision Making

48 Accounting: Business Reporting for Decision Making

5.2.2 Cash flow forecast (All figures are in Australian dollars)

Murphy Recruiting Pty LtdCASH FLOW FORECAST

for the period July 2015 to June 2016

Jul.

Aug.

Sep.

Oct.

Nov.

Dec.

Jan.

Feb.

Mar.

Apr.

May

Jun.

TOTAL

IncomeFees revenue

$0

$5 000

$5 000

$5 000

$10 000

$0

$0

$10 000

$10 000

$15 000

$15 000

$20 000

$95 000

Capital

10 000

10 000

SundryTotal income

10 000

5 000

5 000

5 000

10 000

0

0

10 000

10 000

15 000

15 000

20 000

105 000

ExpensesAccounting/legal services

1 500

800

200

2 500

Advertising

2 000

100

100

100

180

100

100

100

100

100

100

100

3 180

Bank fees

15

15

15

15

15

15

15

15

15

15

15

15

180

Equipment purchases

8 900

8 900

Equipment leases

0

Insurance

2 500

2 500

Light and power

0

Loan repayments

0

Motor vehicle — fuel

50

50

50

50

50

50

50

50

50

50

50

50

600

Motor vehicle — other costs

0

Petty cash

25

25

25

25

25

25

25

25

25

25

25

25

300

Postage, printing and stationery

400

400

Rent

0

Repairs and maintenance

100

100

100

100

400

Staff superannuation

6 000

6 000

Staff director’s wages

5 400

5 340

6 700

5 220

5 340

5 400

5 220

5 340

5 400

5 220

5 340

5 400

65 320

Telephone

50

50

50

50

50

50

50

50

50

50

50

50

600

Other

100

50

50

50

50

50

50

50

50

50

50

50

650

Total expenses

21 040

5 630

7 790

5 610

5 710

5 690

5 610

5 830

5 690

5 610

5 630

11 690

91 530

Cash surplus/(deficit)

• 11 040
  -^630


• 2 790
  -^610

4 290

• 5 690


• 5 610

4 170

4 310

9 390

9 370

8 310

13 470

Bank balance

0

Start of month

0

(11 040

)

(11 670

)

(14 460

)

(15 070

)

(10 780

)

(16 470

)

(22 080

)

(17 910

)

(13 600

)

(4 210

)

(5 160

)

End of month

(11 040

)

(11 670

)

(14 460

)

(15 070

)

(10 780

)

(16 470

)

(22 080

)

(17 910

)

(13 600

)

(4 210

)

(5 160

)

(13 470

)