Use Excel formulas for all calculations and use the template that is provided to perform the following calculations: Calculate a depreciation schedule. Calculate the salvage value. Calculating the operating cash flows. Calculate the working capital cash flows. Combine the calculations performed in Step 3 to calculate the following: Calculate the base case scenario changes to cash flows and the net present value of the capital project cash flows. Calculate the best-case scenario changes to cash flows and the net present value of the capital project cash flows. Calculate the worst-case scenario changes to cash flows and the net present value of the capital project cash flows. Calculate the overall expected net present value using the assumption of 50% of the base case, 25% likelihood of the worst case, and 25% likelihood of the best case occurring.
