Please see attachments, I need a Project Earned Value Chart using the data from these attachments.
Financial Analysis for Valor Veterans support mobile app project Created by: David Cruz Date: 6/27/2023 Note: Change the inputs, such as discount rate, number of years, costs, and benefits. Be sure to double- check the formulas based on the inputs. The discount factor is not rounded. Discount rate 10% Assume the project is completed in Year 0 Year 0 2 3 Total Costs 50 50 50 50 Discount factor 1.00 0.91 0.83 0.75 Discounted costs 50 46 42 38 176 Benefits 0 150 150 150 Discount factor 1.00 0.91 0.83 0.75 Discounted benefits 0 137 125 113 375 Discounted benefits - costs (50) 91 83 75 199 NPV Cumulative benefits - costs (50) 41 124 199 ROI 99% Payback in Year 2 Assumptions The app is offered for free to users. The costs include server hosting, maintenance, and minor development updates. Benefits are derived from partnerships with veterans organizations and targeted advertising.Cost Estimate ect Name: Valor Veterans Support App Date: July 16, 2023 : Enter your WBS, hours, labor rates, etc. Add/delete rows and columns as needed and check all formulas (bolded below). Internal S/hour Internal External S/hour External Total Non-labor $ Total Categories Labor $ Total Labor $ Total Labor itiating 200 5 65 $ 13,000 $ 13,000 anning 600 5 60 $ 36,000 - $ 36,000 36 cecuting App Development - S B.1.1 Needs assessment 200 | $ 60 | $ 12,000 $ 12,000 3.1.2 Research of existing support resources 100 $ 55 S 5,500 - $ 5,500 .1.3 Partnerships 150 5 60 S 9,000 $ 9.000 .1.4 Course development 150 $ 60 S 9.000 $ 9,000 App Development skills, project management, and software trainin 150 15 55 S 8,250 - $ 8,250 B.App Administration 100 5 55 $ 5,500 $ 5,500 Stakeholder Communications 100 5 55 $ 5,500 $ 5,500 onitoring and Controlling 200 $ 55 $ 11,000 $ 11,000 11 osing 100 $ 55 $ 5,500 - $ 5,500 otal 120 erves - 120,250 120.250 S 120 umptions app is offered for free to users. costs include server hosting, maintenance, and minor development updates. fits are derived from partnerships with veterans organizations and targeted advertising. rans have access to smartphones or mobile devices