Finance and management · Budget Planning, Forecasting & Scenarios

Budget, forecast and what-if analysis in the same financial model

Versioned budget, rolling forecast, income statement, cash flow and balance sheet projected in the same model. Scenarios and what-if analysis answer “what if” in seconds, with comparator, sensitivity, tornado, Monte Carlo and measurement of the accuracy of each projection.

The problem and the solution

What changes when Budget Planning, Forecasting & Scenarios works inside the platform

This is connected information about classes, graduates and events across 11 modules, replacing scattered spreadsheets and messages.

Without the platform

Information about Budget Planning, Forecasting & Scenarios lives in separate spreadsheets, and nobody knows which version is current.

With Partiu Formatura

11 modules share the same class, graduate and event records.

Without the platform

A request for a number takes time because someone has to combine data from several places.

With Partiu Formatura

Financial Planning and Base Plan and Rolling Forecast and Monthly Cycle update together, with figures ready for the next meeting.

Without the platform

The process depends on who is working that day, and its history disappears.

With Partiu Formatura

Everyone follows the same workflow, with recorded actions and role-based permissions.

Without the platform

Connecting with other departments means exporting spreadsheets and entering data again.

With Partiu Formatura

Budget Planning, Forecasting & Scenarios shares information directly with other areas of the platform.

How it works

How information moves through Budget Planning, Forecasting & Scenarios

Each step is a real module in this area. Its output moves to the next step without anyone entering the same information again.

Featured

The projection that measures the error itself

Every frozen version becomes a promise against which the accomplished is compared when it arrives. The module stores the error in money, the relative error and the side of the error because being wrong 8% always upwards is a different problem than being wrong 8% both ways. Redesign creates a new version; the previous one becomes history and continues to be measured.

See this in action
  • Frozen version is immutable, and unfreezing requires registered reason
  • Each cell keeps where it came from, and the one typed is never overwritten
  • Balance sheet projected with the spot closing difference
  • Reopened jurisdiction invalidates that month's measure, without erasing the history

Financial Planning and Base Plan

The exercise plan in versions, with each number keeping track of where it came from.

  • Plan per exercise with skills materialized from the first to the last month
  • Versions with history: redesign creates new version and the previous one continues to be measured
  • Frozen version is immutable, and the screen changes "edit" to "create version from this"
  • Each cell stores the origin: typed, by driver, seasonality, imported, copied or calculated
  • Typed cell is sovereign: the engine does not replace it and the scenario does not move it
  • Competency row grid with direct editing and pasting from Excel
  • Ready income statement structure, with revenue, deductions, costs, expenses, EBITDA and profit
  • Analysis-free dimensions: cost center, branch, class, product or channel
  • Comparison between two versions, line by line, with delta and variation
  • Publication of a version as a company reference, with its own permission

Rolling Forecast and Monthly Cycle

Accomplished so far, projection from then on, and the border moves every month.

  • Rolling vision with accumulated achievements added to the projection of what is missing
  • Direct answer to the question "how does the year end if nothing changes"
  • Monthly cycle with window, responsible for area and submission deadline
  • "My part" screen for the manager to deliver only what is his
  • Approval and return of submission with registered reason
  • Consolidation refused while there is outstanding area unless you decide otherwise
  • Opening the cycle creates the new version from the previous one, without deleting the history
  • Competence closure that stops the achievement and moves the rolling frontier

Projected DRE, Cash Flow and Balance Sheet

The three statements as a single model, with the closing check in sight.

  • Projected income statement month by month, from gross to net profit, with calculated margins
  • Cash flow using the indirect method, linked to the Income Statement and the variation in working capital
  • Projected balance moved by the result and the cashier, with the cashier closing the account
  • Closing check across all competencies, with the difference exposed and never hidden in "others"
  • Working capital by PMR, SME and PMP, with calculated needs and financial cycle
  • Suggestion of average deadlines based on what the company practiced in the last twelve months
  • Opening cash balance coming from actual treasury position, not from a typed field
  • Notice when projected cash becomes negative, with the month in which this starts

