Investment Allocation Report 5.0
The Investment Allocation Report 5.0 is available in the Reports panel.
This report is a Microsoft Excel formatted report that helps an organization determine how they are performing in meeting their CRA obligations. The report includes investment data for CRA eligible investments made to both direct investments at the deal level and tax credit funds (middle/upper-tier).
A deal-level CRA investment is displayed in one of two columns based on whether the deal's Actual Close Date is prior to or within the exam period. If the date is prior to the exam period, then the investment amount is displayed in the Prior column. If the date is within the exam period, it is displayed in the Current column. If the date is after the As of Date of the report, it is excluded.
A Fund CRA Allocation is considered Current if the investor's Admission Date is within the Exam Period; otherwise, it is considered Prior. Prior Period Fund CRA Allocations are excluded from the report if the Ending Monthly Book Value for the associated investor is 0 or null for the month prior to the As of Date of the report. If the investor's Admission Date is after the As of Date, the investment is excluded from the report.
The report contains two main tabs—Investment As Of Sale Date and Investment End of Cycle. The tabs represent data based on two timing perspectives—prior to the report As of Date and a future look at the end of the CRA exam period. A third tab—Excluded Investments—lists the allocations that have been excluded from CRA reporting.
The requirements for inclusion in the report:
Deal-level:
The deal must be active.
Committee Review type of Credit Approval with an Approval Date must exist.
Book Balance greater than 0.00 for the month prior to the As of Date must exist (to populate the Invesment As Of Selected Date tab)
A Projected CRA Period End Value greater than 0.00 must exist (to populate the Investment End of Cycle tab)
This field can be populated only through the Book Value Mass Update Import.
The Import can be used only when the Impairment Method is Manual.
A CRA Invested Amount greater than 0.00 must exist (Edit Property).
Middle/upper-tier:
The Fund CRA Allocation has an associated fund, deal, and investor.
The record has an allocation amount.
A Fund CRA Allocation greater than 0.00 must exist.
A CRA Invested Amount greater than 0.00 must exist (Edit Property).
The deal has an associated Committee Review type of Credit Approval with the Approval Date less than or equal to the End Date of the exam period.
The Investor entity's Is Bank Affiliated checkbox is selected.
Note
If two bank-affiliated investors in a fund both have CRA Investment Allocations to the same deal, the report will include a separate line item for each investor and each property associated with the deal.
Application-level:
A Bank CRA Exam period must exist.
The exam period is created through the Bank CRA menu option under the ProLink Admin panel.
CRA Assessment Areas should exist.
These are created through the CRA Admin menu option under the ProLink Admin panel. If not created, then no assessment area will be displayed on the report.
To generate the report:
The As Of Date defaults to the current date. Enter or select a different date within the exam period if needed.
If you try to use a date outside of the selected exam period, the system presents a validation error.
Select the Current CRA Exam Period.
This list shows all active CRA Exam Periods with the most current being the default.
Click Run Report.
Generating the report can take a minute or longer.
Depending on your browser settings, the Microsoft Excel formatted report is downloaded automatically or you are prompted to save the file.
Example file name: "Investment_Allocation_Report_v5 Exam Period 7-1-2020 to 12-31-2022 with As of Date 6-4-2024.xlsx"
Report Field | ProLinkAIM Field | ProLinkAIM Location | Description (Logic) |
|---|---|---|---|
Investment As Of Selected Date Tab | |||
AIM Deal Number | Deal Number | Deal Overview | The number assigned to the deal in ProLinkAIM. |
AIM Deal Name | Deal Name | Deal Overview | The name assigned to the deal in ProLinkAIM. |
Partnership Name | Name | Deal Entities | The name of the deal entity with the role of Partnership. If more than one entity with the role of Partnership exists, multiple entities will be listed. |
Property Name | Property Name | Property Details | The name of the property. |
Origination Date | Actual Close Date | Deal Overview | The Actual Close Date for the deal. |
Street Address | Physical Address | Property Details | The physical address of the property. |
City | City | Property Details | The city where the property is located. |
Zip Code | Zip Code | Property Details | The zip code where the property is located. |
County | County | Property Details | The county where the property is located. |
State | State | Property Details | The state where the property is located. |
AA | CRA Assessment Area | Property Details (Regulatory Information) | The CRA Assessment Area where the property is located. |
Prior Period Amount | For deal-level investments, the CRA Credit Amount if the deal's Actual Close Date is prior to the selected CRA Exam period, otherwise blank. For middle/upper-tier investments, the Ending Monthly Book Value for the investor on the Fund Impairment Schedule for the month prior to the As of Date, multiplied by the Deal Allocation Split Ratio for the associated deal and further multiplied by the Deal-Level Property Split Ratio. | ||
Current Period Amount | For deal-level investments, the CRA Credit Amount if the deal's Actual Close Date is within the selected CRA Exam period, otherwise blank. For middle/upper-tier investments, the Allocation Amount for a single CRA Allocation record multiplied by the Deal-Level Property Split Ratio. | ||
CRA Credit Amount | Ending Book Value for the month before the As of Date (deal-level) Allocation Amount (middle/upper-tier) | Impairments (deal-level_ Fund CRA (middle/upper-tier) | For deal-level investments, the CRA Credit Amount uses a calculated amount and is not pulled directly from the ending Book Balance on Impairments. If the Actual Close Date is prior to the exam period, the report uses the ending book value for the month immediately prior to the As of Date, as long as the value is greater than zero. If the Actual Close Date (Deal Details>Status History>Actual Closing>Effective Date) is within the Exam Period, the report sums the total adjusted capital for the deal's capital contributions that are not marked as "Exclude from Total Capital." For Deals where there is only one associated Property, the Ending Book Balance amount is multiplied by 100% to get the value. For Deals where there are multiple properties, the ending Book Balance is multiplied by a split ratio. The split ratio is calculated as follows:
For middle/upper-tier investments, when the Actual Close Date is prior to the Exam Period, the CRA Credit Amount equals the Prior Month Book Value multiplied by the Deal Allocation Split Ratio, then further multiplied by the Deal-Level Property Split Ratio. For middle/upper-tier investments, when the Actual Close Date is within the Exam Period, the CRA Credit Amount equals the Allocation Amount for a single CRA Allocation record multiplied by the Deal-Level Property Split Ratio. Prior Period example:
Current period example:
|
Exam Period | Identifies whether the deal is in the Prior or Current period (See definition in Prior and Current). | ||
Program (Investment Type) | Deal Type (deal-level) Portfolio Type (middle/upper-tier) | Deal Overview (deal-level) Fund Details (middle/upper-tier) | For deal-level investments, the deal type for the deal. If the Deal Type is Non Tax Credit, the Sub Type (Deal > Benefits Schedule > Total Benefits > Total Benefits - Other) is displayed. For middle/upper-tier investments, the value for the fund field Portfolio Type. |
Community Development Purpose/Category | Community Development Purpose/Category | Property Details (CRA Reportable Data) | This column exists if a user defined field (UDF) exists with the exact Field Title/Section Header combination:
If a value has been saved for the UDF, it is displayed. otherwise blank. |
Total Housing Unit Count | Property Total Residential Units | Property Details (Property Profile) | The total number of housing units for the property. |
Affordable Unit Count | Total Affordable Units | Property Details (Property Profile) | The total number of affordable units for the property. |
Unfunded | Unfunded Amount (deal-level) Unfunded Commitment (middle/upper-tier) | Equity Schedule (Investment Accounting Summary) (deal-level) Equity Schedule (middle/upper-tier) | For deal-level investments, the unfunded equity amount. For deals with one property, then the Unfunded Amount is displayed. If multiple properties for the deal, then the Unfunded Amount is calculated as the Unfunded Amount multiplied by the Property Split Ratio. The ratio is determined by using the CRA Investment Amount for each property.
For middle/upper-tier investments, the value for the Unfunded Commitment in the fund's equity schedule Investor Summary grid for the associated investor multiplied by the Deal Split Ratio and the Property Split Ratio for the associated Fund CRA Allocation and Deal Property, respectively. |
CRA Qualifying Description | CRA Qualifying Description | Property Details (CRA Reportable Data) | This column exists if a user defined field (UDF) exists with the exact Field Title/Section Header combination:
If a value has been saved for the UDF, it is displayed. otherwise blank. |
Investor | Entity Name (deal level) Investor Name (middle/upper-tier) | Ownership Structure (deal-level) Fund CRA (middle/upper-tier) | For deal-level investments, the name(s) of the bank-affiliated legal entities on the finalized ownership schedule for the associated deal. For middle/upper-tier investments, the name of the legal entity that is the associated investor for the Fund CRA Allocation. |
Fund ID | Fund ID | Fund Overview | Blank for deal-level investments. For middle/upper-tier investments, the Fund ID for the fund from which the CRA Investment Allocation is derived. |
AIM Fund Name | Fund Name | Fund Overview | Blank for deal-level investments. For middle/upper-tier investments, the Fund Name for the fund from which the CRA Investment Allocation is derived. |
Fund Partnership Name | Name | Fund Entities | Blank for deal-level investments. For middle/upper-tier investments, the Name for the legal entity representing the fund from which the CRA Investment Allocation is derived. |
Investment End of Cycle | |||
This tab is populated for deals with values in Current Period Amount column and the Prior Period Amount column on As Of Date tab. | |||
AIM Deal Number | Deal Number | Deal Overview | The number assigned to the deal in ProLinkAIM. |
AIM Deal Name | Deal Name | Deal Overview | The name assigned to the deal in ProLinkAIM. |
Partnership Name | Name | Deal Entities | The name of the deal entity with the role of Partnership. If more than one entity with the role of Partnership exists, multiple entities will be listed. |
Property Name | Property Name | Property Details | When a deal has multiple properties, the property name is appended to the Deal Name. |
Origination Date | Actual Close Date | Deal Overview | The Actual Close Date for the deal. |
Street Address | Physical Address | Property Details | The physical address of the property. |
City | City | Property Details | The city where the property is located. |
Zip Code | Zip Code | Property Details | The zip code where the property is located. |
County | County | Property Details | The county where the property is located. |
State | State | Property Details | The state where the property is located. |
AA | CRA Assessment Area | Property Details (Regulatory Information) | The CRA Assessment Area where the property is located. |
Prior Period Amount | For deal-level investments, the CRA Credit Amount if the deal's Actual Close Date is prior to the selected CRA Exam period, otherwise blank. For middle/upper-tier investments, the Projected CRA Period End Value for the investor on the Fund Impairment Schedule for the month prior to the As of Date, multiplied by the Deal Split Ratio and further multiplied by the Deal-Level Property Split Ratio. | ||
Current Period Amount | For deal-level investments, the CRA Credit Amount if the deal's Actual Close Date is within the selected CRA Exam period, otherwise blank. For middle/upper-tier investments, the Allocation Amount for a single CRA Allocation record multiplied by the Deal-Level Property Split Ratio. | ||
CRA Credit Amount | Projected CRA Period End Value for the month before the As of Date (deal-level) Allocation Amount (middle/upper-tier) | Impairments (deal-level) Fund CRA (middle/upper-tier) | For deal-level investments, the CRA Credit Amount uses a calculated amount and is not pulled directly from the Projected CRA Period End Value on Impairments. If the Actual Close Date is prior to the exam period, the report uses the Projected CRA Period End Value for the month immediately prior to the As of Date, as long as the value is greater than zero. If the Actual Close Date (Deal Details>Status History>Actual Closing>Effective Date) is within the Exam Period, the report sums the total adjusted capital for the deal's capital contributions that are not marked as "Exclude from Total Capital." For Deals where there is only one associated Property, the Projected CRA Period End Value amount is multiplied by 100% to get the value. For Deals where there are multiple properties, the Projected CRA Period End Value is multiplied by a split ratio. The split ratio is calculated as follows:
For middle/upper-tier investments, when the Actual Close Date is prior to the Exam Period, the CRA Credit Amount equals the Prior Month Book Value multiplied by the Deal Allocation Split Ratio and the Deal-Level Property Split Ratio. For middle/upper-tier investments, when the Actual Close Date is within the Exam Period, the CRA Credit Amount equals the Allocation Amount for a single CRA Allocation record multiplied by the Deal-Level Property Split Ratio. Prior period example:
Current period example:
|
Exam Period | Identifies whether the deal is in the Prior or Current period (See definition in Prior and Current). | ||
Program (Investment Type) | Deal Type (deal-level) Portfolio Type (middle/upper-tier) | Deal Overview (deal-level) Fund Details (middle/upper-tier) | For deal-level investments, the deal type for the deal. If the Deal Type is Non Tax Credit, the Sub Type (Deal > Benefits Schedule > Total Benefits > Total Benefits - Other) is displayed. For middle/upper-tier investments, the value for the fund field Portfolio Type. |
Community Development Purpose/Category | Community Development Purpose/Category | Property Details (CRA Reportable Data) | This column exists if a user defined field (UDF) exists with the exact Field Title/Section Header combination:
If a value has been saved for the UDF, it is displayed, otherwise blank. |
Total Housing Unit Count | Property Total Residential Units | Property Details (Property Profile) | The total number of housing units for the property. |
Affordable Unit Count | Total Affordable Units | Property Details (Property Profile) | The total number of affordable units for the property. |
Unfunded | Unfunded Amount (deal-level) Unfunded Commitment (middle/upper-tier) | Equity Schedule (Investment Accounting Summary) (deal-level) Equity Schedule (middle/upper-tier) | For deal-level investments, the unfunded equity amount. For deals with one property, then the Unfunded Amount is displayed. If multiple properties for the deal, then the Unfunded Amount is calculated as the Unfunded Amount multiplied by the Property Split Ratio. The ratio is determined by using the CRA Investment Amount for each property.
For middle/upper-tier investments, the value for the Unfunded Commitment in the fund's equity schedule Investor Summary grid for the associated investor multiplied by the Deal Split Ratio and the Property Split Ratio for the associated Fund CRA Allocation and Deal Property, respectively. |
CRA Qualifying Description | CRA Qualifying Description | Property Details (CRA Reportable Data) | This column exists if a user defined field (UDF) exists with the exact Field Title/Section Header combination:
If a value has been saved for the UDF, it is displayed. otherwise blank. |
Investor | Entity Name (deal-level) Investor Name (middle/upper-tier) | Ownership Structure (deal-level) Fund CRA (middle/upper-tier) | For deal-level investments, the name(s) of the bank-affiliated legal entities on the finalized ownership schedule for the associated deal. For middle/upper-tier investments, the name of the legal entity that is the associated investor for the Fund CRA Allocation. |
Fund ID | Fund ID | Fund Overview | Blank for deal-level investments. For middle/upper-tier investments, the Fund ID for the fund from which the CRA Investment Allocation is derived. |
AIM Fund Name | Fund Name | Fund Overview | Blank for deal-level investments. For middle/upper-tier investments, the Fund Name for the fund from which the CRA Investment Allocation is derived. |
Fund Partnership Name | Name | Fund Entities | Blank for deal-level investments. For middle/upper-tier investments, the Name for the legal entity representing the fund from which the CRA Investment Allocation is derived. |
Excluded Investments | |||
Deal-level investments: When the Exclude from CRA checkbox is selected for a deal property, the property will not appear on the Investment As Of Selected Date or Investment End of Cycle tabs. This property will appear on the Excluded Investments tab. Properties excluded from CRA reporting will continue to be included in the Property Split Ratio calculation used to find the CRA Credit Amount. For information about the Exclude from CRA checkbox, see Property Details. | |||
Middle/upper-tier investments: A Fund CRA Allocation will appear on the Excluded Investments tab when the Fund CRA Allocation Amount is greater than 0, the Fund CRA Exclude from CRA Report checkbox is selected, and the Investor entity's Is Bank Affiliated checkbox is selected. If you indicate exclusion at the deal property level, but do not indicate exclusion on the Fund CRA Allocation, the investment will appear on the Investment As of Selected Date and Investment End of Cycle tabs. For more information about the Fund CRA Exclude from CRA checkbox, see Fund CRA. | |||
AIM Deal Number | Deal Number | Deal Overview | The number assigned to the deal in ProLinkAIM. |
AIM Deal Name | Deal Name | Deal Overview | The name assigned to the deal in ProLinkAIM. |
Partnership Name | Name | Deal Entities | The name of the deal entity with the role of Partnership. If more than one entity with the role of Partnership exists, multiple entities will be listed. |
Property Name | Property Name | Property Details | When a deal has multiple properties, the property name is appended to the Deal Name. |
Origination Date | Actual Close Date | Deal Overview | The Actual Close Date for the deal. |
Street Address | Physical Address | Property Details | The physical address of the property. |
City | City | Property Details | The city in which the property is located. |
Zip Code | Zip Code | Property Details | The zip code in which the property is located. |
County | County | Property Details | The county in which the property is located. |
State | State | Property Details | The state in which the property is located. |
AA | CRA Assessment Area | Property Details (Regulatory Information) | The CRA Assessment Area where the property is located. |
Prior Period Amount | For deal-level investments, the CRA Credit Amount if the deal's Actual Close Date is prior to the selected CRA Exam period, otherwise blank. For middle/upper-tier investments, the Ending Monthly Book Value for the investor on the Fund Impairment Schedule for the month prior to the As of Date, multiplied by the Deal Allocation Split Ratio for the associated deal and further multiplied by the Deal-Level Property Split Ratio. | ||
Current Period Amount | For deal-level investments, the CRA Credit Amount if the deal's Actual Close Date is within the selected CRA Exam period, otherwise blank. For middle/upper-tier investments, the Allocation Amount for a single CRA Allocation record multiplied by the Deal-Level Property Split Ratio. | ||
CRA Credit Amount | For deal-level investments, the CRA Credit Amount uses a calculated amount and is not pulled directly from the ending Book Balance on Impairments. If the Actual Close Date is prior to the exam period, the report uses the ending book value for the month immediately prior to the As of Date, as long as the value is greater than zero. If the Actual Close Date (Deal Details>Status History>Actual Closing>Effective Date) is within the Exam Period, the report sums the total adjusted capital for the deal's capital contributions that are not marked as "Exclude from Total Capital." For Deals where there is only one associated Property, the Ending Book Balance amount is multiplied by 100% to get the value. For Deals where there are multiple properties, the ending Book Balance is multiplied by a split ratio. The split ratio is calculated as follows:
For middle/upper-tier investments, when the Actual Close Date is prior to the Exam Period, the CRA Credit Amount equals the Prior Month Book Value multiplied by the Deal Allocation Split Ratio, then further multiplied by the Deal-Level Property Split Ratio. For middle/upper-tier investments, when the Actual Close Date is within the Exam Period, the CRA Credit Amount equals the Allocation Amount for a single CRA Allocation record multiplied by the Deal-Level Property Split Ratio. Prior period example:
Current period example:
| ||
Exam Period | Identifies whether the deal is in the Prior or Current period (See definition in Prior and Current). | ||
Program (Investment Type) | Deal Type | Deal Overview | For deal-level investments, the deal type for the deal. If the Deal Type is Non Tax Credit, the Sub Type (Deal > Benefits Schedule > Total Benefits > Total Benefits - Other) is displayed. For middle/upper-tier investments, the value for the fund field Portfolio Type. |
Community Development Purpose/Category | Community Development Purpose/Category | Property Details (CRA Reportable Data) | This column exists if a user defined field (UDF) exists with the exact Field Title/Section Header combination:
If a value has been saved for the UDF, it is displayed, otherwise blank. |
Total Housing Unit Count | Property Total Residential Units | Property Details (Property Profile) | The total number of housing units for the property. |
Affordable Unit Count | Total Affordable Units | Property Details (Property Profile) | The total number of affordable units for the property. |
Unfunded | Unfunded Amount | Equity Schedule (Investment Accounting Summary) | For deal-level investments, the unfunded equity amount. For deals with one property, then the Unfunded Amount is displayed. If multiple properties for the deal, then the Unfunded Amount is calculated as the Unfunded Amount multiplied by the Property Split Ratio. The ratio is determined by using the CRA Investment Amount for each property.
For middle/upper-tier investments, the value for the Unfunded Commitment in the fund's equity schedule Investor Summary grid for the associated investor multiplied by the Deal Split Ratio and the Property Split Ratio for the associated Fund CRA Allocation and Deal Property, respectively. |
CRA Qualifying Description | CRA Qualifying Description | Property Details (CRA Reportable Data) | This column exists if a user defined field (UDF) exists with the exact Field Title/Section Header combination:
If a value has been saved for the UDF, it is displayed. otherwise blank. |
Investor | Entity Name (deal-level) Investor Name (middle/upper-tier) | Ownership Structure (deal-level) Fund CRA (middle/upper-tier) | For deal-level investments, the name(s) of the bank-affiliated legal entities on the finalized ownership schedule for the associated deal. For middle/upper-tier investments, the name of the legal entity that is the associated investor for the Fund CRA Allocation. |
Fund ID | Fund ID | Fund Overview | Blank for deal-level investments. For middle/upper-tier investments, the Fund ID for the fund from which the CRA Investment Allocation is derived. |
AIM Fund Name | Fund Name | Fund Overview | Blank for deal-level investments. For middle/upper-tier investments, the Fund Name for the fund from which the CRA Investment Allocation is derived. |
Fund Partnership Name | Name | Fund Entities | Blank for deal-level investments. For middle/upper-tier investments, the Name for the legal entity representing the fund from which the CRA Investment Allocation is derived. |