Can someone do this in excel ?

1. Compute all IRRs for the following sequence of cash flows Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 $10,000 $8,000 $1,500 $1,500 $1,500 $1,500 2. Consider a project with the following cash flows. Determine the project's IRR. If the annual cost of capital is 20 percent, would you undertake this project? ear 3 SA000 Year 1 Year 2 |-54,000 | $2.000 3. Find all IRRs for the following project: Year 1 Year 2 Year3 $100 -$300 $250 4 Find all IRRs for a project having the given cash flows on the listed dates: 1/10/2003 7/10/2003 5/25/2004 7/18/2004 3/20/2005 4/1/2005 1/10/2006 -$1,000 $900 $800 $700 500 $500 $350 Consider the following two projects and assume a company's cost of capital is 15 percent. Find the IRR and NPV of each project. Which projects add value to the company? If the company can choose only a single project, which project should it choose? 5. og 5326 Year 1 -$40 -$80 Year 3 $19 |$36 Year 4 Project Project 2 $130 36 |s36 Twenty-five-year-old Meg Prior intends to invest $10,000 in her retirement fund at the beginning of each of the next 40 years. Assume that during each of the next 30 years, Meg will earn 15 percent on her investments and during the last 10 years before she retires, her investments will earn 5 percent. Determine the IRR associated with her investments and her final retirement position. How do you know there will be a unique IRR? How would you interpret the unique IRR? 6