Scenarios, Sensitivity and Risk

"What if evasion rises 3 points and the CDI drops to 9%?" in seconds, without redoing the plan.

  • Scenario saves the adjustment, not a copy of the plan: the corrected basis applies to everyone
  • Percentage, absolute or replacement adjustment, on driver, premise or line
  • Simulation without messing up the working version
  • Base comparator and up to four scenarios, in results, cash and margin
  • Expected value weighted by probabilities, calculated only when they add up to close to 100%
  • Tornado that orders the variables by impact and shows which ones decide the year
  • Monte Carlo simulation with seed, for the round to be reproducible tomorrow
  • Percentiles, probability of hitting the target and distribution histogram
  • Break-even point calculated based on the real model, not the fixed cost formula

Drivers, Assumptions and Indicator-Driven Model

Revenue is not a typed number: it is classes × graduates × ticket × (1 − dropout).

  • Graduation driver catalog: classes, graduates per class, average ticket, dropout rate, adherence to extras
  • History collected from the system itself, without retyping
  • Projection by average, moving average, trend, seasonality or fixed growth
  • Method without sufficient history falls to the simplest and warns rather than inventing series
  • Macro assumptions by competence: IPCA, IGP-M, CDI, Selic, exchange rate and salary adjustment
  • User-written formulas, with validation as you type and error position
  • Circular dependency refused on save, with cycle path in message
  • Reference to previous jurisdiction for default and delayed effects
  • Seasonality profiles, including those derived from actual company history

Investments, People and Debt

Capex, headcount and financing with rules that no one can get right.

  • Investment plan with disbursement and depreciation from entry into operation
  • People plan by position, with charges, benefits, 13th salary and vacation provision
  • Salary adjustment applied in the right month, based on the chosen premise
  • Sheet projected month by month, with December peak visible
  • Debt by SAC, Price or bullet, with grace period and automatically generated schedule
  • Debit balance derived from the schedule, never entered
  • Total cost of money in interest, which does not appear in the contract
  • Recurring contracts with annual validity and adjustment, without entering the same value 24 times
  • Separate permission for people plan, which exposes individual salary

Accomplished, Deviations and Result Bridge

What happened next to what was planned, and the explanation that adds up.

  • Automatically collected from twelve sources within the system itself
  • Source chosen by line between cash and accrual basis, and shown next to the number
  • Recollect replaces and never adds: running twice gives the same number
  • Detail of the composition of each cell, with document count
  • Budgeted, forecast and realized matrix, with deviation against each reference
  • Result bridge that breaks down the difference into the five lines that explain it most
  • Justification with classification, action plan, owner and deadline
  • Timing deviation separate from real loss: revenue that only changed month is not cost cutting
  • List of deviations above tolerance still unexplained

Forecast Accuracy

How much the last projection was wrong, and in which direction.

  • Mean Money Error (MAE) and Relative Error (MAPE) by Version and Competency
  • Bias with sign, which separates those who always err on the same side from those who oscillate
  • Reading in Portuguese: "optimistic projection", "pessimistic projection", "within tolerance"
  • Accuracy per line, ordered by error size, to find where the projection fails
  • Measure triggered at the end of the competence, without anyone needing to remember
  • Reopened jurisdiction invalidates that month's measure, and this is recorded
  • Comparison of accuracy between versions, to know which projection to trust

Goals, Alerts and Executive Cockpit

The single screen, and the number that goes to the person instead of waiting for them.

  • Catalog of financial indicators with visible formula and calculation memory
  • Gross margin, EBITDA, net profit, cash generation, burn, runway and cash days
  • Net debt over EBITDA, current liquidity and financial cycle
  • Own indicator created by the user, without depending on development
  • Goal with target, attention range, critical range and mandatory person responsible
  • Score that respects the direction of the indicator: in burn and debt, lower is better
  • Cockpit with results, cash, goals, accuracy and pending issues on one screen
  • Target alerts outside the range, negative cash and balance sheet that does not close
  • Alert deduplication: the same warning does not become thirty identical notifications

