Blog · Board and management reporting · Investment banking
Explain investment banking fee movements using completed deals, recognized fees and service mix. Reconcile advisory and underwriting revenue before investigating changes in deal size, participation and negotiated terms.
Investment banking revenue analysis explains recognized fees by completed deal, client, product and period. Match fee-ledger postings to the underlying mandates, then separate completion volume, service mix and realized fees. This is an operating business analysis for bank finance and product leaders.
An announcement, a mandate win and a cash receipt answer different questions from revenue. Use the accounting recognition period as the bridge's primary time field, while retaining announcement, completion, invoice and receipt dates for investigation.
For a concrete reporting reference, Goldman Sachs' annual report describes advisory and underwriting fee recognition in Note 7. Its policy ties recognition to completion of the relevant services or underlying transaction under assignment terms. Apply your own approved policy to deposits, milestones, retainers and reimbursements rather than assuming every item follows the same timing.
Define included ledger accounts before comparing periods. Keep advisory, debt underwriting and equity underwriting separate. Do not add trading revenue, lending interest or principal investment gains to a fee bridge without explicitly expanding its scope.
The commercial banking revenue analysis workflow handles balances and interest rates. Here, the unit is the recognized mandate and its allocated fee.
Use one row per fee posting, retaining deal identifier, client identifier, product, recognition period, completion status, currency, bank-recognized fee, fee component, adjustment reason and source reference. Separate gross fees from pass-through reimbursements when your reporting boundary requires it.
Add eligible transaction value, contractual rate and bank participation where the engagement terms make those meaningful. A headline deal value is not automatically the fee calculation base. Advisory retainers and minimum fees may not be proportional to transaction value at all.
Make a second summary with one row per deal and product before counting completions. Otherwise several ledger postings on one mandate become several deals. Link fee-only adjustments to the original deal and report them separately if they belong to earlier completions.
In Excel, suppose Fees has recognition period in A, product in B, deal ID in C and signed recognized fee in D. With period in B1 and product in A2:
=SUMIFS(Fees!$D:$D,Fees!$A:$A,B$1,Fees!$B:$B,$A2)
Microsoft's SUMIFS documentation explains the multiple-criteria calculation. Count completions from the deduplicated deal summary, then divide the matching recognized fees by that count. Covirage is not affiliated with Microsoft or Goldman Sachs.
A US investment bank compares two illustrative quarters. Every deal in this example is completed and recognized in its stated quarter, with no cross-period adjustments. Average fees below are exact, and all fees represent the bank's own revenue allocation.
| Product | Prior deals | Current deals | Prior average fee (USD) | Current average fee (USD) | Prior revenue (USD) | Current revenue (USD) |
|---|---|---|---|---|---|---|
| Advisory | 4 | 5 | 1,000,000 | 1,100,000 | 4,000,000 | 5,500,000 |
| Debt underwriting | 6 | 4 | 400,000 | 450,000 | 2,400,000 | 1,800,000 |
| Equity underwriting | 2 | 3 | 800,000 | 700,000 | 1,600,000 | 2,100,000 |
| Total | 12 | 12 | 8,000,000 | 9,400,000 |
For this summary, put prior deal count in B, current count in C, prior average fee in D and current average fee in E. The revenue formulas are:
=B2*D2
=C2*E2
The count stayed unchanged while revenue increased by $1,400,000. A headline statement that completion volume drove the increase would miss the product shift.
Use prior fees to value the change in each product's deal count. Then apply the change in average fee to current deals. This fixed order assigns the interaction to the average-fee component.
Count effect = (Current deals − Prior deals) × Prior average fee
Realized fee effect = Current deals × (Current average fee − Prior average fee)
=(C2-B2)*D2
=C2*(E2-D2)
| Product | Count effect at prior fees (USD) | Realized fee effect (USD) | Total change (USD) |
|---|---|---|---|
| Advisory | 1,000,000 | 500,000 | 1,500,000 |
| Debt underwriting | −800,000 | 200,000 | −600,000 |
| Equity underwriting | 800,000 | −300,000 | 500,000 |
| Total | 1,000,000 | 400,000 | 1,400,000 |
Because total deal count is unchanged, the $1,000,000 aggregate count effect is a service-mix effect: completions shifted among products with different prior average fees. The remaining $400,000 is the change in realized average fees within products. It can include transaction size, participation and fee terms.
The proof is $8,000,000 + $1,000,000 + $400,000 = $9,400,000. Independently, the product movements of $1,500,000, −$600,000 and $500,000 sum to $1,400,000. Both periods must also tie to the selected revenue ledger accounts.
For a proportional underwriting fee, retain eligible proceeds, contractual fee rate and bank share in separate columns. If these are G, H and I, the contract check is:
=G2*H2*I2
Compare that calculated fee to recognized revenue and explain differences using the actual settlement and recognition terms. Do not force a retainer, minimum fee or adjustment into a proportional calculation.
Finance owns the ledger reconciliation. Product heads explain completions and participation; coverage teams explain the client movements. Client wallet and league table analysis answers a separate coverage question. Once the fee bridge is sound, use investment banking cost analysis to assess the expense side and an investment banking dashboard to track the agreed measures.
Upload your fee ledger and completed-deal register with matched recognition periods. Covirage maps the columns, and its tools compute and check the comparisons; the external AI model explains the result with every figure traced to its rows. Create a free Covirage account in about a minute and bring a sample of your own data.
See revenue driver analysis for the supporting workflow from period totals to contributing rows.
No. Deal value measures the underlying transaction, while revenue is the fee recognized by the bank under its accounting policy and engagement terms. A large announced mandate may produce no recognized fee in the comparison period. Keep announced and completed transactions in separate views.
Use the bank's recognized fee allocation from its fee ledger and reconcile it to the syndicate settlement. Total issuance proceeds or the entire syndicate fee pool are different measures. Retain participation, fee components and adjustments so an allocation change can be explained.
Not necessarily. Average fees can rise because larger transactions closed, the product mix changed or the bank received a larger participation. Test negotiated fee rates on comparable transactions, using the same transaction-value definition and accounting treatment, before describing the change as stronger pricing.