Reference no: EM133905572

Question

You are a project manager at a mid-sized technology company, Tech Solutions Inc. Your company is planning to launch a new software product that aims to streamline project management processes for small to medium enterprises (SMEs). The executive board has provided you with initial data and tasked you with analyzing the project viability, estimating costs, and preparing a detailed budget. Additionally, you need to report on the project's status after the first three months using EVM techniques. Provided Data Funding Sources: Internal Funds: $500,000 Bank Loan: $3,000,000 at an annual interest rate of 5% Top-Down Budget: Total estimated budget: $3,200,000 Forecasted Benefit Realization: Year 1: $500,000 Year 2: $1,200,000 Year 3: $2,000,000 Year 4: $2,500,000 Year 5: $3,000,000 Discount Rate: 8% Project Phases and Estimated Costs: Phase 1: Planning - $200,000 Phase 2: Development - $1,500,000 Phase 3: Testing - $500,000 Phase 4: Marketing - $700,000 Phase 5: Deployment - $300,000 Contingencies: 10% contingency for Development 5% contingency for Testing 15% contingency for Marketing Tasks Project Selection Using Discounted Cash Flow (DCF) and Sensitivity Analysis: Calculate the Net Present Value (NPV) of the project using the provided discount rate. Perform a sensitivity analysis on the discount rate (±2%). Provide a rationale for whether the project should be selected based on the NPV and sensitivity analysis results. Cost Estimations and Bottom-Up Budget: Estimate the total cost for each project phase considering the provided contingencies. Build a detailed bottom-up budget that includes: Labor costs Material costs Overheads Compare the bottom-up budget with the top-down budget and discuss any discrepancies. Status Report Using EVM Techniques: Assume the project is three months into execution, and the following data is available: Planned Value (PV): $750,000 Earned Value (EV): $600,000 Actual Cost (AC): $800,000 Calculate the following EVM metrics: Schedule Variance (SV) Cost Variance (CV) Schedule Performance Index (SPI) Cost Performance Index (CPI) Based on the EVM metrics, provide a status report discussing the project's current status, potential risks, and recommended corrective actions. I have to submit this can you provide NPV in excel type so I can add that one.