[PDF]13-Week Cash Flow - Rackcdn.com250289cfae1eb4f31743-3650f420020265fcc2ea96c682f1749d.r37.cf1.rackcdn.com/...
0 downloads
189 Views
161KB Size
OLC MBA FINANCE EP 3 CASH CYCLE - 13-WEEK CASH FLOW Cash Flow Forecast -- by Carl Seidman (in thousands of Dollars) Week Beginning CASH INFLOWS: Project Progress Payments Contract Collections Asset Sale Proceeds Debt Issuance TOTAL INFLOWS CASH OUTFLOWS: Projects Accounts Payable & Indirects Direct Labor Equipment Total Project Payments Non Project Related Payroll Insurance & Workers' Comp Total Non Project Related Payroll Non Project Related Accounts Payable Operating Capex Total Accounts Payable Debt Repayments TOTAL OUTFLOWS NET CASH INFLOW (OUTFLOW) Beginning Cash Balance Cumulative Net Cash Flow ENDING CASH BALANCE
Week 1 10/1/2018 CODE Forecast
Week 2 10/8/2018 Forecast
Week 3 10/15/2018 Forecast
Week 4 10/22/2018 Forecast
Week 5 10/29/2018 Forecast
Week 6 11/5/2018 Forecast
Week 7 11/12/2018 Forecast
Week 8 11/19/2018 Forecast
Week 9 11/26/2018 Forecast
Week 10 12/3/2018 Forecast
Week 11 12/10/2018 Forecast
Week 12 12/17/2018 Forecast
Week 13 12/24/2018 Forecast
Total 13-Week 10/1/2018 12/24/2018
2,783 253 3,036
7,853 253 1,150 9,256
1,026 253 1,279
2,259 253 2,512
13,564 253 13,817
1,565 253 1,818
4,960 253 5,213
2,900 253 3,153
9,026 253 9,279
5,286 253 5,539
1,055 253 1,308
2,075 253 2,328
4,335 253 4,588
58,686 3,295 1,150 63,131
APP DL APP
240 1,025 390 1,654
2,182 1,053 407 3,642
6,677 1,071 410 8,158
669 1,171 432 2,272
5,776 1,229 435 7,440
862 1,316 440 2,618
4,152 1,516 530 6,197
1,314 1,476 510 3,299
1,074 1,657 614 3,345
3,740 1,832 661 6,233
3,562 1,847 677 6,087
942 1,847 677 3,466
1,619 1,942 677 4,238
32,807 18,981 6,860 58,648
PR MED
178 22 200
-
178 22 200
-
178 22 200
-
178 22 200
-
-
178 22 200
-
178 22 200
-
1,067 132 1,199
APNP APNP
163 8 171 2,025 1,012 795 1,012 1,807
253 8 261 3,902 5,354 1,807 6,366 7,161
PF
163 8 171 8,528 (7,249) 7,161 (883) (88)
163 423 586 2,857 (345) (88) (1,228) (433)
131 8 139 7,779 6,038 (433) 4,810 5,605
221 8 229 2,847 (1,028) 5,605 3,782 4,577
131 8 139 6,536 (1,323) 4,577 2,459 3,254
131 8 139 3,438 (285) 3,254 2,174 2,969
131 732 863 4,208 5,071 2,969 7,245 8,040
201 8 209 6,641 (1,102) 8,040 6,143 6,938
111 8 119 6,205 (4,897) 6,938 1,246 2,041
111 8 119 3,784 (1,456) 2,041 (210) 585
111 70 181 110 4,529 60 585 (150) 645
2,019 1,306 3,325 110 63,281 (150) 795 (150) 645