c. Show the process by which a computer would perform a simulation analysis for this project. Use
Question:
c. Show the process by which a computer would perform a simulation analysis for this project. Use the random numbers 44, 17, 16, 58, 1; 79, 83, 86; and 19, 62, 6 to illustrate the process with the first computer run. Actually calculate the firstrun NPV and IRR. Assume the cash flows for each year are independent of cash flows for other years. Also, assume the computer operates as follows: (1) A developmental cost and a project life are estimated for the first run using the first two random numbers. (2) Next, sales volume, sales price, and cost per unit are estimated using the next three random numbers and used to derive a cash flow for the first year. (3) Then, the next three random numbers are used to estimate sales volume, sales price, and cost per unit for the second year, hence the cash flow for the second year. (4) Cash flows for other years are developed similarly, on out to the first run’s estimated life. (5) With the developmental cost and the cash flow stream established, NPV and IRR for the first run are derived and stored in the computer’s memory. (6) The process is repeated to generate perhaps 500 other NPVs and IRRs. (7) Frequency distributions for NPV and IRR are plotted by the computer, and the distributions’ means and standard deviations are calculated.
Step by Step Answer:
Financial Management Theory And Practice
ISBN: 9781439078105
13th Edition
Authors: Eugene F. Brigham, Michael C. Ehrhardt