Hi guys. My first post!
I am trying to model multiple players entering a market with pre-defined probability. The portion that I cannot solve is starting a cash flow when the players enters the market and ends when the revenue reaches a certain level within a five year period.
For example, the likelihood of a player entering a market is 34% in any given year with in the five year period. There are 5 players that can enter anytime. Once the cummulative revenue reaches an expected total revenue, the player exits the market.
How can I model this? I am stuck in how the annual revenue starts and continue when the player enters the market.
Please advise.
I am trying to model multiple players entering a market with pre-defined probability. The portion that I cannot solve is starting a cash flow when the players enters the market and ends when the revenue reaches a certain level within a five year period.
For example, the likelihood of a player entering a market is 34% in any given year with in the five year period. There are 5 players that can enter anytime. Once the cummulative revenue reaches an expected total revenue, the player exits the market.
How can I model this? I am stuck in how the annual revenue starts and continue when the player enters the market.
Please advise.