Transaction Fees & Expenses

Let’s make some assumptions about the fees the target will pay to complete the LBO transaction. Typically, there is an advisory fee measured as a percentage of the transaction size, a financing fee associated with each tranche of debt calculated as a percentage of principal, and miscellaneous expenses of a fixed nature, such as legal and accounting fees. There may also be a fee paid to the sponsor.

 

Webinar: The AI Edge in Investment Banking

Presented By LSEG & Macabacus: Learn practical insights about AI’s influence on the future of banking.

Thursday, Oct 30th at 10AM EDT / 2PM GMT.

For now, we will just set up our percentage and fixed-expense assumptions, since we do not yet have enough information about the capital structure to calculate financing and advisory fees in dollar amounts. However, there is one exception–the revolver–whose size we assumed in the previous step. Fees on the revolver are calculated as a percentage of the total committed amount, so we can calculate the revolver fee right away. We’ll revisit this section of the model later to compute the amortization of capitalized financing costs, which feeds into the pro forma P&L.

Download Template

Download Template

Transaction Fees & Expenses

Try Macabacus for free to accelerate financial modeling in Excel.

Discover more topics

Webinar: The AI Edge in Investment Banking
Join experts from Macabacus & LSEG to learn practical insights about AI’s influence on the future of banking.
Read more
DCF Excel Template
Elevate your investment analysis with our free DCF model template. Understand discounted cash flow principles and perform accurate valuations in Excel.
Read more
Operating Model Excel Template
Download our free operating model Excel template. Forecast revenue, expenses, and key financial metrics for better decision-making.
Read more
LBO Excel Model
Try LBO modeling with our comprehensive Excel template. Understand key concepts, calculate returns, and gain actionable insights.
Read more