slide1
Download
Skip this Video
Download Presentation
Community Investment Impact System (CIIS) CIIS 3.4 Release CDE TLR Content May 2006

Loading in 2 Seconds...

play fullscreen
1 / 32

Community Investment Impact System CIIS CIIS 3.4 Release CDE TLR Content May 2006 - PowerPoint PPT Presentation


  • 93 Views
  • Uploaded on

US Department of the Treasury. Community Development Financial Institutions Fund. Community Investment Impact System (CIIS) CIIS 3.4 Release CDE TLR Content May 2006. Presentation Outline. Introduction to CIIS TLR Instructions Certifying CIIS Reports Useful Information.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Community Investment Impact System CIIS CIIS 3.4 Release CDE TLR Content May 2006' - tocho


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
slide1

US Department of the Treasury

Community Development Financial Institutions Fund

Community Investment Impact System (CIIS)

CIIS 3.4 Release

CDE TLR Content

May 2006

slide2

Presentation Outline

  • Introduction to CIIS
  • TLR Instructions
  • Certifying CIIS Reports
  • Useful Information
introduction to ciis
Introduction to CIIS
  • What is CIIS?
    • Community Investment Impact System
    • System for CDEs to report QLICI activity to the Fund
  • CIIS Reports Due Dates
    • Annual
    • Report period = Allocatee’s fiscal year
      • (2005 Report period = Allocatee’s fiscal year ending in 2005)
    • CIIS due date is 180 days after report period end
      • (If Allocatee’s 2005 fiscal year end is 12-31-2005, 2005 reports are due 6-27-2006)
introduction to ciis4
Introduction to CIIS
  • Institution Level Report (ILR)
    • Institution level data
    • Required if Allocatee (or Sub) closed one or more QEIs by report period end.
    • General Data
      • Organizational Structure / Affiliation
      • Geographies Financed
      • FTEs Dedicated to NMTC Program
      • Financial Position
    • QLICIs:
      • QEI Distribution
      • Loan Purchases
      • FCOS
introduction to ciis5
Introduction to CIIS
  • Transaction Level Report (TLR)
    • Transaction level data (Portfolio)
    • Required if the Allocatee (or Sub) had one or more current QLICIs during report period.
      • Allocatee is responsible for TLR report.
      • Report/update entire NMTC portfolio annually.
    • QLICIs:
      • Investments in QALICBs
      • Investments in CDEs
      • (Report investments in CDEs through to the QALICB)
    • Data must represent the report period end date.
slide6
TLR Instructions

HINT:

If you Certified a TLR in a previous report period, begin the FY 2005 TLR by downloading the previous report to the Manual/Online entry or to a current Excel Template.

tlr instructions financial notes projects
TLR Instructions: Financial Notes & Projects
  • Financial Notes
    • Each TLR transaction represents a single Financial Note.
    • Loan, line of credit, debt with equity, or equity investment.
tlr instructions financial notes projects8
TLR Instructions: Financial Notes & Projects
  • Projects
    • Many Allocatees finance Projects with more than one Financial Note. 
    • The Fund recognizes Financial Notes as part of a Project if each of the Notes share the same:
      • Investee (Borrower - indicated by Client ID);
      • Investee Address;
      • Project Address(es); and
      • Total Project Cost.
    • All Project Level data points must be the same for each Financial Note.
    • FY 2005: Indicate Projects in ILR Comments Section
    • FY 2006: System re-structured for Projects
tlr instructions reading the instructions
TLR Instructions – Reading the Instructions
  • Data point instructions in this presentation:
  • Originator Transaction ID
  • “Loan Number”
  • Used to track loan/investment across report periods

Double border: MANDATORY data point

Thick Border: CONDITIONALLY REQUIRED data point

Business Description

  • Open-ended text field

Blue background: Data point used for COMPLIANCE

tlr instructions reading the instructions10
TLR Instructions – Reading the Instructions
  • Data point instructions in the TLR Instructions:

Double border: MANDATORY data point

Thick Border: CONDITIONALLY REQUIRED data point

Blue background: Data point used for COMPLIANCE

tlr instructions transaction identifiers
TLR Instructions - Transaction Identifiers
  • Assign a unique identifier to each Financial Note:
  • Assign a unique identifier to distinct investees (clients/borrowers):
  • Provide the TIN for the Allocatee or Suballocatee that originated/invested in the QLICI.
  • Originator Transaction ID
  • “Loan Number”
  • Used to track loan/investment across report periods
  • ClientID
  • Project Level
  • Used to track investee across loans/investments & report periods
  • Investor TIN
  • Not related to QEI Investor
