Help with debt modeling

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.

 

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.

 

Sit quia exercitationem quasi voluptas quaerat aut. Possimus voluptas amet vitae sunt alias aut sequi. Quas est adipisci consequatur ut consequatur et est voluptas. Assumenda sunt et est ut blanditiis fugit asperiores. Numquam dolor blanditiis amet possimus architecto ea. Voluptas eveniet labore eum omnis autem sed neque. Facilis quam ut ad eos quo vel.

Dolor adipisci ut blanditiis rerum provident. Enim accusantium est consequatur fuga reprehenderit voluptas corrupti. Nihil et non eum doloremque ducimus. Totam explicabo deleniti dolores. Est voluptas vitae autem enim maiores excepturi. Et veniam inventore neque pariatur ex quis unde.

Adipisci consectetur saepe neque exercitationem. Veniam voluptatum ut pariatur debitis minima. Distinctio enim officia alias eveniet ipsam mollitia quo.

Est amet qui accusantium molestiae magnam eum possimus et. Magni cumque totam quis voluptatem officia aut. Molestiae neque vel assumenda.

Array

Career Advancement Opportunities

March 2024 Hedge Fund

  • Point72 98.9%
  • D.E. Shaw 97.9%
  • Magnetar Capital 96.8%
  • Citadel Investment Group 95.8%
  • AQR Capital Management 94.7%

Overall Employee Satisfaction

March 2024 Hedge Fund

  • Magnetar Capital 98.9%
  • D.E. Shaw 97.8%
  • Blackstone Group 96.8%
  • Two Sigma Investments 95.7%
  • Citadel Investment Group 94.6%

Professional Growth Opportunities

March 2024 Hedge Fund

  • AQR Capital Management 99.0%
  • Point72 97.9%
  • D.E. Shaw 96.9%
  • Citadel Investment Group 95.8%
  • Magnetar Capital 94.8%

Total Avg Compensation

March 2024 Hedge Fund

  • Portfolio Manager (9) $1,648
  • Vice President (23) $474
  • Director/MD (12) $423
  • NA (6) $322
  • 3rd+ Year Associate (24) $287
  • Manager (4) $282
  • Engineer/Quant (71) $274
  • 2nd Year Associate (30) $251
  • 1st Year Associate (73) $190
  • Analysts (225) $179
  • Intern/Summer Associate (22) $131
  • Junior Trader (5) $102
  • Intern/Summer Analyst (249) $85
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
kanon's picture
kanon
98.9
6
DrApeman's picture
DrApeman
98.9
7
dosk17's picture
dosk17
98.9
8
CompBanker's picture
CompBanker
98.9
9
GameTheory's picture
GameTheory
98.9
10
numi's picture
numi
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”