Preferably in excel form

Part B: Calculate using Excel formulas, the NPV of each of the 3 projects It is possible that ABC Company may not be able to advise ABC Company complete all 3 projects. Therefore, as to the order in which they should pursue the projects (i.e. which project should ABC Company attempt to do first, second, and last). Provide justification and analysis as to why you chose the order you did. The analysis must also be done in Excel, not in a separate document. ABC Company's management is also considering 3 new projects consisting of the purchase of new equipment. The company has limited resources, and may not be able to make all 3 purchases. The information is as follows for the purchases below. complete Project 1 Project 2 Project 3 Purchase Price $80,000 $22,700 $175,000 Required Rate of Return 6% 12% 8% 2 years 5 years Time Period 3 years $13,000 $85,000 $48,000 Cash Flows - Year 1 $13,000 $74,000 Cash Flows -Year 2 $36,000 N/A $38,000 $22,000 Cash Flows-Year 3 N/A $26,800 N/A Cash Flows- Year 4 N/A $19,000 N/A Cash Flows - Year 5