Actual Forecast Forecast Forecast Forecast Forecast

Week start 14-Aug 21-Aug 28-Aug 4-Sep 11-Sep 18-Sep

Week end 20-Aug 27-Aug 3-Sep 10-Sep 17-Sep 24-Sep
Week no. 0 1 2 3 4 5

Cash beginning 20,000 17,300 27,600 32,520 37,570

Change in cash (2,700) 10,300 4,920 5,050 (1,500)
Cash ending 20,000 17,300 27,600 32,520 37,570 36,070

CASH INFLOWS

Paying on time customers 25,000 18,800 14,780 8,000 36,000

Customer 1 12,000 21,000
Customer 2 5,800 7,500 7,000
Customer 3 1,000 1,500
Customer 4 15,000
Customer 5 1,500 1,000
Customer 6 12,000 12,000 2,580
Customer 7
Customer 8 1,700
Customer 9
Customer 10 1,000

Late paying customers 12,000 1,000 4,280 500 400

Customer 1 12,000 2,580
Customer 2 500
Customer 3 1,700 400
Customer 4
Customer 5 1,000

Other inflows 12,000 - 4,280 500 400

Cash sales and new sales 12,000 2,580
Advances received 500
Other receivables to be collected 1,700 400
Loans or overdrafts

Total cash inflows 49,000 19,800 23,340 9,000 36,800

CASH OUTFLOWS

Due amounts to suppliers 26,000 4,000 7,280 1,000 36,000

Supplier 1 21,000
Supplier 2 3,000
Supplier 3 1,000 1,500
Supplier 4 15,000
Supplier 5 1,500 1,000
Supplier 6 25,000 2,580
Supplier 7
Supplier 8 1,700
Supplier 9
Supplier 10 1,000

Postponed payments to supp 12,000 1,000 4,280 500 400

Supplier 1 12,000 2,580
Supplier 2 500
Supplier 3 1,700 400
Supplier 4
Supplier 5 1,000

Other outflows 13,700 4,500 6,860 2,450 1,900

Salaries and bonuses 12,000 2,580
Rent and utilities 1,200
Other liabilites that should be paid (in books) 1,700 400
Expected advance payments to suppliers
Equipment purchase 1,200 2,580
Maintenance 500
Phone & internet 750
Post office 250
Travel
Office supplies
Legal and Accounitng fees 750
Consultants 500 500
Licenses
Loans and interest payments 4,500

Total cash outflows 51,700 9,500 18,420 3,950 38,300

40,000 37,570
36,070
35,000 32,520
30,000 27,600
25,000 22,87
20,000
20,000 17,300
15,000

10,000

5,000

20-Aug 27-Aug 3-Sep 10-Sep 17-Sep 24-Sep 1-Oc

Download full Corporate Finance Modeling Set

https://robojan.gumroad.com/l/CFmodeling?layout=profile
Forecast Forecast Forecast Forecast Forecast Forecast Forecast Forecast
25-Sep 2-Oct 9-Oct 16-Oct 23-Oct 30-Oct 6-Nov 13-Nov
1-Oct 8-Oct 15-Oct 22-Oct 29-Oct 5-Nov 12-Nov 19-Nov
6 7 8 9 10 11 12 13

36,070 22,870 26,370 27,670 24,720 24,220 17,220 20,020

(13,200) 3,500 1,300 (2,950) (500) (7,000) 2,800 2,050
22,870 26,370 27,670 24,720 24,220 17,220 20,020 22,070

4,280 4,000 5,080 5,780 10,320 2,700 10,080 2,700

2,580
1,000 2,580 2,580 1,000 1,000
2,580 1,500 7,500

3,000 2,580 2,580

2,500
1,700 1,700 1,700 1,700

2,580 2,580

1,700 250 1,500 1,700 2,580 1,700 2,580 1,700

1,500
1,700 250 1,700 1,700 1,700

2,580 2,580

1,700 2,750 1,500 1,700 1,200 6,900 4,500 5,700

1,200 5,200 4,000
2,500 1,500 4,500
1,700 250 1,700 1,700 1,700

7,680 7,000 8,080 9,180 14,100 11,300 17,160 10,100

4,280 3,000 2,580 5,780 10,320 1,700 10,080 1,700

2,580
2,580 2,580
2,580 1,500 7,500

3,000 2,580 2,580

1,700 1,700 1,700 1,700

2,580 2,580

1,700 250 1,500 1,700 2,580 1,700 2,580 1,700

1,500
1,700 250 1,700 1,700 1,700
 2,580 2,580

14,900 250 2,700 4,650 1,700 14,900 1,700 4,650

12,000 12,000
1,200 1,200
1,700 250 1,700 1,700 1,700

1,500
750 750
250 250
1,200 1,200 1,200 1,200 1,200

750 750
500 500

20,880 3,500 6,780 12,130 14,600 18,300 14,360 8,050

37,570
36,070

27,670
26,370
24,720 24,220
22,870 22,070
20,020
17,220

p 10-Sep 17-Sep 24-Sep 1-Oct 8-Oct 15-Oct 22-Oct 29-Oct 5-Nov 12-Nov 19-Nov

ng Set
22,070