Based on the following data, conduct a Monte Carlo simulation with at least 100 realizations to...

  

Transcribed Image Text:

Based on the following data, conduct a Monte Carlo simulation with at least 100 realizations to find the distribution in NPV for the following project: Value Mean Value Standard Deviation $2,000,000 $250,000 $100,000 $50,000 $500,000 САРEХ OPEX (can vary annually) Gross Revenue (per year) $1,000,000 Royalty 10% 0% You may assume no amortization, no depreciation and no depletion. CAPEX occurs on year 0, OPEX occurs every year from years 1-10 and the discount rate is 10%. All random variables are randomly distributed. Submit: 1. A histogram of your NP, as well as a CDF and a PDF. Based on the following data, conduct a Monte Carlo simulation with at least 100 realizations to find the distribution in NPV for the following project: Value Mean Value Standard Deviation $2,000,000 $250,000 $100,000 $50,000 $500,000 САРEХ OPEX (can vary annually) Gross Revenue (per year) $1,000,000 Royalty 10% 0% You may assume no amortization, no depreciation and no depletion. CAPEX occurs on year 0, OPEX occurs every year from years 1-10 and the discount rate is 10%. All random variables are randomly distributed. Submit: 1. A histogram of your NP, as well as a CDF and a PDF.