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
Get step-by-step solutions from verified subject matter experts
