. * Normal DODHdbull Aabble 1 No Spac... Heading 1 Heading 2 Styles Font A- . A Z - Paragraph NPV IRR Excel/Word group Assignment Instructions The Balol Corporation would like you to perform NPV and IRR analysis for two prospective capital investment projects. The data for these two projects is contained on the Data tab of the Excel workbook provided for this assignment. Your portion of group Assignment Requirements: 1. Use the Excel Workbook provided to compute the NPV and IRR of the two initial plans. Format your work using the exhibit on page 1487 of your text as an example. Complete your work for the initial data on the initial NPV IRR tab of the Excel Workbook provided. 2. Recalculate the NPV and IRR of the two plans assuming that the initial cost of the plans will be $5,500,000. Complete your work for these revised numbers on the Revised NPV IRR tab of the Excel Workbook provided. 3. Answer the following questions in a Word document: a. Referring to your calculations for the initial project costs, which plan, if any, should the company adopt and why? What qualitative factors other than financial analyses may the company consider in making their decision? Please state at least 3 specific items. b. Explain the relationship between NPV and IRR. Discuss the application of this relationship to the results you obtained for your calculations of the initial plans. c. Considering the results of the analysis with the lower cost (requirement 2): If the company has the resources to pursue both plans, what would you recommend? I. If the company may only pursue one plan, what would you recommend? Specific instructions: 1. Download the Excel Workbook provided for this assignment. Save the Excel document and create your Word document with your first initial and last name. Example: ILastname BALOINPVIRR. 2. Construct your NPV IRR tables using the example format in your text. You must use the formulas in Excel for your calculations. Do not refer to or use the factors provided in the table in your text. 3. Proper text formatting includes attention to bolding, capitalization, cell alignment, and borders. 4. Proper number formatting includes attention to dollar signs, percentage signs, decimal places, borders, and alignment. 5. Use Excel formulas to calculate NPV, IRR, and summations. You should consider using the Formulas tab in Excel to help you construct these formulas. 6. Your written response contained in your Word document should follow proper writing requirements and should contain comlete centences please nav attention to formatting **, X Font AaBbcc AalbCcD