Categories

# problem 1 in Excel: Top Wonder Tours is evaluating 2 mutually exclusive projects

##### Swamped with your writing assignments? Take the weight off your shoulder!

problem 1 in Excel: Top Wonder Tours is evaluating 2 mutually exclusive projects. The probabilities of the different project returns are shown below. 1. Calculate the expected NPV. Which project is better? 2. Calculate the variance and standard deviation. Now which project is better? 3. Calculate the coefficient of variation and the probability of negative return. Does this change your decision? problem 2 in Excel: Franco’s Salt Company is evaluating a possible Rock Salt Contract. The contract runs 5 years with 32,000 tons to be delivered per year. The revenue per ton is \$150 and the variable cost per ton is \$115. The machinery will cost \$1,520,000 and is to be depreciated using MACRS 5 year class. FC per year are \$350,000. After 5 years the equipment can be sold for \$109,000 in salvage value. There is an \$90,000 investment needed in net working capital that will be recovered in year 5. The required return is 10% and the company tax rate is 36%. 1. Calculate the Annual Cash Flows for the project. 2. Calculate the NPV. 3. Calculate the payback and discounted payback 4. Calculate the IRR and MIRR. 5. Should the company pursue the contract?