Question: Use your for model from Problem 3-4 to construct a simulation model for the TitMar PTV. Incorporate two random (i. e., stochastic) variables in your

Use your for model from Problem 3-4 to construct a simulation model for the TitMar PTV. Incorporate two random (i. e., stochastic) variables in your model to capture the size of the market for scooters. Each of these variables is modeled differently, as follows:
MARKET SHARE Market share follows a triangular distribution with a most likely value of 15%, a minimum of 10%, and a maximum of 20%.
GROWTH RATE IN MARKET SIZE The growth rate in market size for year 1 is assumed to be normally distributed with a mean of 5% and standard deviation of 2%. For year 2, the expected market-size growth rate is equal to the simulated growth rate for year 1 and has a standard deviation of 2%. The growth rates for years 3 and beyond follow the pattern described for year 2. Run 10,000 random trials and define two output variables— NPV and IRR. What is the probability that the NPV will be zero or lower? What is the probability of an IRR less than 18%?

Step by Step Solution

3.52 Rating (169 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

tr msoheightsourceauto col msowidthsourceauto br msodataplacementsamecell style43 msonumberformat 000 000 00220022 msostylenameComma msostyleid3 style45 msonumberformat00220022 00000220022 ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Excel file Icon

565-B-A-I (7066).xlsx

300 KBs Excel File

Students Have Also Explored These Related Accounting Questions!