Capital Magnet Fund Performance Reporting Data Points

Capital Magnet Fund Performance Report and Environmental Review Form

CMF Performance Reporting Data Points _241018.xlsx

Capital Magnet Fund Performance Report

OMB:

Document [xlsx]
Download: xlsx | pdf

Overview

Guide to Data Points
CMF Performance Report PRA

Sheet 1: Guide to Data Points
This spreadsheet contains the data points, also known as data fields, for the Capital Magnet Fund (CMF) Performance Report. The CMF Performance Report is an online form in the CDFI Fund's Awards Management Information System (AMIS). Recipients of the CMF Award submit the CMF Annual Performance Report via AMIS once a year, three (3) months after their Period of Performance. Recipients respond to the questions in the CMF Annual Performance Report by providing numerical figures, “yes” or “no” answers, or narrative responses, as appropriate. This report is used to determine Recipient compliance with the applicable performance goals in their Assistance Agreement (“Agreement”), and to demonstrate how Award funds are expended.

Prior to submitting the report, the Recipient will be required to select checkboxes to certify, on behalf of the organization, the following:
1.The person entering the data and making these certifications is an Authorized Representative.

2.Any information or data provided to the CDFI Fund that is entered in AMIS (or other submission method) is true, accurate, and complete, and accurately represents the activities and/or performance of the Recipient.

3.The Recipient is compliant with all applicable assurances, certifications, representations and warranties, covenants, and agreements set forth in the Agreement or, alternatively, has notified the CDFI Fund of the Recipient’s inability to be compliant with such provisions of the Agreement through the submission of a Material Event notification.

NOTE: All capitalized terms used herein but not defined have such definitions as specified in the Program’s Interim Rules, applicable Notice of Funds Availability, or Agreement.

This spreadsheet contains two tabs: Guide to Data Points and CMF Performance Report Fields. Commenters should review all tabs in this spreadsheet and are encouraged to reference field numbers (column A on the tab entitled "CMF Performance Report") when providing comments. Note: Changes to data points from the prior version of the CMF Performance Report (i.e. data points being added/modified/removed) are identified in the second column in the CMF Performance Report Fields worksheet in the column titled "Data Field Changes."
The information below explains how to interpret the information for each field in the CMF Performance Report Fields tab. The fields in this tab represent the proposed data collection from CMF Recipients for purposes of monitoring performance and compliance with Assistance Agreements under the CMF Program. Capitalized terms not defined in this document (other than titles) have meanings set forth in the CMF Interim Rule (12 C.F.R. 1807) or the CMF Assistance Agreement. The CMF Interim Rule and a template for the most recent Assistance Agreement are available on the CDFI Fund’s website: www.cdfifund.gov/cmf.
·         Field # – Provided for ease of identification.
·         Data Field Changes – Notates changes (if any) to data points.
·         Category – General category of data
·         Field Name – Name of the Field as it will appear in AMIS. Note, field names often contain abbreviated words due to AMIS limitations.
·         Instruction – Brief instruction for the data to be entered.
·         Record Type - Indication of the record type where the data point appears in AMIS. A Project Record generally contains information entered only one time for each Project. An Annual Project Report Record supplements the Project Record and contains milestone dates and similar data points and data that may change from year to year, such as occupancy data. Data entered on an Annual Project Report record can be "cloned" after the first time the data is entered to reduce the requirement for data re-entry in subsequent years. Annual Project Report Records can be created through a .csv file format upload or individually. A Project Location record is a record type used to record location information for rental projects. Homeownership Program records are a type of record in which the user creates a Homeownership Program to which individual Homeownership properties can then be linked. The Performance Scorecard summarized Recipient performance against performance goals. It only requires Recipient input when noncompliance occurs. The Uses of Award data is used to monitor use of award funds.
·         Input Type – Type of data input
·         Options for Input – Options for data input, if applicable.
·         Mandatory/Conditionally Required/Optional? - Data points may be mandatory, conditionally required based on circumstances (e.g. a completion date is required only if the project has met the conditions for Project Completion)
·         Applies to Direct Administrative Expense – “Yes” indicates that this field applies to a Direct Administrative Expense entry.
·         Applies to Economic Development Activities – “Yes” indicates that this field applies to an Economic Development Activities entry.
·         Applies to Rental Projects – “Yes” indicates that this field applies to a Rental Projects entry.
·         Applies to Homeownership – “Yes” indicates that this field applies to a Homeownership entry.

