In: Finance
EXERCISE 2: Cost and Benefit Analysis Techniques
Assuming economic benefits of an information system at $95,000 at year 1, $125,000 at year 2, and $145,000 at year 3, development costs are $235,000 and operating costs are $15,000 at year 1, $16,000 at year 2, and $18,000 at year 3, a discount rate of 5%, and a 3-year time horizon,
Please show all work.
A. NPV = 60954.54
| cash flows | year 1 | year 2 | year 3 |
| inflows | 95000 | 125000 | 145000 |
| development cost | -235000 | ||
| operating cost | -15000 | -16000 | -18000 |
| NET CASH FLOWS | -155000 | 109000 | 127000 |
| DISCOUNT RATE | 5% | ||
| NPV | $60,954.54 | ||
| ROI = NPV / SUM OF OUTFLOWS | 22.73% | ||
| BEP = development cost / INFLOWS - operating cost | 2.9375 | 2.155963303 | 1.850393701 |
B.
| present value of outflows | |||
| Year 1 | 250000 | 0.952380952 | 238095.2381 |
| year 2 | 16000 | 0.907029478 | 14512.47166 |
| year 3 | 18000 | 0.863837599 | 15549.07677 |
| 268156.786526 |
| ROI = NPV / SUM OF OUTFLOWS | 22.73% |
=60,954/268156 = 22.73%
C.
| BEP = development cost / INFLOWS - operating cost | 2.9375 | 1.75 | 1.394025605 |
| present value of outflows | |||
| Year 1 | 15000 | 0.952380952 | 14285.71429 |
| year 2 | 16000 | 0.907029478 | 14512.47166 |
| year 3 | 18000 | 0.863837599 | 15549.07677 |
| 44347.26271 | |||
| year 1 | 235000 | 0.952380952 | 223809.5238 |
| present value of intflows | |||
| Year 1 | 95000 | 0.952380952 | 90476.19048 |
| year 2 | 125000 | 0.907029478 | 113378.6848 |
| year 3 | 145000 | 0.863837599 | 125256.4518 |
| BEP = development cost / INFLOWS - operating cost | 2.9375 | 1.75 | 1.394025605 |