EPA-R-HQ-NCIF-23-01 - Template - Budget Table.xlsx
XLSX spreadsheet 41 KB Posted
- Attached to
- National Clean Investment Fund (NCIF)
- Opportunity number
- EPA-R-HQ-NCIF-23
- Issued by
-
Environmental Protection Agency
About this file
This document provides an optional budget table template for applicants to the National Clean Investment Fund grant opportunity under the Environmental Protection Agency. The template standardizes the format for applicants to itemize costs by year and category including personnel, fringe benefits, travel, equipment, supplies, contractual obligations, and other direct and indirect costs. Applicants must separate financial assistance costs into three categories: acquisitions of intangible property, subawards, and participant support costs. The template calculates totals by year, category, and overall. Eligible costs include staff salaries, travel, data subscriptions, professional services, and financial assistance for emissions reduction projects. Applicants must specify the share of requested funds for passing through as financial assistance. The associated federal grant opportunity is the National Clean Investment Fund under the Greenhouse Gas Reduction Fund and Environmental Protection Agency.
EPA-R-HQ-NCIF-23-01 - Template - Budget Table
View the file
Other files
| File | Type | Posted |
|---|---|---|
| EPA-R-HQ-NCIF-23-01.v2.pdf | ||
| EPA-R-HQ-NCIF-23-01 - Template - Financial Projections.xlsx | XLSX spreadsheet | |
| EPA-R-HQ-NCIF-23-01.pdf |
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
Overview
| Legend | |
| Text | Example inputs - applicants should delete information in these cells and replace it with relevant information for their program in black, non-italicized text |
| Costs for financial assistance in different project categories - applicants may disaggregate costs for financial assistance into different project categories to facilitate consideration of an application for partial funding, to the extent practicable |
Introduction:
This Excel Workbook is an optional template for applicants to fill in and submit as the detailed budget table, which is described in Section 1.4.2 of the Narrative Proposal, for the Greenhouse Gas Reduction Fund - National Clean Investment Fund competition. This is an optional template, and applicants will not be penalized if they do not use the template. If you do use this template, you may upload the file as an Excel titled per the instructions in the Notice of Funding Opportunity.
Please see the Notice of Funding Opportunity for guidance on how to create this budget table. In particular, refer to Appendix D: Program Budget for detailed guidance.
Instructions:
Below is a description of the steps an applicant should complete to finish the template.
- In column C, add and subtract rows to detail itemized costs (and specific descriptions of costs) in each cost category per the guidance in Appendix D: Program Budget.
- In columns D through J, fill in the cost for the line item per year, including subtotals for each budget category - personnel, fringe benefits, travel, equipment, supplies, contractual, and other direct costs (e.g., subawards, participant support costs, other) as well as indirect costs (note: the template examples only have year 1 values included, yet applicants must fill in costs for every year of the applicant's proposed period of performance). As directed in Appendix D: Program Budget, ensure that costs for financial assistance are aggregated and separated from all other costs for three specific categories: (1) acquisitions of intangible property, (2) subawards, and (3) participant support costs.
- In column L, calculate the total cost for the line item for the entire program, including subtotals for each budget category - personnel, fringe benefits, travel, equipment, supplies, contractual, and other direct costs (e.g., subawards, participant support costs, other) as well as indirect costs.
- At the bottom of the table (row 68 of the template), calculate the share of funds used for financial assistance (both the direct costs of funds passed through for financial assistance as well as associated indirect costs).
Budget Table Template
| Budget Table Template |
| An OPTIONAL template for applicants to fill in and submit as the detailed budget table, which is described in Section 1.4.2 of the Narrative Proposal |
| BUDGET BY YEAR | |||||||||
| COST-TYPE | CATEGORY | YEAR 1 | YEAR 2 | YEAR 3 | YEAR 4 | YEAR 5 | YEAR 6 | YEAR 7 | TOTAL |
| Direct Costs | Personnel | ||||||||
| 3 FTE Program Manager @ $110,000/yr (100% Assigned) | $330,000 | ||||||||
| 1 FTE Outreach Coordinator @ $70,000/yr (50% Assigned) | $35,000 |
| TOTAL PERSONNEL | $365,000 |
| Fringe Benefits | |
| Program Managers @ 20% of salary | $66,000 |
| Outreach Coordinator @ 20% of salary | $7,000 |
| TOTAL FRINGE BENEFITS | $73,000 |
| Travel | |
| Travel for 2 staff to attend DOE technical assistance workshops | |
| Airfare: 2 @ $600 round trip | $1,200 |
| Per Diem: 2 staff X 4 days @ $60/day | $480 |
| Hotel: 2 staff X 3 nights @ $250/night | $1,500 |
| Local Mileage | |
| Outreach Coordinator, 100 mi/mo @ $.54/mi x 12 mo | $648 |
| TOTAL TRAVEL | $3,828 |
| Equipment | |
| Data server | $75,000 |
| TOTAL EQUIPMENT | $75,000 |
| Supplies | |
| Office and related supplies (e.g., paper, pens) | $10,000 |
| TOTAL SUPPLIES | $10,000 |
| Contractual | |
| Emissions data subscription | $250,000 |
| Financial data subscription | $125,000 |
| Contract with home energy audit professional | $150,000 |
| Translation services for community meetings | $10,000 |
| Climate scenario analysis modeling services | $75,000 |
| Financial assistance characterized as "acquisitions of intangible property" | |
| Financial assistance – project category #1 (acquisitions of intangible property) | $4,000,000 |
| Financial assistance – project category #2 (acquisitions of intangible property) | $4,000,000 |
| Financial assistance – project category #3 (acquisitions of intangible property) | $4,000,000 |
| TOTAL CONTRACTUAL | $12,610,000 |
| OTHER | |
| Insurance | $10,000 |
| Financial assistance characterized as "subawards" | |
| Financial assistance – project category #1 (subawards) | $4,000,000 |
| Financial assistance – project category #2 (subawards) | $4,000,000 |
| Financial assistance – project category #3 (subawards) | $4,000,000 |
| Financial assistance characterized as "participant support costs" (PSCs) | |
| Financial assistance – project category #1 (PSCs) | $4,000,000 |
| Financial assistance – project category #2 (PSCs) | $4,000,000 |
| Financial assistance – project category #3 (PSCs) | $4,000,000 |
| TOTAL OTHER | $24,010,000 |
| TOTAL DIRECT | $37,146,828 |
| Indirect Costs | Indirect Costs (Indirect Cost Rate) | 10% |
| Indirect costs on financial assistance – project category #1 | $25,000 | |
| Indirect costs on financial assistance – project category #2 | $25,000 | |
| Indirect costs on financial assistance – project category #3 | $25,000 | |
| Other indirect costs | $107,183 | |
| TOTAL INDIRECT | $182,183 |
| Total Funding ($) | $37,329,011 |
| Share for Financial Assistance (%) | 97% |
Incomplete - Comment Log table
| Media: | NPM: | Regional Division: | EPA Goal: | EPA Objective: | Workplan Component | Commitment FY | Workplan Commitment | Commitment Comment | Outcome | Status | Status Comment | EPA Comment | State Comment | Comment Date | Target Completion |
| Air & Radiation | OAR | ARD | Goal 1 - Core Mission | Objective 1.1 – Improve Air Quality | Ozone, PM2.5, PM10, and CO | FY18 | Continue participation in EPA's AIRNOW program. Submit real-time pollutant data and provide forecasts and alerts. By March 1, 2018, work with EPA to enable Twitter and real-time notification features of EnviroFlash. Attend R1 air quality outreach and forecasting workshop, if held, either in person or remotely. Attend EPA's National Air Quality Conference. (FY'18-19 DRAFT OAR NPM Guidance: NAAQS, 2.1.1.3 Other, #1; and Ambient Air Monitoring for Criteria Pollutants, 2.4.1, #8) | ||||||||
| Air & Radiation | OAR | ARD | Goal 1 - Core Mission | Objective 1.1 – Improve Air Quality | Ozone, PM2.5, PM10, and CO | FY19 | |||||||||
| Air & Radiation | OAR | ARD | Goal 1 - Core Mission | Objective 1.1 – Improve Air Quality | Ozone, PM2.5, PM10, and CO | FY19 | For all future revisions to the SIP, work to implement the recommendations in the final Standard Operating Procedures document developed by EPA Region 1 and the New England states. | Complete | NH will implement these recommendations |
Standardized Terms
| Standardized Term | Definition | Also Known As | ||
| Workplan Component | A negotiated set or group of work plan commitments established in the grant agreement. A work plan may have one or more work plan components | Program Area | ||
| Workplan Commitment | The outputs and outcomes associated with each work plan component, as established in the grant agreement | Activity | Planned Accomplishments/Requirements | Output |
| Status | Short defined list of status options. Detailed status information can be captured in the comment field | |||
| Comment | ||||
| Subcomponent | a subgrouping of commitments under a larger workplan component | Related Measure |
File details come from the government source that posted it. Updated .