Question: Make sure to get the split view of the chart (i.e. the frequency chart on the left and the statistics on the right). You can

 Make sure to get the split view of the chart (i.e.

Make sure to get the split view of the chart (i.e. the frequency chart on the left and the statistics on the right). You can get the split view from the view menu of the chart when you run the simulation. Now, move the arrows on either side of the chart to get a certainty % in the middle box. Step through this exercise on your own using the data provided and then change the input cell values (assumptions) to see how it impacts the project's NPV. Run the simulation again and compare the forecast charts for the two scenarios. ASSIGNMENT SUBMISSION: 1. Excel sheet with given date, assumptions and forecast definitions; simulation chart, analysis 2. Excel sheet with changed date, assumptions and forecast definitions; simulation chart, analysis Tip: After you run simulation and get the chart, you can copy the chart from Edit -> Copy Chart and paste it inside the Excel next to(or below) the date table. You can either submit two separate excel files one for each or you can submit one file with two tabs

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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

Students Have Also Explored These Related Accounting Questions!