The managers of Camping World are considering manufacturing pop-up campers. They expect to sell 250 campers annually for the next 6 years, and believe that they can sell them for $5000 per camper. The necessary plant and equipment to produce the campers will require an initial outlay of $950,000, which will be depreciated straight line to zero over the projects life. The firm expects to be able to dispose of the manufacturing equipment for $125,000 at the end of the project. Labor and material costs total $2500 per camper, and fixed costs are $175,000 per year. Camping World has a tax rate of 34% and a 13% discount rate. What is the IRR? (29.72%)

Please show how to calculate in excel, specifically how to find the Labor and material costs as well as EBIT.