Financial modelling is an essential part of business planning, budgeting, forecasting, and investment analysis. Traditionally, building a financial model requires working with historical financial statements, calculating assumptions, creating Excel formulas, and testing different business scenarios.
ChatGPT can make this process more efficient by helping users organise financial data, design spreadsheet structures, generate formulas, forecast business performance, and analyse financial results.
However, ChatGPT should not be treated as an independent financial modelling system. Its calculations, assumptions, and outputs must be checked before they are used for business decisions.
This guide explains how to use ChatGPT to build a financial model step by step, from preparing financial data to creating forecasts, testing scenarios, and validating the final spreadsheet.
What Is Financial Modelling?
Financial modelling is the process of creating a numerical representation of a business’s financial performance. It uses historical financial information and assumptions to estimate future revenue, expenses, profits, cash flow, and financial position.
Businesses use financial models to:
- Forecast revenue, expenses, and profitability.
- Prepare annual budgets and financial plans.
- Evaluate investment opportunities.
- Estimate business value.
- Assess cash flow requirements.
- Compare different business strategies.
- Understand potential financial risks.
A typical financial model includes three interconnected financial statements:
| Financial statement | What it shows |
|---|---|
| Income statement | Revenue, expenses, and profitability. |
| Balance sheet | Assets, liabilities, and shareholders’ equity. |
| Cash flow statement | Cash generated and used by operating, investing, and financing activities. |
ChatGPT can help structure these statements, explain their relationships, and generate the formulas needed to build a working model.
How Can ChatGPT Help Build a Financial Model?
ChatGPT can support several stages of financial modelling, reducing repetitive spreadsheet work and helping users understand complex calculations.
Its most useful applications include:
| Financial modelling task | How ChatGPT helps |
|---|---|
| Financial data analysis | Reviews historical financial statements and identifies trends. |
| Model structure | Suggests spreadsheet layouts and worksheet organisation. |
| Formula generation | Creates Excel formulas based on specified calculations. |
| Revenue forecasting | Projects future revenue using historical performance and assumptions. |
| Expense forecasting | Estimates operating costs and cost structures. |
| Scenario analysis | Compares optimistic, base, and pessimistic forecasts. |
| Financial ratios | Calculates and explains important financial indicators. |
| Error checking | Helps identify inconsistencies and potential formula problems. |
| Financial reporting | Summarises model results and explains key findings. |
The important distinction is that ChatGPT helps build and analyse the model, while the financial professional remains responsible for its assumptions, accuracy, and interpretation.
How to Use ChatGPT to Build a Financial Model: 8 Steps
The following workflow demonstrates how to build a basic financial forecast using ChatGPT and Microsoft Excel.
For this example, assume you are creating a five-year financial model for a hypothetical company with annual revenue of $1 million.
Step 1: Prepare Your Historical Financial Data
Before asking ChatGPT to build a financial model, collect the company’s historical financial information.
Useful documents include:
- Income statements.
- Balance sheets.
- Cash flow statements.
- Historical sales reports.
- Operating expense records.
- Existing financial forecasts.
Ideally, prepare at least two to three years of historical financial data. This provides a starting point for understanding business performance and identifying trends.
You can upload supported spreadsheet files, including XLSX, XLS, and CSV, directly to ChatGPT for analysis.
Example prompt:
I am preparing a five-year financial model for a business. I will provide its historical income statements, balance sheets, and cash flow statements.
Analyse the financial information and identify:
-
- Historical revenue growth.
- Gross profit and operating margins.
- Operating expense trends.
- Working capital movements.
- Cash flow patterns.
- Any unusual financial changes.
Present the findings in tables. Show your calculations, identify missing information, and clearly distinguish actual figures from assumptions. Do not invent missing financial data.
Why this step matters: Historical financial information provides the foundation for future projections. Without reliable starting figures, even correctly written formulas can produce misleading results.
Step 2: Ask ChatGPT to Design the Financial Model Structure
Once your historical data is organised, ask ChatGPT to recommend a spreadsheet structure.
A well-organised financial model should separate historical figures, assumptions, calculations, and forecast outputs.
For a basic business model, you can create these worksheets:
| Worksheet | Purpose |
|---|---|
| Historical Data | Stores previous financial statements. |
| Assumptions | Contains revenue growth, expense growth, tax rates, and other inputs. |
| Revenue Forecast | Calculates projected sales. |
| Income Statement | Forecasts revenue, expenses, and net income. |
| Balance Sheet | Projects assets, liabilities, and equity. |
| Cash Flow | Tracks projected cash movements. |
| Dashboard | Summarises important financial results. |
Example prompt:
Design a five-year financial model in Microsoft Excel for a small business.
Organise the workbook into separate worksheets for historical financial data, assumptions, revenue forecasts, income statements, balance sheets, cash flow statements, and financial dashboards.
Explain the purpose of each worksheet, identify the required financial inputs, and show how the worksheets should connect through formulas.
Keep assumptions separate from calculated outputs and make the model easy to update.
This structure makes the financial model easier to understand, update, and audit.
Step 3: Define Financial Assumptions
Financial assumptions are the inputs used to calculate future financial performance.
They should be based on historical performance, management expectations, industry conditions, and realistic business plans.
For our hypothetical company, assume the following:
| Financial assumption | Example value |
|---|---|
| Starting annual revenue | $1,000,000 |
| Annual revenue growth | 10% |
| Cost of goods sold (COGS) | 40% of revenue |
| Annual operating expense growth | 7% |
| Tax rate | 25% |
| Forecast period | 5 years |
These figures are illustrative, not industry benchmarks or predictions.
Ask ChatGPT to organise the assumptions into a dedicated worksheet and explain how each input affects the forecast.
Example prompt:
Create an assumptions worksheet for a five-year financial model using the following inputs:
-
- Starting revenue: $1,000,000
- Annual revenue growth: 10%
- COGS: 40% of revenue
- Operating expense growth: 7%
- Tax rate: 25%
Separate all assumptions from calculated financial figures. Explain which assumptions should drive the income statement and how changes in each input affect profitability.
Do not introduce additional numerical assumptions without identifying them as estimates requiring approval.
Important: Do not allow ChatGPT to silently select growth rates, margins, or tax assumptions. Every input should have a clear source or an explicitly documented estimation method.
Step 4: Generate Excel Formulas for Financial Calculations
This is one of the most practical applications of ChatGPT in financial modelling.
Instead of manually writing every Excel formula, you can describe the calculation and ask ChatGPT to generate the appropriate formula based on your worksheet layout.
For example, a basic income statement may contain the following calculations:
| Financial metric | Calculation |
|---|---|
| Revenue | Previous year’s revenue × (1 + growth rate) |
| COGS | Revenue × COGS percentage |
| Gross Profit | Revenue − COGS |
| Operating Expenses | Previous year’s expenses × (1 + growth rate) |
| Operating Profit | Gross Profit − Operating Expenses |
| Tax | Positive taxable profit × applicable tax rate, subject to tax rules |
| Net Income | Profit Before Tax − Tax Expense |
For a simple Excel worksheet, assume:
- B2 contains previous-year revenue.
- C2 contains revenue growth.
- D2 contains forecast revenue.
- D3 contains COGS percentage.
- D5 contains operating expenses.
The formulas could look like this:
| Cell | Formula |
|---|---|
| D2 | =B2*(1+C2) |
| D3 | =D2*40% |
| D4 | =D2-D3 |
| D5 | =300000*(1+7%) |
| D6 | =D4-D5 |
These are illustrative formulas. In a production model, the percentages and starting values should reference dedicated assumption cells rather than being hardcoded.
Example prompt:
Generate Excel formulas for a five-year financial forecast.
The model should calculate revenue, COGS, gross profit, operating expenses, operating profit, taxes, and net income.
Use separate assumption cells for revenue growth, COGS percentage, operating expense growth, and tax rate.
Provide the exact Excel formulas, explain the cell references, and ensure that forecast years update automatically when assumptions change.
Do not hardcode assumptions inside calculation formulas.
Always test generated formulas against manually calculated results before using them in the model.
Step 5: Build the Three Financial Statements
A more complete financial model should connect the income statement, balance sheet, and cash flow statement.
These statements should not be treated as three independent spreadsheets. Changes in one statement can affect the other two.
1. Income statement
The income statement forecasts business profitability.
It typically includes:
- Revenue.
- Cost of goods sold.
- Gross profit.
- Operating expenses.
- Operating income.
- Interest expense.
- Taxes.
- Net income.
2. Balance sheet
The balance sheet shows the company’s financial position.
It includes:
- Cash and cash equivalents.
- Accounts receivable.
- Inventory.
- Property and equipment.
- Accounts payable.
- Debt.
- Shareholders’ equity.
Its fundamental accounting equation is:
3. Cash flow statement
The cash flow statement explains how cash moves through the business.
It contains three main sections:
- Operating activities: Cash generated or used by business operations.
- Investing activities: Cash spent on or received from investments and assets.
- Financing activities: Cash received from or paid to lenders and shareholders.
For example, a business may report positive net income but still experience cash shortages because customers have not paid their invoices.
This is why forecasting profitability alone is insufficient.
Example prompt:
Help me build an integrated three-statement financial model in Excel.
Create linked projections for the income statement, balance sheet, and cash flow statement.
Include working capital, depreciation, capital expenditure, debt movements, interest expense, retained earnings, and cash balances.
Explain how each statement connects to the others. Provide the required formulas and identify additional assumptions or information needed.
Ensure that the balance sheet balances in every forecast period and explain how to test the cash flow and balance sheet calculations.
This is a more advanced modelling task. The accounting treatment should be reviewed carefully, particularly for depreciation, taxes, debt, and working capital.
Step 6: Create Financial Scenarios and Sensitivity Analysis
Financial forecasts depend on assumptions that may change. Scenario analysis helps businesses understand how different conditions could affect future performance.
Ask ChatGPT to create three scenarios:
| Scenario | Revenue growth | COGS | Operating expense growth |
|---|---|---|---|
| Optimistic | 15% | 38% | 6% |
| Base case | 10% | 40% | 7% |
| Pessimistic | 3% | 45% | 10% |
Illustrative assumptions for demonstrating scenario modelling.
These scenarios allow management to compare potential outcomes under different operating conditions.
Example prompt:
Create three financial forecast scenarios for my business: optimistic, base case, and pessimistic.
Use the following assumptions:
-
- Optimistic: Revenue growth 15%, COGS 38%, operating expense growth 6%.
- Base case: Revenue growth 10%, COGS 40%, operating expense growth 7%.
- Pessimistic: Revenue growth 3%, COGS 45%, operating expense growth 10%.
Calculate projected revenue, gross profit, operating profit, and net income for each scenario over five years.
Present the results in a comparison table. Explain which assumptions have the greatest impact on profitability.
You can also use sensitivity analysis to understand how changing one assumption affects a financial outcome.
For example:
- What happens if revenue growth falls from 10% to 5%?
- How does a 5-percentage-point increase in COGS affect gross profit?
- What happens if operating expenses increase faster than revenue?
- How much additional cash is required if customer payment periods increase?
The objective is not to predict exactly what will happen. It is to understand how financial outcomes change under different conditions.
Step 7: Create a Financial Dashboard
Once your forecasts are complete, ask ChatGPT to help summarise the results in a financial dashboard.
A dashboard makes the model easier for business owners, managers, and investors to understand.
Consider including these key performance indicators:
| Financial KPI | What it measures |
|---|---|
| Revenue Growth | Percentage increase in sales. |
| Gross Profit Margin | Gross profit as a percentage of revenue. |
| Operating Profit Margin | Operating profit as a percentage of revenue. |
| Net Profit Margin | Net income as a percentage of revenue. |
| Current Ratio | Current assets divided by current liabilities. |
| Debt-to-Equity Ratio | Debt relative to shareholders’ equity. |
| Free Cash Flow | Operating cash flow less capital expenditure. |
Example prompt:
Review my completed financial model and recommend an executive financial dashboard.
Include revenue growth, gross profit margin, operating profit margin, net profit margin, current ratio, debt-to-equity ratio, and free cash flow.
Recommend suitable Excel charts and KPI summaries. Highlight significant changes between forecast years and explain the business implications.
Use only figures from the financial model and clearly identify any missing information.
Useful visualisations include revenue trend charts, profitability comparisons, cash flow projections, and scenario comparisons.
Step 8: Validate and Review the Financial Model
A financial model is only useful when its calculations and assumptions are reliable.
ChatGPT can help identify potential problems, but its review should not replace spreadsheet auditing or professional financial review.
Ask it to check:
- Incorrect or inconsistent formulas.
- Missing assumptions.
- Hardcoded numbers inside forecast calculations.
- Broken worksheet references.
- Unexpected changes in margins.
- Negative cash balances.
- Incorrect working capital movements.
- Balance sheet differences.
- Inconsistencies between net income and cash flow.
Example prompt:
Audit my financial model for potential errors.
Review the formulas, assumptions, financial statement relationships, and forecast calculations.
Check whether:
- The balance sheet balances in every forecast year.
- Cash flow movements reconcile with opening and closing cash.
- Revenue and expense forecasts use the correct assumptions.
- There are broken formulas or inconsistent cell references.
- There are unexplained changes in financial ratios.
- Any calculations contain circular references or unsupported assumptions.
Create a table showing each identified issue, its location, why it matters, and the recommended correction.
Do not claim that the model is error-free unless every relevant calculation has been independently checked.
You can also use Excel’s built-in formula auditing and error-checking tools to trace and investigate calculation problems.
Can ChatGPT Create an Excel Financial Model?
Yes. ChatGPT can help create spreadsheet structures, generate formulas, analyse uploaded financial data, and produce tables and charts.
Depending on the available tools and features, it can also help generate an Excel workbook that you can download and review.
There are two practical approaches.
1. Using ChatGPT with Excel
You can ask ChatGPT to generate formulas, explain calculations, and help organise your spreadsheet. You can then transfer the results into Microsoft Excel.
2. Using ChatGPT’s spreadsheet integration
ChatGPT for Excel and Google Sheets provides a spreadsheet-native experience that can help build, update, and understand spreadsheets directly within supported spreadsheet applications. Availability depends on the account and workspace.
For users working with complex financial models, the second approach can reduce the need to move repeatedly between applications.
Best Practices for Using ChatGPT in Financial Modelling
To get reliable results, follow these practices:
| Best practice | Why it matters |
|---|---|
| Provide accurate historical data | Prevents unreliable starting figures. |
| Use specific prompts | Reduces ambiguity in calculations. |
| Separate assumptions from formulas | Makes the model easier to update. |
| Request formulas, not just results | Improves transparency and auditability. |
| Use consistent financial periods | Prevents comparison errors. |
| Document assumptions | Makes forecasts easier to review. |
| Validate calculations independently | Helps identify AI-generated errors. |
| Review different scenarios | Reveals potential financial risks. |
One particularly useful practice is to ask ChatGPT to explain every important formula before using it.
For example, instead of asking for a projected net income figure, ask it to show the revenue, expense, tax, and calculation logic behind that figure.
This makes the model easier to understand and maintain.
Limitations of Using ChatGPT for Financial Modelling
Although ChatGPT can support financial modelling, it has limitations that users should understand.
1. Incorrect calculations
ChatGPT can generate incorrect formulas, arithmetic results, or spreadsheet references. Always verify important calculations independently.
2. Unsupported financial assumptions
If historical data is incomplete, ChatGPT may suggest assumptions that do not reflect the actual business. Require it to identify missing information rather than silently filling gaps.
3. Limited understanding of business circumstances
A financial forecast depends on factors such as market conditions, competition, customer behaviour, operational capacity, and management decisions. ChatGPT cannot automatically understand all these circumstances.
4. Complex accounting requirements
Advanced models involving deferred taxes, lease accounting, consolidation, debt schedules, and complex revenue recognition require specialist knowledge and careful review.
5. Financial data privacy
Financial statements may contain confidential business information. Review your organisation’s AI and data-handling policies before uploading documents. Remove personal information, customer identifiers, banking details, and commercially sensitive information unless the use is authorised.
6. No guarantee of accurate predictions
A financial model is based on assumptions about future conditions. ChatGPT cannot guarantee that projected revenue, expenses, or profitability will match actual business performance.
The best approach is to use ChatGPT as a modelling assistant, not as a replacement for financial expertise, accounting controls, or professional judgement.
Frequently Asked Questions (FAQs)
Can ChatGPT build a financial model in Excel?
Yes. ChatGPT can help design financial model structures, generate Excel formulas, analyse historical financial data, and create forecasts. Depending on available features, it can also assist with generating or editing spreadsheet files.
Can ChatGPT create a three-statement financial model?
Yes. It can help build an integrated income statement, balance sheet, and cash flow statement. However, users must provide the necessary financial information and verify that all three statements are correctly connected.
What information do I need to build a financial model with ChatGPT?
You generally need historical financial statements, revenue and expense information, working capital data, capital expenditure details, debt information, and assumptions about future business performance. The exact requirements depend on the type of model.
Can ChatGPT generate Excel formulas for financial forecasting?
Yes. You can describe the required calculations and spreadsheet layout, and ChatGPT can generate formulas for revenue growth, expenses, gross profit, operating income, taxes, and other financial metrics. Always test the formulas before relying on them.
Is ChatGPT accurate enough for financial modelling?
ChatGPT can be useful for financial modelling, but it is not automatically accurate. Generated calculations, assumptions, and formulas should be checked against reliable financial data and independently verified.
Can ChatGPT help with financial forecasting?
Yes. It can analyse historical trends, apply user-defined assumptions, and create revenue, expense, profitability, and cash flow projections. It can also compare different scenarios to help users understand potential outcomes.
Is ChatGPT better than Excel for financial modelling?
No. They serve different purposes. Excel provides spreadsheet functionality, calculation controls, and structured financial modelling capabilities, while ChatGPT helps users create formulas, analyse information, and explain calculations. Using both together can be more effective than relying on either alone.
Final Thoughts
ChatGPT has made financial modelling more accessible by helping users organise financial information, generate Excel formulas, develop forecasts, and analyse different business scenarios.
However, building a useful financial model involves more than generating numbers. It requires accurate historical information, realistic assumptions, connected financial statements, and reliable validation procedures.
The most effective approach is to combine ChatGPT’s analytical assistance with Excel’s spreadsheet capabilities and human financial expertise.
Whether you are a business owner preparing a financial forecast, a student learning financial modelling, or an analyst developing business projections, ChatGPT can help simplify the process while allowing you to spend more time understanding the financial results and making informed decisions.
