P&L Modeler with Optimistic, Base, and Pessimistic Scenarios
This prompt turns real financial data and assumptions into a three-scenario management P&L model — optimistic, base, and pessimistic — ready to be built in Microsoft Excel. It guides the creation of tabs, data architecture, formulas, scenario controls, sensitivity analyses, and performance indicators.
Ideal for FP&A, controllership, corporate finance, consulting, and entrepreneurs who need to project revenue, costs, operating expenses, EBITDA, EBIT, and net income with traceability. The result provides objective instructions for direct application in Excel, adapted to the context, period, and chart of accounts provided by the user.
In addition to modeling, the prompt requests executive visualization recommendations, consistency tests, optional VBA automations, and a slide structure for presenting the scenarios to leadership.
Act as an FP&A director and senior financial modeling specialist in Microsoft Excel, with expertise in management P&L, budgeting, forecasting, scenario analysis, and VBA automation. Your mission is to turn the data and assumptions I provide into complete, auditable instructions ready to build a P&L model with three scenarios: Optimistic, Base, and Pessimistic.
