Copilot ROI From a 50-User Pilot: How to Measure the Results

A Copilot pilot answers one question: for which roles does the counted value of saved time exceed the seat price by enough margin to survive the assumptions? Everything in the method serves that comparison.

The cost side is known before the pilot starts. On the October 2026 price list, Microsoft 365 Copilot is $30.00 per user per month on an annual term, $360.00 per user per year, and the list carries no month-to-month option for it. Microsoft 365 Copilot Business, the edition for tenants on Business Basic, Standard or Premium with 300 or fewer users, is $21.00 per user per month on an annual term ($252.00 per year) or $25.20 month to month. All are Microsoft list prices.

The value side is what the pilot measures: hours per active user per month saved in the named workflows, counted at a realization share you choose and at finance's loaded hourly rate. The rest of this article is how to get those inputs honestly.

Pick five roles with ten people each, not fifty volunteers. Selection criteria that produce usable data:

• At least one recurring written deliverable per week: a status report, a proposal, a client summary.
• A measurable share of the week in meetings or email triage.
• Files in SharePoint or OneDrive, not on a file share Copilot cannot read.
• Two or three skeptics per role; enthusiasts overstate.
• Nobody on leave for more than a week during the 90 days.

Term decision rule: on a Business plan, buy Copilot Business month to month for the pilot and convert the keepers to the annual term, or to the Business Standard with Copilot bundle at $23.50 or Business Premium with Copilot at $32.00 per user per month on an annual term, when the base plan renews. On Microsoft 365 E3 or E5, the annual Microsoft 365 Copilot seat is the only option, so the 50 are a year's decision: under the New Commerce Experience a subscription can be canceled for a prorated refund only within seven calendar days of purchase, and after that the seat count cannot go down until renewal, though a seat can be reassigned to another user. Details are in Microsoft 365 Copilot licensing and pricing and the Copilot Business trial article.

The baseline is the part most pilots skip, and without it there is no before-and-after. For each role, name three to five workflows and measure them for four weeks:

Keep the log to two questions per workflow: minutes spent today, and how many. Four weeks smooths month-end spikes. Record each role's loaded hourly rate from finance now, before anyone has a result to argue about.

Run the data readiness check in the same four weeks. Copilot respects existing permissions, so an overshared SharePoint site becomes visible to anyone who asks the right question. The Copilot oversharing and Purview before Copilot articles cover the checks; a site that fails them is excluded from the pilot, not ignored.

Assign licenses on a Monday, train each role on its own workflows with its own files, and keep the daily log running. Two Microsoft reports tell you whether anyone is using the seats:

• The Microsoft 365 Copilot usage report in the Microsoft 365 admin center (Reports, then Usage, then Microsoft 365 Copilot) shows enabled users, active users and each user's last activity date, and the Copilot Chat view can be set to the last 7, 30, 90 or 180 days. This is the source for the active-user count the value formula needs.
• The Copilot Dashboard in Viva Insights, included with the Copilot subscription without a separate Viva license since the third quarter of 2024, adds adoption trends and an estimate it calls Copilot assisted hours, with a breakdown of the actions behind it under How do we estimate this. Its default minimum group size is ten, adjustable down to five. Treat the assisted-hours figure as Microsoft's model of activity; the daily log is the measurement.

Checkpoints:

• Day 21: any role with fewer than half its people active in the last seven days gets a second training session before anything is judged.
• Day 45: reassign a seat that has shown no activity for 30 days to someone on the waiting list; the license moves, the term does not.
• Day 90: close the log, export both reports, and compute.

Report both license lines. The quarter figure is what the pilot consumed; the commitment figure is what the organization signed for, and on an Enterprise plan it is the real number. Microsoft bills the licenses to you; a partner's fixed-price work is a separate line.

Counted monthly value for a role = active users × hours saved per active user per month × realization share × loaded hourly rate.

