Question: please show how to complete in excel 22. Develop a simulation model for a three-year nan- cial analysis of total prot based on the following
please show how to complete in excel

22. Develop a simulation model for a three-year nan- cial analysis of total prot based on the following data and information. Sales volume in the rst year is estimated to be 100,000 units and is projected to grow at a rate that is normally distributed with a mean of 'T': per year and a standard deviation of 4%. The selling price is $10, and the price increase is normally distributed with a mean of $0.50 and stan- dard deviation of $0.05 each year. Per+unit variable costs are $3. and annual xed costs are $200,000. Per-unit costs are expected to increase by an amount normally distributed with a mean of 5% per year and standard deviation of 2%. Fixed costs are expected to increase following a normal distribution with a mean of I0% per year and standard deviation of 3%. Based on 500 simulation trials, compute summary statistics for the average three-year undiscounted cumulative prot
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
