For this Assignment, we will work on Setting Up Recruiting Department -then answer the following parts. Use the excel sheet below. DO NOT COPY WHAT IS ALREADY DONE IN CHEGG. THESE ARE DIFFERENT FIGURES

II. Estimate the cost and benefits of your investment using present value. III. Calculate the payback period, net present value, benefit cost ratio, and internal rate of return of the proposed investment. IV. Submit an executive summary paper (two to three pages maximum including your one-page Excel spreadsheet). In addition, please cite all references in a bibliography at the end of your paper. Grades will be based on the quality of the following: I. Cost/Benefit Analysis II. Excel Spreadsheet III. Executive summary paper including upfront statement of purpose and recommendation and informative section headings IV. If working in a team, peer reviews of your contribution to the team 42 43 Discount Rate 15% 44 Net Present Value @15\% $140,858 45 Benefit cost Ratio 1.17 46 22% 48 Indirect benefits - recruiters helping to build employer brand and company culture 49 Indirect costs - recruiters may not know the labor market as well as employment agencies II. Estimate the cost and benefits of your investment using present value. III. Calculate the payback period, net present value, benefit cost ratio, and internal rate of return of the proposed investment. IV. Submit an executive summary paper (two to three pages maximum including your one-page Excel spreadsheet). In addition, please cite all references in a bibliography at the end of your paper. Grades will be based on the quality of the following: I. Cost/Benefit Analysis II. Excel Spreadsheet III. Executive summary paper including upfront statement of purpose and recommendation and informative section headings IV. If working in a team, peer reviews of your contribution to the team 42 43 Discount Rate 15% 44 Net Present Value @15\% $140,858 45 Benefit cost Ratio 1.17 46 22% 48 Indirect benefits - recruiters helping to build employer brand and company culture 49 Indirect costs - recruiters may not know the labor market as well as employment agencies