tlr instructions transaction identifiers cde v qalicb
TLR Instructions - Transaction Identifiers (CDE v. QALICB)
  • QLICI Type
  • Project Level

Investment in QALICB

Investment in CDE

  • Advance Purchase Commitment
  • Loan purchase based on an agreement in advance of the origination. (See NMTC regs)

Investee TIN

Project Level

Yes

No

  • Seller Organization
  • Seller of Advance Purchase
tlr instructions transaction identifiers purpose
TLR Instructions - Transaction Identifiers (Purpose)

Purpose

Real Estate –

Constr/Perm/Acq w/o Rehab - Commercial

Real Estate –

Rehab

– Commercial

Acquisition or Rehabilitation

Construction or Permanent Financing

Acquis & Rehab

Rehab Only

Constr

Perm

Both

Take-out or Acquisition Financing

Rehabilitation Amount

Takeout

Acq w/o Rehab

tlr instructions transaction identifiers debt terms
TLR Instructions - Transaction Identifiers (Debt Terms)

Transaction Type

Debt (Term Loan, LOC, Debt w/Equity)

Equity

Interest Rate

Term

Interest Type

Date First Payment Due

Points

Guarantee

Origination Fees

Lien Position

Amortization Type

Collateral Type

Equity-Like Features

Collateral Value

tlr instructions address
TLR Instructions - Address
  • Investee Address
  • Project Level

Project Address(es)

  • Project Level
  • User may provide multiple Project Addresses
  • Business Investments
    • If investee qualifies as QALICB, re-enter Investee Address as Project Address.
    • If investee does NOT qualify as QALICB, provide each business location financed.
  • Real Estate Investments
    • If site(s) is within single census tract, provide one Project Address to represent investment.
    • If site(s) are NOT within single census tract, provide one Project Address for each census tract financed.
tlr instructions address16
TLR Instructions - Address
  • Addresses
    • Must pass Address Verification
      • Verify that address is “geocodable”
      • If Address does not pass Address Verification, User may enter FIPS Code
      • CIIS cannot geocode PO Boxes or Rural Routes
    • Use CIMS/Mapping to confirm geocoding and compliance with “Service Area” and “Areas of Higher Distress Criteria.”
tlr instructions borrower investee profile
TLR Instructions - Borrower/Investee Profile

QALICB Type

  • Project Level
  • If QALICB is RE developer, select RE
  • If QALICB is operating business (non-RE), select Non-RE.
  • If QALICB is single-purpose entity created by operating business to lease back property to that business, user may select RE or Non-RE.
  • QLICI Type
  • Project Level

Investment in QALICB

Investment in CDE

Business Description

  • Open-ended text field
tlr instructions borrower investee profile18
TLR Instructions - Borrower/Investee Profile
  • Investee Guidance:
    • If QALICB is RE developer, Investee is the developer.
    • If QALICB is operating business (non-RE), Investee is the business.
    • If QALICB is single-purpose entity created by operating business to lease back property to that business, Investee is that business.
  • Project Level data points

Minority Owned/Controlled

Date Business Established

Women Owned/Controlled

Low-Income Owned/Controlled

Entity Structure

tlr instructions borrower investee profile19
TLR Instructions - Borrower/Investee Profile
  • For business lending:
  • Jobs at Time of Loan/Investment
  • Project Level
  • If Purpose = Business, include jobs in business
  • Exclude construction jobs
  • Exclude tenant jobs
  • Exclude other “multiplier jobs”
  • Jobs at Reporting Period End
  • Project Level
  • Updates in Status Section
tlr instructions transaction status
TLR Instructions - Transaction Status
  • Transaction Status section requires an annual update.
  • Loan Status
  • Active = “On-the-books” or “Open”
  • Closed = “Off-the-books,” “Paid in full,” or “Exited”
  • Sold / Charged Off / Refinanced = “Off-the-books”, but not paid off
tlr instructions transaction status disbursements
TLR Instructions - Transaction Status (Disbursements)

Original Loan/Investment Amount

Disbursement ID

Disbursement ID

Disbursement Date

Disbursement Date

Disbursement Amount

Disbursement Amount

