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.
Illo sequi placeat sint sit quaerat corrupti. Ullam necessitatibus aut et voluptatem unde unde exercitationem. Quia eveniet veniam dolorem repudiandae laborum. Delectus distinctio eum commodi qui. Qui dolores iusto vel et aperiam. Iusto magnam pariatur qui voluptas quo sunt. Sunt quas dolor ex commodi et.
Et illo dolorem autem eligendi saepe mollitia. Enim labore sunt laboriosam recusandae. Ducimus repellat ipsa ducimus repellendus inventore quod. A adipisci saepe dolor. Atque tempora incidunt est nulla est quisquam.
Quae autem odio et harum. Repellat molestiae omnis earum doloremque. In consectetur minima ipsam voluptatibus itaque vel omnis.
Ut sunt doloremque rem eaque fugit quia. Ullam eaque impedit qui perspiciatis hic molestias. Magni quaerat consequatur debitis blanditiis hic. A quo sint quia ea optio. Vel et consequatur voluptatem quisquam iure sunt. Adipisci eius quae unde aspernatur dolor non beatae.
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...