Multi-year, Valuation and Consolidation

The three to five year plan, how much the company is worth and the consolidated branches.

  • Multi-year plan designed by method, not by 400 lines invented for 2029
  • Base year annualized from the detailed plan, without underestimating partial horizons
  • Valuation by discounted cash flow, with each WACC component separate
  • Weight of perpetuity in the value is always visible, because it tends to be the largest part
  • WACC sensitivity against growth, which shows the range instead of a single point
  • Perpetual growth above WACC is declined, and does not return an infinite number
  • Consolidated of headquarters and branches with participation and consolidation method
  • Intercompany eliminations, with warning when they are missing and revenue is inflated
  • Covenants tested against the model, pointing out in which month the index breaks

Exports, Automations and Governance

The number leaves the system, and the module maintains itself.

  • Export of grid, income statement, cash flow, balance sheet and carried out in CSV that Brazilian Excel opens
  • Accounting layout for the accountant to import, separate from the management DRE
  • Membership meeting package with summary, scenarios and accuracy, ready to print
  • Spreadsheet import with mandatory preview and the reason for each line rejected
  • Collection of results, recalculation and automatic alerts every day, in the right order
  • Job panel showing the last execution of each one: a silent job is a stopped job
  • Twelve separate permissions, including approve other than publish
  • Complete trail with author, before and after, including version unfreezing
  • Module is born offline, with mirror mode to check before trusting

Checklist

Everything included in Budget Planning, Forecasting & Scenarios

