How do you calculate impact?

Brian.Brown

Dashboard Statement

The WPF Dashboard is a report that measures the foundation’s overall impact since inception. The dashboard is updated quarterly. The figures presented include Whole Planet Foundation’s contributions as well as reporting data from WPF’s MFI partners through the end of the reporting period.

People

Approx. Number of Loans Made to Entrepreneur Families Due to WPF Support of Microfinance Partners:

First, to find how many loans WPF programs have funded we get the Average First Loan Size reported by our partners and divide it over the funds that have been disbursed to the MFI. Next, we find how many times those funds have been distributed and repaid back to the MFI since their disbursement. Finally we incorporate the repayment rate reported by the MFI to account for any funds that have been defaulted.

Total Loans Made to Entrepreneur Families Due to WPF Support = SUM{(([AmountDisbursed] / [AvgFirstLoanSize]) X [Turn]) X [RepaymentRate]}

Turn = (Reporting Period –Disbursement Date) / AverageLoanTerm

This is applied to every disbursement WPF has made to its partners since inception.

Approx. Number of Opportunities for Entrepreneurs and Their Families (Loans Disbursed X Average Family Size, Including Multiple Loan Recipients & Their Families)

Every loan provides a unique opportunity for the supported client and their family members. To estimate total opportunities first we gather the fertility rate to determine the average family size in each country. We add 1.75 to the average fertility rate to include parents or other relatives that live in the household. As of March 2022, the average family size across WPF’s portfolio is about 5.05 people. Next we factor in the number of loans supported.

Opportunities for WPF- Supported Clients = Total Loans Made to Borrower-Families Due to WPF Support X AverageFamilySize

Current Active Entrepreneurs

Active clients reported by MFI partners in each quarter to WPF.

Current Active Entrepreneurs & Their Families

Active clients reported in WPF communities including their family members.

% Women Clients

This is a weighted average of the figures reported by the MFIs across WPF’s portfolio.

Places

Eligible Countries

Total of Authorized Countries and Program Countries in Development where both a Whole Foods Market product connection and viable microfinance industry has been identified.

Total Projects

Total count of projects approved to receive funding.

Authorized Program Countries

Countries which funding has been approved by WPF’s Board of Directors.

Active Countries

Countries which funding has been approved by WPF’s Board of Directors and funds have been disbursed.

Authorized U.S. Cities

Total U.S. cities in which funding has been approved by WPF’s Board of Directors.

Active U.S. Cities

Total U.S. cities in which funding has been approved by WPF’s Board of Directors and funds have been disbursed.

WFM Products

Unique number of products sold in WFM stores that are sourced from WPF countries around the world.

Microfinance Partners

Total number of unique partners funded by WPF.

Funding & Loans

First Loan Disbursed

Date in which WPF began funding loans.

Authorized Disbursements

Total amount of funding approved for WPF projects by the foundation’s Board of Directors

Disbursed to Microfinance Partners

Total amount of funds disbursed by Whole Planet Foundation to its MFI partners for on-lending capital.

Avg. First Loan Size

Weighted average across the portfolio reported by MFI partners

Repayment Rate

Weighted average across the portfolio reported by MFI partners

[Update:11/13/2020]

Starting with the reporting through September 30, 2020 we have revised this formula to more accurately quantify this metric. After review by the Field Team after two quarters after the start of COVID-19 the team concluded that the previous formula was not accurately reflecting PAR.

Previous Formula =SUMPRODUCT(CGAP PAR % > 30 days for Institution, Approx. Loans Made to Entrepreneur Families Due to WPF Support/SUM(Approx. Loans Made to Entrepreneur Families Due to WPF Support))

Revised Formula =SUMPRODUCT(CGAP PAR % > 30 days for Institution, Total loan Balance Outstanding on Institutional Loans (USD)/SUM(Total loan Balance Outstanding on Institutional Loans (USD)))

* In addition to this revision the Field Team agreed that it is important to remove all CLOSED projects and any projects where MFI data is being duplicated (ex: CASHPOR G2, G3, G5, G6) to most accurately reflect this value

Approx. Value of Loans Supported by WPF

Funds to MFI partners continue to grow over time. To find the total leveraged amount takes each disbursement and calculates the turn to find out how many times those funds have been distributed and repaid to the MFI. Then we factor in the MFI’s Repayment Rate to account for any defaulted % of their portfolio

Sum{ ([AmountDisbursed]+( [AmountDisbursed] X [Turn] X [RepaymentRate]))}

Total Loans Supported by WPF Funding (Purchasing Power Parity basis)

Approx. Value of Loans Supported by WPF adjusted for the exchange rate in each countries’ local currency. The Economist: The Big Mac index