Project 1 WBIT 3111 Information Technology Project Management As the Director of Project Management for Georgia State University, you have been asked to prepare a financial analysis to help the University select one of three strategic IT projects for 2019 Each project involves the purchase and integration of commercial software and is expected to be completed within a year The three projects and their projected costs and benefits are shown below Use a discount rate of 9 for your analysis Project Initial Cost (Year 0) Annual Costs (Years 1 3) Annual Benefits(Years 1 3) NPV ROI Payback Period (year) Enrollment Management System 275,000 75,000 200,000 Financial Aid Management 150,000 50,000 125,000 Student Recruiting System 100,000 75,000 150,000 Formatting Instructions Use the example in your textbook on pg 163 to develop a worksheet to calculate the NPV, ROI, and payback period for each project (show all three projects on a single worksheet and include all calculations) Label the worksheet Financial Analysis At the bottom of the worksheet, summarize your recommendation to the University based on financial considerations and include the completed table shown above to support your recommendation Your worksheet should be professionally formatted (include a title, cell references for all calculations, formulas and accurate number formatting (accounting, 0 decimals)

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 21, 2024

Project 1; WBIT 3111- Information Technology Project Management As the Director of Project Management for Georgia State University, you have been asked to prepare a

Project 1; WBIT 3111- Information Technology Project Management

As the Director of Project Management for Georgia State University, you have been asked to prepare a financial analysis to help the University select one of three strategic IT projects for 2019. Each project involves the purchase and integration of commercial software and is expected to be completed within a year. The three projects and their projected costs and benefits are shown below. Use a discount rate of 9% for your analysis.

Project	Initial Cost (Year 0)	Annual Costs (Years 1-3)	Annual Benefits(Years 1-3)	NPV	ROI	Payback Period (year)
Enrollment Management System	275,000	75,000	200,000
Financial Aid Management	150,000	50,000	125,000
Student Recruiting System	100,000	75,000	150,000

Formatting Instructions: Use the example in your textbook on pg. 163 to develop a worksheet to calculate the NPV, ROI, and payback period for each project (show all three projects on a single worksheet and include all calculations). Label the worksheet Financial Analysis. At the bottom of the worksheet, summarize your recommendation to the University based on financial considerations and include the completed table shown above to support your recommendation. Your worksheet should be professionally formatted (include a title, cell references for all calculations, formulas and accurate number formatting (accounting, 0 decimals).