DCF prompts in FP&A

Finance teams are starting to use artificial-intelligence prompts to build discounted cash flow models with bear, base, and bull cases instead of presenting one headline valuation. (x.com) A discounted cash flow model estimates what an asset or business is worth by forecasting future cash flows and discounting them back to today. Corporate Finance Institute says the model’s output changes materially when assumptions such as discount rate, terminal growth, and forecast cash flow move. (corporatefinanceinstitute.com) In practice, the prompt-generated versions are being used to produce sensitivity tables that show valuation ranges across different discount rates and growth assumptions. One common setup is a two-way table with weighted average cost of capital on one axis and terminal growth on the other. (x.com) (corporatefinanceinstitute.com) That matters because a DCF is often most sensitive to a small set of inputs, especially the discount rate and the assumptions embedded in terminal value. Corporate Finance Institute says terminal value typically makes up a large percentage of total value in a DCF model. (corporatefinanceinstitute.com) Financial planning and analysis teams already use scenario planning to show management what happens if demand, costs, or capital markets move against plan. Corporate Finance Institute says FP&A models should illustrate multiple scenarios, and McKinsey says probability-weighted, scenario-based forecasts produce the most reliable results in volatile conditions. (corporatefinanceinstitute.com) (mckinsey.com) The new wrinkle is speed: prompts can draft a conservative, base, and upside case in minutes, then recalculate the valuation grid as assumptions change. The examples circulating in finance circles show teams using that setup to stress-test forecasts before capital-allocation reviews with executives and boards. (x.com 1) (x.com 2) The appeal for executives is not that artificial intelligence picks the “right” number. It gives them a narrower question to debate: what discount rate, growth path, margin profile, or reinvestment level is realistic enough to support a decision. (modelreef.io) (mckinsey.com) The risk is that faster modeling can also make weak assumptions travel faster. Training materials from valuation providers still treat the mechanics—cash-flow forecasting, discounting, terminal value, and sensitivity analysis—as the core discipline, which means the prompt is only as good as the operator reviewing it. (corporatefinanceinstitute.com) (financialedge.com) So the shift in FP&A is less about replacing finance judgment than packaging it in ranges that boards can interrogate. A single DCF number looks precise; a sensitivity table shows exactly which assumptions have to hold for the valuation to survive. (modelreef.io)