Hi all,
Doing a take-home case study and after two days, my model's a mess.. Balance sheet way out of whack with Assets adding up to several billion less than L&E.
Have a bunch of loans disclosed in the filings, but just total size, maturity, and interest rates, with no details on amortization schedules, and I fear this may be the major hole in the whole thing. What's the best way to approach this?
Thanks in advance for your help.
| +31 | Distressed Debt the most right-tail outcome? | 17 | 1d |
| +20 | Disillusioned - what to do | 6 | 5h |
| +10 | Bad GPA, HF offer, lost in life, what do i do? | 7 | 15h |
| +9 | Confused on all the HF fee jargon | 1 | 6d |
| +9 | Take-private spreads: Baldwin Insurance ($7.7B EV) vs a small UK deal like Dianomi (£19M). Same playbook? | 1 | 22h |
| +6 | Ultramarathon/ intense running in HF? | 2 | 4d |
| +6 | HH in London | 2 | 1d |
| +6 | Delete | 4 | 1h |
| +3 | Cubist | 1 | 21h |
| +1 | Timing from Superday to offer | 1 | 3d |
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.
Start over
I would look very closely to make sure you don't have data on the life of the loans. If you truly don't they expect you to make an assumption so compare the loan interest to some benchmark with an appropriate risk factor and find the length that looks the closest. Otherwise I would peg the schedule to match depreciation, asset life, etc. As long as you can justify your assumption and your numbers make sense.
worry about the debt schedule later..get the model working first with just basic assumptions in for the debt. Once everything flows correctly, build in the actual debt schedule.
Officiis voluptatem minus sed aspernatur. Qui ut in porro pariatur atque deleniti. In harum possimus quis tempore sit aliquam. Perspiciatis consequuntur aut consequatur quam porro.
Dolor iusto porro accusantium rerum sint explicabo. Est consequuntur ab quo et tenetur. Quis consectetur quasi consequatur nihil recusandae et esse.
Vero magnam suscipit aliquid. Praesentium fugiat quis cupiditate quia veniam possimus dolorum adipisci. Voluptatem eius temporibus ipsam consequatur. Perferendis ea culpa illo at repudiandae aliquam voluptate. Quae accusamus saepe dignissimos optio occaecati nisi. Ea sed laborum iure.
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...