Revenue Projection Growth Screen

Flag forecast months whose month-over-month revenue growth exceeds a chosen limit.

Description

Revenue growth screening checks a projection for jumps above a chosen maximum.

Revenue growth screening checks a projection for jumps above a chosen maximum.1

Flag forecast months whose month-over-month revenue growth exceeds a chosen limit.

When to use Revenue Projection Growth Screen

Use this tool to flag forecast months whose month-over-month revenue growth exceeds a chosen limit.

Prepare consistently defined customer counts, durations, costs or forecast assumptions. Keep aligned records and monetary amounts on a common period and currency basis.

How to use Revenue Projection Growth Screen and understand its results

  1. Prepare consistently defined customer counts, durations, costs or forecast assumptions. Keep aligned records and monetary amounts on a common period and currency basis.
  2. Enter projectedMonthlyRevenue, maximumMonthlyGrowthFraction using the field table and calculation rules, then run the tool.
  3. Read monthsAboveLimit, peakGrowthFraction. The explanation below defines the units, signs, ordering and any flags or placeholder values.
  4. If the tool reports an input issue, correct the values and run it again. Apply the stated assumptions when interpreting a successfully returned result.
Input fieldMeaningValue type; see rules belowRequirement
projectedMonthlyRevenueProjected monthly revenuelist of numberRequired
maximumMonthlyGrowthFractionMaximum monthly growth fractionnumberRequired

Enter at least two positive revenues and nonnegative ceiling. Compute growth rates, then return peak growth and strict exceedance indices identifying the later zero-based revenue position.

growth[i]=revenue[i+1]/revenue[i]−1

Units, indexing, boundary conditions and exceptional cases are defined in the calculation rules above.

Output fieldMeaningValue type
monthsAboveLimitMonths above limitlist of number
peakGrowthFractionPeak growth fractionnumber
json
{
  "input": {
    "projectedMonthlyRevenue": [
      100,
      200,
      300
    ],
    "maximumMonthlyGrowthFraction": 0.6
  },
  "output": {
    "monthsAboveLimit": [
      1
    ],
    "peakGrowthFraction": 1
  }
}

Limitations and assumptions

Peak may be negative. No demand or forecast accuracy is validated.

Numeric inputs, where present, must be finite. Follow the calculation-specific rules for overflow, underflow and exceptional cases. Lists are limited to 100,000 entries; the rules above may require smaller limits. Missing required fields, extra fields, wrong value types and violations of the calculation rules are input errors.

Alternative or Complementary methods

Use Default Alive Runway: Simulate whether recurring revenue reaches operating cost before cash runs out. For a complementary task, use Viral Referral K Factor: Estimate referrals generated per active user from invitations and conversion.

References

  1. Revenue Projection Growth Screen — tool.io

Similar or alternative tools

Don't forget to set a bookmark for tool.io!
Privacy | Imprint | Cookies