LBO - Model Tour
- 02:11
An overview of the Excel template provided. Reviewing each section of the model to get a sense for the different sections that need to be completed.
Download a file of the data from the free downloads section, or access the live industry data in Felix. Access the live industry data for Flowers Foods here: https://felix.fe.training/company-analytics/?ticker=FLO&cik=0001128928
Transcript
Here we have a template that we'll use to build the LBO model for our target company. Now, before we go through this template, it is important to note the formatting. You will see some gray cells where you should import Felix data directly. You will also see some blue background cells, such as row 17, where you'll enter some key assumptions for the model. And of course, you have the rest of the cells, the white cells, where you're gonna build out the formula of this model. So let's go through the model. The very top section allows you to import revenue and earnings data for the target company directly from Felix. Below that, you have the section where you're gonna calculate the acquisition enterprise value of the target. And here you're gonna use some Felix data, some calculations, as well as some key assumptions from the handout. Once we get through the acquisition enterprise value, we have additional key acquisition assumptions to build out here so that we can finally build our sources and uses of funds. After that, you will find the operational model as well as the debt model for the target. And in this section here, we are given specific assumptions that were alluded at in the handout. So for example, we're told that in the period from December, 2028 through December, 2030, we're gonna see revenue growth of about 2%. So you wanna work with these assumptions and you wanna build the operational model as well as the debt model below based on these assumptions. Now the very last section is the returns to equity holder section, and this will be the last step in building out our LBO model. Here you're gonna arrive at the IRR of the private equity firm.