Can you do this with Excel Please?

2. Robert Washington, president of the Sunshine Hotel, is considering two investments projects. Only one of the two will be selected this year. Information regarding each project is as follows: Project 1: Renovate an existing motel for $1,000,000. After tax, free cash flows are expected to be 200,000 per year for twenty years. Project 2: Build a new motel for $4,000,000. After tax, annual cash flows for twenty years are expected as follows: Free Cash Flow Year -200,000 -50,000 200,000 600,000 1,100,000 5-20 Assume a discount rate of 12 percent. Required: 1) Based on the NPV model, which of the two projects would be selected? 2) Based on the IRR model, which of the two projects would be selected? 3) Which model would you prefer, why