Insights

PE 100 Day Plan: Put Reporting in Week One

Most 100 day plan private equity templates park reporting near the end. Lock KPI definitions, the close calendar, and a Power BI model built once in the first weeks.

The deal closed on a Friday. Monday morning the operating partner sends over the 100 day plan. It has workstreams for pricing, procurement, working capital, the ERP, and talent. Reporting is in there too, near the bottom, with a target date around day 90. Then the sponsor asks for the first monthly package in about four weeks.

That gap is where portfolio companies get hurt. Every other workstream in the plan gets measured with numbers. If the numbers are still being rebuilt in Excel every month, each workstream argues about its own baseline. A 100 day plan for a private equity portfolio company works better when reporting goes first, in week one, and the rest of the plan stands on it.

Black and white image of plowed furrows stretching to the horizon

What a 100 day plan private equity template leaves out

Search for a 100 day plan private equity template and you get a grid. Workstreams down the side, weeks across the top, owners in the cells. Most of them treat reporting as one more workstream. It is not. It is the ruler the others get measured with.

For a manufacturer with no analytics team, the template misses three things. Nobody has written down what each KPI means. Nobody has agreed on when the books are closed enough to report. And nobody owns the model the numbers come from, because there is no model. There is a controller with a workbook and a lot of late nights.

What it costs when reporting waits until day 90

  1. Every workstream sets its own baseline. Procurement measures savings against one cost number. Pricing measures lift against another. Working capital pulls inventory from a different extract. By day 60 the board deck has three versions of EBITDA and nobody can say which one is right.
  2. The first sponsor package gets built by hand. The controller stops closing the books to build the deck. The close slips. The next package is late too, and the sponsor starts asking questions about the finance team instead of the business.
  3. The value creation plan has no proof. A value creation plan private equity template asks you to show progress against the thesis. Without stable definitions, progress is a story. Stories get discounted.
  4. Add-ons make it worse. The first add-on brings its own ERP, its own chart of accounts, and its own idea of what gross margin means. If the platform company never locked definitions, now there are two companies to untangle instead of one.

We wrote about this pressure in the reporting bar moves the day the deal closes. The 100 day plan is where you answer it.

How to put reporting in week one

You do not need a data platform in week one. You need a short list of decisions and one place where the numbers live.

  1. Pick the KPIs the sponsor will actually read. Revenue, gross margin, EBITDA, cash, working capital, and the two or three operating measures in the thesis. For a manufacturer that might be on-time delivery, scrap, or throughput. Keep the list short. You can add later. You cannot easily take away.
  2. Write the definition of each one in plain words. What is in it, what is out, which system it comes from, and who signs off. Gross margin at standard cost or actual cost. Revenue on ship date or invoice date. Write it down and get the CFO and the operating partner to agree before anyone builds a chart. One definition across the portfolio is the whole point.
  3. Lock the close calendar. Decide which business day the books are closed enough to report, and when the package goes out. If month end already takes a week, the plan should say so out loud. Why month end still takes a week covers the usual reasons.
  4. Build the model once, not one report per request. Load the general ledger, sales, and the operating data the KPIs need into a single Power BI semantic model. Every report the sponsor sees reads from it. When the procurement team wants a savings view, it uses the same cost measure the board deck uses.
  5. Name an owner for the model. One person on the finance side owns the definitions. Someone owns the refresh. If the company has no analytics team, that owner might be an outside partner for the first few months. It still has to be a name, not a department.
  6. Ship the first package from the model. Even if it is rough. The second package will be better, and both will tie to the ledger. That is worth more than a pretty deck built by hand.

How the rest of the 100 days goes when reporting is first

Once the ruler is in place, every other workstream gets easier to judge.

  1. Working capital has a real baseline. AR, AP, and inventory come from the shared model, on the same close calendar. The working capital dashboard stops being a separate project and becomes three more pages on the model you already built.
  2. Pricing and procurement argue about the business, not the math. Both teams read gross margin from one measure. When they disagree, they disagree about price and cost, which is the argument you want.
  3. The value creation plan gets a scoreboard. Each initiative has a KPI with a definition and a baseline from week one. Progress at day 100 is a number the sponsor can check.
  4. Add-ons have a landing spot. The next acquisition maps its accounts and items into the definitions you already wrote. It is still work. It is not starting over.

This is different from the first 90 days of a Power BI program. That piece is about running a BI program. This one is about making sure the deal plan has numbers that hold before anyone is graded on them.

What to put in the plan document

If you are filling in the template this week, change three cells.

  1. Move reporting to the top row. Week one to week four, with the KPI list, the definitions, the close calendar, and the first package as the deliverables.
  2. Make every other workstream depend on it. Each workstream names the KPI it will move and points to the definition. If the KPI is not on the list, add it now or admit it will not be measured.
  3. Give the model an owner and a review date. Write down who owns it at day 100, and when the sponsor reviews whether the definitions still fit.

Executive takeaway

A 100 day plan private equity sponsors can trust puts reporting in week one. Pick the KPIs, write the definitions, lock the close calendar, and build the model once, so every workstream and every package reads from it. Then the pricing, procurement, and working capital work gets judged on numbers that hold, and the value creation plan has a scoreboard from the start.

If you are inside the first 100 days and the sponsor package is still being built by hand, see how acquisition performance visibility works, then Book a Session.

Book a Session

Need a clearer finance or executive reporting stack? Book a Session.

Book a Session