Excel
Stub Period
In many cases, there will be a period of time between the transaction closing date and the date of the next fiscal year-end. In our case, this is 2 months....
Read more
Balance Sheet Set-Up
Now that we've begun to build our income statement let's switch gears and set up our balance sheet. For now, we are going to simply plug in historical...
Read more
Fully-Diluted Shares Outstanding
Now, let's calculate the target's fully-diluted shares outstanding ("FDSO"), as we will need this figure to calculate enterprise value in the next step....
Read more
LBO Model Enterprise Value
What is Enterprise Value in LBO?
Now that we have calculated the target's fully-diluted shares outstanding ("FDSO"), let's compute enterprise...
Read more
Financing Summary
Let's now take the financing case selected by the cell we named "fin_case" and display the sources and uses of funds for this case in the transaction overview/assumptions...
Read more
Amortization of Capitalized Financing Costs
In a previous step, we assumed that most financing fees were capitalized as an asset on the company's balance sheet and amortized over the lives (i.e....
Read more