Investment banking cost analysis by deal and team

Investment banking cost analysis shows how much an advisory engagement contributes after its labor, direct expenses and share of operating costs. Start with recognized fees and approved time for the same reporting period, then reconcile the resulting costs to the ledger before ranking deals or teams.

This is an operating review of the advisory firm. Keep valuation work and securities recommendations outside the exercise; use investment banking revenue analysis for the separate question of what moved fee income.

Start with records that share a deal identifier

Collect the fee ledger, approved time export, expense ledger and the schedule supporting shared operating costs. Each record needs a reporting period and a stable engagement identifier. Add client, deal type and responsible advisory team as attributes of that identifier, rather than joining files on a client's abbreviated name.

Choose the fee basis with the controller. Cash receipts and recognized revenue answer different questions. The IRS discussion of accounting methods distinguishes income earned from cash received under accrual accounting; that timing distinction explains why a bank deposit export is not automatically a fee revenue report. This article uses recognized fees from the firm's accounting records, without prescribing a revenue recognition policy.

Build labor rates from an approved compensation schedule, including the employment costs your policy assigns to delivery work. Benefits are part of compensation: the IRS fringe benefit overview describes a fringe benefit as pay for services. Its tax rules do not determine your management allocation, so document the costs included in the rate separately.

Keep compensation already embedded in that rate out of the shared pool. Otherwise the same payroll expense appears twice.

Calculate costs in a simple deal worksheet

Deal contribution = Recognized fees − Attributable labor − Direct expenses − Allocated shared costs

Contribution margin = Deal contribution / Recognized fees

Consider an illustrative US advisory firm for one quarter. The following are worksheet columns A through E, rows 2 through 4. Hourly rates are approved inputs; fees, hours and expenses come from the period's reconciled exports.

The separately identified shared cost pool is $450,000, entered in L2. For this example, approved engagement hours are the documented allocation driver. The pool divided by 4,500 hours produces an allocation rate of $100 per hour.

Add columns F through J for labor, shared costs, total cost, contribution and margin. Enter these formulas in row 2 and fill them down through row 4:

F2 = C2*D2
G2 = $L$2*C2/SUM($C$2:$C$4)
H2 = F2+E2+G2
I2 = B2-H2
J2 = IF(B2=0,NA(),I2/B2)

Keep the formulas at full precision; display dollars as whole numbers and margins to two decimal places. A zero-fee engagement retains its costs but has no meaningful percentage margin.

For Northstar, total cost is $324,000 + $76,000 + $180,000 = $580,000. Its fee less that cost leaves $620,000. The table makes each subtraction visible instead of presenting a ranking without its cost basis.

Prove the total before comparing teams

Three checks make the worksheet useful. Fees must tie to the selected revenue accounts. Labor plus direct expenses plus shared costs must tie to the selected expense scope. Finally, allocated shared costs must exhaust the approved pool exactly.

Shared pool check = SUM(G2:G4)-L2
Contribution check = SUM(B2:B4)-SUM(H2:H4)-SUM(I2:I4)
Total margin = SUM(I2:I4)/SUM(B2:B4)

Both checks should return zero. Here, $780,000 + $170,000 + $450,000 = $1,400,000, and $2,400,000 − $1,400,000 = $1,000,000. Divide total contribution by total fees for 41.67%; do not average the deal percentages.

Maintain a separate reconciliation for expenses outside this report. Calling the residual contribution accounting net income would overstate what this limited scope establishes. The distinctions in gross margin, contribution margin and net margin help label that boundary.

Then group the same deal rows by client, deal type and advisory team. A team view should include active engagements, completed mandates and unsuccessful pursuits. Otherwise teams with heavy prospecting workloads can appear artificially efficient.

Turn the finding into an operating question

Summit's lower contribution suggests reviewing staffing mix, rework and scope against its engagement terms. It does not establish that the client should be dropped. A strategic assignment can have a different purpose, and a short reporting period may contain work whose fees appear later.

Ask the engagement leader to explain the hours before changing the allocation basis. Ask finance whether timing or expense recoveries account for the difference. For wider context, investment banking analytics covers related business questions, while commercial banking cost analysis addresses a different operating structure.

Where it goes wrong

• Cash compared with accrued costs. A delayed collection makes a profitable engagement look weak if receipts replace recognized fees.
• Loaded payroll counted twice. Benefits and compensation in hourly rates must not also remain in the shared pool.
• Missing unsuccessful work. Zero-fee mandates still consume staff time and direct expenses.
• Changing allocation drivers. Moving from hours to fees changes the reported spread even when operating costs stay constant. Show that policy effect separately.

Analyze your own deal records in Covirage

Bring a sample of your own fee, time and expense exports: Covirage maps the columns, and its tools compute and check the contribution figures. The external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring your file.

See customer profitability for the supporting business use case.