Actual Forecast Earnings

Actual forecast earnings are the earnings for a program line calculated using the forecast rate on the current actual transactions.

To explain actual forecast earnings, we must first explain how Enable calculates the forecasted transacted value. The forecasted transacted value is, by default, calculated as a linear extrapolation of the actual transacted value across the duration of the program line. The actual transacted value is multiplied by a scaling factor X/Y, where X is the duration of the program line in days, and Y is the number of days between the start of the program and the latest transaction date for the program line (inclusive).

Enable then determines the target band that will be reached using the forecasted transacted value, and the rate for the forecasted target band is set as the forecasted earnings rate. The actual forecast earnings are calculated from actual transaction values applied to the forecasted rate.

Using an example program line with 3% earnings at $100,000, 4% at $200,000 and 5% at $300,000. Halfway through the year, $110,000 of transactions have been imported for this program line. Taking the linear approach to forecasting, the forecasted transacted value will be $220,000, so the forecasted rate is 4%.  Applying this rate to the actual transactions, earnings will be reported as $4,400, being 4% of $110,000.

Note that actual forecast earnings can only be reported in the Daily Earnings report.

If you are using the Forecasting module it is possible to calculate forecasted transacted values using non-linear calculations, and the forecasted transacted values from the Forecasting module will be used in the earnings calculations instead. See our article covering forecasting program line earnings for more information.