Hi guys -
Building an lbo model for the first time and having trouble balancing the model. Gone through everything and not having any luck. Any help would be massively appreciated
Cheers
| Attachment | Size |
|---|---|
| practice_model_6_23_wso_upload.xls 152 KB | 152 KB |
| +73 | Ex Apollo Associate Q&A (But I Actually Answer) | 114 | 5m | |
| +56 | Q&A - Anything about PE / MBA / Life | 62 | 2s | |
| +45 | How to Model SaaS Projections for Interviews | 49 | 1d | |
| +36 | [Technical doubt]: Cash sweep and mandatory amortization | 9 | 14h | |
| +23 | European Megafunds (based on PEI 2023) | 17 | 2d | |
| +22 | Is internal reporting at most funds really so Excel & PPT heavy still? | 8 | 8h | |
| +22 | Partners Group Long Term | 8 | 1d | |
| +19 | Advent NYC Culture/WLB - 2024 update | 9 | 48m | |
| +18 | How is your life in PE? | 12 | 27m | |
| +18 | How much thematic work / industry research do you guys do? | 0 | 2h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
You're not accruing retained earnings and you doing an average of debt values to get your interest payments. Should fix it.
Also, format your numbers a bit more. Use the "accounting" format for numbers, percents for percents, blue font for inputs, green for links between cells.
The assumptions (http://www.streetofwalls.com/finance-training-courses/private-equity-tr…) says to use average balances for calculating Interest Expense - does this still meaning im doing it incorrectly? Thank you muchly
Edit: the accrual issue was pt one of the fix, really appreciate it
Also, deferred financing fees are a non-cash expense, so those should be added back in your CFS, which will clear up the difference in your first year and accumulated difference once you make the above change.
Your cash balance in 2012 is plugged, so just make that dynamic and link properly if you ever change your min cash balance assumption.
You should never have hard codes in your cells (for example, your annual capex assumption), and also build out your depreciation table as a % of capex or if you do your waterfall the actual calculation of years of depreciation for the capex.
Edit: turns out your CFS is just linked wrong to your IS for deferred financing fees.
That was the issue - you're a saint. Broke out the interest on the IS and forgot to re-check links for the other parts.
Gracias amigo
Why not regress cogs to revenue and grow revenue by that as your base?
There are many questionable assumptions in his model. Financing assumptions, "unit renewal" rate, several COGS assumptions (in particular % bad debt) and most of the SG&A.
Gotcha, I was reading it on my phone
Would suggest using the WSO Template given the nine practice lbo models available.
Those models have helped me a ton in practicing to LBO like a pro....
Also, I have actually recreated the Street of Walls Template in the past (pitch perfect including format which is wild given that they only provide screenshots without instructions for certain formulas). I would still recommed learning and practicing from WSO's own version given their variety of lbo models.
Dolor dicta aut sapiente sed ipsum. Accusantium alias est dolore quasi praesentium.
Optio iusto nostrum enim esse tempora tempore. Consequatur aliquam et quia ut delectus veniam.
Ut molestiae iure repudiandae perspiciatis magnam repellendus. Voluptas culpa dolor harum aspernatur. Facere excepturi non nesciunt voluptatem qui incidunt ad.
Quo asperiores quas molestias nulla doloremque distinctio id. Quia incidunt dolor non enim. Eos unde illo quisquam voluptas aperiam sed.
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...