I want help on how to do it on an Excel Sheet. If you can screenshot an Excel sheet or send me your email in the answers so I can get help please

The solution can be found using Excel's NPV function, which finds the NPV of CF1 to CFN, and then add the value of CFO to the result. NPVL = NPVS= Choose both projects if they're independent, but if they're mutually exclusive choose Project S. (2) What is each project's IRR? The internal rate of return (IRR) is that discount rate which forces the NPV of a project to equal zero. The solution to this equation can be found using Excel's IRR function. IRRL= IRRS= Choose both projects if they're independent, but if they're mutually exclusive choose Project S. As a separate project (Project P), the firm is considering sponsoring a pavilion at the upcoming World's Fair. The pavilion would cost $800,000, and it is expected to result in $5 million of incremental cash inflows during its one year of operation. However, it would then take another year, and $5 million of costs, to demolish the site and return it to its original condition. Thus, Project P's expected cash flows (in millions of dollars) look like this: Cash Flow Year 0 ($0.8) 1 $5.0 2 ($5.0) WACC = 10% The project is estimated to be of average risk, so its WACC is 10%. (3) What is Project P's NPV? What is its IRR? NPV = IRR = However, since this project has nonnormal cash flows, we must be aware of the possibility of multiple IRRs. Therefore, we will perform the IRR calculation again, but this time a guess of 300% will be entered to test for another IRR. IRR = Indeed, it is revealed that two IRRs exist. Because there are two sign changes in the cash flow stream, we can be sure that there are two and only two IRRS