Financial Analysis Engine — Chaos Theory Macro

Gross Margin

—%

—

EBITDA Margin

—%

—

Revenue

—

EBIT

—

Op. Income Margin

—

Net Income

—

Net Margin

—

Free Cash Flow

—

FCF / Revenue

—

YoY Growth

—

Revenue growth rate

vs prior period

📈

Awaiting Data

Import a CSV to populate live charts and analytics — or explore the full dashboard with sample data.

ACTUALS CSV

📊 Drop Actuals CSV Row 1 = periods · Col A = line items · $M

No actuals loaded

FORECAST CSV

📋 Drop Forecast CSV Same format as actuals

No forecast loaded

CHART METRIC

VIEW TOGGLE

Forecast vs Actuals

Load actuals to begin

--

Budget Variance Detail

--

Period	Forecast	Actual	Variance $	Variance %
Load actuals and forecast to see variance

Line Item Breakdown

Subcomponent forecast vs actual by period

--

Category Weighting

% of total · latest period

Line Item Variance Detail

--

Line Item	Forecast	Actual	Variance $	Variance %	% of Total
Load data to see line item detail

Scenario Lab

Adjust drivers to model outcomes

Growth Drivers

Revenue Growth (YoY %) +5%

Volume Growth (units %) 0%

Pricing Power (% ASP chg) 0%

Cost & Efficiency

Gross Margin Expansion (bps) 0

Labour / HC Cost Δ (%) 0%

OpEx Efficiency Gain (%) 0%

Macro Factors

Interest Rate Δ (bps) 0

FX Impact (% on Revenue) 0%

Tax Rate Δ (bps) 0

Inflation on COGS (%) 0%

Base Revenue

—

Scenario Revenue

—

Base EBITDA

—

Scenario EBITDA

—

Base Net Income

—

Scenario Net Income

—

Interactive Sensitivity Model

Baseline vs Scenario across P&L

Δ $0M

Impact Attribution

Drivers

Driver	Impact on Revenue	Impact on EBITDA

Cash Flow Manager

— Load CSV to begin

Import Daily Cash Data

Opening Balance ($)

Min Threshold ($)

No data — load a CSV or sample

CSV Format Guide

Col A: Date (MM/DD/YYYY)
Col B: Description
Col C: Amount (+ in / − out)
Col D: Category (optional)

Largest events auto-annotated on chart

Current Balance

—

opening position

Total Inflows

—

period receipts

Total Outflows

—

period payments

Net Cash Flow

—

period net

Lowest Point

—

vs threshold

Runway

—

days of cash

Load a CSV or use sample data to visualize daily cash flow with event annotations

Daily Cash Balance

Forecasted receivables & payables · annotated events

0 events

Transaction Detail

— entries

Date	Description	Category	Amount	Running Balance
Import a CSV or load sample data

Accounts Receivable

Outstanding customer invoices · aging analysis

No data loaded

📄

Unpaid Invoices

—

total outstanding

⏰

Overdue Amount

—

past due date

📅

Overdue 30+ days

—

aging bucket

🗓️

Overdue 90+ days

—

critical aging

Unpaid by Customer (Top 10)

sorted by total outstanding amount

Distribution by Customer

% share of total outstanding

AR Aging

Aging Summary

in home currency

Customer	Current	1–30	31–60	61–90	91+	Total
Load sample data or import CSV

Unpaid Invoices

—

Customer / Vendor	Invoice #	Date	Due Date	Amount Due	Status
Load sample data or import CSV

Paid Invoices

Paid by Customer

in home currency

Customer / Vendor	Current Month	Last Month	Year to Date
Load sample data

Year-to-Date Paid

distribution by customer / vendor

Pricing Strategy Lab · Set your cost and pricing assumptions

Unit Price

$ per unit / per engagement

Monthly Volume

units / clients / transactions

Variable Cost / Unit

$ direct cost per unit

Monthly Fixed Costs

$ rent, salaries, software…

Monthly Revenue

—

Price × Volume

Gross Profit

—

after variable costs

Net Profit

—

after all costs

Gross Margin

—

contribution per unit

Break-Even Units

—

units / month to cover fixed costs

Safety Margin

—

volume above break-even

Break-Even Analysis

Fixed costs vs. contribution margin over volume

Price × Volume — Net Profit Sensitivity

Each cell = monthly net profit · green = profitable · red = loss

Margin Waterfall

How each cost layer erodes revenue

Price Ladder — Scenario Comparison

