Advanced Excel portfolio
What changed
in December?
Nine engagements. Twelve months. A $96,581 matched contribution margin, with three December engagements still on hold. Open the workbook to trace the numbers, then see what a rate change would buy.
Download the working file at Will’s Workbooks · Consulting Portfolio (XLSX).
All client names and records are fictional. This portfolio demonstrates a larger commission. The $2,000 fixed-price workbook has its own published scope.

Executive · Period selector C5
Read the month before judging the change.
Open a fresh copy in desktop Excel with calculation set to Automatic. On Executive, choose 2026-12 in C5. Exactly one valid activity row and one valid cost row for the same period and engagement ID enter the reported totals.
| Billed | $186,663 |
|---|---|
| Direct cost | $90,082 |
| Contribution margin | $96,581 |
| Margin rate | 51.74% |
| Delivery hours | 701 |
Switch to 2026-11. November shows $140,845 in matched margin and no held engagement keys. December excludes $57,911 in billed activity, so the difference alone cannot establish that delivery performance declined. Switch back to December.

Reconciliation · Engagement
Find what the headline leaves out.
Choose Review held records or open the Reconciliation tab. Start with the first three entries. E07 is missing cost, E08 is missing activity, and E09 has a duplicate key. A held key can represent several source rows.
| Source | Matched | Held | Export total |
|---|---|---|---|
| Billed | $186,663 | $57,911 | $244,574 |
| Cost | $90,082 | $35,692 | $125,774 |
On Engagement, select E07 in C5. Halcyon Museum’s November row shows $24,300 billed and $11,900 cost. December’s financial fields are blank while the cost record is missing. Use Open row on the reconciliation sheet to inspect the available source.

Scenario · Driver D7
Try a higher rate without rewriting history.
Keep December as the base and open Scenario. Leave hours growth at 2%, vendor inflation at 6%, and vendor cost share at 35%. Read the Month 2 contribution margin in D24.
| Rate uplift in D7 | Month 2 margin |
|---|---|
| 4% · starting case | $105,370 |
| 8% · alternative | $112,986 |
Enter 8% in D7. Projected Month 2 margin rises about $7,616. Return to Executive to verify that December’s recorded margin is still $96,581. The forecast uses matched portfolio activity and the stated assumptions.
Across all three periods, the 4% case returns $316,110 at 53.2%, below the 54% target in I7. The 8% case returns $338,957 at 54.9%, clearing that target. The sensitivity grid in C35:G39 shows how Month 1 responds to other rate and hours combinations. Restore D7 to 4% before the next exercise.

Cost Export · Optional exercise
Watch a missing cost rejoin the report.
Use a separate copy of the original download. Enter the following fictional, verified cost record into the reserved cells on Cost Export. For the period in C113, type '2026-12. The leading apostrophe makes Excel store the period as text.
| B113 · Record ID | CST-12-E07 |
|---|---|
| C113 · Period | 2026-12 |
| D113 · Engagement | E07 |
| E113 · Cost | 9800 |
| F113 · Category | Direct delivery |
On Executive, December now has two held keys. Matched billed becomes $210,234, cost $99,882, margin $110,352, and hours 798. E08 and E09 still need their own source checks. In a real engagement, confirm a correction against the approved source before entering it.