• Active users: from the usage report, users active in the last 30 days, not licensed users.
• Hours saved per active user per month: the baseline minutes minus the pilot minutes for each workflow, multiplied by that workflow's weekly count, summed and converted to a month. Use the log, not a survey question that asks people how much time they think they saved.
• Realization share: the fraction of saved time you are willing to count as capacity the business can use. Some saved time becomes a shorter day, backlog clearing or better quality rather than output. Agree the fraction with finance before you see the data, write it down, and keep it for every role.
• Loaded hourly rate: salary plus benefits and overhead divided by working hours, from finance.

Break-even per seat is small, which is why the realization share matters. At a $60.00 loaded rate, a Microsoft 365 Copilot seat at $30.00 per month breaks even on half an hour of counted time per month; at $120.00, on a quarter of an hour. Counted time, not reported time. The Copilot ROI calculator turns these inputs into a month-by-month cost and value series and a payback month; replace every default with your own pilot figures.

Expansion carries two licensing constraints. Copilot Business stops at 300 seats per tenant, and a Microsoft 365 Copilot seat on an annual term cannot be reduced until renewal. Time the expansion to the base plan's renewal date so one term covers both.

One page per role and one summary:

1. The cost table with both license lines and the internal hours.
2. Baseline versus day-90 minutes per workflow, with the log entries behind each figure.
3. The weekly active-user trend from the usage report.
4. The realization share and loaded rate, and who approved them.
5. Counted value against seat price per role, and the decision.
6. Data readiness findings and exclusions.
7. The next-wave seat count and its renewal date.

A report with those seven items survives a finance review. A report with a single ratio does not, because the first question will be which assumption produced it.

How much does a 50-user Microsoft 365 Copilot pilot cost in licenses?

At Microsoft list price, October 2026 price list: 50 Microsoft 365 Copilot seats on an annual term commit $18,000 for the year, of which $4,500 falls in a 90-day pilot. 50 Copilot Business seats month to month cost $3,780 for the same 90 days with no commitment, if the tenant is on a Business plan with 300 or fewer users.

Can we cancel Copilot licenses after the pilot?

Only within seven calendar days of purchase, for a prorated refund under the New Commerce Experience. After that an annual seat runs to renewal, though it can be reassigned to another user; a month-to-month Copilot Business seat can be dropped at the end of any month.

Does Microsoft provide the ROI numbers for us?

The Copilot Dashboard in Viva Insights estimates Copilot assisted hours from usage events and explains the actions behind the estimate. It is an estimate from Microsoft's model, not a measurement of your workflows; use it to spot adoption gaps and keep the value calculation on your own baseline.

Do we need Viva Insights licenses for the Copilot Dashboard?

No. Since the third quarter of 2024 the dashboard is included with the Microsoft 365 Copilot subscription. A newer daily usage snapshot report requires at least 50 Copilot licenses in the tenant.

Should the pilot use Copilot Business or Microsoft 365 Copilot?

Copilot Business if the tenant is on Business Basic, Standard or Premium with 300 or fewer users, because it can be bought month to month at $25.20 and carries the same capabilities. Tenants on E3, E5 or Office 365 plans use Microsoft 365 Copilot on an annual term.

• Microsoft 365 reports in the admin center: Microsoft 365 Copilot usage — Microsoft Learn, checked 2026-10-11
• Microsoft 365 reports in the admin center: Microsoft 365 Copilot Chat usage — Microsoft Learn, checked 2026-10-11
• Copilot Dashboard in Viva Insights — Microsoft Learn, checked 2026-10-11
• MC1314949: Microsoft Viva Copilot Analytics: daily Copilot usage snapshot — Microsoft 365 Message Center post, public mirror, checked 2026-10-11
• New commerce cancellation policy — Microsoft Learn, Partner Center, checked 2026-10-11
• IT Partner articles linked above on Copilot licensing and the Copilot Business trial, which cite Microsoft Learn's license options for Microsoft 365 Copilot and the Copilot Business FAQ
• Microsoft commercial price list, October 2026 (US), for the Microsoft 365 Copilot, Copilot Business and bundle prices quoted