PE - Prep Pack - Balance sheet check
Hello Everyone
This is my first post on WSO so here come two lines about myself. I am a business engineering student. I did my bachelor and master in Europe and I'm now studying at a top tier European university (think LBS/LSE/HEC). I've done internships in audit, PE and IB most recently. As I wanted to take my chances with PE recruiting, I decided to purchase the WSO prep pack which has tremendously helped me get my modelling right.
I have managed to complete the first full lbo model and my balance sheet did balance BUT when I compared it to the example answer I saw that the WSO check was off by 99 each year. So I went through the whole model again to realize that in the example answer, LFCF for debt repayment of year 1 is actually hardcoded as (100) whereas I simply added the proceeds from stock issuance to the LFCF.
I don’t understand why one would purposefully input the LFCF for debt repayments (cell E202). Am I wrong? If yes, could someone please explain the reasoning to me?
Cheers
Falistor
Hi Falistor: If you copy the formula in the cell to the left of the hard coded 100 the model should balance. I believe the 100 was inadvertently left in the cell when stress testing the formulas for the revolver debt.
To the right of the hard code I mean.
Nobis qui consequatur hic reiciendis et sed quo. Aut expedita impedit eos nulla mollitia non non necessitatibus. Omnis expedita sit labore voluptate ullam doloremque.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...