ForecastSeries
Projects a single base value forward over N periods at a compound growth rate, producing a series where each period builds on the last. The first value in the output is the base itself, and each following value is the prior one times (1 + GrowthRate). This is the standard driver for a DCF: project free cash flow here, then discount the result.
Inputs
| Input | Accepts | Required |
|---|---|---|
Base | Value (a single number) | Yes |
GrowthRate | Value (a single number) | Yes |
Periods | Value (a single number) | Yes |
Outputs
| Output | Produces |
|---|---|
Result | Series (a list of numbers) |
Settings
Typed in on the node or set by the assistant, not wired.
| Setting | Default | Notes |
|---|---|---|
Base | 100 | The value in the first projected period. Default 100. |
GrowthRate | 0.05 | Compound growth per period as a decimal; 0.08 for 8%. Default 0.05. |
Periods | 5 | Number of periods to project. Default 5. |
Example
Free cash flow is $5.0M this year and you expect 8% growth over a 5-year explicit period. Set Base to 5000000, GrowthRate to 0.08, and Periods to 5. The series comes out $5.00M, $5.40M, $5.83M, $6.30M, $6.80M. Wire it into DiscountCashFlows (with WACC feeding the discount rate and TerminalValue capping the tail) to finish the valuation.
Tips
The output is a plain series of numbers with no dates attached, so a chart of it alone will label periods generically. If you want the projection to carry real dates and appear as its own table tab, extend the source table with ExtendForecast instead.