High Impact Financial Analysis
  • Home
  • About High Impact
    • Our Team >
      • Join Our Team
    • Annual Reports
  • Underwriting
    • For Real Estate Lenders
    • For Business Lenders
    • For NMTC Allocatees
    • Multi-Lender Underwriting
  • Portfolio Analytics
  • MEDIA
    • Insights
    • Blog
    • Impact Lenders Podcast
    • Publications
    • Youtube
    • News
    • Newsletter
  • CONTACT

INSIGHTS

Top Five Dashboards for CDFIs

AUGUST 2021
Dashboards provide critical insights through visual representations of key data and trends that are easy to interpret and direct focus to the most important information and takeaways… But they can be so much more! By incorporating targeted dashboards and interactive features, which allow users to dive into the data, key stakeholders can access the insights and advanced analytics they need to make stronger strategic decisions.

Effective dashboard packages utilize a combination of Summary and Supporting schedules. Summary dashboards focus on KPIs as well as key trends, ratios, and metrics, while supporting pages provide more granular insights and can leverage interactive features to support deeper analytics. For example, while a summary page might focus on total portfolio growth, supporting dashboards would include insights on the funds, products, and/or geographies driving that growth.

So, what information should you include in a CDFI dashboard package? That depends on your audience. CDFIs have many different stakeholders—both internal and external—and they all need different information to meet their needs. Remember, information overload can be just as detrimental as a lack of information. Connecting stakeholders to the right information so they can act upon it is your primary goal in designing a dashboard package.

This is where business intelligence software’s powerful analytical and distribution capabilities shine. Once data modeling is complete, you have full control over which content your various audiences can access. Here is our take on the top five dashboards that CDFIs need to ensure that the right data are available for the right stakeholders at all times.

#1: The CFO Dashboard 
CDFI CFOs have a lot to manage—not just income and expenses, but also asset-liability matching, deployment, and strategic planning. The perfect CFO dashboard gives key information on all of these topics.
  • Revenue data: Revenue by source versus budget.
  • Expense data: Expenses by category budget.
  • Cash position: Operating cash dollar amount and days’ cash on hand.
  • Financial health indicators: Deployment ratio and net asset ratio.
  • Delinquency data: 30-60-90-day delinquencies and dollar amount of nonperforming assets.
  • Maturities data: Upcoming maturities of both loans receivable and notes payable.
Picture

#2: The Board Dashboard
CDFI Boards of Directors are responsible for the overall strategy and oversight of the organization. Their needs are best met by monitoring the big-picture numbers and strategic direction. Adding in a taste of impact is critical.
  • Top-line income statement data: Total income and total expenses against the budget.
  • Top-line lending data: Originations by quarter, loan portfolio outstanding balance, and 30-60-90-day delinquency.
  • Strategic plan benchmarks: Established strategic plan benchmarks with a numeric component that can be tracked with meters or other data visualizations to quickly communicate progress.
  • Impact data: Relevant indicators including financing to minority- and women-owned businesses, number of housing units financed, or number of technical assistance hours.
Picture

#3: The Chief Lending Officer Dashboard
Chief Lending Officers are often charged with both generating originations and ensuring that only good loans are made. An effective dashboard will keep an eye on both.
  • Pipeline data: Number of loans and dollars of loans in the pipeline, segmented by stage in the pipeline, if available.
  • Originations data: Loans committed and closed versus budgeted originations.
  • Portfolio growth: Outstanding principal balance and outstanding number of loans over time.
  • Investment area: Year-to-date progress towards CDFI Fund lending area requirements.
  • Maturities data: Upcoming loan maturities.
  • Delinquency data: 30-60-90-day delinquencies and dollar amount of nonperforming assets.
  • Interest rate data: Weighted cost of loan capital and weighted average interest rate in the portfolio.
Picture

#4: The Resource Development Dashboard 
Staff focused on raising funds need to be able to effectively tell the impact story of the loan fund. Equipping them with clear, concise dashboards that communicate the success of the CDFI is critical.
  • Portfolio growth: Outstanding principal balance and outstanding number of loans over time.
  • Technical assistance: Hours and number of applicants and borrowers provided with technical assistance.
  • Outcome units: Depending on the CDFI’s core lending sectors, may include housing units, education seats, jobs preserved or created, or other indicators.
  • Geographic impact: Heat map showing neighborhoods, counties, or states where capital has been deployed.
Picture

#5: The Investor Dashboard
Investors in CDFIs want to be able to understand the financial security of their investment along with the social impact made. CDFI investors are notorious for having unique requirements. A tool like Microsoft’s Power BI, which supports easy replication and tweaking of custom dashboards, is a great option for CDFIs managing multiple investors.
  • Financial health indicators: Deployment ratio and net asset ratio.
  • Outcome units: Depending on the CDFI’s core lending sectors, may include housing units, education seats, jobs preserved or created, or other indicators.
  • Portfolio growth: Outstanding principal balance and outstanding number of loans over time.
  • Delinquency data: 30-60-90-day delinquencies and dollar amount of nonperforming assets.
  • Custom covenants: Tracking of financial or other covenants required to be met by the investor.
Picture

By making these dashboards easily accessible and up to date, all the critical internal and external stakeholders have access to the insights they need to make sound, confident decisions.
​

For more on how High Impact can help your CDFI set up and maintain effective dashboards, click here: http://www.highimpactanalysis.com/portfolioanalytics.html. 
High Impact Logo
69 State Street
Suite 1200D
​Albany, NY 12207
​
​P: (518) 599-0482
analysis@highimpactanalysis.com
​About Us
Underwriting
Portfolio Analytics
Impact
​
Media
Contact
Picture
  • Home
  • About High Impact
    • Our Team >
      • Join Our Team
    • Annual Reports
  • Underwriting
    • For Real Estate Lenders
    • For Business Lenders
    • For NMTC Allocatees
    • Multi-Lender Underwriting
  • Portfolio Analytics
  • MEDIA
    • Insights
    • Blog
    • Impact Lenders Podcast
    • Publications
    • Youtube
    • News
    • Newsletter
  • CONTACT