Calculate net present value of costs for each year

Assignment Help Operation Management

Reference no: EM131276151

As a systems analyst, you are preparing a new information system project proposal for management that require you to create a costs-benefits analysis prior to project presentation. Assume that the project is expected to return monetary benefits of $55,000 per year, one-time costs of $75,000, and recurring costs of $15,000 per year. The project has a discount rate of 8% and a five-year time horizon. a) Create a costs-benefits analysis spreadsheet similar to the one on page 121 in Chapter 5. b) Calculate net present value (NPV) of benefits for each year. c) Calculate net present value (NPV) of costs for each year. d) Calculate overall net present value (NPV) at the end of project life. e) Calculate overall return on investment (ROI) at the end of project life. f) Perform break-even analysis (BEA) for the project. g) Calculate break-even point for this project.

Reference no: EM131276151

Questions Cloud

What is the continuing value for apparelco as of year 5 : What percentage of ApparelCo's total operating value is attributable to current invested capital, to interim economic profits, and to economic profits in the continuing-value period?

Design a domino circuit to compute the given equation : Choose transistor sizes to achieve least delay and estimate this delay in Y.

Explain why the company supply chain strategy : Explain why the company's supply chain strategy is successful, for example, the selection and management of suppliers, and determination of information needs and systems. What advantage does Zara gain against the competition by having a very responsi..

What is the continuing value as of year 5 : If NOPLAT equals $26.6 million in year 6, return on new invested capital (RONIC) equals 15 percent, and the cost of capital equals 10 percent, what is the continuing value as of year 5?

Calculate net present value of costs for each year : As a systems analyst, you are preparing a new information system project proposal for management that require you to create a costs-benefits analysis prior to project presentation. Create a costs-benefits analysis spreadsheet similar to the one on pa..

Design a 4-input footed dynamic nand gate : Design a 4-input footed dynamic NAND gate driving an electrical effort of 1. Estimate the worst charge-sharing noise as a fraction of VDD assuming that diffusion capacitance on uncontacted nodes is about half of gate capacitance and on contacted n..

What is the flaw in your colleagues argument : A colleague argues that this is too conservative, as SuperiorCo will create value well beyond the forecast period. What is the flaw in your colleague's argument?

Most important managerial function : Planning is the “most important managerial function.” As a nurse supervisor at the local hospital, examine what function you would use to plan for this year’s influenza scare due to a vaccine shortage. Outline how would you benchmark and forecast for..

What is bangalore breads cost of capital : If the Indian risk-free rate is 7 percent, the market risk premium is 5 percent, and the marginal tax rate is 30 percent, what is Bangalore Bread's cost of capital?

User Account

All Pages