AI Prompts for ChatGPT for Financial Modeling

I need to build a three-statement financial model for [DESCRIBE BUSINESS TYPE]. Walk me through the architecture: what goes in the income statement, balance sheet, and cash flow statement, and how the three statements link together.

Design a revenue model for [DESCRIBE BUSINESS MODEL, E.G. "A SAAS COMPANY WITH MONTHLY AND ANNUAL SUBSCRIPTIONS AND PROFESSIONAL SERVICES"]. Define the revenue drivers, how to structure the input assumptions, and how to calculate MRR, ARR, and churn.

I need to build a unit economics model for [DESCRIBE BUSINESS]. Define the key unit metrics (CAC, LTV, payback period, contribution margin), how to calculate each, and what assumptions are most sensitive.

Explain how to structure a driver-based model vs a line-item model for [DESCRIBE USE CASE]. Which approach is better for my situation and what are the practical trade-offs in terms of flexibility and maintainability?

I am building a model with multiple business segments: [LIST SEGMENTS]. How should I structure the model so each segment can be modeled independently but roll up cleanly into consolidated financials?

Write the assumptions section for a financial model projecting [DESCRIBE BUSINESS] over 3 years. Cover revenue growth drivers, margin assumptions, headcount, capex, and working capital, with notes on how each assumption was derived.

I need to build a bottoms-up revenue forecast for [DESCRIBE SALES MOTION]. Define the pipeline stages, conversion rates, deal sizes, and sales cycle length needed to project bookings for the next 4 quarters.

Create a scenario framework for this model: [DESCRIBE MODEL]. Define the assumptions that differ between base, upside, and downside scenarios, and build a toggle so stakeholders can switch between scenarios easily.

I have a top-down market sizing model and a bottoms-up sales capacity model that produce different revenue numbers. Help me reconcile them and decide which should anchor the forecast.

Write the sensitivity analysis section for this model. The key outputs are [DESCRIBE OUTPUTS]. Identify the 5 inputs with the most impact, build a two-variable data table for each, and write the interpretation.

Write an executive summary of these financial projections for a non-finance audience: [PASTE KEY OUTPUTS]. Explain the key assumptions, what drives the results, and the most important risks to the forecast in plain language.

A business partner is questioning why our margin is declining in year 2: [DESCRIBE MODEL DYNAMICS]. Write a clear explanation of the drivers, using plain language and concrete examples rather than accounting jargon.

I need to present three funding scenarios to our board: [DESCRIBE SCENARIOS]. Write the narrative for each scenario that explains the investment required, what it buys, and the expected financial outcome.

Write the model documentation for [DESCRIBE MODEL]. Include a purpose statement, input description, key formula explanations, known limitations, and instructions for updating assumptions.

I need to communicate a budget variance to the leadership team. We are [OVER/UNDER] on [BUDGET LINE] by [AMOUNT] due to [REASON]. Write the variance explanation memo that is direct, not defensive, and focuses on resolution.

Walk me through building a DCF valuation model for [DESCRIBE COMPANY TYPE]. Cover the free cash flow projection, terminal value calculation, WACC derivation, and how to sanity-check the output.

I need to build an LBO model for [DESCRIBE TARGET COMPANY]. Explain the structure, how to model the debt schedule, the equity waterfall, and how to calculate IRR and MOIC for different leverage scenarios.

Design a headcount and compensation model for [DESCRIBE COMPANY, N EMPLOYEES]. Include current headcount, planned hires by quarter, role-level salary bands, loaded cost multiplier, and how to flag budget vs actual variance.

Build a working capital model for [DESCRIBE BUSINESS]. Define the key working capital metrics (DSO, DPO, DIO), how to calculate cash conversion cycle, and how changes in each metric affect free cash flow.

I need to model the impact of pricing changes on our P&L. Current pricing is [DESCRIBE]. I am considering [DESCRIBE PRICING CHANGE]. Build the analysis showing revenue, volume, mix, and net impact under three elasticity assumptions.