CASH FLOW YEAR 3
Sales
Loan
Month 1
Actual
380,000
380,000
0
400,000
Production cost
Salary
Depreciation
Utilities
Others
40,000
96,833
0
7,000
90,000
INDIRECT COSTS / Overheads
Rent
Other costs
CAPITAL COSTS/FIXED ASSETS
Equipment
OTHER COSTS
Bank Charges
Loan Repayment
Interest
TOTAL CASH PAID OUT
CASH ON HAND
[Beginning of month]
CASH POSITION
[End of month]
1,127,033
C
A- B + C
TOTAL COSTS Profit & Loss items (before adjustments)
350,000
400,000
0
0
0
3,200
133,333
6,667
4,251,474
3,524,441
-603,833
Month 2
Month 3
Month 4
Month 5
Month 6
Actual
450,000
450,000
0
Actual
800,000
800,000
0
Actual
1,500,000
1,500,000
0
0
Actual
1,000,000
1,000,000
0
0
Actual
550,000
550,000
0
0
450,000
800,000
1,500,000
1,000,000
550,000
65,000
96,833
7,000
7,000
350,000
96,833
0
7,000
100,000
300,000
96,833
0
7,000
120,000
350,000
96,833
0
7,000
39,000
170,000
96,833
0
7,000
6,000
0
0
0
0
0
1,700
133,333
6,667
0
0
0
0
0
3,800
133,333
6,667
0
0
0
0
0
0
0
0
3,700
133,333
6,667
0
0
0
0
0
1,900
133,333
6,667
0
2,600
133,333
6,667
317,533
697,633
666,433
636,533
421,733
3,524,441
3,656,908
3,759,275
4,592,842
4,956,309
3,656,908
3,759,275
4,592,842
4,956,309
5,084,576
274,167
246,167
976,167
507,167
270,167
Month 7
Month 8
Month 9
Month 10
Month 11
Actual
590,000
590,000
0
0
Actual
700,000
700,000
0
0
Actual
600,000
600,000
0
0
Actual
600,000
600,000
0
0
Actual
1,300,000
1,300,000
0
0
590,000
700,000
600,000
600,000
1,300,000
98,000
96,833
0
7,000
90,000
140,000
96,833
0
6,800
100,000
145,000
96,833
0
6,800
80,000
82,000
96,833
0
6,800
70,000
400,000
96,833
0
6,800
85,000
0
0
0
0
0
500
133,333
6,667
0
0
0
0
0
2,900
133,333
6,667
0
0
0
0
0
1,500
133,333
6,667
0
0
0
0
0
2,000
133,333
6,667
0
0
0
0
0
3,770
133,333
6,667
432,333
486,533
470,133
397,633
732,403
5,084,576
5,242,243
5,455,710
5,585,577
5,787,944
5,242,243
5,455,710
5,585,577
5,787,944
6,355,541
298,167
356,367
271,367
344,367
711,367
Month 12
Actual
2,000,000
2,000,000
0
0
2,000,000
700,000
96,833
74,625
6,800
68,000
0
0
0
0
0
2,500
133,333
6,667
Total Cash Flow After 12 months
10,470,000
10,470,000
10,490,000
2,840,000
1,161,996
74,625
83,000
855,000
350,000
400,000
30,070
1,599,996
80,004
NET CASH
1,088,758
#REF!
6,355,541
7,266,783
1,053,742
4,705,379
CASH FLOW YEAR 2
Sales
Loan
Month 1
Actual
400,000
400,000
0
400,000
Production cost
Salary
Depreciation
Utilities
Others
65,000
96,833
0
7,000
70,000
INDIRECT COSTS / Overheads
Rent
Other costs
CAPITAL COSTS/FIXED ASSETS
Equipment
OTHER COSTS
Bank Charges
Loan Repayment
Interest
TOTAL CASH PAID OUT
CASH ON HAND
[Beginning of month]
CASH POSITION
[End of month]
1,131,333
C
A- B + C
TOTAL COSTS Profit & Loss items (before adjustments)
350,000
400,000
0
0
0
2,500
133,333
6,667
2,765,250
2,033,917
-588,833
Month 2
Month 3
Month 4
Month 5
Month 6
Actual
450,000
450,000
0
Actual
1,050,000
1,050,000
0
Actual
500,000
500,000
0
0
Actual
1,000,000
1,000,000
0
0
Actual
550,000
550,000
0
0
450,000
1,050,000
500,000
1,000,000
550,000
70,000
96,833
7,000
65,000
400,000
96,833
0
7,000
40,000
70,000
96,833
0
7,000
80,000
350,000
96,833
0
7,000
72,000
150,000
96,833
0
7,000
64,000
0
0
0
0
0
3,000
133,333
6,667
0
0
0
0
0
28,000
133,333
6,667
0
0
0
0
0
0
0
0
18,000
133,333
6,667
0
0
0
0
0
4,555
133,333
6,667
0
32,000
133,333
6,667
381,833
711,833
425,833
683,833
462,388
2,033,917
2,102,084
2,440,251
2,514,418
2,830,585
2,102,084
2,440,251
2,514,418
2,830,585
2,918,197
211,167
506,167
246,167
474,167
232,167
Month 7
Month 8
Month 9
Month 10
Month 11
Actual
590,000
590,000
0
0
Actual
700,000
700,000
0
0
Actual
686,000
686,000
0
0
Actual
600,000
600,000
0
0
Actual
620,000
620,000
0
0
590,000
700,000
686,000
600,000
620,000
92,000
96,833
0
7,000
90,000
160,000
96,833
0
7,000
100,000
145,000
96,833
0
7,000
40,000
82,000
96,833
0
7,000
70,000
70,000
96,833
0
7,000
85,000
0
0
0
0
0
2,000
133,333
6,667
0
0
0
0
0
2,400
133,333
6,667
0
0
0
0
0
5,200
133,333
6,667
0
0
0
0
0
2,000
133,333
6,667
0
0
0
0
0
2,000
133,333
6,667
427,833
506,233
434,033
397,833
400,833
2,918,197
3,080,364
3,274,131
3,526,098
3,728,265
3,080,364
3,274,131
3,526,098
3,728,265
3,947,432
304,167
336,167
397,167
344,167
361,167
Month 12
Actual
900,000
900,000
0
0
900,000
250,000
96,833
74,625
7,000
25,000
0
0
0
0
0
2,500
133,333
6,667
Total Cash Flow After 12 months
8,046,000
8,046,000
8,046,000
1,904,000
1,161,996
74,625
84,000
801,000
350,000
400,000
104,155
1,599,996
80,004
NET CASH
595,958
#REF!
3,947,432
4,251,474
446,542
3,270,379
CASH FLOW YEAR 1
Sales
Loan
Month 1
Actual
325,000
325,000
4,000,000
4,325,000
Production Cost
Salary
Depreciation
Utilities
Others
250,000
81,000
0
50,000
250,000
INDIRECT COSTS / Overheads
Rent
Other costs
CAPITAL COSTS/FIXED ASSETS
Equipment
OTHER COSTS
Bank Charges
Loan Repayment
Interest
TOTAL CASH PAID OUT
CASH ON HAND
[Beginning of month]
CASH POSITION
[End of month]
3,444,000
C
A- B + C
TOTAL COSTS Profit & Loss items (before adjustments)
300,000
0
0
2,500,000
0
13,000
0
0
881,000
-606,000
Month 2
Month 3
Month 4
Month 5
Month 6
Actual
370,000
370,000
0
Actual
400,000
400,000
0
Actual
450,000
450,000
0
0
Actual
455,000
455,000
0
0
Actual
550,000
550,000
0
0
370,000
400,000
450,000
455,000
550,000
70,000
81,000
5,000
180,250
70,000
81,000
0
5,000
130,000
120,000
81,000
0
5,000
110,000
130,000
81,000
0
5,000
112,000
100,000
81,000
0
5,000
100,000
0
0
0
0
0
4,000
0
0
0
0
0
0
0
1,500
0
0
0
0
0
0
0
0
0
0
2,000
0
0
0
0
0
0
0
2,000
0
0
0
2,000
0
0
340,250
287,500
318,000
330,000
288,000
881,000
910,750
1,023,250
1,155,250
1,280,250
910,750
1,023,250
1,155,250
1,280,250
1,542,250
33,750
114,000
134,000
127,000
264,000
Month 7
Month 8
Month 9
Month 10
Month 11
Actual
580,000
580,000
0
0
Actual
600,000
600,000
0
0
Actual
585,000
585,000
0
0
Actual
590,000
590,000
0
0
Actual
605,000
605,000
0
0
580,000
600,000
585,000
590,000
605,000
90,000
81,000
0
5,000
80,000
95,000
81,000
0
5,000
50,000
100,000
81,000
0
5,000
80,000
90,000
81,000
0
5,000
75,000
70,000
81,000
0
5,000
45,000
0
0
0
0
0
2,000
133,333
6,667
0
0
0
0
0
3,000
133,333
6,667
0
0
0
0
0
2,000
133,333
6,667
0
0
0
0
0
2,000
133,333
6,667
0
0
0
0
0
2,000
133,333
6,667
398,000
374,000
408,000
393,000
343,000
1,542,250
1,724,250
1,950,250
2,127,250
2,324,250
1,724,250
1,950,250
2,127,250
2,324,250
2,586,250
324,000
369,000
319,000
339,000
404,000
Month 12
Actual
620,000
620,000
0
0
620,000
100,000
81,000
12,500
5,000
100,000
0
0
0
0
0
2,500
133,333
6,667
Total Cash Flow After 12 months
6,130,000
6,130,000
4,000,000
10,130,000
1,285,000
972,000
12,500
105,000
1,312,250
300,000
2,500,000
38,000
799,998
40,002
NET CASH
441,000
#REF!
2,586,250
2,765,250
321,500
2,143,250
