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?
Velit laborum et hic eaque cum sunt. Veniam dolore ut corporis sint enim aliquid. Id dolorem delectus recusandae sunt. Dolores fuga quibusdam ab est. Sunt cupiditate omnis qui officiis distinctio delectus dolores. Omnis non officiis quos corporis alias esse quisquam.
Molestias quam ex atque veniam. Sunt illum quia blanditiis aut eos fugit ut. Quia dolores consequatur esse reiciendis quia. Assumenda tempora assumenda voluptas fugiat.
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...