Generate pro forma financial statements with revenue projections, expense forecasts, and multi-scenario analysis
You are a financial planning specialist helping me build a comprehensive pro forma financial statement. I need forward-looking projections that are grounded in realistic assumptions and formatted for professional use with investors, lenders, or internal planning teams. The business I am projecting for is [COMPANY_NAME], which operates in the [INDUSTRY] industry. The company is currently at the [BUSINESS_STAGE:select:Pre-revenue startup,Early-stage (under 2 years),Growth stage (2-5 years),Established business (5+ years),Turnaround or restructuring] stage. A brief description of what the company does and its primary revenue sources: [BUSINESS_DESCRIPTION]. I need a pro forma [STATEMENT_TYPE:select:Income Statement,Balance Sheet,Cash Flow Statement,All Three Statements Combined] covering a projection period of [PROJECTION_PERIOD:select:12 months (monthly breakdown),3 years (quarterly for year 1 then annual),5 years (annual breakdown),Custom period]. The primary purpose of this pro forma is [PURPOSE:select:Securing investor funding,Bank loan application,Internal strategic planning,New product or service launch,Market expansion,Merger or acquisition analysis,Board presentation]. Here are the key financial assumptions and data to work from: Current or expected annual revenue: [REVENUE_AMOUNT]. Revenue growth assumptions or drivers: [REVENUE_DRIVERS]. Key expense categories and estimated amounts: [EXPENSE_DETAILS]. Any planned capital expenditures: [CAPEX_PLANS?]. Existing debt obligations or planned financing: [DEBT_INFO?]. Headcount plans and payroll estimates: [HEADCOUNT_PLANS?]. For scenario modeling, generate [SCENARIO_COUNT:select:Single best-estimate scenario,Two scenarios (base and optimistic),Three scenarios (conservative base and optimistic)] so I can see how changes in key assumptions affect the financial outlook. Vary revenue growth rates, cost structures, and timing assumptions across scenarios to show a realistic range of outcomes. Build the pro forma using the following structure. Start with a clear statement of all assumptions listed in one place so the reader can see exactly what drives each number. Group assumptions into revenue assumptions, cost assumptions, capital assumptions, and financing assumptions. Every line item in the projections should trace back to a stated assumption. For the income statement projection, begin with gross revenue and show any deductions to reach net revenue. Break out cost of goods sold or cost of services to calculate gross margin. List operating expenses in meaningful categories rather than lumping them together. Show EBITDA, depreciation and amortization, interest expense, taxes, and net income as separate line items. Include gross margin percentage, operating margin percentage, and net margin percentage alongside the dollar figures. For the balance sheet projection, separate current and non-current assets, list current and long-term liabilities with enough detail to understand the debt structure, and include retained earnings that tie back to the income statement. Verify that assets equal liabilities plus equity for each period. For the cash flow projection, organize it into operating, investing, and financing activities. Start from net income and adjust for non-cash items and working capital changes. Show free cash flow and ending cash balance for each period. Highlight any periods where cash drops below a minimum threshold. After the projections, include a sensitivity analysis showing how net income and cash flow change if revenue comes in 10 percent above or below the base case and if cost of goods sold increases by 5 percentage points. Present this as a table with the variable changed, the assumption shift, and the resulting impact. End with a narrative summary identifying key inflection points such as when the company reaches profitability, achieves positive cash flow, or may need additional funding. Flag assumptions that carry outsized risk and suggest what data I should gather to validate them. Format all figures with proper accounting conventions, using parentheses for negative numbers. Round to the nearest dollar for projections under one million and to the nearest thousand for larger figures. Label every table and section clearly.
Use this prompt anywhere
10,000+ expert prompts for ChatGPT, Claude, Gemini, and wherever you use AI.
Get Early AccessForecasting your company's financial future is one of the most important steps in raising capital, planning growth, or preparing for a major business decision. A pro forma financial statement projects revenue, expenses, and cash flow over a future period based on specific assumptions. Investors, lenders, and board members rely on these documents to evaluate whether a venture is worth funding or whether an expansion plan is financially sound.
This pro forma template generates complete forward-looking financial statements, including income statements, balance sheets, and cash flow projections, with built-in scenario modeling. Enter variables like [COMPANY_NAME], [REVENUE_AMOUNT], and [PROJECTION_PERIOD] and the AI produces structured projections with assumption tracking, margin analysis, and sensitivity tables. It adapts output depth based on your [PURPOSE] and [BUSINESS_STAGE] so the document matches what your audience expects. If you need to analyze existing financials before projecting forward, start with the financial statement analyzer. For a focused look at money coming in and going out, try the cash flow statement generator.
Open the template in the Dock Editor to customize each section and run multiple scenarios with AI assistance. You can also use this prompt directly in ChatGPT, Claude, or Gemini to generate your projections in a single pass.
Enter [COMPANY_NAME], select your [INDUSTRY], and choose the [BUSINESS_STAGE] that fits. Add a [BUSINESS_DESCRIPTION] covering what your company does and how it earns revenue. This context shapes the assumptions the AI builds into the projections.
Select the [STATEMENT_TYPE] you need, from a single income statement to all three statements combined. Pick a [PROJECTION_PERIOD] that matches your planning horizon. A startup raising seed funding typically needs 3 to 5 years, while an internal budget cycle may only require 12 months.
Provide [REVENUE_AMOUNT], [REVENUE_DRIVERS], and [EXPENSE_DETAILS] as your core inputs. Add optional fields like [CAPEX_PLANS], [DEBT_INFO], and [HEADCOUNT_PLANS] for a more complete picture. The more specific your inputs, the more accurate the projections.
Choose [SCENARIO_COUNT] to control whether the output includes a single estimate or multiple scenarios. Three-scenario modeling (conservative, base, optimistic) is standard for investor presentations and loan applications.
Check the sensitivity analysis section first to see which assumptions have the biggest impact on your bottom line. Adjust any inputs that seem too aggressive or conservative, then regenerate until the projections reflect a realistic and defensible financial outlook.
Build investor-ready financial projections that show a clear path to profitability, with multi-scenario modeling that demonstrates you have considered different market outcomes and funding timelines.
Create pro forma statements for bank loan applications or SBA funding requests that include the revenue forecasts, expense breakdowns, and cash flow projections lenders require.
Generate structured projection models for expansion planning, M&A due diligence, or board presentations that include assumption documentation and sensitivity analysis in a professional format.
Project rental income, operating expenses, capital improvements, and debt service for property acquisitions or development projects with clear period-by-period cash flow visibility.
Discover more prompts that could help with your workflow.
Track daily and monthly expenses with categorized spending logs, trend analysis, and budget alerts for personal or business finances
Project how your savings grow over time with compound interest, regular contributions, and inflation adjustments
Create professional receipts for sales, services, and transactions with itemized details
10,000+ expert-curated prompts for ChatGPT, Claude, Gemini, and wherever you use AI. Our extension helps any prompt deliver better results.