13-Week Cash Flow


[PDF]13-Week Cash Flow - Rackcdn.com250289cfae1eb4f31743-3650f420020265fcc2ea96c682f1749d.r37.cf1.rackcdn.com/...

0 downloads 176 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