EPA-R-HQ-NCIF-23-01 - Template - Financial Projections.xlsx

XLSX spreadsheet 37 KB Posted Jul 13, 2023

Attached to: National Clean Investment Fund (NCIF)
Opportunity number: EPA-R-HQ-NCIF-23
Issued by: Environmental Protection Agency

About this file

Written by GovTribe AI · Dec 20, 2023

This document provides an optional Excel template for financial projections required in applications to the EPA's National Clean Investment Fund grant program. The template includes worksheets for the statement of financial position and statement of activities over a seven-year period for both the grant program funds and the applicant's total organization. Definitions are provided for line items in the statements. The grant program seeks to reduce greenhouse gas emissions and is assigned under the Greenhouse Gas Reduction Fund with solicitation number EPA-R-HQ-NCIF-23. Awards are determined based on evaluation criteria in the Notice of Funding Opportunity. The optional template provides guidance and standardization for the required financial projections, though use of the template is not mandatory.

From the source

EPA-R-HQ-NCIF-23-01 - Template - Financial Projection

View the file

Other files

File	Type	Posted
EPA-R-HQ-NCIF-23-01.v2.pdf	PDF	Aug 11, 2023
EPA-R-HQ-NCIF-23-01 - Template - Budget Table.xlsx	XLSX spreadsheet	Jul 13, 2023
EPA-R-HQ-NCIF-23-01.pdf	PDF	Jul 13, 2023

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.

Overview

Introduction:

This Excel Workbook is an optional template for applicants to fill in and submit as the financial projections (statement of financial position and statement of activities), which are described in Section 2.5.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.

Instructions:

Below is a description of the steps an applicant should complete to finish the template.

Statement of Financial Position

- In column B, add and subtract rows for specific line items in your projections of the statement of financial position to support evaluation against the evaluation criteria listed in Section V.A: Evaluation Criteria. Applications may be able to receive full points even if they submit only selected line items; in this case, the individual line items may not sum together. The statement of financial position will be evaluated based on the evaluation criteria, regardless of whether you include all line items or only selected line items.

- In columns C-P, fill in the projections for year-end figures for each year of your proposed program's period of performance. Provide separate projections for the program funds ("program account") as well as for your entire organization ("total organization"). For the purposes of the financial projections, the statement of financial position should assume the full EPA funding request is recognized as an asset at the beginning of the period of performance. Given that the period of performance is anticipated to begin by July 2024, the statement of financial position should reflect year-end figures as of June 30th of each year, starting with June 30th, 2025.

Statement of Activities

- In column B, add and subtract rows for specific line items in your projections of the statement of activities to support evaluation against the evaluation criteria listed in Section V.A: Evaluation Criteria. Applications may be able to receive full points even if they submit only selected line items; in this case, the individual line items may not sum together. The statement of activities will be evaluated based on the evaluation criteria, regardless of whether you include all line items or only selected line items.

- In columns C-P, fill in the projections for annual figures for each year of your proposed program's period of performance. Provide separate projections for the program funds ("program account") as well as for your entire organization ("total organization"). Given that the period of performance is anticipated to begin by July 2024, the statement of activities should reflect activities from July through June of each year, starting with July 2024-June 2025.

Definitions -In columns A-C, add and subtract rows for specific line items that may need to be defined for evaluators to assess your financial projections against the evaluation criteria listed in Section V.A: Evaluation Criteria.

Statement of Financial Position

Statement of Financial Position (Balance Sheet)

Year 1

Year 2

Year 3

Year 4

Year 5

Year 6

Year 7

Program Account

Total Organization

Program Account

Total Organization

Program Account

Total Organization

Program Account

Total Organization

Program Account

Total Organization

Program Account

Total Organization

Program Account

Total Organization

Line

Assets

1a.

Restricted Cash and Cash Equivalents

1b.

Unrestricted Cash and Cash Equivalents

1c.

Total Current Assets

1d.

Restricted Grants Receivables

1e.

Unrestricted Grants Receivables

