\f6 I'll '5: [E' ( Excel ProjectAssignmentlnstructi... [ 0 Switch To Light Mode . I . I ' V I complete/make all 3 purchases. Therefore. calculate the NPV for each. and place the projects in the order in which they should be completed using NPV as the reasoning. The information is as follows for the purchases below. Project 1 Project 2 Project 3 Purchase Price SRITLIJOCI $1 75.000 $31700 Required Rule of Relurn h\"-.\\ guy \" 2% Time Period Cash Flows Year I 348.001] $81000 $11000 Cash Flows 7 Year 2 S3 .300 3574.000 $I3Jltlll Cash Flows Year 3 522.000 $3.000 NJA Cash Flows 7 Year 4 NA $263400 NA Cash Flows 7 Year 5 N'A 5:10.000 NeA Required Action: Part 1 : ' Prepare the year-end balance sheet for 20X]. Be sure to use proper headings and labels. This should be done in Excel. using the rst tab in the worksheet. Part 2: ' Using Excel formulas. calculate the NPV for each of the 3 potential projects. It is possible that ABC. Company may not be able to complete all 3 projects. Therefore. advise ABC Company as to the order in which they should pursue the projects (i.e.. which project. should ABC Company attempt to do rst. second. and last). ' This portion should be completed on a separate tab in Excel. This assignment must be submitted as 1 Excel document. with 2 separate tabs. Note: Your assignment will be checked for originality via the Turnitin plagiarism tool. 3 D3 Calendar To Do Notications