How net profit changes across price points at current volume

Price / Unit	Revenue	Gross Profit	Gross Margin	Net Profit	Net Margin	BE Units

Demand Elasticity Analysis · How your market responds to price changes

Market Type

select your market positioning

Elasticity Coefficient (ε)

e.g. −1.0 = unit elastic · −0.5 = inelastic

Price Range to Model

to

$ min price → $ max price

Optimal Price (Revenue Max)

—

revenue-maximizing price point

At Optimal Price

—

projected monthly revenue

Projected Volume

—

units at optimal price

Optimal Net Profit

—

after all costs

vs Current Price

—

revenue delta from optimal

Elasticity Type

—

Demand Curve & Revenue Maximization

Volume & Revenue indexed to peak (100) · hover for actual values · shaded band = elasticity uncertainty

Elasticity Scenario Comparison

Net profit across price points under 3 elasticity assumptions

What This Means for Your Business

Capital Asset Investment Decision

Discounted Cash Flow · NPV · IRR · Payback · Sensitivity — Should you invest?

Run analysis to see recommendation

Asset Details

Asset Name / Description

Total Capital Outlay ($)

Full acquisition cost incl. install, training, freight

Useful Life (Years)

Salvage / Residual Value ($)

Estimated resale or scrap value at end of life

Annual Cash Flow Drivers

Year 1 Annual Revenue / Savings ($)

New revenue generated OR cost savings from this asset

Annual Revenue Growth Rate (%)

Year 1 Annual Operating Costs ($)

Maintenance, energy, labor, materials — excl. depreciation

Annual OpEx Inflation Rate (%)

Financing & Hurdle Rate

Discount Rate / WACC (%)

Your cost of capital or minimum required return (hurdle rate)

Tax Rate (%)

Depreciation Method

Net Present Value

—

PV of future cash flows minus outlay

Internal Rate of Return

—

vs — hurdle rate

Payback Period

—

years to recover capital outlay

Profitability Index

—

> 1.0 = value created per $ invested

Cumulative Cash Flow vs. Outlay

Payback crossover point · undiscounted vs. discounted

Annual Free Cash Flow After Tax

Revenue − OpEx − Tax · depreciation tax shield applied

NPV Sensitivity Matrix — Discount Rate vs. Revenue Growth

Each cell shows NPV · Green = Buy (NPV > 0) · Amber = Marginal · Red = Pass (NPV < 0)

Run analysis to generate sensitivity matrix

Annual Cash Flow Schedule

All values in $ · tax shield from depreciation included

Year	Revenue / Savings	Operating Costs	Depreciation	EBIT	Tax	After-Tax FCF	PV Factor	Discounted FCF	Cumulative NPV
Enter inputs and click Analyze Investment

Data Import Hub · connect your data sources

Import files from QuickBooks, Xero, Excel, or any CSV export. Each card feeds the corresponding dashboard tab automatically.

P&L · No data

Forecast · No data

Cash Flow · No data

AR/AP · No data

📊

P&L · Actuals

Income statement · monthly or quarterly columns
QuickBooks P&L export · Xero · Excel · CSV

Feeds → Historicals & KPIs · Forecast & FvA · Scenario Lab

⬆

Drop P&L CSV or click to browse

Row 1 = period headers · Col A = line items · values in $M

No file loaded

📈

Forecast

Budget or projected P&L · future periods
Must match the same row structure as Actuals

Feeds → Forecast & FvA · Variance Analysis · Drilldown

⬆

Drop Forecast CSV or click to browse

Same format as Actuals · future period columns

No file loaded

💵

Cash Flow

Daily or weekly transaction ledger
Date · Description · Amount · Category · Balance

Feeds → Cash Flow Manager · Balance Chart · Weekly Detail

⬆

Drop Cash Flow CSV or click to browse

Columns: Date · Description · Amount · Category · Balance

No file loaded

🧾

A/R · A/P Ledger

Accounts receivable and payable detail
Invoice · Customer/Vendor · Amount · Due Date · Status

Feeds → A/R · A/P page · Aging Analysis · Paid by Customer

⬆

Drop AR/AP CSV or click to browse

Entity · Invoice # · Date · Due Date · Amount · Status · Type

No file loaded

🗺️

Row Mapper · P&L Line Items

Auto-detected from your P&L file. Adjust any row that didn't map correctly. Changes apply immediately to all charts.

Current P&L status: No actuals loaded

Raw Data Preview

Load a file to preview