parts A,B,C are based on excel basic finance calculations. Part D involves use of R code.

3. The Yummy Bread Company recently includes new machine to process and produce the own brand croissant (This new machine does not replace other existing machines as this machine is the part of new product line expansion project and install on the extra space of the existing factory). The new equipment costs, including installation and set-up cost, $5 million. The CCA rate applied in this machine is 30%. However, as the following table shows, there is some uncertainty both about yearly future sales and associated various types of cost. We assume that there is no growth on yearly sales and cost of goods sold: Parameters Worst case Base case Best case Sales 2.5 3 3.5 Cost of goods sold 2.3 2 1.7 Administration costs 0.1 0.1 0 1 Increase of net working capital 1.5 1 0.5 Project lifespan (years) 7 12 17 Corporate tax rate 35% 30% 25% Cost of capital 13% 10% 7% (Sales or costs unit: $ Million) We also assume that the increase of net working capital only incurs in year 1. No matter how long the lifespan of this project is, the amount of asset disposal is always equal to undepreciated capital cost amount applied on the subsequent year. a. It is assumed that the manager use the base case as the proxy for breakeven analysis. Conduct breakeven analysis on this project. (excluding the parameters on Administration costs, increase of net working capital, and duration of project) b. Conduct sensitivity analysis on this project (excluding the parameters on Admin istration costs, increase of net working capital, and duration of project) c. Conduct scenario analysis on this project based on each three cases. (1. Let's assume that the assigned probabilities on each of the case is same and independent across six variables. Specically, the probability the worst case occurs is 25%, the probability the base case occurs is 40%, and the probability the best case occurs is 35%. Conduct the Monte Carlo simulation analysis with the number of replicates 100,000. Estimate the expected NPV and the standard deviation of NPV. What is the probability that NPV will be positive? (Note: Make sure to adhere the procedure of forecasting free cash ow and beware of project lifespan.)