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.
By Atomiq
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.
Open the template in Atomiq or download the Excel workbook.
Read the Readme worksheet for the period layout, units, input colors, and statement links.
Enter your opening balance sheet in Supporting Schedules.
Enter your historical figures in the input cells on Supporting Schedules.
Update the scenario adjustments on Scenarios for your business.
Review Checks for Base, Upside, Downside, and Stress.
Compare the linked statements and KPIs after the accounting checks show ALL CHECKS OK.
The workbook includes an income statement, balance sheet, cash flow statement, and statement of changes in equity. Supporting Schedules supplies their calculations.
The template contains eight quarters of historical actuals followed by eight quarters of forecasts. If you change the period count, update the supporting schedules and statement ranges together.
Select Base, Upside, Downside, or Stress on Scenarios. Each case applies adjustments to drivers derived from the historical actuals.
Use the input cells identified in Readme. Enter actuals in Supporting Schedules and scenario adjustments on Scenarios. Keep the linked statement formulas intact.
It means the workbook's accounting checks are internally consistent. Review any amber plausibility warnings separately, because they identify assumptions that need attention.
Monthly budget-vs-forecast model for a small company or startup that closes the books and has to explain plan vs. actual, then reforecast the rest of the year. Best for a single business with a few entities, departments and products — not for job costing, consolidations, or a full three-statement model.
Small scale enterprise deal CRM appropriate for founder or sales lead at an small business or startup. Comes with a filterable table with conditional formatting and a dashboard to track key pipeline metrics. Adjust as needed.
A cash runway model for communicating funding requirements to investors during an early-stage financing round. Revenue modeling assumes product-lead-growth and SaaS business model. Can be adapted as needed.
