Exhibit E

Initial 13-Week Budget

Case:17-03283-LTS Doc#:2298-5 Filed:01/27/18 Entered:01/27/18 23:51:50 Desc:

Exhibit E - Budget Page 1 of 2
Puerto Rico Electric Power Authority ("PREPA")

13 Week Cash Flow Model

($ in millions) Actual Actual Actual Actual Actual 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

Week ending 12/22 12/29 01/05 01/12 01/19 01/26 02/02 02/09 02/16 02/23 03/02 03/09 03/16 03/23 03/30 04/06 04/13 04/20 04/27 05/04 15 Weeks

Receipts

Customer collections $ 14.3 35.9 $ $ 24.6 16.5 $ 23.5 $ 24.9 $ $ 15.0 14.8 $ $ 21.7 19.8 $ 22.3 $ 14.1 $ 15.2 $ 20.6 $ $ 20.8 $ 22.8 $ 22.8 $ 29.9 $ 30.0 $ 327.8 33.2 $ 

Transfers from Emergency Account - - 47.8 - - - - - - - - - - - - - - - - - - 

Insurance Proceeds - - - - - - - - - - - - - - - - - - - - - 

Other - - - - - - - - - - - - - - - - - - - - - 

Total Receipts $ 14.3 35.9 $ $ 24.6 64.2 $ 23.5 $ 24.9 $ $ 15.0 14.8 $ $ 21.7 19.8 $ 22.3 $ 14.1 $ 15.2 $ 20.6 $ $ 20.8 $ 22.8 $ 22.8 $ 29.9 $ 30.0 $ 327.8 33.2 $ 

Disbursements

Eligible Energy Purchases

Eligible Power purchase - AES $ 13.7 - $ $ - - $ 13.7 $ $ 12.3 - $ $ 24.1 - $ 12.4 $ 12.1 $ $ 20.9 - $ $ - $ - $ 9.4 $ 7.0 $ 7.0 $ 10.2 - $ 115.4 $ 

Eligible Power purchase - EcoElectrica 31.0 - - - - 24.1 - 26.5 - 27.1 - - - 29.0 - 7.8 7.8 7.8 7.8 142.6 4.8 

Eligible Power purchase - Renewable sources - - - - - - - - 10.4 - - - - - - - - - - 10.4 - 

Eligible Fuel purchase - Fleet and storage - 0.5 0.4 - 0.1 - - 6.0 - 1.5 - 1.5 - - - - 1.5 - - 10.5 - 

Eligible Fuel purchase - Freepoint - - 9.2 4.6 4.4 9.0 9.0 4.4 9.2 4.4 4.6 28.8 12.8 - 14.4 9.4 5.1 9.4 16.4 5.1 142.0 

Eligible Fuel purchase - Puma 15.9 9.6 12.0 5.6 11.0 9.8 7.0 9.5 7.9 6.7 8.2 9.3 7.4 8.4 8.5 7.1 - - - 97.1 6.1 

Eligible LNG purchase - Fenosa 11.1 - 13.9 - - - 16.0 - - - 11.1 15.1 - 3.8 3.8 3.8 3.8 6.3 6.3 76.0 6.3 

Subtotal Energy Purchases $ 23.3 58.4 $ $ 35.5 10.2 $ 28.0 $ 20.0 $ $ 31.9 56.3 $ $ 29.4 73.6 $ 63.0 $ 38.1 $ 44.9 $ 54.0 $ $ 26.7 $ 37.4 $ 25.2 $ 30.5 $ 19.2 $ 594.0 43.7 $ 

Other Disbursements

Eligible Estimated Payroll 7.8 - 7.8 - - 7.8 7.8 - 7.8 - - 7.8 - 7.8 - 7.8 - 7.8 - 7.8 62.4 

Eligible Social security 2.8 - 2.5 - - 2.0 2.0 - 2.0 - - 2.0 - 2.0 - 2.0 - 2.0 - 2.0 16.2 

Eligible Payroll taxes 0.6 - 0.6 - - 1.1 1.1 - 1.1 - - 1.1 - 1.1 - 1.1 - 1.1 - 1.1 8.8 

Eligible Contributions to employee benefit programs 5.0 - 5.3 - - 5.5 5.5 - 5.5 - - 5.5 - 5.5 - 5.5 - 5.5 - 5.5 44.0 

Eligible Medical benefit costs 1.0 - 9.0 3.8 - 3.5 1.8 5.4 - 5.8 - 5.8 - - - 5.8 - - - 34.0 5.8 

Eligible Workers compensation / disability funding - - 3.4 - - - - - 6.0 - - - - - - - - - - 6.0 - 

Ineligible Estimated Gross Overtime 5.6 - 4.8 - - 3.5 3.5 - 3.5 - - 3.5 - 3.5 - 3.5 - 3.5 - 3.5 28.0 

Ineligible Contract Labor - Title III - - 2.0 - - 4.9 1.4 1.4 1.4 1.4 1.4 1.7 1.7 1.7 1.7 1.7 1.7 1.7 1.7 1.7 26.8 

Eligible Contract Labor - Other - - 0.0 - - 1.6 0.3 0.3 0.3 0.3 0.3 0.4 0.4 0.4 0.4 0.4 0.4 0.4 0.4 0.4 7.1 

