Kindly do "high level financial analysis" and "further breakdown cost" for the given project.

Template for 'High Level Financial Analysis" is given below:

Template for "further breakdown cost" is given below:

Phase 1: Initiating Scenario XYZ. is one of the world's fastest growing biotechnology firms. In addition to performing basic research, the company provides several FDA-approved drugs. They have recently expanded into the genetically modified food market and energy market, as well. The company has over 30,000 employees today, having added almost 10,000 people last year alone. They predict that they will continue to grow in the future. They currently are headquartered in California and have offices in six other states and five other countries. They plan to open four additional offices next year. Part of the reason for the company's success has been their strong work culture. The company's founders wanted to focus on using science and innovation to improve people's lives. They believe in hiring highly talented and motivated individuals who can work well on self-managed teams. Due to their rapid growth, the CIO (David) and the VP (Liz) of Human Resources have both made this project a priority to help manage the company's workforce. Their current system is not working well for doing basic functions like applicant tracking, new employee orientation, benefits management, employee security, compensation, etc. There are several decentralized systems various managers use for managing their people currently, including software to help assign people to various projects. The main goal of this project is to provide one centralized yet flexible system to more effectively manage all of XYZ, Inc.'s people. Senior managers believe it will take about one year and $1 million for this important project. They also feel it would be best to purchase an existing application and tailor it, as needed. David and Liz formed a search committee to find the best candidate for managing the Human Resource Management System Project. Since this was a high priority project that should be completed in one year, they felt it was appropriate to go outside the company in this case. After reviewing many strong candidates, they decided to hire You to manage this critical project. You worked for a consulting firm where you had successfully implemented several human resource systems in large organizations. They knew they were paying a premium for yours contract, but a lot was at stake. David and Liz agreed to be joint project sponsors. They would let the new project manager, You, form the rest of the project team. O Senior managers now want to see some high level financial analysis for this project to help them make some important decisions on functionality and system life: Assume it will cost $1 million in year 0 to provide the basic software functionality required (software license and software development). If you add the ability to make team assignments across the organization and professional development management and tracking, it will cost an additional $500,000 in year 0. Maintenance costs each year are estimated to be 20% of the initial investment cost. Assume the benefits of the basic system are conservatively projected to be $500,000 each year for the life of the system. Assume the benefits would be $700,000 each year for the life of the system with the added capabilities. Assume a three-year system life and discount rate of 8% in calculating the ROI, NPV, payback period and IRR. Use the same information but assume a 5-year system life. . O O There is a template for Financial Analysis. I will provide it separately. After you do "High Level Financial Analysis, please rethink project costs. Make a further cost breakdown and repeat the above task Title Created By: Date: Note: Change numbers shown in green below (i.e. interest rate, number of years, costs, and benefits) based on your project. Be sure to double-check the formulas based on the 8% 0 1 2 3 4 5 Total Discount Rate: Period Costs Discount Factor Discounted Costs 0.93 0.86 0.79 0.74 0.68 Benefits Discount Factor Discounted Benefits 0.93 0.86 0.79 0.74 0.68 Total cash-flow Discounted Benefits - Discounted Costs Cumulative Discounted Benefits - Discounted Costs #DIV/0! $ (You will need to determine when this occurs.) ROI: NPV: Payback Year: IRR: Assumptions Enter assumptions here #NUM! Notes Enter notes about costs/benefits here Title Created By: (Note: There are two tables below that need to be done.) Date: $0 Cost Breakdown This cost breakdown total must be within 10% of above financial analysis' total Prepared by: Date: Note: Change the categories and other entries to meet your project needs. Information Technology Project Management, Fourth Edition. Also make sure the formulas work properly based on the data you enter. # Units/Hrs. Cost/Unit/Hr. Subtotals Category Totals % of Total Categories 1. Project Management #DIV/0! 1.1 Project manager 1.2 Project team members Contractors (10% of software development and testing) 2. Hardware $0 #DIV/0! 2.1 Handheld devices 2.2 Servers 3. Software $0 #DIV/0! 3.1 Licensed software 3.2 Software development 4. Testing (10% of total hardware and software costs) $0 #DIV/0! 5. Training and Support $0 #DIV/0! 5.1 Trainee cost 5.2 Travel cost 5.3 Project team members 6. Reserves (20% of total estimate) $0 #DIV/0! Total project cost estimate $0 Other optional categories: * Executive Overview Delivery Excellence * Planning for this project's impact on other products Tips to consider when including the other optional categories. Non-involved folks from your company review team's work Usually takes 5 to 6 hours per milestone A risk review assesing health of project by a senior person not part of a team. Typically done quarterly, then monthly as project progresses 8% 0 1 2 3 4 5 Total (Update this table from Set 1 as you now know more information) Discount Rate: Period Costs Discount Factor Discounted Costs 1 0.93 0.86 0.79 0.74 0.68 Benefits Discount Factor Discounted Benefits 1 0.93 0.86 0.79 0.74 0.68 E f f f f f Total cash-flow Discounted Benefits - Discounted Costs Cumulative Discounted Benefits - Discounted Costs ROL: NPV: Payback Year: IRR: #DIV/0! $ $0.00 #NUM! Notes to further explain financial numbers. Phase 1: Initiating Scenario XYZ. is one of the world's fastest growing biotechnology firms. In addition to performing basic research, the company provides several FDA-approved drugs. They have recently expanded into the genetically modified food market and energy market, as well. The company has over 30,000 employees today, having added almost 10,000 people last year alone. They predict that they will continue to grow in the future. They currently are headquartered in California and have offices in six other states and five other countries. They plan to open four additional offices next year. Part of the reason for the company's success has been their strong work culture. The company's founders wanted to focus on using science and innovation to improve people's lives. They believe in hiring highly talented and motivated individuals who can work well on self-managed teams. Due to their rapid growth, the CIO (David) and the VP (Liz) of Human Resources have both made this project a priority to help manage the company's workforce. Their current system is not working well for doing basic functions like applicant tracking, new employee orientation, benefits management, employee security, compensation, etc. There are several decentralized systems various managers use for managing their people currently, including software to help assign people to various projects. The main goal of this project is to provide one centralized yet flexible system to more effectively manage all of XYZ, Inc.'s people. Senior managers believe it will take about one year and $1 million for this important project. They also feel it would be best to purchase an existing application and tailor it, as needed. David and Liz formed a search committee to find the best candidate for managing the Human Resource Management System Project. Since this was a high priority project that should be completed in one year, they felt it was appropriate to go outside the company in this case. After reviewing many strong candidates, they decided to hire You to manage this critical project. You worked for a consulting firm where you had successfully implemented several human resource systems in large organizations. They knew they were paying a premium for yours contract, but a lot was at stake. David and Liz agreed to be joint project sponsors. They would let the new project manager, You, form the rest of the project team. O Senior managers now want to see some high level financial analysis for this project to help them make some important decisions on functionality and system life: Assume it will cost $1 million in year 0 to provide the basic software functionality required (software license and software development). If you add the ability to make team assignments across the organization and professional development management and tracking, it will cost an additional $500,000 in year 0. Maintenance costs each year are estimated to be 20% of the initial investment cost. Assume the benefits of the basic system are conservatively projected to be $500,000 each year for the life of the system. Assume the benefits would be $700,000 each year for the life of the system with the added capabilities. Assume a three-year system life and discount rate of 8% in calculating the ROI, NPV, payback period and IRR. Use the same information but assume a 5-year system life. . O O There is a template for Financial Analysis. I will provide it separately. After you do "High Level Financial Analysis, please rethink project costs. Make a further cost breakdown and repeat the above task Title Created By: Date: Note: Change numbers shown in green below (i.e. interest rate, number of years, costs, and benefits) based on your project. Be sure to double-check the formulas based on the 8% 0 1 2 3 4 5 Total Discount Rate: Period Costs Discount Factor Discounted Costs 0.93 0.86 0.79 0.74 0.68 Benefits Discount Factor Discounted Benefits 0.93 0.86 0.79 0.74 0.68 Total cash-flow Discounted Benefits - Discounted Costs Cumulative Discounted Benefits - Discounted Costs #DIV/0! $ (You will need to determine when this occurs.) ROI: NPV: Payback Year: IRR: Assumptions Enter assumptions here #NUM! Notes Enter notes about costs/benefits here Title Created By: (Note: There are two tables below that need to be done.) Date: $0 Cost Breakdown This cost breakdown total must be within 10% of above financial analysis' total Prepared by: Date: Note: Change the categories and other entries to meet your project needs. Information Technology Project Management, Fourth Edition. Also make sure the formulas work properly based on the data you enter. # Units/Hrs. Cost/Unit/Hr. Subtotals Category Totals % of Total Categories 1. Project Management #DIV/0! 1.1 Project manager 1.2 Project team members Contractors (10% of software development and testing) 2. Hardware $0 #DIV/0! 2.1 Handheld devices 2.2 Servers 3. Software $0 #DIV/0! 3.1 Licensed software 3.2 Software development 4. Testing (10% of total hardware and software costs) $0 #DIV/0! 5. Training and Support $0 #DIV/0! 5.1 Trainee cost 5.2 Travel cost 5.3 Project team members 6. Reserves (20% of total estimate) $0 #DIV/0! Total project cost estimate $0 Other optional categories: * Executive Overview Delivery Excellence * Planning for this project's impact on other products Tips to consider when including the other optional categories. Non-involved folks from your company review team's work Usually takes 5 to 6 hours per milestone A risk review assesing health of project by a senior person not part of a team. Typically done quarterly, then monthly as project progresses 8% 0 1 2 3 4 5 Total (Update this table from Set 1 as you now know more information) Discount Rate: Period Costs Discount Factor Discounted Costs 1 0.93 0.86 0.79 0.74 0.68 Benefits Discount Factor Discounted Benefits 1 0.93 0.86 0.79 0.74 0.68 E f f f f f Total cash-flow Discounted Benefits - Discounted Costs Cumulative Discounted Benefits - Discounted Costs ROL: NPV: Payback Year: IRR: #DIV/0! $ $0.00 #NUM! Notes to further explain financial numbers