Disbursement Source (QEI#)

Disbursement Source (QEI#)

Disbursement Source (QEI#)

Disbursement Source Amount

(not total QEI)

Disbursement Source Amount

(not total QEI)

Disbursement Source Amount

(not total QEI)

tlr instructions transaction status disbursements22
TLR Instructions - Transaction Status (Disbursements)

$150,000

#01

#02

6/15/2005

6/30/2005

$50,000

$100,000

01QEI00000

01QEI00000

Non-QEI

$50,000

$20,000

$80,000

  • Total Amount Disbursed cannot exceed Original Amount (except Line of Credit)
  • Total Amount Disbursed must be “explained” by QEI Source or “Non-QEI”
tlr instructions transaction status debt terms
TLR Instructions - Transaction Status (Debt Terms)

Transaction Type

Debt (Term Loan, LOC, Debt w/Equity)

Equity

Fair Value at End of Reporting Period

Number of Times 60+ Days Past Due

Principal Balance Outstanding

Number of Times Loan was Restructured

Amount Recovered

Amount Charged Off

Days Delinquent

tlr instructions impact profile total project cost
TLR Instructions - Impact Profile (Total Project Cost)
  • Total funding for “Project” financed by QLICI.
    • If there are multiple Financial Notes for a single project, enter the Total Project Cost each Note.
    • Do NOT divide Total across Notes.
  • Total Project Cost
  • Project Level
  • Total Project Cost – Public Sources
  • Project Level
  • Non-NMTC Funds
  • Subset of Total Project Cost
  • Total Project Cost – Affiliates & Related Programs
  • *CIIS FY 2006*
  • Non-NMTC Funds
  • Subset of Total Project Cost
tlr instructions projected impacts
TLR Instructions - Projected Impacts
  • All projected impacts are collected at the Project Level.
    • If there are multiple Financial Notes for a single project, enter the full impact amount for each Note.
    • Do NOT divide impacts across Notes.
  • Other Impacts (Description, #)
  • Project Level
  • Add your own impacts
  • If user provides Description, must provide #
tlr instructions projected impacts26
TLR Instructions - Projected Impacts

Purpose

Real Estate

Business

Project Level

Capacity of Community Facility

  • Capacity of Community Facility in CIIS FY 2006
  • CIIS will have distinct data points for educational, childcare, healthcare, arts center, and other community facilities.

Square Feet of RE – Manufacturing/Office/Retail

Total Square Feet of RE in CIIS FY 2006

Affordable/Housing Units – Sale/Rental

tlr instructions projected impacts27
TLR Instructions - Projected Impacts

Purpose

Real Estate

Business

  • Projected Jobs to be Created
  • Project Level
  • (Purpose = RE) Include construction jobs / Exclude tenant jobs
  • (Purpose = Bus) Include jobs in business
  • Exclude other “multiplier jobs”
  • Projected Jobs to be Created
  • *CIIS FY 2006*
  • CIIS will have distinct data points for Business Jobs, Construction Jobs, and Tenant Jobs.
tlr instructions nmtc compliance data
TLR Instructions - NMTC Compliance Data
  • Data points used to measure the Allocatee’s compliance with their Allocation Agreement:
  • NMTC Eligibility
  • Project Level
  • Geographic (Census 1990 or 2000)
  • Target Area (Fund approval)
  • Target Population
  • Low Population or High Migration Tracts
  • Related Entity
  • Project Level
  • QLICI Level
  • Original or Reinvestment
tlr instructions nmtc compliance data29
TLR Instructions - NMTC Compliance Data
  • Better Rates & Terms:
    • Respond “Yes” or “No” for each Financial Note:
    • In *FY 2006 Report*, CIIS will require “Comparable” rates and terms for each of the “Better Rates & Terms” selected by the user.
    • For example, if the user enters “Yes” to “Below Market Interest Rate,” CIIS will require the user to provide the “Market Interest Rate.”
  • Areas of Higher Distress:
    • Respond “Yes” or “No” for each Project.
certifying ciis reports
Certifying CIIS Reports
  • CIIS has a single Certification for the ILR and TLR.
  • Organizations may only Certify one time per Report Period.
  • Users may Certify TLR when:
    • ILR is complete.
    • TLR – There are one or more Pre-Certified Transactions.
    • TLR – There are no Transactions in the Pending List.
  • How to Certify: Select “Certify” from CIIS home page
certifying ciis reports31
Certifying CIIS Reports
  • CIIS has a single Certification for the ILR and TLR.
  • Organizations may only Certify one time per Report Period.
  • Users may Certify TLR when:
    • ILR is complete.
    • TLR – There are one or more Pre-Certified Transactions.
    • TLR – There are no Transactions in the Pending List.
  • How to Certify: Select “Certify” from CIIS home page
useful information
Useful information
  • Additional CIIS information is available at www.cdfifund.gov/what_we_do/ciis.asp
  • Contact the CIIS Help Desk at [email protected] or (703) 373 -1516
ad