Sheet 2: CMF Performance Report PRA
Field # Data Field Changes (Keep/Add/
Modify/
Remove)		 Category Field Name Instruction Record Type Input type Options for Input Mandatory/ Conditionally Required/ Optional? * Applies to Direct Admin. Expenses Applies to Econ. Dev. Activities Applies to Rental Projects Applies to Home-ownership *2 Applies to Investment Period of Performance *** Applies to Affordability Period of Performance (Mandatory) Column2
1 Keep Administrative Project Record type Select the type of Project type to begin creation of a Project record. CMF Project Record Single item picklist Drop-down menu - Economic Development Activities, Homeownership Housing, Rental Housing Mandatory
Yes Yes Yes Yes
Yes
No
2 Keep Administrative Project Name Enter a user defined Project name for identification purposes. CMF Project Record Text Field N/A Mandatory
Yes Yes Yes Yes
Yes
No
3 Modify Administrative Eligible Activity Choose Eligible Activity (Previously called Eligible Use) CMF Project Record Single item picklist Choose from Homeownership Housing, Rental Housing, Economic Development Activities, or Direct Administrative Expenses Mandatory
Yes Yes Yes Yes
Yes
No
4 Modify Financing Characteristics Primary Financing Type Enter the financing type. CMF Project Record Multi-select checkbox • Predevelopment
• Acquisition
• Construction
• Bridge/short term financing
• Permanent (1st Lien)
• Permanent (2nd Lien or lower) – includes soft debt
• Refinancing
• Loan Loss Reserve
• Loan Guarantee
• Secondary market activity
• Equity
• Down payment/Closing Cost Assistance		 Mandatory
No Yes Yes Yes
Yes
No
5 Modify Financing Characteristics Project Type Enter each financing type used in each Project. CMF Project Record Multi-select checkbox Homeownership: (SF-New Development, SF- Rehab, SF- Purchase (Mortgage Finance), SF-Purchase (Down Payment/Closing Cost Assistance)

Rental: (MF - New Development, MF - Rehab, MF - Preservation without Rehab, MF - Preservation with Rehab, MF - Acquisition without Rehab, MF - Acquisition with Rehab)

EDA: EDA (Commercial Facilities), EDA (Community Service Facilities)		 Mandatory
No Yes Yes Yes
Yes
No
6 Add Financing Characteristics Consortium Project Check box if Project is financed by Recipients using a Consortium Approach. CMF Project Record Checkbox N/A conditionally Required
No Yes Yes Yes
Yes
No
7 Remove Financing Characteristics Project Type - 2016 Only Enter each financing type used in each Project. CMF Project Record Single item picklist SF - New Development, SF - Rehab, SF - Preservation without Rehab, SF -Preservation with Rehab Mandatory
No No No Yes
Yes
No
8 Modify CMF Award $ Project Commitment Amount Enter the Project Commitment Amount (total amount of CMF Award Committed to the Project). CMF Project Record Currency Dollar amount Mandatory
Yes Yes Yes Yes
Yes
No
9 Keep CMF Award $ Total CMF Disbursement Amount Through FYE Enter the total amount of the CMF Award disbursed to each Project through the last day of the performance year. CMF Project Record Currency Dollar amount Mandatory
Yes Yes Yes Yes
Yes
No
10 Keep Financing Characteristics Type of Disbursement Enter the primary disbursement type. CMF Project Record Single item picklist grant, debt, equity Conditionally required
No Yes Yes Yes
Yes
No
11 Keep Administrative Date of Project Commitment Enter the date the Recipient issued a Commitment to the Project. CMF Project Record Date field N/A Conditionally required
Yes Yes Yes Yes
Yes
No
12 Keep Administrative Date of First Disbursement Enter the date the Recipient issued its first disbursement of the CMF Award or Program Income to the Project. CMF Project Record Date field N/A Conditionally required
No Yes Yes Yes
Yes
No
13 Keep Administrative Date of Full Disbursement Enter the date the Recipient issued its final and full disbursement of the CMF Award or Program Income to the Project. CMF Project Record Date field N/A Conditionally required
No Yes Yes Yes
Yes
No
14 Modify Administrative Project Completion Date Enter the date the Project was completed. CMF Project Record Date field N/A Conditionally required
No Yes Yes Yes
Yes
No
15 Keep Administrative Placed into Service Date Enter the date the Project was Placed into Service. CMF Project Record Date field N/A Conditionally required
No Yes Yes Yes
Yes
No
16 Keep Administrative Initial Occupancy Date Enter the date the Project was Initially Occupied. CMF Project Record Date field N/A Conditionally required
No Yes Yes Yes
Yes
No
17 Add Administrative Foreclosure Date Enter the date the Project was foreclosed CMF Project Record Date field N/A Conditionally required
No Yes Yes Yes
Yes
No
18 Add Administrative Intent to replace terminated unit Select the intent to replace the unit pursuant to CMF requirements. CMF Project Record Single item picklist I intend to replace the unit; I do not intend to replace the unit Conditionally required
No No No Yes
Yes
No
19 Keep Administrative Termination Date Enter the date the Project no longer was being considered for CMF financing or no longer met CMF Program affordability requirements, after being occupied. CMF Project Record Date field N/A Conditionally required
No Yes Yes Yes
Yes
No
20 Keep Administrative Housing Project Replaced Enter the project name of the home that this home is replacing in the case of a replacement of a home during the Homeownership Affordability Period. CMF Project Record Single item picklist Options based on prior Homeownership records created. Conditionally required
No No No Yes
Yes
No
21 Modify Administrative Investment Period or Affordability Period at Recipient’s FY End Select the appropriate Award Period (Investment Period or Affordability Period) for the Project as of the date of the last day in the annual reporting period. CMF Project Record Single item picklist Affordability Period, Investment Period Mandatory
No Yes Yes Yes
Yes
No
22 Modify Administrative Project Status at Fiscal Year End Enter the status of the Project as of the last day of the reporting period. CMF Project Record Single item picklist Picklist options for Homeownership: Committed, Partially Complete, Complete: Unoccupied, Complete: Occupied, Terminated: Unit Replaced, Foreclosed, Incomplete – Terminated

Picklist options for Rental: Committed, Partially Complete, Complete, Placed into Service, Foreclosed, Incomplete – Terminated

Picklist options for EDA: Committed, Partially Complete, Complete, Change in Use, Foreclosed, Incomplete – Terminated		 Mandatory
No Yes Yes Yes
Yes
No
23 Keep Administrative No Additional EPCs to Report Check the box to indicate that the Project has achieved Project Completion, is initially occupied, and there will be no additional Eligible Project Costs to report in the following year. This will simplify the annual project report display in the following year. CMF Project Record Checkbox N/A Optional
No No Yes No
Yes
No
24 Modify Administrative Housing Program Associate each home with a Homeownership Housing Program, if applicable. CMF Project Record Single item picklist Options based on the Recipient's creation of Homeownership Housing Programs in AMIS Conditionally required
No No No Yes
Yes
No
25 Modify Family Characteristics Homebuyer Income Category Enter the income category of the homeowner/purchaser. CMF Project Record Single item picklist ≤30% AMI, >30% AMI but ≤ 50% AMI, >50% AMI but ≤ 60% AMI, >60% AMI but ≤ 80% AMI, >80% AMI but ≤ 120% AMI, > 120% AMI Mandatory
No No No Yes
Yes
No
26 Modify Financing Characteristics Homeownership Purchase Price Limit Enter the Purchase Price Limit pursuant to the CMF Award. CMF Project Record Currency Dollar amount Mandatory
No No No Yes
Yes
No
27 Modify Financing Characteristics Purchase Price Enter the purchase price or the value of the home at time of financing or post rehab value, as applicable. CMF Project Record Currency Dollar amount Mandatory
No No No Yes
Yes
No
28 Add Financing Characteristics Secondary Market Activity Amount Enter dollar amount of CMF Award funds used to purchase secondary market mortgages. CMF Project Record Currency Dollar amount Mandatory
No No Yes Yes
Yes
No
29 Modify Family Characteristics Homeowner - Race Indicate the race and/or ethnicity of the homeowner if available from the homeowner. CMF Project Record Multi-select checkbox American Indian or Alaska Native, Asian, Black or African American, Hispanic or Latino, Middle Eastern or North African, Native Hawaiian or Pacific Islander, White, Did not ask the Family to provide, Family declined to provide. Optional
No No No Yes
Yes
No
30 Remove Family Characteristics Homeowner - Hispanic Indicate if the homeowner is of Hispanic origin. CMF Project Record Single item picklist Yes, No, Not Available Optional
No No No Yes
Yes
No
31 Modify Property Characteristics Projected Units (≤ 30% AMI) Enter the total projected rental units to be completed for this income category. CMF Project Record Numeric N/A Mandatory
No No Yes No
Yes
No
32 Modify Property Characteristics Projected Units (>30% AMI but ≤ 50% AMI) Enter the total projected rental units to be completed for this income category. CMF Project Record Numeric N/A Mandatory
No No Yes No
Yes
No
33 Add Property Characteristics Projected Units (>50% AMI but ≤ 60% AMI) Enter the total projected rental units to be completed for this income category. CMF Project Record Numeric N/A Mandatory
No No Yes No
Yes
No
34 Modify Property Characteristics Projected Units (>60% AMI but ≤ 80% AMI) Enter the total projected rental units to be completed for this income category. CMF Project Record Numeric N/A Mandatory
No No Yes No
Yes
No
35 Modify Property Characteristics Projected Units (>80% AMI but ≤ 120% AMI) Enter the total projected rental units to be completed for this income category. CMF Project Record Numeric N/A Mandatory
No No Yes No
Yes
No
36 Modify Property Characteristics Projected Units (>120% AMI) Enter the total projected rental units that are not unrestricted by income. CMF Project Record Numeric N/A Mandatory
No No Yes No
Yes
No
37 Modify Property Characteristics Completed Units (≤ 30% AMI) Enter the total actual number units completed in the indicated income category by the end of the last performance year. CMF Project Record Numeric N/A Conditionally Required
No No Yes No
Yes
No
38 Modify Property Characteristics Completed Units (>30% AMI but ≤ 50% AMI) Enter the total actual number of units completed in the indicated income category by the end of the last performance year. CMF Project Record Numeric N/A Conditionally Required
No No Yes No
Yes
No
39 Add Property Characteristics Completed Units (>50% AMI but ≤ 60% AMI) Enter the total actual number of units completed in the indicated income category by the end of the last performance year. CMF Project Record Numeric N/A Conditionally Required
No No Yes No
Yes
No
40 Modify Property Characteristics Completed Units (>60% AMI but ≤ 80% AMI) Enter the total actual number units completed in the indicated income category by the end of the last performance year. CMF Project Record Numeric N/A Conditionally Required
No No Yes No
Yes
No
41 Modify Property Characteristics Completed Units (>80% AMI but ≤ 120% AMI) Enter the total actual number units completed in the indicated income category by the end of the last performance year. CMF Project Record Numeric N/A Conditionally Required
No No Yes No
Yes
No
42 Modify Property Characteristics Completed Units (>120% AMI) Enter the total actual number units completed in the indicated income category by the end of the last performance year. CMF Project Record Numeric N/A Conditionally Required
No No Yes No
Yes
No
43 Modify Family Characteristics Occupied Units (≤ 30% AMI) Enter the occupancy by income category as of the last day of the last performance year. CMF Project Record Numeric N/A Conditionally Required
No No Yes No
Yes
Yes
44 Modify Family Characteristics Occupied Units (>30% AMI but ≤ 50% AMI) Enter the occupancy by income category as of the last day of the last performance year. CMF Project Record Numeric N/A Conditionally Required
No No Yes No
Yes
Yes
45 Add Family Characteristics Occupied Units (>50% AMI but ≤ 60% AMI) Enter the occupancy by income category as of the last day of the last performance year. CMF Project Record Numeric N/A Conditionally Required
No No Yes No
Yes
Yes
46 Modify Family Characteristics Occupied Units (>60% AMI but ≤ 80% AMI) Enter the occupancy by income category as of the last day of the last performance year. CMF Project Record Numeric N/A Conditionally Required
No No Yes No
Yes
Yes
47 Modify Family Characteristics Occupied Units (>80% AMI but ≤ 120% AMI) Enter the occupancy by income category as of the last day of the last performance year. CMF Project Record Numeric N/A Conditionally Required
No No Yes No
Yes
Yes
48 Modify Family Characteristics Occupied Units (>120% AMI) Enter the occupancy by income category as of the last day of the last performance year. CMF Project Record Numeric N/A Conditionally Required
No No Yes No
Yes
Yes
49 Remove Family Characteristics LI Families - 61 - 80% AMI Enter the occupancy by income category as of the last day of the last performance year. CMF Project Record Numeric N/A Conditionally Required
No No Yes No
Yes
Yes
50 Remove Family Characteristics VLI Families - 31 - 60% AMI Enter the occupancy by income category as of the last day of the last performance year. CMF Project Record Numeric N/A Conditionally Required
No No Yes No
Yes
Yes
51 Add Financing Characteristics Term (in months) Enter the number of months at origination that a loan financed/or supported with a CMF Award is scheduled to exist. (i.e., the number of months from loan origination until the loan is fully due at maturity). CMF Project Record Numeric Whole number Conditionally required
No Yes Yes Yes
Yes
No
52 Keep Financing Characteristics Amortization Type Choose one of the pre-defined values below and report how the financial note is amortized at origination: Fully Amortized - Both interest and principal payments scheduled throughout the loan's life; Partially Amortized - Schedule includes some periodic principal payments with a larger principal payment at maturity; Non-Amortized - Schedule includes interest only payments with a single principal payment at maturity; Other CMF Project Record Single item picklist Fully Amortized, Partially Amortized, Non-Amortized, Other Conditionally required
No Yes Yes Yes
Yes
No
53 Keep Financing Characteristics Interest Rate Report the interest rate of the loan at origination. Enter the percentage as a whole number (i.e. if the Interest Rate is 2.5%, enter 2.5). If the interest rate is unknown or not applicable, enter “99”. For Homeownership loans, enter the APR on the loan financed and/or supported by the CMF Award. For Rental or Economic Development Activity (EDA) Projects enter the interest rate on the loan financed and/or supported by the CMF Award. CMF Project Record Numeric N/A Conditionally required
No Yes Yes Yes
Yes
No
54 Remove Financing Characteristics Federal Sources Funding Amount Enter the total amount of funding source from other federal grant or loan programs. CMF Project Record Currency N/A Conditionally required
No Yes Yes Yes
Yes
No
55 Remove Financing Characteristics Federal Sources Funding Source Enter the names of any other federal grant or loan programs financing the project. CMF Project Record Text Field N/A Conditionally required
No Yes Yes Yes
Yes
No
56 Modify Financing Characteristics Other CDFI Fund Program Funds Used Indicate whether the Project has financing via another CDFI Fund program. CMF Project Record Multi-select checkbox BEA, FA, TA, RRP, ERP, SDLP, NMTC, BGP,HFFI, Other Mandatory
No Yes Yes Yes
Yes
No
57 Modify Financing Characteristics Other Federal Housing Program Funds Used Indicate if a funding source from other federal grant or loan programs was used. CMF Project Record Single item picklist yes, no Mandatory
No Yes Yes Yes
Yes
No
58 Add Financing Characteristics Federal Sources of Funding Identify any other federal grant or loan programs that were used to fund the project. CMF Project Record Multi-select checkbox LIHTC, HOME, Section 8, CDBG, FHLB Affordable Housing Program, USDA Multi-family Direct Loans, USDA Multi-family Loan Guarantees, HUD Section 202 (Elderly), HUD Section 811 (Disabled), HUD Choice Neighborhood Implementation Grants, Other - please specify (with open text box) Conditionally required
No Yes Yes Yes
Yes
No
59 Keep Impact # Construction Jobs Created Enter the number of construction jobs created. CMF Project Record Numeric N/A Optional
No Yes Yes Yes
Yes
No
60 Keep Impact # Non-Construction Jobs Created Enter the number of non-construction jobs created. CMF Project Record Numeric N/A Optional
No Yes No No
Yes
No
61 Keep Impact First-Time Homebuyer Indicate if the homeowner is a first time homeowner. CMF Project Record Single item picklist yes, no Mandatory
No No No Yes
Yes
No
62 Keep Program Income PI earned - equity & loan principal repayment plus any recoveries Enter the total amount of Program Income through the last day of the reporting year from equity and loan repayments or recoveries. CMF Project Record Currency Dollar amount Conditionally required
No Yes Yes Yes
Yes
No
63 Keep Program Income PI earned - Interest Income Enter the total amount of Program Income through the last day of the reporting year from interest. CMF Project Record Currency Dollar amount Conditionally required
No Yes Yes Yes
Yes
No
64 Remove Project Costs Enterprise-level Capital Enter the total amount of Enterprise-level capital invested in the Project. CMF Project Record Numeric N/A Mandatory
No Yes Yes Yes
Yes
No
65 Remove Project Costs EPC: Projected Recipient - Level Leverage $ Enter the projected Recipient-level leverage to be invested in the Project. CMF Project Record Numeric N/A Mandatory
No Yes Yes Yes
Yes
No
66 Remove Project Costs EPC: Recipient - Level Leverage $ Enter the Recipient-level leverage invested in the Project through the end of the last performance year. CMF Project Record Numeric N/A Mandatory
No Yes Yes Yes
Yes
No
67 Modify Project Costs Projected EPC: Private Leverage ($) Enter the total projected Eligible Project Costs that will be financed with private leverage for this Project. CMF Project Record Currency Dollar amount Mandatory
No Yes Yes Yes
Yes
No
68 Modify Project Costs Projected EPC: Public Leverage ($) Enter the total projected Eligible Project Costs that will be financed with public leverage for this Project. CMF Project Record Currency Dollar amount Mandatory
No Yes Yes Yes
Yes
No
69 Modify Project Costs Families Projected EPC
(≤ 30% AMI)		 Enter the total projected Eligible Project Costs for units restricted to this income category. CMF Project Record Currency Dollar amount Mandatory
No No Yes No
Yes
No
70 Modify Project Costs Families Projected EPC (>30% AMI but ≤ 50% AMI) Enter the total projected Eligible Project Costs for units restricted to this income category. CMF Project Record Currency Dollar amount Mandatory
No No Yes No
Yes
No
71 Add Project Costs Families Projected EPC (>50% AMI but ≤ 60% AMI) Enter the total projected Eligible Project Costs for units restricted to this income category. CMF Project Record Currency Dollar amount Mandatory
No No Yes No
Yes
No
72 Modify Project Costs Families Projected EPC (>60% AMI but ≤ 80% AMI) Enter the total projected Eligible Project Costs for units restricted to this income category. CMF Project Record Currency Dollar amount Mandatory
No No Yes No
Yes
No
73 Modify Project Costs Families Projected EPC (>80% AMI but ≤ 120% AMI) Enter the total projected Eligible Project Costs for units restricted to this income category. CMF Project Record Currency Dollar amount Mandatory
No No Yes No
Yes
No
74 Modify Project Costs Families Projected - Project costs that are not EPCs (>120%) Enter the total projected Eligible Project Costs for units unrestricted to this income category. CMF Project Record Currency Dollar amount Mandatory
No No Yes No
Yes
No
75 Modify Project Costs EPC: Private Leverage ($) Enter the total private leverage invested in the Project through the end of the last performance year. CMF Project Record Currency Dollar amount Mandatory
No Yes Yes Yes
Yes
No
76 Modify Project Costs EPC: Public Leverage ($) Enter the total amount of the CMF award plus any other public investments in the Project through the end of the last performance year. CMF Project Record Currency Dollar amount Mandatory
No Yes Yes Yes
Yes
No
77 Add Project Costs Families Completed EPC
(≤ 30% AMI)		 Enter the actual Eligible Project Costs for units restricted to this income category through the end of the last performance year. CMF Project Record Currency Dollar amount Mandatory
No No Yes No
Yes
No
78 Modify Project Costs Families Completed EPC (>30% AMI but ≤ 50% AMI) Enter the actual Eligible Project Costs for units restricted to this income category through the end of the last performance year. CMF Project Record Currency Dollar amount Mandatory
No No Yes No
Yes
No
79 Add Project Costs Families Completed EPC (>50% AMI but ≤ 60% AMI) Enter the actual Eligible Project Costs for units restricted to this income category through the end of the last performance year. CMF Project Record Currency Dollar amount Mandatory
No No Yes No
Yes
No
80 Modify Project Costs Families Completed EPC (>60% AMI but ≤ 80% AMI) Enter the actual Eligible Project Costs for units restricted to this income category through the end of the last performance year. CMF Project Record Currency Dollar amount Mandatory
No No Yes No
Yes
No
81 Modify Project Costs Families Completed EPC (>80% AMI but ≤ 120% AMI) Enter the actual Eligible Project Costs for units restricted to this income category through the end of the last performance year. CMF Project Record Currency Dollar amount Mandatory
No No Yes No
Yes
No
82 Modify Project Costs Non Eligible Families- Project costs that are not EPCs (>120% AMI) Enter the actual non-Eligible Project Costs for unrestricted units or other non-eligible costs. CMF Project Record Currency Dollar amount Mandatory
No No Yes No
Yes
No
83 Keep Project Costs Non Eligible Project Costs in Year Enter the total actual non-Eligible Project Costs invested in the Project through the end of the last performance year. CMF Project Record Currency Dollar amount Mandatory
No Yes Yes Yes
Yes
No
84 Keep Program Income Commit. of PI – equity/loan/recoveries Enter the amount of the CMF Award Committed to the Project from Program Income (PI) that was from return of equity, principal repayment, or recoveries (e.g. principal repayments from a CMF loan are the source of funds made to use the subsequent investment). CMF Project Record Currency Dollar amount Conditionally required
Yes Yes Yes Yes
Yes
No
85 Keep Program Income Commitment of PI – Interest Income Enter the amount of the CMF Award Committed to the Project from Program Income that was from return on equity, principal repayment, or any other form of Program Income (e.g., interest payments on a CMF loan are the source of funds made to use a subsequent disbursement). CMF Project Record Currency Dollar amount Conditionally required
Yes Yes Yes Yes
Yes
No
86 Keep Program Income Disbursement of PI - Interest Income Enter the total amount of the CMF Award disbursed to the Project from Program Income that was from return on equity, principal repayment, or any other form of Program Income (e.g., interest payments on a CMF loan are the source of funds made to use a subsequent disbursement). CMF Project Record Currency Dollar amount Conditionally required
Yes Yes Yes Yes
Yes
No
87 Keep Program Income Disbursement of PI -equity/loan/recoveries Enter the total amount of the CMF Award Disbursed to the Project from Program Income that was from return of equity, principal repayment, or recoveries. (e.g. Principal repayments from a CMF loan are the source of funds made to use the subsequent investment.) CMF Project Record Currency Dollar amount Conditionally required
Yes Yes Yes Yes
Yes
No
88 Remove Project Costs Projected Enterprise-level Capital Enter the total amount of projected Enterprise-level capital to be invested in the Project. CMF Project Record Numeric N/A Mandatory
No Yes Yes Yes
Yes
No
89 Add Property Characteristics Expiration date of affordability restrictions Date of the expiration or recission of existing restrictions CMF Project Record Date field N/A Conditionally required
No No Yes No
Yes
No
90 Keep Property Characteristics Out of Service Units Indicate the number of units out of service for Rehabilitation or repair for at least 90 days during the Fiscal Year. CMF Project Record Numeric N/A Conditionally required
No No Yes No
Yes
No
91 Remove Property Characteristics Rental Housing Waiting List? Indicate the number of families on the waiting list for available units at the end of the reporting period, if available. CMF Project Record Numeric N/A Mandatory
No No Yes No
Yes
No
92 Add Financing Characteristics Tenant Income Recertification Exemption Is this Project subject to the CMF rent certification exemption? (100% of units are rent restricted) CMF Project Record Single item picklist yes, no Mandatory
No No Yes No
Yes
No
93 Keep Locational 2018 Disaster Area Check the box if the Project is located in a 2018 Disaster Area. CMF Project Record Checkbox Check or leave blank. Conditionally required
No Yes Yes Yes
Yes
No
94 Keep Property Characteristics EDA type Enter the primary use of the EDA facility. CMF Project Record Single item picklist Business, Arts/Culture, Childcare, Education, Healthcare, Multi-service/Other Mandatory
No Yes No No
Yes
No
95 Keep Locational Related Project Address Enter street address of at least one related affordable housing location served by the EDA Activity. CMF Project Record Text Field N/A Mandatory
No Yes No No
Yes
No
96 Keep Locational Related Project City Enter city for the related affordable housing location served by the EDA Activity. CMF Project Record Text Field N/A Mandatory
No Yes No No
Yes
No
97 Keep Locational Related Project State Enter state of at least one related affordable housing location served by the EDA Activity. CMF Project Record Single item picklist State/Territory Abbreviations Mandatory
No Yes No No
Yes
No
98 Keep Locational Related Project Zip Code Enter zip code of at least one related affordable housing location served by the EDA Activity. CMF Project Record Text Field N/A Mandatory
No Yes No No
Yes
No
99 Keep Property Characteristics Square footage Enter the square footage if EDA is a commercial property (e.g. grocery store, retail). CMF Project Record Numeric N/A Conditionally required
No Yes No No
Yes
No
100 Keep Impact Project image Optionally, upload an image of the Project. This information may be shared publicly and should not contain any personally identifiable information. CMF Project Record Image upload N/A Optional
No Yes Yes Yes
Yes
No
101 Keep Administrative Housing Program Name Enter the name of each Homeownership program used in association with this CMF Award. Homeownership Program Record Text Field N/A Mandatory
No No No Yes
Yes
No
102 Modify Administrative Homeownership Program Commitment Date Enter the date the Recipient established the Homeownership Program and made a Commitment to that program. Homeownership Program Record Date field N/A Conditionally required
No No No Yes
Yes
No
103 Modify CMF Award $ Homeownership Program Commitment Amount Enter the Project Commitment Amount (total amount of CMF Award Committed to the Homeownership Program). Homeownership Program Record Currency Dollar amount Mandatory
No No No Yes
Yes
No
104 Keep Administrative Direct Admin Expenses Amount spent on Direct Admin Expenses Performance Scorecard Currency Dollar amount Mandatory
Yes No No No
Yes
No
105 Modify Administrative Eligible Use Choose Eligible Use (previously called Eligible Activity) Performance Scorecard Single item picklist Capitalize Loan Loss Reserves,
Capitalize a Revolving Loan Fund,
Capitalize an Affordable Housing Fund,
Capitalize a fund to support Economic Development Activities,
Make Risk-Sharing Loans,
Provide Loan Guarantees,
Direct Administrative Expenses, Feasibility Determination Expenses		 Mandatory
Yes Yes Yes Yes
Yes
No
106 Add Administrative Eligible Use - Amount Enter the Award amount spent on Eligible Use Amount Performance Scorecard Currency Dollar amount Mandatory
No Yes Yes Yes
Yes
No
107 Add Administrative Amount Committed for Eligible Use Enter the amount of the Award the Recipient committed their Award for an Eligible Use Performance Scorecard Currency Dollar amount Mandatory
No Yes Yes Yes
Yes
No
108 Add Administrative Date Committed for Use Enter the date the Recipient committed their Award for a Use Performance Scorecard Date field N/A Mandatory
No Yes Yes Yes
Yes
No
109 Modify Administrative Earnings in excess of $500 in an interest bearing account If at the end of any fiscal year, the Recipient determines that it has earned in excess of $500 in interest income from deposits prior to their allocation to an Eligible Use under 3.2(a) of the Recipient’s CMF Assistance Agreement (Advances), the amount in excess of $500 must be remitted to HHS Performance Scorecard Single item picklist Yes, No Mandatory
Yes Yes Yes Yes
Yes
No
110 Modify Administrative Excess Interest Amount If yes, how much was earned in excess of $500 in an interest bearing account       Performance Scorecard Currency Dollar amount Conditionally required
Yes Yes Yes Yes
Yes
No
111 Modify Administrative Excess Interest Remitted to HHS If yes, have you remitted this amount to HHS       Performance Scorecard Single item picklist Yes, No Conditionally required
Yes Yes Yes Yes
Yes
No
112 Add Administrative Feasibility Determination Expenses Amount spent to determine project feasibility (Feasibility Determination Expenses) Performance Scorecard Currency Dollar amount Mandatory
Yes No No No
Yes
No
113 Keep Failed PG&M Response What actions will you take to meet PG&M? Provide a narrative response to the question. Performance Scorecard Text Field N/A Conditionally required
Yes Yes Yes Yes
Yes
No
114 Keep Failed PG&M Response Why did you fail to meet this PG&M? Provide a narrative response to the question. PG&M means Performance Goal & Measure. Performance Scorecard Text Field N/A Conditionally required
Yes Yes Yes Yes
Yes
No
115 Keep Failed PG&M Response Why will you not meet PG&M by FYE? Provide a narrative response to the question. Performance Scorecard Text Field N/A Conditionally required
Yes Yes Yes Yes
Yes
No
116 Keep Failed PG&M Response Will you meet this PG&M next FYE? Select yes or no. FYE means fiscal year end. Performance Scorecard Single item picklist yes, no Conditionally required
Yes Yes Yes Yes
Yes
No
117 Add Impact CMF Impact Category Select at least one impact (and no more than three) that have resulted from the Affordable Housing strategy implemented by this Award. Performance Scorecard Multi-select checkbox •Improved financial stability and wealth building
•Improved health outcomes
•Increased opportunities to remain in the affordable homes and/or neighborhoods
•Improved access to education opportunities or transportation
•Assisted in the long-term recovery and rebuilding of affordable housing in federally designated disaster areas
•Increase homeownership rate for populations with lower rates of homeownership
•Assist in the transition to clean energy 		Mandatory
No Yes Yes Yes
Yes
No
118 Modify Impact Impact narrative Provide a brief narrative including metrics describing the its impacts and outcomes that resulted from this Award. See guidance for examples of metrics for each impact category. This information may be shared publicly and should not contain any personally identifiable information. Performance Scorecard Text Field Narrative Optional
No Yes Yes Yes
Yes
No
119 Keep Administrative Site Name Enter a user defined Project location name for identification purposes. Project Location Text Field N/A Mandatory
No No Yes No
Yes
No
120 Keep Locational $ CMF Award + PI at Location Enter the total amount of the CMF Award invested in the Project at each location. Project Location Currency Dollar amount Mandatory
No No Yes No
Yes
No
121 Modify Property Characteristics Number of Units Enter the total number of CMF-financed eligible units at each location. Project Location Numeric N/A Mandatory
No No Yes No
Yes
No
122 Add Property Characteristics Project meets expanded HOA Check box if project meets expanded HOA criteria Project Location Checkbox N/A Conditionally required
No No Yes No
Yes
No
123 Add Property Characteristics Expanded HOA Criteria Does Project meet at least 3 of the 4 criteria: 1) Access to high-quality youth (K-12) education opportunities;
(2) Access to employment opportunities;
(3) Access to transportation opportunities; and/or
(4) Access to financial service opportunities;
And is not located in a Food Desert		 Project Location Multi-select checkbox Select all that apply as defined in the Assistance Agreement as providing:
{ } Access to high-quality youth (K-12) education opportunities;
{ } Access to employment opportunities;
{ } Access to transportation opportunities;
{ } Access to financial service opportunities;
and
{ } Confirm not located in a Food Desert.		 Conditionally required
No No Yes No
Yes
No
124 Keep Locational Project Address Enter street address of the Project (or site for multi-site rental projects). Project Record (HO and EDA) or Project Location Record (Rental) Text Field N/A Mandatory
No Yes Yes Yes
Yes
No
125 Keep Locational Project City Enter city where the Project is located (or site for multi-site rental projects). Project Record (HO and EDA) or Project Location Record (Rental) Text Field N/A Mandatory
No Yes Yes Yes
Yes
No
126 Keep Locational Project State Enter state where the Project is located (or site for multi-site rental projects). Project Record (HO and EDA) or Project Location Record (Rental) Single item picklist State/Territory Abbreviations Mandatory
No Yes Yes Yes
Yes
No
127 Keep Locational Project Zip Code Enter zip code of the Project (or site for multi-site rental projects). Project Record (HO and EDA) or Project Location Record (Rental) Text Field N/A Mandatory
No Yes Yes Yes
Yes
No
128 Add Administrative Affordability Period Program Income Enter the total amount of Program Income through the last day of the reporting year from equity and loan repayments or recoveries. Performance Scorecard Currency Dollar amount Mandatory
No Yes Yes Yes
No
Yes
129 Add Administrative Eligible Units Financed with Program Income During Affordability Period Enter the number of Eligible Units financed with Program Income through the last day of the reporting year from equity and loan repayments or recoveries. Performance Scorecard Numeric N/A Mandatory
No No Yes Yes
No
Yes
File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00
© 2024 OMB.report | Privacy Policy