Employee Disbursements & Contract Labor $ 22.8 - $ $ 35.4 3.8 $ $ 29.9 - $ $ 23.4 7.1 $ $ 27.6 7.5 $ $ 27.8 1.7 $ $ 22.0 2.1 $ $ 27.8 2.1 $ $ 22.0 2.1 $ $ 27.8 2.1 $ 233.2 $ 

Other Disbursements

Eligible Insurance premiums - - 0.9 - - - - - - 0.1 - - 1.5 - - - 0.3 - - 2.0 - 

Eligible Maintenance Disbursements - - 0.6 - 1.0 - 3.2 - 3.2 3.2 4.5 4.5 4.5 4.5 4.5 3.9 3.9 3.9 3.9 52.0 4.3 

Eligible Employee expense reimbursements - - - - - 0.8 0.8 0.8 0.8 0.8 0.8 0.8 0.8 0.8 0.8 0.8 0.8 0.8 0.8 12.0 0.8 

Eligible Additional accounts payable - 2.4 2.6 - 5.1 2.0 4.8 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 2.0 32.8 2.0 

Eligible Other 2.3 8.1 (10.3) (1.5) (1.1) - - - - - - - - - - - - - - - - 

Subtotal Other Disbursements $ 10.5 $ (1.5) 2.3 $ (6.3) $ $ 2.8 5.1 $ $ 2.8 $ 8.8 $ 6.2 $ 7.3 6.0 $ 7.3 $ 8.8 $ 7.3 $ $ 7.3 $ 6.7 $ 7.0 $ 6.7 $ 6.7 $ 98.8 7.1 $ 

Total Disbursements $ 48.4 68.9 $ $ 64.6 12.4 $ 33.1 $ 52.7 $ $ 64.2 66.2 $ $ 63.0 87.3 $ 72.0 $ 73.2 $ 55.8 $ 83.3 $ $ 36.1 $ 71.9 $ 34.3 $ 59.2 $ 28.0 $ 926.0 78.6 $ 

Net Cash Flow $ (34.0) (32.9) $ $ (40.0) 51.8 $ $ (27.8) (9.6) $ $ (49.2) (51.4) $ $ (41.4) (67.4) $ (49.8) $ (59.1) $ (40.6) $ (62.8) $ $ (15.3) $ (49.2) $ (11.5) $ (29.3) $ (45.5) 2.0 $ (598.3) $ 

Opening Balance $ 242.2 275.1 $ $ 259.9 208.1 $ 219.9 $ $ 187.0 $ 182.5 $ 131.1 $ 14.5 81.9 $ (26.9) $ (76.7) $ (135.8) $ (176.5) $ $ (239.3) $ (254.6) $ (303.7) $ (315.2) $ (344.5) $ (342.5) $ 187.0

Net Operating Cash Flows (32.9) (34.0) (40.0) 51.8 (27.8) (9.6) (49.2) (51.4) (41.4) (67.4) (49.8) (59.1) (40.6) (62.8) (15.3) (49.2) (11.5) (29.3) (45.5) 2.0 (598.3) 

Emergency Spend, net from General Fund - - - - - - - - - - - - - - - - - - - - - 

Ending Balance, before Emergency Related $ 208.1 242.2 $ $ 219.9 259.9 $ 210.3 $ 159.2 $ $ 131.1 $ 81.9 $ (26.9) 14.5 $ (76.7) $ (135.8) $ (176.5) $ (239.3) $ $ (254.6) $ (303.7) $ (315.2) $ (344.5) $ (342.5) $ (411.3) (387.9) $ 

Emergency Related

Ineligible Emergency Spend $ - - $ (15.4) $ $ (50.3) (9.7) $ $ (51.8) - $ (25.0) $ $ (44.5) (12.5) $ (44.5) $ (44.5) $ (44.5) $ (12.5) $ $ (137.5) (12.5) $ $ (32.0) $ (32.0) $ (21.0) - $ (514.8) $ 

FEMA Reimbursements - - 15.4 27.0 9.7 23.3 25.0 51.8 44.5 12.5 44.5 44.5 44.5 12.5 12.5 44.5 32.0 32.0 - 21.0 445.1 

Subtotal Other Disbursements $ - - $ $ - $ (23.3) - $ $ 23.3 $ - $ - $ - $ - - $ - $ - $ - $ $ (93.0) - $ $ - $ - $ - $ (69.7) - $ 

Ending Balance $ 208.1 242.2 $ $ 219.9 259.9 $ 187.0 $ 182.5 $ $ 131.1 $ 81.9 $ (26.9) 14.5 $ (76.7) $ (135.8) $ (176.5) $ (239.3) $ $ (254.6) $ (396.7) $ (408.2) $ (437.5) $ (435.5) $ (480.9) (480.9) $ 

Privileged and Confidential - Working Draft Subject to Material Change - Professional's Eyes Only - Subject to Mediation - Agreement But 

Not Subject to any Cleansing Obligations Thereunder

DRAFT - Subject to Change

Case:17-03283-LTS Doc#:2298-5 Filed:01/27/18 Entered:01/27/18 23:51:50 Desc:

Exhibit E - Budget Page 2 of 2