PLEASE WRITE THE FORMULAS FOR THE EXCELS, THANK YOU

4. Light Sweet Petroleum, Inc., is trying to evaluate a generation project with the following cash flows: Year Cash Flow 0 1 -$45,000,000 71,000,000 -15,000,000 2 1. If the company requires a return of 12 percent on its investments, should it accept this project? Why? 2. Compute the IRR for this project. How many IRRs are there? Using the IRR decision rule, should the company accept the project? What's going on here? 5. Consider the project with the following cash flows. How many different IRRs are there? (Hint: Search between 20 percent and 70 percent.) When should we take this project? Year 0 1 Cash Flow -$ 3,024 17,172 36,420 34,200 -12,000 2 3 4 Part 2: Making Capital Investment Decisions