Analysis

Once your model contains multiple business units, each with its own set of accounts and worksheets, you need a way to see the big picture. The Analysis section configures consolidation worksheets that aggregate data from individual units into unified financial statements.

Analysis worksheets answer the question every executive and investor asks: "What does the whole company look like?"

Types of Analysis

The application offers three consolidation modes, each producing a different level of detail. You can enable any combination of them.

Full Analysis

The Full Analysis worksheet consolidates every account across all business units into a single, comprehensive view. It mirrors the complete account hierarchy defined in your chart of accounts, showing every line item from every unit summed together.

When to use: Full Analysis is ideal for detailed financial review, audit preparation, and situations where you need visibility into every account. It produces the most thorough output but can be lengthy for models with many accounts.

Quick Analysis

Quick Analysis covers the same account rows as the Full Analysis but with a different formula strategy: instead of referencing each account's own worksheet, it re-derives every figure inline on one sheet — actuals read the Database table directly, and composite accounts reference other rows of the same sheet.

When to use: Quick Analysis produces a self-contained consolidation that does not depend on the per-account worksheets at all — useful as an independent cross-check of the full analysis, or as the leaner data source for reports and charts.

Quick Analysis per Unit

This mode generates a separate condensed analysis for each individual business unit. Rather than consolidating all units together, it produces one Quick Analysis worksheet per unit, allowing side-by-side comparison of unit performance.

When to use: Quick Analysis per Unit is valuable for multi-unit businesses where management needs to evaluate each division, product line, or geography independently. It highlights which units are driving overall performance.

Statement Sections

Within each analysis mode, you can control which financial statement sections are included:

Include Income Statement

Adds the Income Statement section to the analysis output. This shows revenue, expenses, and profitability metrics consolidated across the selected scope.

Include Balance Sheet

Adds the Balance Sheet section, showing consolidated assets, liabilities, and equity positions.

Include Cash Flow Statement

Adds the Cash Flow Statement section, consolidating operating, investing, and financing cash flows.

Include Valuation Summary

Adds a valuation summary section that presents DCF results and key valuation metrics alongside the financial statements. This requires the Valuation section to be configured.

How Consolidation Works

The analysis engine follows a straightforward process:

1. Reads each unit's account data for every period in the model.
2. Aggregates values by account code across units (e.g., all units' Revenue accounts are summed).
3. Preserves the hierarchy defined in Master Accounts and the account tree, so subtotals and section breaks appear correctly.
4. Applies formatting consistent with the model's formatting settings.

The result is one or more worksheets that look and feel like standard financial statements but represent the consolidated view of the entire model.

Configuration Recommendations

• For small models (one or two units with few accounts), Full Analysis alone may be sufficient.
• For mid-sized models, enable both Full Analysis (for detailed work) and Quick Analysis (for presentations).
• For large multi-unit models, enable all three modes. Use Full Analysis for deep dives, Quick Analysis for executive summaries, and Quick Analysis per Unit for operational reviews.
• Enable the Valuation Summary only if you have configured the Valuation section and want DCF metrics alongside your financial statements.