Intermediate LBO Model-PC

This is the intermediate model. You should only practice with this after mastering the easy model from a blank sheet. 

This is much more complicated than the easy model because we are dealing with the balance sheet and building a more complex waterfall. Remember, take as much time as you need on the first pass. Really try to figure things out on your own before 'cheating' with the answer sheet.  

If you're able to nail this down, you'll be prepared for 85% of PC modeling tests. All other featured models are just different scenarios you may be asked to run in a prompt. 

Goal: complete the template in under 45 minutes, model from a blank sheet in under 1 hour. Try to summarize in 3 sentences or less why this would or would not be a good investment purely based on the output of the model. 

Steps:

1. Download the prompt and use the attached template to assist your modeling 
2. Take a minute to look through the different sections of the model to understand where inputs may be flowing and where outputs are coming from (balance sheet, waterfall, and covenants featured!)
3. Work the model top-down filling in the assumptions section, then the sources & uses, etc. You should only have to fill out the cells colored light gray 
4. After a first try, open up the answer file and really study the underlying formulas and the levers to impact returns (waterfalls can seem complex at first!)
5. Attempt the template again. After completing the template with no assistance from the answer file, open up a blank excel and try to build a model from scratch to answer the prompt

The_Pulse_LBO_Model_Intermediate_Prompt PC.docx

The_Pulse_LBO_Intermediate_PC.xlsx

The_Pulse_LBO_Intermediate_Answer_PC.xlsx

📌Password: Buyside📌