Sharing Knowledge. Growing Impact.
Updated Tour Video
Updated Tour Video
Entering CF Insights Data
Entering CF Insights Data
Creating Peer Groups and Benchmarking Reports
Creating Peer Groups and Benchmarking Reports
CF Insights Members The Field
Services Expert Guidance and Analysis Checked
Peer Learning and Connections Checked
Technical Assistance
with Tools
Consulting and Project Support Checked Checked
Tools Benchmarking and Custom Reports Checked with Annotation
Dashboard for Board Presentations Checked
Activity-Based Costing Analysis Model Checked Checked
Economic Scenario Planning Model Checked Checked
Interactive Strategy Model Checked Checked
Knowledge Member Research Briefs Checked
Trend Analysis and Rankings Checked Checked
Reports on Key Issues and Ideas Checked Checked

* Columbus Survey Participants have on-demand access to a select subset of
benchmarking reports

Data We Collect
Data We Collect

Data Collected by CF Insights

All data collected by CF Insights is available to members as criteria with which to build peer groups and as the basis for over 60 on-demand reports.

Foundation Basics:

  • Fiscal Year End Date
  • Year Foundation Created
  • Staffing by Function
  • Strategic Operating Priorities
  • Affiliations with Other Foundations
  • Software Type Used
  • Engagement in the Following Areas:
    • Community Leadership
    • Fiscal Sponsorship/Fundraising
    • Fundraising for Operations
    • Nonprofit Resource Center
    • Services to Private Foundations
    • Special Initiatives


  • Urban vs. Rural
  • Population of Area Served
  • Geographic Area Served
  • State
  • Region

Assets and Funds:

  • Total Assets
  • Total Assets by Product Type
  • Total Number of Foundation Funds
  • Total Number of DAFs
  • Total Number of Funds Held at SOs
  • Total Number of SOs
  • Operating Endowment and Reserves



  • Total Operating Expenses
  • Special Initiative Operations Expenses
  • Operating Expenses as Percent of Assets


  • Total Foundation Contributions - $ and #
  • Total Contributions to DAFs - $ and #
  • Total Contributions to SOs - $ and #


  • Total Foundation Grants - $ and #
  • Total Grants from DAFs - $ and #
  • Total Grants from SOs - $ and #

Activity-Based Costing Results:

  • Contributions/Subsidies by Product - $
  • Total Cost by Product - $
  • Total Cost by Activity Type - $

Administrative Fee Schedules:

CF Insights collects the following fee information by specific product and fund type.

  • Total Fees
  • Minimum Fees
  • Minimum Fund Balance

Investment Data from the Colonial Consulting/FAOG Investment Survey:

Colonial Consulting and FAOG provide CF Insights with the results of their annual and quarterly investment surveys.

  • Annualized Returns
  • Overall Allocation
  • Equity Allocation
  • Fixed Income Allocation
  • Alternate Allocation

Contact for more information.

Economic Scenario Planning

The Economic Scenario Planning (ESP) Model, or "Stress Test," allows community foundations to create five-year forecasts to answer questions such as:

  • What will be the impact of different investment performance scenarios on asset levels?
  • What amount of grantmaking can we expect in the next few years?
  • What happens to our economics if donors behave in different ways?
An Overview of Economic Scenario Planning provides a rundown of the entire process, including how to populate the Model with your foundation's data, how to think about, define, and test alternative 5-year scenarios, as well as a demonstration of the Model's many outputs and financial projections. Write to David Rosado for a copy of the presentation.

Download a working Economic Scenario Planning (ESP) model with illustrative data:

Develop an ESP model and presentation for your foundation:

See how your peers have used the resources.     

Read stories in Learning from the Future » (PDF, 3.24MB)
Case studies illustrating the uses of the tool

Contact CF Insights staff to find out more about how your peers are developing forecasts & sharing results.

Examples of Insights

    • Integrate perspectives to create a common plan
    • Provide a reality check for future goals
    • Structure a process to facilitate board discussions about the future
    • Catalyze a new call to action
    • Track progress toward goals

The Economic Scenario Planning Model is provided through support from The Council on Foundations’ Community Foundation Leadership Team.

This tool and supporting documentation are available for free to community foundations for internal use only. Any commercial use of the tools by community foundations or the consultants that serve them requires a licensing fee. Inquire about licensing.

32 Old Slip, 24th Floor, New York, NY 10005 |

Created by Community Foundations // Propelled by Candid