Please use excel with formulas to answer this question(Ps. We didnt cover the stimulation by excelsim on class so I really dont know how to do it. I really appreciate it if you can present detail steps on how I should perform this function on excel).

Lakers Kobe Bryant B Kobe Bryant - FamoD Henderson Recalls F Seriously Synonyms Kobe Bryant of LoRab bi Spring 2018 A.McLcod FI 389 5. Potash Industries, Inc. is negotiating a contract to sell a minimum of 80,000 tons of potash per year to Fertilizer Industries Corporation. Potash Industries, Inc.'s management believes that the actual quantity will average 90,000 tons per year. The firm will need an initial $11 million investment in mining and processing equipment to get the project started. The accounting department has estimated that annual fixed costs will be $1.2 million and that variable costs should be about $260 per ton of the final product. The new equipment will be depreciated to zero on a straight-line basis over five years. At the end of the project, it is estimated that the equipment could be sold for $1 million. The marketing department beheves that Fertilizer Industries Corporation will agree to a selling price of$315 per ton. The firm's required rate of return for the proyectis 10%, and the marginal tax rates 30%. A. Use the worksheet provided to calculate the project's incremental cash flows, which include the initial outlay, annual cash flow, and terminal value. B. Calculate the NPV and IRR of this project. Is the project acceptable? C. Perform a Monte Carlo simulation with 500 trials to determine the expected NPV and the standard deviation of the expected NPV. The uncertain variables and their probability distributions are given below. The tons of potash sold should be simulated for each year independently of the others (i.e., each year's sales is a separate variable). Triangular with a minimum of 80,000, most likely of 90,000, and maximum of 105,000. Tons of potash per year Normal with a mean of $260 and a standard deviation of Variable cost per ton $20. Salvage value ofUniform with a minimum of $700,000 and a maximum of equipment $1,200,000 D. Create a histogram showing the probability distribution of NPV. (Note: For part D, the Analysis ToolPak add-in must be enabled.) E. Using the output of the simulation, what is the probability that the NPV will be less than or equal to zero? Would you suggest that the project be accepted