All AI spreadsheets

Three Statement Model

By Atomiq

A fully linked quarterly three-statement financial model featuring eight quarters of actuals and eight quarters of forecast, with scenario-driven assumptions, supporting schedules, automated checks, and KPI analysis. Use it to build and stress-test integrated income statement, balance sheet, cash flow, and equity forecasts while preserving transparent roll-forwards and balance integrity.

Open in Atomiq →

All Atomiq models export to Excel

About

Build a quarterly financial forecast with linked income, balance sheet, cash flow, and equity statements. This template starts with eight quarters of example actuals and eight quarters of forecasts. Supporting schedules connect revenue, operating costs, working capital, fixed assets, debt, taxes, and equity. Use the scenario controls to compare assumptions, then review the accounting checks and financial KPIs.

Features

  • Eight quarters of actuals and eight quarters of forecasts in one consistent quarterly layout.
  • Linked income statement, balance sheet, cash flow statement, and statement of changes in equity.
  • Base, Upside, Downside, and Stress scenarios controlled from the Scenarios worksheet.
  • Supporting schedules for working capital, fixed assets, debt, interest, taxes, equity, and cash.
  • Checks for balance sheet integrity, cash reconciliation, and accounting roll-forwards.
  • Quarterly and annual KPIs for growth, margins, cash conversion, leverage, and liquidity.

How to edit in Atomiq

  1. Include your context

    Upload whatever is easiest: a PDF of your financial statements, a Google Sheet or Excel file with the numbers, or just describe your business and forecast assumptions to Atomiq.

  2. Let Atomiq customize it

    Tell Atomiq how your business works and what you need to forecast. The agent adapts the linked statements and supporting schedules using your data.

  3. Refine and Verify

    Use data tracing to follow figures back to their sources and agent change logs to review edits. Check the model’s accounting checks and ask Atomiq to resolve discrepancies.

  4. Share or export

    Share the financial model in Atomiq, or export to Excel for your planning process.

FAQ

Who is this template for?

Finance teams building a linked financial forecast or comparing business scenarios.

What is not included in this model?

The model forecasts quarterly results, not monthly results. It starts with eight forecast quarters; a longer horizon requires extending the linked schedules.

How do I get my own data and assumptions in?

Include your data from any spreadsheet, including Google Sheets and Excel, or from a PDF. Tell Atomiq what assumptions to use and what you need changed. The agent customizes the workbook for you; use data tracing and agent change logs to verify its work.

Can I get it in Excel or Google Sheets?

Yes. Export the workbook to Excel. To use it in Google Sheets, import the exported Excel file. You can also keep working and share it in Atomiq.