Analytics Tools · Managed service
Financial Modeling
Your board’s scenarios, side by side, built from your own statements.
We turn your financial statements, budgets and the spreadsheets your finance team already keeps into one model, with a lever for each decision in front of you. Your leadership and board see revenue, expenses, margin and reserves under each scenario, year by year, and every figure traces back to the statement it came from. We build the model, run it with you and keep it current.
Step by step
From a stack of statements to a model your board can use.
Five steps, with your finance team alongside us at each one.
Step 1 of 5
Bring what you have
Profit and loss statements, annual statements, budgets and the spreadsheets your finance team already keeps. You don’t reformat anything; we read them.
Step 2 of 5
We build the baseline
Each business line gets its own model, with shared administrative costs allocated across them. The baseline reconciles to your finance team’s own numbers before any scenario is run, so they can check every line.
Step 3 of 5
A lever for each decision
Funding that ends, a program you might add, staffing, a margin target, a policy change that shifts your revenue. Each decision is a lever your team can move.
Step 4 of 5
See every scenario over time
Revenue, expenses, margin and reserves, year by year, with scenarios side by side, including how long reserves last and what it would take to close a gap.
Step 5 of 5
Take it to your board
A board-ready view your leadership can present and answer questions from. When something changes, we update the model and run it again.
Case study
Why we built it: planning past the end of a funding stream.
Our financial modeling started with a regional health collaborative that had to show its board how it would sustain its programs after time-limited Medicaid funding ended. We have since built the same kind of model for other organizations.
The challenge
The organization’s finances lived in a detailed spreadsheet model and a set of budget worksheets. Leadership needed to put scenarios in front of its board and finance committee without walking them through spreadsheet tabs, and to size how much new funding it would need.
What we built
- A model for each business line, with shared administrative costs allocated by expense share
- A baseline that matched the finance team’s own model before any scenario was run
- Levers for revenue, staffing, expenses, start dates and a margin target
- A summary view of reserves, the runway they give and revenue by source
What it gave them
One model the board and finance committee can explore together, with every assumption visible: when reserves run out under each scenario, how much funding it would take to close the gap, and the answer to a “what if” while the question is still on the table.
Shared with the organization’s details and figures removed. The model and the numbers in it belong to the client; the modeling approach is Nexus’s.
A managed service
Built with your finance team, not handed to it.
Name the decisions
What your board is weighing and the scenarios it needs to see.
Build and reconcile
Your statements in, a baseline your finance team signs off on.
Walk your team through it
Every lever and figure explained, for staff and for the board.
Keep it current
New statements, new funding news and new questions go in as they come.
Put your board’s scenarios side by side.
A 30-minute conversation: the decision in front of you, the statements you have and what a model would show.
The screen above is an illustration with made-up figures. Budget and scenario modeling for planning, not a replacement for an audit or actuarial certification.