Subjects finance

Cost Benefit Analysis 5Fcbae

Step-by-step solutions with LaTeX - clean, fast, and student-friendly.

Search Solutions

Cost Benefit Analysis 5Fcbae


1. **Problem Statement:** We are given costs and benefits of a tracking system over 5 years and need to perform cost-benefit analysis including Payback Period, ROI, and NPV with an 8% discount rate. 2. **Given Data:** | Year | Cost | Benefit | |------|-------|---------| | 0 | 50000 | 0 | | 1 | 20000 | 50000 | | 2 | 20000 | 50000 | | 3 | 20000 | 50000 | | 4 | 20000 | 50000 | 3. **Formulas and Rules:** - Payback Period: Time to recover initial investment from net benefits. - ROI = $\frac{\text{Total Benefits} - \text{Total Costs}}{\text{Total Costs}} \times 100$% - NPV = $\sum_{t=0}^n \frac{\text{Net Benefit}_t}{(1 + r)^t}$ where $r=0.08$ (discount rate) 4. **Step a) Payback Period Calculation:** - Calculate net benefit each year: $\text{Benefit} - \text{Cost}$ - Year 0: $0 - 50000 = -50000$ - Year 1: $50000 - 20000 = 30000$ - Year 2: $50000 - 20000 = 30000$ - Year 3: $50000 - 20000 = 30000$ - Year 4: $50000 - 20000 = 30000$ - Cumulative net benefit: - End Year 0: $-50000$ - End Year 1: $-50000 + 30000 = -20000$ - End Year 2: $-20000 + 30000 = 10000$ - Payback occurs between Year 1 and Year 2. - Fraction of Year 2 needed: $\frac{20000}{30000} = 0.67$ years - Payback Period = $1 + 0.67 = 1.67$ years 5. **Step b) ROI Calculation:** - Total Costs = $50000 + 20000 \times 4 = 50000 + 80000 = 130000$ - Total Benefits = $0 + 50000 \times 4 = 200000$ - ROI = $\frac{200000 - 130000}{130000} \times 100 = \frac{70000}{130000} \times 100 = 53.85$% 6. **Step c) NPV Calculation:** - Calculate present value of net benefits each year: - Year 0: $\frac{-50000}{(1+0.08)^0} = -50000.00$ - Year 1: $\frac{30000}{1.08^1} = 27777.78$ - Year 2: $\frac{30000}{1.08^2} = 25720.35$ - Year 3: $\frac{30000}{1.08^3} = 23815.69$ - Year 4: $\frac{30000}{1.08^4} = 22050.65$ - Sum NPV = $-50000 + 27777.78 + 25720.35 + 23815.69 + 22050.65 = 49364.47$ 7. **Step d) Evaluation:** - Payback Period of 1.67 years is short compared to project length (5 years), indicating quick recovery. - ROI of 53.85% shows a good return on investment. - Positive NPV of 49364.47 indicates the project adds value considering the discount rate. **Conclusion:** The tracking system is economically feasible based on payback period, ROI, and NPV analysis.