Lawrenceville Manufacturing has narrowed their selection of projects to the two choices below. These projects are mutually exclusive, and they would like your analysis and recommendation of the best project for them to move forward with.

• The discount rate to evaluate these projects is 6.40%.
• The Board of Directors requires all projects must pay back within a 3-year period.

	Project X		Project Y
0	-150000000		-372500000
1	68710000		159410000
2	76900000		193300000
3	71400000		154900000
4	40610000		110510000

• You are required to use excel to complete the following analysis.
• CLEARLY indicate your answers and question number.
• Save your work in one single excel file and upload to Canvas to the designated link.

1. Indicate the Payback Period for each project, indicate which project is accepted under this criteria
2. Calculate the Net Present Value (NPV) for each project using excel
3. Calculate the Internal Rate of Return (IRR) using excel
4. Calculate the Profitability Index (PI) using excel
5. Using the results from parts 2,3 and 4, create a (brief) formal memo to the president of Lawrenceville Manufacturing to explain your final recommendation, support your decision.