1f.

Loans and Financing Receivables (Gross)

1g.

Loan Loss Reserves

1h.

Total Assets

Liabilities

1i.

Short-Term Notes Payable

1j.

Current Portion of Long-Term Notes Payable

1k.

Total Current Liabilities

1l.

Long-Term Notes Payable

1m.

Total Liabilities

Net Assets, Net Worth, and Other

1n.

Unrestricted Net Assets

1o.

Temporarily Restricted Net Assets

1p.

Permanently Restricted Net Assets

1q.

Total Net Assets

	Supplemental Data
1r.	Off-Balance Sheet Obligations, Contingent Liabilities
1s.	Portfolio-at-Risk

Statement of Activities

Statement of Activities (Income Statement)

Year 1

Year 2

Year 3

Year 4

Year 5

Year 6

Year 7

Program Account

Total Organization

Program Account

Total Organization

Program Account

Total Organization

Program Account

Total Organization

Program Account

Total Organization

Program Account

Total Organization

Program Account

Total Organization

Line

Income and Other Revenue

2a.

Interest Income

2b.

Fee Income

2c.

Other Income

2d.

Grants and Contributions

2e.

Other Operating Revenue, Income

2f.

Non-Operating Revenue, Income

2g.

Total Revenue, Income

Expenses

2h.

Amortization Expense

2i.

Depreciation Expense

2j.

Provision for Loan Losses

2k.

Operating Expenses

2l.

Interest Expense on Loans

2m.

Non-Operating Expenses

2n.

Total Expenses

2o.

Total Change in Net Assets

2p.

Total Net Assets, Beginning of Period

2q.

Total Net Assets, End of Period

Definitions

Statement of Financial Position (Balance Sheet) Definitions
Line	Line Item	Definition
1a.	Restricted Cash and Cash Equivalents	The total value of cash and cash equivalent items, which are restricted as to withdrawal or usage. This includes any cash balances or marketable securities held to satisfy specific covenants or requirements against borrowing agreements or contracts entered into with other parties.
1b.	Unrestricted Cash and Cash Equivalents	The total value of cash and cash equivalent items, which can be converted into cash immediately (such as bank accounts or marketable securities) and are not restricted as to withdrawal or usage.
1c.	Total Current Assets	The value of all assets that are reasonably expected to be converted into cash within one year in the normal course of business, and face no restrictions on such conversion. This includes cash, accounts receivable net of any allowance for uncollected receivables (if applicable), inventory, marketable securities, prepaid expenses, current portion of loans receivable net of any allowance for loan losses (if applicable), and other liquid assets that can be readily converted to cash.
1d.	Restricted Grants Receivables	The value of any money owed to the organization in the form of a committed grant or donation with restrictions on usage.
1e.	Unrestricted Grants Receivables	The value of any money owed to the organization in the form of a committed grant or donation that is unrestricted and can be utilized for any decided-upon purpose.
1f.	Loans and Financing Receivables (Gross)	The gross value of a portfolio of loans and other financial products receivable, excluding any amounts related to undisbursed funds and/or holdbacks. This shall be equal to the unpaid principal balance of the entire portfolio of loans.
1g.	Loan Loss Reserves	The cumulative allowance set aside as a reserve to offset future losses on outstanding loans and any off-balance sheet credit instruments.
1h.	Total Assets	The total value of the organization's current assets and noncurrent assets.
1i.	Short-Term Notes Payable	Notes payable within the current 12-month period (excluding the current portion of long-term notes payable).
1j.	Current Portion of Long-Term Notes Payable	The current portion of long-term debt that must be paid in the coming 12-month period.
1k.	Total Current Liabilities	The total value of all debts or obligations that must be paid in the coming 12-month period, as presented in the current liabilities section of the balance sheet. Current liabilities include, but are not limited to, accounts payable, accrued expenses, short-term notes or debt payable, and the current portion of long-term debt payable.
1l.	Long-Term Notes Payable	Notes payable beyond the current 12-month period or operating cycle.
1m.	Total Liabilities	The total value of the organization's current liabilities and noncurrent liabilities.
1n.	Unrestricted Net Assets	Net assets that are unrestricted and can be utilized for any decided-upon purpose.
1o.	Temporarily Restricted Net Assets	The portion of any donor-restricted funds that are not classified as permanently restricted net assets.
1p.	Permanently Restricted Net Assets	The value of assets (funds or other endowments) given by an outside individual or agency that are supposed to be kept in perpetuity with restrictions on their use or purpose.
1q.	Total Net Assets	"Total Assets" less "Total Liabilities."
1r.	Off-Balance Sheet Obligations, Contingent Liabilities	Value of all contingent liabilities that do not appear on the balance sheet. The information would be reported only if the contingency is probable and the amount of the liability can be estimated. Contingent liabilities represent financial obligations that may be incurred dependent upon the outcome of one or more future events or the actions of another party. Examples include agreements to lend money if a borrower cannot obtain alternative financing, or cases where an organization substitutes its own credit for a third party, including any standby letters of credit; sale and repurchase agreements; and financial futures and forward contracts.
1s.	Portfolio-at-Risk	The total amount of troubled debt restructurings and loans delinquent by 90 days or more.