All 96 features in this area, grouped by module so you can compare systems item by item.

  • Plan per exercise with skills materialized from the first to the last month
  • Versions with history: redesign creates new version and the previous one continues to be measured
  • Frozen version is immutable, and the screen changes "edit" to "create version from this"
  • Each cell stores the origin: typed, by driver, seasonality, imported, copied or calculated
  • Typed cell is sovereign: the engine does not replace it and the scenario does not move it
  • Competency row grid with direct editing and pasting from Excel
  • Ready income statement structure, with revenue, deductions, costs, expenses, EBITDA and profit
  • Analysis-free dimensions: cost center, branch, class, product or channel
  • Comparison between two versions, line by line, with delta and variation
  • Publication of a version as a company reference, with its own permission
  • Rolling vision with accumulated achievements added to the projection of what is missing
  • Direct answer to the question "how does the year end if nothing changes"
  • Monthly cycle with window, responsible for area and submission deadline
  • "My part" screen for the manager to deliver only what is his
  • Approval and return of submission with registered reason
  • Consolidation refused while there is outstanding area unless you decide otherwise
  • Opening the cycle creates the new version from the previous one, without deleting the history
  • Competence closure that stops the achievement and moves the rolling frontier
  • Projected income statement month by month, from gross to net profit, with calculated margins
  • Cash flow using the indirect method, linked to the Income Statement and the variation in working capital
  • Projected balance moved by the result and the cashier, with the cashier closing the account
  • Closing check across all competencies, with the difference exposed and never hidden in "others"
  • Working capital by PMR, SME and PMP, with calculated needs and financial cycle
  • Suggestion of average deadlines based on what the company practiced in the last twelve months
  • Opening cash balance coming from actual treasury position, not from a typed field
  • Notice when projected cash becomes negative, with the month in which this starts
  • Scenario saves the adjustment, not a copy of the plan: the corrected basis applies to everyone
  • Percentage, absolute or replacement adjustment, on driver, premise or line
  • Simulation without messing up the working version
  • Base comparator and up to four scenarios, in results, cash and margin
  • Expected value weighted by probabilities, calculated only when they add up to close to 100%
  • Tornado that orders the variables by impact and shows which ones decide the year
  • Monte Carlo simulation with seed, for the round to be reproducible tomorrow
  • Percentiles, probability of hitting the target and distribution histogram
  • Break-even point calculated based on the real model, not the fixed cost formula
  • Graduation driver catalog: classes, graduates per class, average ticket, dropout rate, adherence to extras
  • History collected from the system itself, without retyping
  • Projection by average, moving average, trend, seasonality or fixed growth
  • Method without sufficient history falls to the simplest and warns rather than inventing series
  • Macro assumptions by competence: IPCA, IGP-M, CDI, Selic, exchange rate and salary adjustment
  • User-written formulas, with validation as you type and error position
  • Circular dependency refused on save, with cycle path in message
  • Reference to previous jurisdiction for default and delayed effects
  • Seasonality profiles, including those derived from actual company history
  • Investment plan with disbursement and depreciation from entry into operation
  • People plan by position, with charges, benefits, 13th salary and vacation provision
  • Salary adjustment applied in the right month, based on the chosen premise
  • Sheet projected month by month, with December peak visible
  • Debt by SAC, Price or bullet, with grace period and automatically generated schedule
  • Debit balance derived from the schedule, never entered
  • Total cost of money in interest, which does not appear in the contract
  • Recurring contracts with annual validity and adjustment, without entering the same value 24 times
  • Separate permission for people plan, which exposes individual salary
  • Automatically collected from twelve sources within the system itself
  • Source chosen by line between cash and accrual basis, and shown next to the number
  • Recollect replaces and never adds: running twice gives the same number
  • Detail of the composition of each cell, with document count
  • Budgeted, forecast and realized matrix, with deviation against each reference
  • Result bridge that breaks down the difference into the five lines that explain it most
  • Justification with classification, action plan, owner and deadline
  • Timing deviation separate from real loss: revenue that only changed month is not cost cutting
  • List of deviations above tolerance still unexplained
  • Mean Money Error (MAE) and Relative Error (MAPE) by Version and Competency
  • Bias with sign, which separates those who always err on the same side from those who oscillate
  • Reading in Portuguese: "optimistic projection", "pessimistic projection", "within tolerance"
  • Accuracy per line, ordered by error size, to find where the projection fails
  • Measure triggered at the end of the competence, without anyone needing to remember
  • Reopened jurisdiction invalidates that month's measure, and this is recorded
  • Comparison of accuracy between versions, to know which projection to trust
  • Catalog of financial indicators with visible formula and calculation memory
  • Gross margin, EBITDA, net profit, cash generation, burn, runway and cash days
  • Net debt over EBITDA, current liquidity and financial cycle
  • Own indicator created by the user, without depending on development
  • Goal with target, attention range, critical range and mandatory person responsible
  • Score that respects the direction of the indicator: in burn and debt, lower is better
  • Cockpit with results, cash, goals, accuracy and pending issues on one screen
  • Target alerts outside the range, negative cash and balance sheet that does not close
  • Alert deduplication: the same warning does not become thirty identical notifications
  • Multi-year plan designed by method, not by 400 lines invented for 2029
  • Base year annualized from the detailed plan, without underestimating partial horizons
  • Valuation by discounted cash flow, with each WACC component separate
  • Weight of perpetuity in the value is always visible, because it tends to be the largest part
  • WACC sensitivity against growth, which shows the range instead of a single point
  • Perpetual growth above WACC is declined, and does not return an infinite number
  • Consolidated of headquarters and branches with participation and consolidation method
  • Intercompany eliminations, with warning when they are missing and revenue is inflated
  • Covenants tested against the model, pointing out in which month the index breaks
  • Export of grid, income statement, cash flow, balance sheet and carried out in CSV that Brazilian Excel opens
  • Accounting layout for the accountant to import, separate from the management DRE
  • Membership meeting package with summary, scenarios and accuracy, ready to print
  • Spreadsheet import with mandatory preview and the reason for each line rejected
  • Collection of results, recalculation and automatic alerts every day, in the right order
  • Job panel showing the last execution of each one: a silent job is a stopped job
  • Twelve separate permissions, including approve other than publish
  • Complete trail with author, before and after, including version unfreezing
  • Module is born offline, with mirror mode to check before trusting

Want to see Budget Planning, Forecasting & Scenarios in your operation?

See a demonstration using your own numbers, with no obligation. A conversation will help you decide whether the module solves your needs.