It Is the Best
Enter the results of your analysis in the Results Box on the spreadsheet. Briefly explain on a supporting sheet how you obtained your results.
Make use of Watch Cells and Watch Names in ExcelSim to determine, for each iteration, the initial outlay at time zero, the net cash flow at the end of each of the ny years, and the NPV of all cash flows (including the initial outlay) for both rates of discount. Present in your answer the results for only the first 10 and the last 10 iterations, appending the summary statistics, histogram and cumulative frequency distribution for NPV for both rates of discount. nter the results of your analysis in the Results Box on the spreadsheet. Briefly explain on a supporting sheet how you obtained your results.
Make use of Watch Cells and Watch Names in ExcelSim to determine, for each iteration, the initial outlay at time zero, the net cash flow at the end of each of the ny years, and the NPV of all cash flows (including the initial outlay) for both rates of discount. Present in your answer the results for only the first 10 and the last 10 iterations, appending the summary statistics, histogram and cumulative frequency distribution for NPV for both rates of discount.
nter the results of your analysis in the Results Box on the spreadsheet. Briefly explain on a supporting sheet how you obtained your results.
Make use of Watch Cells and Watch Names in ExcelSim to determine, for each iteration, the initial outlay at time zero, the net cash flow at the end of each of the ny years, and the NPV of all cash flows (including the initial outlay) for both rates of discount. Present in your answer the results for only the first 10 and the last 10 iterations, appending the summary statistics, histogram and cumulative frequency distribution for NPV for both rates of discount. nter the results of your analysis in the Results Box on the spreadsheet.