Financial Model Aggregator

Power prices move 15%. What happens to your portfolio?

FMA answers that with aggregated, portfolio-level insights, on demand, driven by the Excel models you already know and trust.

Move the Driver. Get your portfolio results in seconds.

Merchant power price /MWh
$38Base $48$58
Portfolio IRR
Portfolio NAV
DSCR
Project ModelsIRRDSCR

Illustrative demo portfolio. In production these are your workbooks, rerun in their own logic.

The problem

Most teams stop asking, or spend days getting the answer.

Answering one portfolio question means opening each Project Model, changing inputs, recalculating, and copying results into the rollup by hand. Every new question restarts the whole manual process.

So portfolio questions get answered once a quarter, or once a month at best. In between, the real world happens. When power prices move 15% and you want the impact on your portfolio, the honest answer is a best guess, or two days of manual work.

solar_a.xlsx
8
9
10
11
12
13
14
solar_b.xlsx
8
9
10
11
12
13
14
solar_c.xlsx
8
9
10
11
12
13
14
portfolio_rollup_v7_FINAL.xlsx
8
9
10
11
12
13
14
Every reporting cycleOpen every Project ModelChange the input by handRecalculate and copy outRebuild the rollup~2 days per question
The solution

An integrated analysis platform built on the Excel models your team already knows.

FMA takes the time-consuming, manual and error-prone work out of aggregation. Your models stay exactly as they are; FMA unlocks them with rapid, portfolio-level analytics through a single interface.

Project Model · Solar ASource · EBITDADriver Target · Merchant priceProject Model · Solar BSource · EBITDADriver Target · Merchant priceProject Model · Solar CSource · EBITDADriver Target · Merchant pricePortfolio ModelSOURCE TARGETSSolar ASolar BSolar CPORTFOLIO EBITDA$95.6m+$9.6m vs baseDRIVERMerchant priceChange it once; every model updates.
The process

From your models to portfolio answers in three steps.

1

Setup

Tag your models where they are. The FMA add-in for Excel marks the cells that matter with two simple labels. No migration, no templates, no new system to move your models into.

SourcesOutputs that feed your portfolio analysisAny result you want in the Portfolio Model: revenue, EBITDA, equity cash flows.e.g. C12 · EBITDA
DriversInputs that drive your resultsCPI, merchant power prices, discount rates, interest rates, sensitivities. Each model keeps its own value until you move a Driver.e.g. C8 · Merchant price

Upload your tagged Project Models and FMA validates each one, screening data and macros and checking for errors, before it joins the portfolio.

FileHomeInsertFormulasDataFMA
6
7
8Merchant price ($/MWh)48.00
9
10Revenue31.4
11
12EBITDA18.0
13
14Equity cash flow9.6
15
16
FMA
Sheet1!C12 · EBITDASource
Sheet1!C14 · Equity cash flowSource
Sheet1!C8 · Merchant priceDriver Target
Upload and validate
2

Aggregate

FMA brings your disparate Project Models into one cohesive Portfolio Model. Monthly, quarterly and annual series align automatically, so the right metrics land in the right period.

Already have a Portfolio Model you like? FMA aggregates into it. No Portfolio Model yet? FMA generates one for you.

3

Run sensitivities

Run sensitivities against your portfolio using real outputs from your Project Models, not portfolio-level shocks. Move a Driver and every model reruns through its own Excel logic in the cloud, then the results roll back up in seconds.

Base case$48/MWh
Solar A$18.0m
Solar B$24.0m
Solar C$9.0m
Solar D$14.0m
Solar E$21.0m
Portfolio EBITDA$86.0m
Scenario$55/MWh
Solar A$19.8m +1.8
Solar B$27.0m +3.0
Solar C$10.3m +1.3
Solar D$15.1m +1.1
Solar E$23.4m +2.4
Portfolio EBITDA$95.6m+$9.6m vs base
Support

White-glove onboarding, then a partner as you grow.

FMA is easy to run on your own, and every customer starts with white-glove onboarding so models are connected properly from day one. Our team sets you up, tags your models with you, and shows you how to make changes.

After that, we support FMA's expansion across your portfolio: onboarding new investments, building custom dashboards and reporting, and adding new scenarios.

1
OnboardingModels tagged, validated and connected with you
2
New investmentsAdded to the portfolio as you grow
3
New scenariosDrivers and sensitivities set up on request
4
Custom reportingDashboards and views built around your questions
See it on your portfolio

Bring us one portfolio.

Request a free VIP Pilot and send three or more Project Models with one Driver you care about. We build a Portfolio Model from your files and run scenarios with you, live.

Request your free VIP Pilot

Questions

We already have a process. Why change it?

Your process works for the questions you plan for. FMA is for the ones you do not: a power price move, a rate change or a new investment, answered across every Project Model in seconds instead of days, and without depending on the one person who built the rollup.

Our portfolio companies' models are all structured differently. Does that matter?

No, FMA is built for this. You tag the relevant cells in each model, and that is it. No common template is needed.

How much work is tagging?

Users select ranges in a workbook and tag them as Sources or Driver Targets. Tags are metadata: they do not change the model's layout or logic. A model takes anywhere from 10 seconds to 30 minutes to tag, depending on its size and complexity. Leo Berwick can tag for you, or your team can after a short training. To add a model later, tag it in the add-in and run a new aggregation.

Can we push changes down into the models, not just roll values up?

Yes. Drivers flow down into each Project Model, each model recalculates through its own Excel logic, and the updated Sources roll back up into the Portfolio Model.

Does FMA work with our existing rollup?

Yes. FMA aggregates into your existing Portfolio Model, or generates one for you.

How many models do we need?

FMA is built for portfolios of three or more Project Models that share Drivers such as power price, interest rates, or inflation.