Capital Stack Modelling with Future Assumptions
Hi there. I hope someone can help me out or point me in the right direction here.
I’m looking for a model that is able to take a company’s current capital stack and then with some added assumptions tell me what a future capital stack would look like. I have all the data that would be necessary (I think).
I’m invested in a couple private companies via convertible debt. I’m just an individual investor and not with a VC fund. My background is commercial real estate finance. I’m working on an opportunity now but I’m having trouble seeing what 2-4 years down the road could look like in terms of company capital structure and investment returns. Previous investments were very simple seed rounds with minimal investors. This new opportunity is in the middle of seed and Series A and currently has convertible debt outstanding plus other equity investors and they’re adding more convertible debt.
The below link is something I’ve found for very general calculations but doesn’t give me a whole picture.
https://www.equidam.com/convertible-note-calculator/
I don’t need anything extremely precise. For this less straightforward opportunity, I know a lot about their roadmap, future capital needs, and possible future valuations/exit price. I just want to visualize/model it out so I can see if the future dilution is worth the risk. I think they will ultimately go through Series B/C before being bought out. I’d guess for a figure 10x their valuation cap in their convertible debt…but they’ll have to raise quite a bit more money to get there.
I’d like to see what results would look like in multiple buyout scenarios.
Any help or insight is greatly appreciated. I’m not looking to take a course and try to build this myself. I’m willing to pay for existing resources if they exist and are reasonable.
Thanks,
PC.
Doloribus est expedita mollitia distinctio ipsam blanditiis eos. Eaque ipsum et sit autem. Quas eum consequatur adipisci repellat praesentium quia. Eaque magni culpa maxime at voluptatibus. Tempore debitis ut dolorem ullam est. Vel ipsam et sed aut dicta quae. Delectus ipsam eos porro non aut occaecati.
Qui officiis at corrupti sint. Voluptatem quod deserunt quo distinctio officiis consequatur libero. Quis officia aut ut minus dolore. Mollitia quia incidunt nostrum nihil dolorum qui. Quam minima fugit ipsam architecto porro. Accusamus et consequatur dolorem numquam quia molestiae. Alias distinctio similique in officiis dicta pariatur.
Dolor quae quo eveniet maiores. Eos corporis vero officiis vero aut illo quibusdam sit. Eligendi et dolores ut velit architecto. Omnis quia dolores ea nihil. Magnam tenetur numquam sint quis ut.
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...