The model updates shall include:

Update project pipeline disbursements and repayments with current projects

b.      Update existing disbursement and repayment data, and other cash flows

c.      Update base/BIL/ARPA co-funding metrics as needed

d.      Update Assumptions worksheet to add categories of projects, as directed by DEP

e.      Update other worksheets as needed

f.        Add additional features, such as macros, increase automation of formulas, and cash target calculations, as directed by NJDEP

g.       Testing to ensure accuracy of all modules. 

1. All the updates will be carried out for both the CWSRF and the DWSRF Cash Flow Models.

a.      Each model will reflect the actual operations of each program, including loan terms, disbursement patterns, DWSRF set-aside uses, and more.

1. The contractor will conduct several meetings with NJDEP to discuss topics pertinent to the development and update of the Cash Flow Models.

2. The contractor will run model scenarios to assist NJDEP in making decisions on funding commitments, leveraging, and other key program decisions, as well as to respond to EPA inquiries.

3. Deliverable: NJDEP will receive updated Excel CWSRF and DWSRF Cash Flow Models for their further modeling efforts. These will be delivered as 2 separate files, one for the DWSRF and one for the CWSRF. 

The selected contractor will implement additional updates as requested by NJDEP. For budgeting purposes, these updates are expected to occur every six months. The updates will include:

1. Excel CWSRF and DWSRF Cash Flow Model Updates and Revisions

a.      Update pipeline disbursements and repayments as needed

b.      Updated existing cash flows

c.      Adjust loan terms and assumptions as necessary

d.      Add additional analytic tools as necessary and desired by NJDEP

1. In between updates, smaller corrections may be required on an ad-hoc basis.

2. The contractor will conduct meetings with NJDEP prior and during each update to discuss topics pertinent to the update of the Cash Flow Models.

3. The contractor will run model scenarios to assist NJDEP in making decisions on funding commitments, leveraging, and other key program decisions, as well as to respond to EPA inquiries.

4. Deliverable: Following each update, NJDEP will receive updated Microsoft Excel CWSRF and DWSRF Cash Flow Models for their further modeling efforts. These will be delivered as 2 separate files, one for the DWSRF and one for the CWSRF.  

NJDEP is building in-house capacity to update and maintain the SRF Cash Flow Models.

1. The Contractor will conduct training sessions with the NJDEP point(s) of contact to build the capacity.

2. As NJDEP builds capacity, the contractor and NJDEP will work in partnership to implement updates and changes to the model.

3. The contractor will develop Standard Operating Procedures with step-by-step instructions on model updates.

4. The contractor will be available for ad-hoc meetings to discuss updates and efforts by the NJDEP staff being trained.

5. For budgeting purposes, 11 2-hour training sessions across 3 years are assumed.

6. Deliverables:

a.      Standard Operating Procedures with step-by-step instructions on using and updating the Cash Flow Model

b.      Recordings of any Microsoft Teams-based virtual training sessions