Modeling Test: Raising Debt to Pay Shareholders
Task:
The management is committed to paying $30m to shareholders in 2023 ($15m is already distributed). To keep a safe cash balance, calculate how much venture debt (or regular high-yield debt) the company should raise in 2H2023 and at what terms (including payback schedule) to deliver on the plan envisioned. Please include your calculations inside the model file. Feel free to add a separate scenario inside the current structure or do it in a separate sheet.
I'm given historical and forecasted IS, BS, and CFS.
I'm unfamiliar with building such models. I'm lost. Where do I start?
How do I determine what's a "safe cash balance", how much debt the company should raise, and with what terms to raise that debt?
Eius nemo dicta nihil corrupti tenetur. Voluptatem in voluptatem itaque et. Nam placeat modi aut cupiditate sed vitae. Labore voluptatem minus nisi.
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...