Attachment 2_Financial Schedules 1-5a_UESC_9May19.xlsx

93 KB Posted

Attached to
Request for Proposal - 99th U. S. Army Reserve Readiness Division (USARRD) UESC
Solicitation number
W912DY24R0029
Issued by

About this file

Written by GovTribe AI ·

This document contains financial schedules and templates for a utility energy savings contract opportunity with the U.S. Army Corps of Engineers. The schedules include proposed cost savings and contractor payments over a 25-year period, implementation prices by energy conservation measure, post-acceptance performance period cash flows, estimated first year energy and cost savings by measure, and annual cancellation ceilings. The related federal contract opportunity is a request for proposal from the 99th U.S. Army Reserve Readiness Division for energy management services under a firm fixed price, 25-year utility energy services contract with the U.S. Army Corps of Engineers Engineering Support Center Huntsville. The opportunity involves reducing energy costs at facilities in Boston, MA.

View the file

Other files

File Type Posted
99th USARRD RFP Questions_Answers_5April2024.docx DOCX document
RFP_Amendment_24-R-00290002.pdf PDF
Attachment 9 - BAA Certification for Contractors Signature.docx DOCX document
RFP_Amendment_24-R-00290001.pdf PDF
RFP_Conformed_Copy_Amendment_24-R-00290001.pdf PDF
Attachment 3_Data Item Descriptions_UESC_18Oct20.pdf PDF
Attachment 1 -PWS for UESC 99th USARRD.docx DOCX document
Attachment 6_Past Performance Questionnaire.docx DOCX document
Attachment 7_Price Worksheet.xlsx XLSX spreadsheet
Attachment 4_SCA_WD_Boston_16Feb2024.pdf PDF
Attachment 4_DB_WD_Boston_16Feb2024.pdf PDF
RFP_W912DY24R0029_UESC_99th_USARRD.pdf PDF
Attachment 5 _Letter of Commitment of Key Subcontractor.docx DOCX document
Attachment 8 - Small Business Participation Plan.pdf PDF
Show all 14

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

INDEX

FINANCIAL SCHEDULES
FOR UTILITY ENERGY SAVINGS CONTRACTS
Schedule-1 Proposed Cost Savings and Contractor Payments (Draft submitted with Preliminary Assessment (PA) Report

Schedule-1 Proposed Cost Savings and Contractor Payments

Schedule-2 Implementation Price by Energy Conservation Measure

Schedule-3 Post-Acceptance Performance Period Cash Flow

Schedule-4 Performance Period First Year Estimated Annual Cost Savings, by Energy Conservation Measure and Technology Category (TC)

Schedule-5 Annual Cancellation Ceiling

Schedule-5a Monthly Financing Termination Liability

TO Schedule 1

SCHEDULE-1

PROPOSED COST SAVINGS AND CONTRACTOR PAYMENTS

IMPORTANT INFORMATION
(1)This should not be altered. Please note any clarifications in the comments/explanations area below.
(2)The first year post-acceptance performance period estimated annual cost savings reflect technical proposal and engineering estimates as presented in SCHEDULE-4.
(3)The proposed annual cost savings are supported by Performance Assurance Plan (and M&V if agreed).
(4)The total of contractor payments (columns c and f) represents the order or contract price and should be supported by information submitted in and provided with SCHEDULES-2 and -3.
(5)If applicable, prior to post-acceptance performance period, implementation period allowable payments and energy savings are one- time amounts only.
(6)If applicable, provide a separate table showing proposed energy rates (i.e., $/kWh, $kW, $/MBtu) for each post-acceptance performance period year, derived using the National Institute of Standards and Technology Handbook 135 and Annual Supplement. Also, submit escalation rates applied to energy-related O&M savings (including water and sewer): % per year.
(7)If selected, the contractor shall complete the installation of all proposed ECMs not later than months after award.
Contract No.:Contractor Name:Project Site:
(a)
Estimated Cost Savings ($)(b)
Proposed Cost Savings ($)(c)

Contractor Payments ($)

Implementation Period$0$0$0
Post-Acceptance Performance Period Year(d)
Estimated Annual Cost Savings ($)(e)
Proposed Annual Cost Savings ($)(f)

Annual Contractor Payments ($)

One
Two
Three
Four
Five
Six
Seven
Eight
Nine
Ten
Eleven
Twelve
Thirteen
Fourteen
Fifteen
Sixteen
Seventeen
Eighteen
Nineteen
Twenty
Twenty-one
Twenty-two
Twenty-three
Twenty-four
Twenty-five
Totals
Explanations/Comments:

TO Schedule 2

SCHEDULE-2

IMPLEMENTATION PRICE BY ENERGY CONSERVATION MEASURE

IMPORTANT INFORMATION:
(1)This schedule should not to be altered. Please note any clarifications in the comments/explanations area below.
(2)Implementation expense shall include only direct costs for each ECM and no post-acceptance performance period expenses. Indirect expenses and profit will be applied to the sum of direct expenses for all ECMs and project development to calculate total implementation price (d) for the project.
(3)Contractor shall attach adequate supporting information detailing total implementation expenses.
(4)Contractor shall propose bonded amount representing the basis of establishing performance and payment bonds per Section H of the contract, as required.
(5)Attached supporting information shall be presented to identify portions of ECM or project expenses included in proposed bonded amount.
(6)Proposed bonded amount is assumed to include indirect expenses and profit applied to implementation expenses above, unless otherwise specified by contractor.
(7)For the following ECMs, enter the total installed capacity of new equipment in the units specified (e.g., chillers-150); chillers and packaged units in tons, VFDs in hp, boilers and furnaces in input Btu/hr, BAS/EMCS in number of points, transformers in kVA, generators in kW. For lighting ECMs, specify baseline kW treated.
(8)M&V expense shall not include any performance period expenses.
Project Site:Order or Contract No.:Contractor Name:
Technical Category (TC)ECMEquipment Description - TitleECM SizeM&V Expense (if included)Implementation Expense(c) Profit $(d) Implementation Price: Totals (a)+(b)+(c) = (d)
(a) Direct(b) Indirect
TOTALS$0$0$0$0
Bonded Amount ($)

Explanations/Comments:

TO Schedule 3

SCHEDULE-3 – POST-ACCEPTANCE PERFORMANCE PERIOD CASH FLOW
Project Site:Order or Contract No.:Contractor Name:
Project CapitalizationApplicable Financial Index:Issue Date:
Total Implementation Price (from SCH-2 Total)Term (Years):Source:
Plus Financing Procurement Price ($)Index Rate:Effective Through:
Less Implementation Period Payments (from
SCH-1 (final) (c))(If proposed, must be fully documented)Added Premium (adjusted for tax incentives):

Total Amount Financed (Principal) $0 Project Interest Rate:

Annual Debt Service12345678910111213141516171819202122232425Totals
Annual Cash Flow (Post-Acceptance Performance Period)
Debt Service
Principal Repayment ($)$0
Less incentives (i.e., REC, White Tag, etc.)
Net principal repayment before interest$0
Interest ($)$0
Total Debt Service (a)$0
Post-Acceptance Performance Period Expenses
Management/Administration
Operation
Maintenance
Repair and Replacement
Measurement and Verification (and/or Performance Assurance)$0
Permits and Licenses
Insurance
Property Taxes
Other – Describe and Explain
Other – Describe and Explain
SUBTOTAL Before Application of Indirect Rates$0
Indirect Cost Rate (%)
Indirect Cost Applied ($)
SUBTOTAL Post-Acceptance Performance Period Exp$0
Post-Acceptance Performance Period Profit (%)0.00%
Post-Acceptance Performance Period Profit ($)$0
Total Post-Acceptance Performance Period Expenses (b)$0
TOTAL - ANNUAL CONTRACTOR PAYMENTS (a)+(b)$0
Explanations/Comments:

TO Schedule 4

SCHEDULE-4

Performance Period First Year Estimated Annual Cost Savings, by Energy Conservation Measure and Technology Category (TC)

IMPORTANT INFORMATION:
(1)Project Square Footage (in 1000 SF) - Include only building square footage affected by installed ECMs in project.
(2)For column (a) insert estimated energy baseline by ECM and total project in MBtu based on IGA, and proposal data.
(3)For column (c1), annual electric demand savings (kW/yr) is the sum of the monthly demand savings
(4)Energy conversion factors for MBtu: MBtu=106 Btu; Electricity - 0.003413 MBtu/kWh; Natural Gas - 0.1 MBtu/therm ; #2 Oil - 0.128 MBtu/gal.
(5)Specify "Other" energy savings in (e)(1) and (e)(2) as applicable. Include energy type _____ ; energy units _______ ; and MBtu conversion factor ______ MBtu/ ______ (unit)
(6)This schedule should not to be altered. Please note any clarifications in the comments/explanations area below.
Project Site:Order/Contract #:Contractor Name:Project Square Footage (KSF):
TC per SCH-2ECMa.

ECM energy baseline (MBtu/yr) b1.

Electric energy savings (kWh/yr) b2.

Electric energy savings ($/yr) c1.

Electric demand savings (kW/yr) c2.

Electric demand savings ($/yr) d1.

Natural gas savings (MBtu/yr) d2.

Natural gas savings ($/yr) e1.

Other savings (MBtu/yr) e2.

Other savings ($/yr) f.

b1+d1+e1 Total energy savings (MBtu/yr) g.=b2+c2+d2+e2 Total energy cost savings ($/yr) h.

Other energy- related and O&M cost savings ($/yr) i.

Water savings (1000 gal/yr) j.

Water savings ($/yr) k=g+h+-j Estimated annual cost savings ($yr) l.

Implementation price ($) m=l/k Simple Payback (yrs.)

TOTALS

Explanations/Comments:

TO Schedule 5

SCHEDULE TO-5
ANNUAL CANCELLATION CEILING SCHEDULE
IMPORTANT INFORMATION
(1) Cancellation Ceilings for each time period specified below establish the maximum termination liability for that time period, and includes the remaining unamortized principal on total amount financed for each time period specified above plus any prepayment charges. Actual total termination costs will be negotiated.
(2) The contractor may attach a monthly Financing Termination Liability Schedule.
(3) In the event of TO cancellation or termination for convenience, FAR 52.217-2 or 52.249.2 will apply.
Project Site:Task Order No:Contractor Name:
Time PeriodTermination LiabilityCancellation Ceiling
Installation Acceptance
End of Year One
End of Year Two
End of Year Three
End of Year Four
End of Year Five
End of Year Six
End of Year Seven
End of Year Eight
End of Year Nine
End of Year Ten
End of Year Eleven
End of Year Twelve
End of Year Thirteen
End of Year Fourteen
End of Year Fifteen
End of Year Sixteen
End of Year Seventeen
End of Year Eighteen
End of Year Nineteen
End of Year Twenty
End of Year Twenty One
End of Year Twenty Two
End of Year Twenty Three
End of Year Twenty Four
End of Year Twenty Five

TO Schedule 5a

SCHEDULE 5a – MONTHLY, QUARTERLY OR ANNUAL FINANCING AND TERMINATION LIABILITY
Site:Order or Contract NumberContractor Name
Project Investment:Index Rate:
Paid at Acceptance:Spread:
Interest During Construction:Project Rate:
Other Financing Procurement Cost:Termination Liability:
Paid along with First Contractor Payment:Cancellation Ceiling:
Total Financed Amount:

Payment Number Performance Period (Month, Quarter, or Year) Government Loan Invoice Date Government Loan Payment Date Interest Payment ($) Principal Payment ($) Monthly P&I Payment ($) Annual Sum of P&I Payments ($) Monthly Performance Period Expense Payment ($) Annual Sum of Performance Period Expense Payments ($) Monthly Contractor Payment ($) Annual Sum of Contractor Payments ($) Unamortized Principal Balance ($) Financing Termination Liability ($) Contractor Termination Liability ($) Cancelation Ceiling Amount / Termination Value ($) Total Gov't Payment ($)

File details come from the government source that posted it. Updated .