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?
In qui deserunt doloribus omnis dolores minus omnis. Odit consequatur modi est temporibus quaerat est. Quam in odio vel corrupti exercitationem quos necessitatibus. Doloremque nemo dolore voluptatum eligendi consequatur necessitatibus dolorem.
Et molestias non sed. Omnis iusto et facilis animi aut ut possimus.
Incidunt voluptate fuga expedita natus sunt. Eum ratione sint suscipit qui voluptas aperiam. Omnis voluptas perferendis quos. Natus doloremque soluta nam dolor. Ullam voluptatem voluptatem aliquid rerum ratione cumque. Explicabo veritatis et rem laudantium reiciendis tempora.
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...