Attachment 2 - UESC Financial Schedules 1-5a.xlsx
XLSX spreadsheet 95 KB Posted
- Solicitation number
- W912DY24R0047
About this file
This document contains financial schedules for a Utility Energy Savings Contract (UESC) related to a federal contract opportunity. The schedules include proposed cost savings and contractor payments, implementation price by energy conservation measure, post-acceptance performance period cash flow, estimated first-year annual cost savings, and annual cancellation ceilings.
The related federal contract opportunity is a Request for Proposal (RFP) issued by the U.S. Army Corps of Engineers (USACE), Huntsville Center for energy management services at the United States Army Garrison (USAG) Miami in Miami, FL. The contract will be a Firm Fixed Price UESC with a period of performance not to exceed 25 years.
View the file
Other files
Show all 26
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
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) | ECM | Equipment Description - Title | ECM Size | M&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 Capitalization | Applicable 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 Service | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | Totals |
| 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-2 | ECM | a. |
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 Period | Termination Liability | Cancellation 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 Number | Contractor 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 .