Question

In: Finance

EXERCISE 2: Cost and Benefit Analysis Techniques Assuming economic benefits of an information system at $95,000...

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,

  1. net present value (NPV)?
  2. ROI?
  3. break-even point (BEP)?


Please show all work.

Solutions

Expert Solution

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

Related Solutions

Assuming monetary benefits of an information system at $150 at Year 1, $200 at Year 2,...
Assuming monetary benefits of an information system at $150 at Year 1, $200 at Year 2, and $250 at Year 3, one-time costs of $200, recurring costs of $50 per year, a discount rate of 7 percent, and a three-year time horizon, please fill in the cost-analysis benefit table below. Please round each value to 2 decimal places (which indicates that you should keep at least 3 decimal places for intermediate calculations). Each blank between (1) and (23) is worth...
In the context of benefit – cost analysis what criteria can be used to classify benefits...
In the context of benefit – cost analysis what criteria can be used to classify benefits on one hand and costs on the other hand?
Explain briefly what the following mean: Cost benefit analysis Economic impact analysis Cost effectiveness analysis Hedonic...
Explain briefly what the following mean: Cost benefit analysis Economic impact analysis Cost effectiveness analysis Hedonic pricing Shadow pricing
In cost benefit analysis, which of the following best explains why benefits and costs are all...
In cost benefit analysis, which of the following best explains why benefits and costs are all discounted? Select one: a. It makes it easier to compare options b. It is a requirement in project evaluation c. It ensures the project is feasible d. Money today is not the same as money tomorrow e. None of the above Which of the following statement is true of social cost benefit analysis? Select one: a. All benefits and costs need to be discounted...
Background This case study compares benefit/cost analysis and cost effectiveness analysis on the same information about...
Background This case study compares benefit/cost analysis and cost effectiveness analysis on the same information about highway lighting and its role in accident reduction. Poor highway lighting may be one reason that proportionately more traffic accidents occur at night. Traffic accidents are categorized into six types by severity and value. For example, an accident with a fatality is valued at approximately $4 million, while an accident in which there is property damage (to the car and contents) is valued at...
Background This case study compares benefit/cost analysis and cost effectiveness analysis on the same information about...
Background This case study compares benefit/cost analysis and cost effectiveness analysis on the same information about highway lighting and its role in accident reduction. Poor highway lighting may be one reason that proportionately more traffic accidents occur at night. Traffic accidents are categorized into six types by severity and value. For example, an accident with a fatality is valued at approximately $4 million, while an accident in which there is property damage (to the car and contents) is valued at...
Background This case study compares benefit/cost analysis and cost effectiveness analysis on the same information about...
Background This case study compares benefit/cost analysis and cost effectiveness analysis on the same information about highway lighting and its role in accident reduction. Poor highway lighting may be one reason that proportionately more traffic accidents occur at night. Traffic accidents are categorized into six types by severity and value. For example, an accident with a fatality is valued at approximately $4 million, while an accident in which there is property damage (to the car and contents) is valued at...
A cost benefit analysis of a new CD fence project indicates that the net benefits (B-C)...
A cost benefit analysis of a new CD fence project indicates that the net benefits (B-C) of the project in each of the first three (3) years will be $-2,000,000 (-2 million dollars). Thereafter, the project will yield positive net benefits of $750,000 for the next 23yrs. Alternatively, an education project will yield net benefits of $-1,000,000 (-1 million dollars) for the first year, and positive net benefits of $6,000,000 for the next 10yrs, and $10,000,000 for another 15yrs. A)...
A cost benefit analysis of a new CD fence project indicates that the net benefits (B-C)...
A cost benefit analysis of a new CD fence project indicates that the net benefits (B-C) of the project in each of the first three (3) years will be $-2,000,000 (-2 million dollars). Thereafter, the project will yield positive net benefits of $750,000 for the next 23yrs. Alternatively, an education project will yield net benefits of $-1,000,000 (-1 million dollars) for the first year, and positive net benefits of $6,000,000 for the next 10yrs, and $10,000,000 for another 15yrs. Calculate...
• Do a cost-benefit analysis of the selected healthcare organization. Explain your analysis of the cost-benefit...
• Do a cost-benefit analysis of the selected healthcare organization. Explain your analysis of the cost-benefit ratio and how it helps an organization. • Explain the impact of the cost-benefit ratio on recruitment and retention strategies of a healthcare organization. • Outline ways to improve the cost-benefit ratio of the selected healthcare organization. • Explain the role of HRM in ensuring the most competitive compensation package for employees. • Describe methods of improving the compensation package of the selected healthcare...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT