Excel

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