Statement of Activities (Income Statement) Definitions
Line	Line Item	Definition
2a.	Interest Income	The value of all interest collected on loans and notes, excluding interest on investments and any amounts reported as non-interest or other non-operating income.
2b.	Fee Income	The value of any income charged as fees on assets or accounts, including any service charges or commissions. Fees may include, but are not limited to, loan origination fees, management or sponsor fees, etc.
2c.	Other Income	The total value of any other operational income not defined as Interest Income, Fee Income or Other Operation Revenue, excluding realized/unrealized gain on investments.
2d.	Grants and Contributions	The value of all sums of money, endowments, and financial awards from a donor entity or government (federal, state, or local).
2e.	Other Operating Revenue, Income	The value of all non-lending related income earned from normal business transactions within the current reporting period (such as rental income, consulting services, etc.).
2f.	Non-Operating Revenue, Income	The total value of all income unrelated to the main purpose of the business that is derived from sources other than loan interest or fee income (such as interest or realized/unrealized gain on investments), including any miscellaneous or other income amounts reported as one-time gains or unusual receipts.
2g.	Total Revenue, Income	The total value of income from all sources within the reporting period.
2h.	Amortization Expense	The sum of all amounts that recognize the reduction in value or cost of consumption for each intangible asset over the period owned. An intangible asset is a non-physical asset, such as a copyright, patent, or trademark.
2i.	Depreciation Expense	The sum of all amounts that recognize the cost of consumption for long-lived tangible and depreciable assets.
2j.	Provision for Loan Losses	The net change of all estimated expenses booked as an allowance to the loan loss reserve account.
2k.	Operating Expenses	The value of all expenses incurred as a part of normal business operations, not including interest, financing, depreciation, amortization, and loan loss provision expense.
2l.	Interest Expense on Loans	The value of all amounts owed for paying interest on borrowed money, including any interest on subordinated notes and debentures, mortgage indebtedness, and/or capitalized leases. Exclude interest payments made on deposits or other interest-bearing liabilities.
2m.	Non-Operating Expenses	The total value of all non-operational expenses or other expenditures unrelated to the main purpose of the business (such as realized/unrealized loss on investments). This includes any one-time or unusual costs and expenditures.
2n.	Total Expenses	The total value of all operational and non-operational expenses (including interest, financing cost, depreciation, amortization, and loan loss provision) incurred during the reporting period.
2o.	Total Change in Net Assets	"Total Revenues" less "Total Expenses."
2p.	Total Net Assets, Beginning of Period	The Total Net Assets at the Beginning of the Period should match the Total Net Assets at the end of the previous period.
2q.	Total Net Assets, End of Period	The Total Net Assets at the end of the reporting period.

File details come from the government source that posted it. Updated Jul 16, 2023.