Question: Please answer the following questions 1-4 by using VBA programing. Screenshot and paste your VBA codes next to your results on Excel worksheet. Please save

Please answer the following questions 1-4 by using VBA programing. Screenshot and paste your VBA codes next to your results on Excel worksheet. Please save your work as a Macro-enabled Workbook, and submit it on Canvas. Reopen your Macro-enabled workbook before you submit to ensure that your VBA programs are correctly saved and workable. Please highlight your final answer in Excel

Firm ABC is evaluating a project, which costs -6,000 initially and will last for five years. The cash flows in year 1, 2, 3, 4, and 5 are uncertain, i.e. random numbers. The cash flow in each future year follows a normal distribution that has a mean of 1,500 and a standard deviation of 300. Assume the discount rate is 6%. Please calculate the probability that the project is acceptable. (Use Monte Carlo Simulation)

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 Finance Questions!