Perform a Monte Carlo simulation with 1,000 trials of the uncertain variables and their probability distributions (given below). Use the COUNTIF formula to summarize your results into different buckets and plot your results in a chart to show the appropriate distribution. These graphs will not be identical to the distribution charts in the slides, but should look similar in shape.

There are not any questions with this assignment. Please submit your completed spreadsheet.

Variable	Distribution
Tons of rock salt in each year	Triangular with a minimum of 50,000, most likely of 80,000 and maximum of 95,000
Variable cost per ton	Normal with a mean of $45 and a standard deviation of $3
Salvage value of equipment	Uniform with a minimum of $70,000 and a maximum of $200,000

IF you feel ambitious, you can create an NPV for this project. YOU DO NOT NEED TO DO THIS. The quantity of rock salt sold should be simulated for each year independently of the others (i.e. it is five separate variables). Below is the information to create the NPV.

The Salida Salt Company is considering making a bid to supply the highway department with rock salt to drop on roads in the county during the winter. The contract will guarantee a minimum of 50,000 tons in each year, but the actual quantity may be above that amount if conditions warrant. Management believes that the actual quantity will average 80,000 tons per year. The firm will need an initial $1,600,000 investment in processing equipment to get the project started. The contract will last for five years and is not expected to be renewed. The accounting department has estimated that annual fixed costs ill be $500,000 and that variable costs should be about $45 per ton of the final product. The new equipment will be depreciated using MACRS with a class life of five years. At the end of the project, it is estimated that the equipment could be sold for $150,000. The marketing department estimates that the state will grant the contract at a selling price of $60 per ton, though it may get some lower bids if the contract is opened for competitive bidding. The engineering department estimates that the project will need an initial net working capital investment of $115,000. The firms WACC is 10% and the marginal tax rate is 35%.