The project will be delivered three months after approval within a budget of $350.000.00. GDS expects 20% return on investment with 10% interest rate.

• Using an Excel Spreadsheet template,create a budgetthat considers the totals forHardware,Software, andLabor.
• Hardware Requirements:
• Front-end web server- $2,999.00
• Application server -$2,999.00
• SQL Server -$2,999.00
• Software Requirements:
• Database server (SQL Server) & CAL- $20,000.00
• Project Server 2016 Enterprise & CAL - $50,000.00
• SharePoint Server 2013 Enterprise & CAL - $40,000.00
• Windows Server 2012(64-bit) - CAL- $9,000.00
• Labor:$175.000.00
• Using an Excel spreadsheet template,perform a Cost Benefits Analysisby determining theNet Present Value (NPV),Return on investment (ROI)and Breakeven/ cost point.

I am stuck on the cost benefit analysis. I am not sure the best way to fill this in.

Project Development and Maintenance Costs Description FY01 FY02 FY03 FY04 FY05 Total Cost of Project Development Salaries $175,000.00 Workbook I Other internal expenses Consulting costs Capital expenditures $127,997.00 Total project costs $302.997.00 50 00 50.00 50.00 50.00 50.00 Cost of Support Operational costs Nonrecurring costs Recurring costs Total ongoing support costs 60.00 50.00 50.00 50.00 $0.00 50.00 Benefits/Savings Current Process FYO FY02 FY03 FY04 FY05 Total otal annual price $350.000.00 New Process otal annual price $350,000.00 Annual savings 50.0 50.00 50.00 50.00 50.00 50.00 Cumulative savings 60.00 60.00 50.00 $0.00 $0.00 $0.00 Cumulative costs 50.0 50.00 60.00 50.00 50.00 $0.00 Cumulative total net savings $0.00 50.00 50.00 $0.00 $0.00 50.00 Future Value Present Value Interest Rate # Periods Future Value $50000 10.00 $3,850.000.00 Present Value Future Value Interest Rate # Periods Present Value 53.850.000.00 10.00 $350.000.00 Net Present Value Period Cash Flow Present Value 2 3 Totals 50.00 50.00 Project development cost $309,277.00 let present value -5309,277.00