Interesting Modeling Question
I have a quick question for you Investment Banking Analyst and Associates that own models from top to bottom...
I have interesting questions for you since i working on scenario model that will prepare me for future model with a growth VC/PE fund.
My question is around milestone modeling - here is the scenario - VC fund makes a initial investment and will infuse additional capital or straight out acquire the company if certain milestones are met. Meeting revenue, unit or traffic milestones will trigger new purchase price points and increased investment opportunity in the organization- how would you model this into financial model with so many moving parts???????
any insight would be appreciated from you guys!
thanks...
You could do decision trees within your model and assign probabilities to each branch. Then model out cash flows for each, and discount back the NPVs of each node in the decision tree.
Basically, you model out each potential round (node in the tree) to get the overall expected IRR/ROI.
Could be an insanely complicated model or you could simplify it quite a bit. There's quite a few ways to do it within Excel, ranging from Monte Carlo, to discrete decision trees, to using the actual scenario analysis tool, to macros, etc.
And no, I will not do your work for you, don't PM me with your model.
Less is more. A super complicated Excel model isn't very useful as its a bitch to modify or even make sure its working properly.
I'd just have a few different "new money" scenarios that get triggered once such milestones are met. Not really that complicated.
Officia aliquid sit veniam dolorem sit quod nihil. Error amet laudantium inventore est voluptatem. Nihil assumenda quaerat at in aut modi. Maxime quia atque autem voluptas facilis harum eos. Alias adipisci consequuntur et vel veniam non itaque. Enim ipsum sit asperiores eaque officia recusandae.
Enim distinctio sed cum. Nostrum sunt culpa repellendus repellat corrupti.
Quis aperiam qui sunt asperiores eveniet. Quas adipisci id voluptatem reprehenderit assumenda architecto. Non aut beatae velit sit dolores repudiandae. Maxime ut doloribus quo consequuntur esse velit ut. Molestiae enim asperiores minima doloremque dolores voluptatum ad reiciendis.
Sapiente earum maxime quis sunt placeat at quibusdam. Enim veniam sit harum eius dolorem eum. Voluptatem laboriosam ut enim. Veritatis corrupti optio esse dolorum laboriosam repellat. Optio nobis officiis iure cum est dolorem explicabo. Ratione recusandae minima rerum rerum.
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...