Construct a simulation model for the TitMar PTV Incorporate two random ie 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 follows a triangular distribution with a most likely value of 15 a minimum of 10 and a maximum of 20 The growth rate in market size for year 1 is assumed to be normally distributed with a mean of 6 and standard deviation of 2 For year 2 the expected marketsize 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 10000 random trials and define two output variablesNPV and IRR and answer the following questions a What is the probability that the NPV will be zero or lower b What is the probability of an IRR less than 10 For this question you can use NORMINVRANDmeanstdev Note that the simulated growth rate of year 1 will be used to compute simulated growth rate of year 2 only Regardless of simulated growth rate of year 1 we will assume that the market size in year 1 is 200000 Please see the table below for an example In this file the simulated year 1 growth is 467 In your excel market size in year 1 also should be assumed to be 200000 too This question does not give us market size in year 0 thats why we have to make this assumption so that all groups will work on this problem in the same way If you see any difference between my MS word file and the Excel file you should use the numbers in the MS word file I provide you the Excel file so that you can have a template In this assignment PTV is a project of the firm It is logical to assume that TitMar Motor has several projects in the firm If the PTV project generates negative EBT the negative EBT will reduce tax at firms level because negative EBT of this project will reduce positive EBT of other projects of this firm But Note that if you talk about your stock report if negative EBT in your report is already at the firm level tax in that year will be 0 but the negative EBT will have to be carry forward to offset the positive EBT next year or the years after Tax 0 or not depend on your assumption about EBT at the firm level