Forecast Results

The forecast result shows the calculated result of the 10-year forecast based on your input.

Visualisation mode

The line chart has 3 modes:

  1. Accumulate: the next month will include the number from the previous month.
  2. Month by month: each plot represent the actual number of each month.
  3. Compare: this option only available when selecting multiple versions. It will separate each version numbers into separate series to compare the numbers period by period.

Breakeven

Breakeven refers to the month that you started having positive net income if the forecast number will ever each positive net income.

Filters

Transaction Calendar Year

The year that the donation attempts had been made.

Export results to CSV

To export the full results for further use, click the “Export data to CSV” button to export the forecast into a CSV file. If there are multiple forecast version selected, it will summarise all numbers under the same cohort and period into one cell.

The file contains several sections as below.

Forecast details

Provide information about this forecast settings such as version name, version number, channel, supplier, and created date.

Executive summary

Provide information at the high level of total income, total expense, total profit (net income), and total remaining donors at the end of each year.

Metrics Definition
Income Total donation received from donors.
Expense Total cost.
Net income Total profit which is derived from total income deducted by total expense
Net donor numbers Total number of remaining donors.

Financial forecast details

Provide information in detail on financial related metrics.

Metrics Definition
Reporting Date Time indicator at month level.
No. of Regular Givers Total number of remaining active regular giving donors.
Revenue Total Total donation that has been successfully collected.
Declines Value Per Month Total number of declines (failed donation attempts).
Total Expected Income Total donation that should have been collected if there is no declines.
Expenses Total Total expenses of all categories.
Cost Per Acquisition Total expenses from cost per acquisition.
PFRA Total expenses from PRFA membership fee.
Donor Care Cost Total expenses from maintaining donors.
Transaction Cost Total expenses from processing donation attempts.
Net Income Total income after deducting expenses (profit).

Remaining donors details

Provide information in details on how many donors remain by cohort and month. The month at the column header refers to the period of time, whereas the month at the leftmost column is the donor cohort (the month that they were signed up).

Metrics Definition
Acquired Total number of donors acquired.
No First Gift Total number of donors who dropped out before making any donation attempts.