How do I use the "Build a Comprehensive Financial Model Template" prompt?

Copy the prompt template, fill in the variables (BUSINESS_TYPE, FORECAST_PERIOD, PRIMARY_USE_CASE, INDUSTRY, REVENUE_MODEL, MAIN_COST_DRIVERS, GROWTH_STAGE, CURRENCY), and paste it into ChatGPT, Claude, or Gemini.

What AI tools work with this business prompt?

This prompt works with chatgpt, claude, gemini. Simply copy and paste the template into any of these AI assistants.

Tips for getting the best results?

Start with a simple model structure and add complexity gradually - avoid over-engineering from the beginning Use consistent color coding: blue for inputs, black for formulas, red for important outputs or warnings Build in data validation and error checks (IFERROR, conditional formatting) to catch modeling mistakes early Create a separate assumptions sheet that feeds into all other tabs - this makes scenario testing much easier Include monthly detail for at least the first 2 years, then switch to annual for longer-term projections

business advanced

Build a Comprehensive Financial Model Template

Generate professional financial model templates with formulas, assumptions, and projections. Perfect for startups, investments, and business planning.

Works with: chatgptclaudegemini

Prompt Template

Create a comprehensive financial model template for a [BUSINESS_TYPE] with [FORECAST_PERIOD] projections. The model should be suitable for [PRIMARY_USE_CASE] and include the following components: **Required Sections:** 1. Executive Summary Dashboard 2. Key Assumptions & Drivers 3. Revenue Model & Projections 4. Cost Structure & Operating Expenses 5. Cash Flow Statement (Direct/Indirect method) 6. Income Statement (P&L) 7. Balance Sheet 8. Key Financial Ratios & Metrics 9. Scenario Analysis (Base, Optimistic, Pessimistic) 10. Sensitivity Analysis 11. Valuation (DCF, multiples) **Specific Requirements:** - Industry: [INDUSTRY] - Revenue model: [REVENUE_MODEL] - Key cost drivers: [MAIN_COST_DRIVERS] - Growth stage: [GROWTH_STAGE] - Currency: [CURRENCY] **Output Format:** Provide detailed Excel formulas, cell references, and structured layouts for each section. Include: - Clear headers and section organization - Input cells (blue) vs. formula cells (white) formatting guidance - Data validation rules where appropriate - Key assumptions that drive the model - Linking formulas between sheets - Error checking mechanisms - Charts and visualization recommendations Make the template scalable and easy to modify. Include detailed explanations for complex calculations and assumptions that should be reviewed regularly.

Variables to Customize

[BUSINESS_TYPE]

Type of business or company

Example: SaaS startup

[FORECAST_PERIOD]

Time horizon for projections

Example: 5-year

[PRIMARY_USE_CASE]

Main purpose of the financial model

Example: fundraising and investor presentations

[INDUSTRY]

Specific industry or sector

Example: enterprise software

[REVENUE_MODEL]

How the business generates revenue

Example: subscription-based with tiered pricing

[MAIN_COST_DRIVERS]

Primary cost components

Example: personnel, cloud infrastructure, customer acquisition

[GROWTH_STAGE]

Current stage of business

Example: early-stage with product-market fit

[CURRENCY]

Primary currency for the model

Example: USD

Example Output

**SAAS FINANCIAL MODEL TEMPLATE - 5 YEAR PROJECTION** **EXECUTIVE DASHBOARD:** - Key Metrics: ARR, MRR Growth, CAC, LTV, Burn Rate - Formulas: =SUM(Revenue!B2:M2)*12 for ARR **ASSUMPTIONS SHEET:** - Customer Growth: 15% MoM (months 1-12), 10% MoM (years 2-3) - ARPU: $299/month, 5% annual increase - Churn Rate: 5% monthly, improving to 3% by year 3 - CAC: $450, improving with scale **REVENUE MODEL:** - New Customers: =B15*(1+$B$5) linking to growth assumptions - Monthly Revenue: =Customers*ARPU*Retention_Rate - Annual Revenue: =SUM(B25:M25) **COST STRUCTURE:** - Personnel: 60% of revenue (years 1-2), scaling to 45% - Cloud Infrastructure: $12 per customer + 15% of revenue - Sales & Marketing: 40% of revenue **CASH FLOW:** - Operating CF: =Revenue-OpEx+Working_Capital_Change - Investment CF: =CapEx+Asset_Purchases - Financing CF: =Equity_Raised+Debt_Changes **SCENARIO ANALYSIS:** - Base: Current assumptions - Optimistic: +25% customer growth, -20% churn - Pessimistic: -30% customer growth, +50% churn **VALUATION:** - DCF: NPV using 12% WACC - Revenue Multiple: 8x-12x ARR range

Pro Tips for Best Results

Start with a simple model structure and add complexity gradually - avoid over-engineering from the beginning
Use consistent color coding: blue for inputs, black for formulas, red for important outputs or warnings
Build in data validation and error checks (IFERROR, conditional formatting) to catch modeling mistakes early
Create a separate assumptions sheet that feeds into all other tabs - this makes scenario testing much easier
Include monthly detail for at least the first 2 years, then switch to annual for longer-term projections