GET_RUN_RATE_NEXT_MONTH
Project next month's value with an optional growth rate applied.
=GET_RUN_RATE_NEXT_MONTH(currentMonthValue, [growthRate])Gibt zurück: number
Übersicht
GET_RUN_RATE_NEXT_MONTH takes a current month's total (or projected total) and estimates next month's value by applying an optional growth rate. The growth rate is expressed as a decimal where 0.1 represents 10% growth, 0.5 represents 50% growth, and -0.2 represents a 20% decline. If no growth rate is specified, the function assumes flat performance (0% growth), returning the same value.
Parameter
| Parameter | Typ | Erforderlich | Beschreibung |
|---|---|---|---|
currentMonthValue | number | Ja | The current month's total or projected total value. |
growthRate | number | Nein (0) | Expected growth rate as a decimal (e.g., 0.1 for 10%). Defaults to 0 (no growth). |
Beispiele
Flat projection (no growth)
Project next month at the same level as the current month with no growth applied.
=GET_RUN_RATE_NEXT_MONTH(10000)Ausgabe
1000010% month-over-month growth
Project next month with 10% growth applied to the current month value.
=GET_RUN_RATE_NEXT_MONTH(10000, 0.1)Ausgabe
11000Aggressive 25% growth scenario
Model an optimistic scenario with 25% month-over-month growth for planning purposes.
=GET_RUN_RATE_NEXT_MONTH(50000, 0.25)Ausgabe
62500Seasonal decline of 15%
Account for expected seasonal decline by applying a negative growth rate.
=GET_RUN_RATE_NEXT_MONTH(30000, -0.15)Ausgabe
25500Chained with current month projection
First project the current month's total from partial data, then apply 10% growth for next month.
=GET_RUN_RATE_NEXT_MONTH(GET_RUN_RATE_CURRENT_MONTH(5000, 10), 0.1)Ausgabe
17050Anwendungsfälle
Revenue forecasting
Project next month's revenue by applying expected growth rates to current month performance for budget and cash flow planning.
Traffic growth modeling
Estimate next month's website traffic based on current traffic and historical growth trends from SEO efforts.
Capacity planning
Project next month's order volume or support tickets to plan staffing and infrastructure needs ahead of time.
Investor reporting
Create forward-looking projections for board decks and investor updates based on current trajectory and growth assumptions.
Subscription growth modeling
Project next month's subscriber count or MRR by applying net growth rates that account for new signups minus churn.
Seasonal adjustment planning
Model next month's sales with negative growth rates during known slow seasons or positive rates before peak periods.
Profi-Tipps
Use a cell reference for the growth rate to quickly model different scenarios: =GET_RUN_RATE_NEXT_MONTH(B5, C1) where C1 contains the rate.
Create three projections (optimistic, realistic, pessimistic) using different growth rates side by side for scenario planning.
Chain with GET_RUN_RATE_CURRENT_MONTH for a complete two-step forecast from partial current month data to next month projection.
For compound multi-month projections, nest the function: each nesting adds one month of growth.
Use negative growth rates to model seasonal dips or expected churn periods for more realistic planning.
The calculation is straightforward: currentMonthValue multiplied by (1 + growthRate). The result is rounded to the nearest whole number. This makes it easy to model different growth scenarios by changing the growth rate parameter. You can quickly compare optimistic, realistic, and pessimistic projections by using different rates.
This function is designed to work in conjunction with GET_RUN_RATE_CURRENT_MONTH. A typical workflow is: (1) use GET_RUN_RATE_CURRENT_MONTH to project this month's final total from partial data, then (2) feed that projection into GET_RUN_RATE_NEXT_MONTH with your expected growth rate. Together, they give you a two-month forward view based on current performance.
The growth rate can come from historical data (average month-over-month growth), industry benchmarks, or strategic targets. Using a cell reference for the growth rate makes it easy to create scenario models where you can adjust the rate and see the projected impact immediately. Negative growth rates model decline scenarios, which is useful for conservative planning or seasonal adjustments.
Häufige Fehler
Error: Numeric value requiredUrsache: The currentMonthValue parameter is not a number or references a cell with text.
Lösung: Ensure currentMonthValue is a numeric value. If it comes from another function, verify that function returns a number and not an error string.
Projection seems too highUrsache: The growth rate was entered as a whole number (e.g., 10) instead of a decimal (0.1).
Lösung: Express the growth rate as a decimal. 10% growth should be entered as 0.1, not 10. Entering 10 would mean 1000% growth.
Returns 0 when growth rate is -1Ursache: A growth rate of -1 represents a 100% decline, which mathematically produces zero.
Lösung: This is correct behavior. A growth rate of -1 means complete elimination. Use rates between -1 and 0 for partial decline scenarios.
Häufig Gestellte Fragen
The growth rate is a decimal number. Use 0.1 for 10% growth, 0.05 for 5% growth, 0.5 for 50% growth, -0.1 for 10% decline, and so on. A growth rate of 0 (the default) means no change from the current month.
Yes, use a negative decimal for the growth rate. For example, -0.2 represents a 20% decline. =GET_RUN_RATE_NEXT_MONTH(10000, -0.2) returns 8000.
Nest GET_RUN_RATE_CURRENT_MONTH inside: =GET_RUN_RATE_NEXT_MONTH(GET_RUN_RATE_CURRENT_MONTH(valueToDate), growthRate). This first projects the current month total, then applies growth for next month.
The default growth rate is 0, meaning no growth. The function returns the same value as currentMonthValue, projecting flat performance.
Yes, the result is rounded to the nearest whole number using Math.round().
You can chain the function: =GET_RUN_RATE_NEXT_MONTH(GET_RUN_RATE_NEXT_MONTH(currentValue, rate), rate) gives you a two-month projection with compound growth. Each nesting adds another month.
Common sources include historical month-over-month growth averages from your data, industry benchmark reports, strategic growth targets from your business plan, or scenario assumptions for sensitivity analysis.
Verwandte Funktionen
Beginnen Sie noch heute mit GET_RUN_RATE_NEXT_MONTH
Installieren Sie Unlimited Sheets, um GET_RUN_RATE_NEXT_MONTH und 41 weitere leistungsstarke Funktionen in Google Sheets zu erhalten.
