Monte Carlo and DCF for FP&A: An AI How-To

A Monte Carlo model is the cure for false precision. Instead of a single forecast number that is almost certainly wrong, it runs your driver-based model hundreds or thousands of times across ranges of assumptions and gives you a distribution of outcomes: the median, the range, and the probability of hitting your target. A DCF then values the resulting cash flows. AI speeds the setup, the research, and the narrative, while you keep the ranges and the judgement.

Why one number is the wrong answer#

A single-point forecast looks confident and hides all the risk. The board cannot see how likely it is, or how wrong it could be. A distribution fixes that.

On raw prediction, AI and machine learning add incremental accuracy, a method published in the Journal of Accounting and Economics improved earnings-forecast accuracy by about 7% over a naive benchmark. But the real prize is not a slightly better single number; it is the range and the risk a Monte Carlo makes visible.

The build, in five steps#

Build on a driver model so you flex the drivers, not the outputs.

You start from a driver-based model, set plausible ranges (min, base, max) per driver, run a thousand iterations, read the distribution, then DCF the cash flows. For the operating model this sits inside, see the GenAI FP&A operating model.

Where AI helps, and where it does not#

AI researches the ranges, builds the scaffold, and drafts the narrative. It does not choose your ranges or sign off the result; that stays with you, with the assumptions and approver logged.

See it run: 1,000 scenarios live#

Theory is one thing; watching the distribution build is another. The simulation below runs a transparent three-driver mini-DCF, revenue growth, EBIT margin, and discount rate, each drawn from a triangular range, one thousand times, and plots where enterprise value lands. Press Run again to resample.

Read it the way a board should. The median (P50) replaces the single guess, the P10 to P90 band is where you land four times out of five, and the plan line splits the bars into below-plan and at-or-above-plan, so the hit probability is just the share on the right. Notice that the median can sit almost on the plan while the chance of actually hitting it is barely better than a coin flip. That gap is the whole argument for probability over a single number. The deeper budget-versus-forecast question is in AI Forecasting vs Traditional Budgeting.

Build it on your own numbers#

Session 3 of Practical GenAI in FP&A ships a 1,000-iteration Monte Carlo and a DCF waterfall on your own numbers, governed and defendable. It is one of three production artifacts you leave the programme with.