PLEASE USE EXCEL FORMULA TO SOLVE THE PROBLEMS

2) The New World Soccer League is evaluating the purchase of a used van to transport equipment to games. The cost of the van is $10,000 and it is expected to have a useful life of three years. Insurance, maintenance and gas will cost $1,500 annually. At the end of three years it is expected the van could be sold for $2,500. By buying the van New World will save $3,700 annually on rental costs. Using a 11% discount rate/hurdle rate calculate the IRR and NPV. Ignore taxes and inflation. What decision should be made. Why? 1) ABC Yarn Company is evaluating buying a piece of equipment. The cost of the equipment is $40,000 and has a four year useful life. The equipment is expected to generate $16,000 of revenue per year for 4 years. There will be supply expenses of $2,000 a year, maintenance cost of $600 annually Using an 8% discount rate/hurdle rate calculate the IRR and NPV for proposed equipment purchase. Ignore taxes and inflation. What decision should be made. Why