Strategic Modeling EPS Alternatives Skill

The Strategic Modeling EPS Alternatives skill prepares revenue-led, expense-led, and balanced strategies for a specified earnings-per-share target in an existing model.

You supply or resolve the exact EPS account, parent scenario, year, target, unique scenario-name prefix, and editable revenue and expense levers. The balanced plan combines weighted single-lever solutions; it is not a joint optimizer, and its target remains unverified until approved creation, calculation, and read-back. The agent reports each alternative's actual status and tradeoffs, including partial previews or non-convergence, without inventing missing results.

Example Prompts:

  • Prepare EPS alternatives for model <model>, parent <scenario>, year <year>, EPS account <account>, and target <value>, using revenue lever <account>, expense lever <account>, and unique prefix <prefix>.
  • Show the revenue-led, expense-led, and balanced plans in EPS proposal <proposal ID>, with units and tradeoffs.
  • Explain the balanced-plan weighting and identify which outcomes are still unverified in proposal <proposal ID>.
  • Show the preview status for each EPS alternative and identify any partial or non-converged result.
  • After approved execution, compare the calculated and read-back-validated EPS results for all three alternatives against their parent scenario.

Note:

Partial previews without an executable proposal ID cannot be approved for execution. The requested scope must be resolved and a new exact proposal prepared; the agent does not silently execute only the successful alternatives.