Scribd
Upload
52 views9 pages

Cash Flow Budget Analysis Template

The document contains a cash budget for 4 months that shows opening cash balances, cash inflows from sales, and cash outflows for purchases, payroll, utilities, advertising, and other miscellaneous payments. It calculates the net cash flow and ending cash balance each month. The second document is a similar cash budget for 6 months with additional inflows from credit sales. The third document expands the cash budget to 12 months, adds a line for credit purchases being paid the following month, and calculates cumulative cash balances.

Uploaded by

Kyōjux Rinkān
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
52 views9 pages

Cash Flow Budget Analysis Template

The document contains a cash budget for 4 months that shows opening cash balances, cash inflows from sales, and cash outflows for purchases, payroll, utilities, advertising, and other miscellaneous payments. It calculates the net cash flow and ending cash balance each month. The second document is a similar cash budget for 6 months with additional inflows from credit sales. The third document expands the cash budget to 12 months, adds a line for credit purchases being paid the following month, and calculates cumulative cash balances.

Uploaded by

Kyōjux Rinkān
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Cash Budget

Opening
INFLOW
Sales
OUTFLOW
Purchases of stock
pay
Electricit
Advertising
Rates
Misc Payments
Total
Cash and cash equivalent

Cash Budget
Opening
INFLOW
Sales
Credit sales 1 mont
OUTFLOW
Purchases of stock
pay
Electricit
Advertising
Rates
Misc Payments
Total
Cash and cash equivalent

Cash Budget
Opening
INFLOW
Sales
Credit sales 1 mont
OUTFLOW
Purchases of stock
Credit Purchase 1 month
pay
Electricit
Advertising
Rates
Misc Payments

200

250

300

400

100
100

110
100

120
100

20

10

10
230
-75

10
230
-55

115
100
50
10
30
10
315
-70

100

125
100

150
125

200
150

100
100

110
100

120
100

20

10

10
230
-175

10
230
-180

115
100
50
10
30
10
315
-220

10
240
-110

100

125
100

150
125

200
150

100

100
100

115
100

20

10

10

10

110
100
50
10
30
10

-45

0
-45

10
10
240
90

-45

0
-45

10

-45

10
10

Total
Cash and cash equivalent

0
-45

130
-75

220
-70

310
-105

235
10

450

500

130
100
10

140
100
50
10

10
250
290

10
310
480

225
200

250
225

130
100
10

140
100
50
10

10
250
65

10
310
230

225
200

250
225

120
100
10

130
100
50
10

10

10

240
195

300
370

Jan
Inflow
NP SALES
opening
RL Sales Cash
Credit 1 month Paid after purchase
TOTAL
OOUFLOWS
RME
Rate bill
Electricity
Telephone
TOTAL
Cash and Cash Equivalent
Cash Flow

Feb
14
30
7

18

37

9
7
16

24

24

0.25
0.2
24.45
12.55
12.55

24
-8
4.55

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

18

26

50

62

70

50

35

30

9
9
18

13
9
22

25
13
38

31
25
56

35
31
66

25
35
60

17.5
25
42.5

15
17.5
32.5

24

24
1.5
0.25
0.2
25.95
-3.95
-5.4

24

24

24

24

24

24
32
40.6

0.25
0.2
24.45
41.55
82.15

24
36
118.15

24
18.5
136.65

24
1.5
0.25
0.2
25.95
6.55
143.2

24
-6
-1.45

24
14
8.6

Nov

Dec
25

20

12.5
15
27.5

10
12.5
22.5

24

24

24
3.5
146.7

24
-1.5
145.2

Month
Opening
Inflow
Revenue
Cash
10% Credit payable one month
TOTAL
Outflow
Stock
Part time Staf
Rent
Equipment
Electricty
Advert
Personal Expenses
Savings
TOTAL
Cash and Cash Equivalent
Cum

jan

feb

mar

apr

7
1
0.9
0
0.9

2
1.8
0.1
1.9

0.5

0.5
0.2

0.5
0.2

2
1

0.05
1

1
0.1
0.05
1

0.05
1

4
3
3

2.55
-2.55
0.45

2.85
-1.95
-1.5

2.75
-0.85
-2.35

0
7

0
0
0

may

jun

jul

aug

sep

oct

nov

dec

3
2.7
0.2
2.9

4
3.6
0.3
3.9

5
4.5
0.4
4.9

5
4.5
0.5
5

3
2.7
0.5
3.2

2
1.8
0.3
2.1

1
0.9
0.2
1.1

1
0.9
0.1
1

0.5
0.2

1
0.4

1.5
0.4
2

1.5
0.4

1
0.4

0.5
0.2

0.5
0.2

0.5
0.2

1
0.05
1

0.15
0.05
1

0.05
1

0.05
1

0.2
0.05
1

0.05
1

0.05
1

0.15
0.05
1

2.75
0.15
-2.2

2.6
1.3
-0.9

4.95
-0.05
-0.95

2.95
2.05
1.1

2.65
0.55
1.65

1.75
0.35
2

1.75
-0.65
1.35

1.9
-0.9
0.45

You might also like